81,094
社区成员
发帖
与我相关
我的任务
分享
<%@ page language="java" contentType="text/html;charset=gb2312"
import="java.util.*,java.sql.*" pageEncoding="GB2312"%>
<link rel="stylesheet" href="css/code43.css" type="text/css">
<HTML><HEAD>
<title> 查询数据并求和</title>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
</HEAD>
<BODY style=scrollbar-arrow-color:#227776;scrollbar-base-color:#C6DCDE text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0 background="img/bg.gif" marginwidth="0" marginheight="0" >
<form name="form" method="post">
<div align="center">
<table width="959" height="177" border="0">
<tr>
<td width="115" align="right"><div align="center">标题</div></td>
<td width="118" height="37" align="right"><div align="center">日期:</div></td>
<td width="139"><div align="center">金额</div></td>
<td width="102"><div align="center">地点</div></td>
<td width="152"><div align="center">科目</div></td>
<td width="269"><div align="center">心情</div></td>
<td width="34"> </td>
</tr>
<%
request.setCharacterEncoding("gb2312");
String strError = null;
String userid=(String)session.getAttribute("user");
float sum=0 , sramount=0;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:goodschaginfo");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select * from sr where regname like '%"+userid+"%'";
out.println("查询结果如下:");
ResultSet rs = stmt.executeQuery(sql);
String tmp = "";
while(rs.next())
{
tmp = rs.getString("sramount");
if (tmp == null || "".equals(tmp)){ tmp = "0";}
%>
<tr>
<td align="center"><%= rs.getString("srtitle") %></td>
<td height="53" align="center"><%= rs.getString("srdate") %></td>
<td height="53" align="center"><%= tmp %></td>
<td height="53" align="center"><%= rs.getString("srlocation") %></td>
<td align="center"><%= rs.getString("srkemu") %></td>
<td height="53" align="center"><%= rs.getString("srmood") %></td>
</tr>
<%
// 以下这段代码有错
sum += Float.parseFloat(tmp);
}
session.setAttribute("sum",sum);
rs.close();
stmt.close();
con.close();
}
catch(ClassNotFoundException e){
strError = e.toString();
}
catch(SQLException e){
strError = e.toString();
}
%>
<tr>
<td height="79" colspan="3" align="center">
<input type="button" name="Submit2" value="返回" onClick="window.history.go(-1);"> </td>
<td height="79" colspan="3" align="center"><div align="left">收入金额总计:<%=sum%></div></td>
<td height="79" align="center"> </td>
</tr>
</table>
</div>
</form>
</TD>
</td>
</tr>
</table>
</BODY></HTML>
<%@ page language="java" contentType="text/html;charset=gb2312"
import="java.util.*,java.sql.*" pageEncoding="GB2312"%>
<link rel="stylesheet" href="css/code43.css" type="text/css">
<HTML><HEAD>
<title> 查询数据并求和</title>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
</HEAD>
<BODY style=scrollbar-arrow-color:#227776;scrollbar-base-color:#C6DCDE text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0 background="img/bg.gif" marginwidth="0" marginheight="0" >
<form name="form" method="post">
<div align="center">
<table width="959" height="177" border="0">
<tr>
<td width="115" align="right"><div align="center">标题</div></td>
<td width="118" height="37" align="right"><div align="center">日期:</div></td>
<td width="139"><div align="center">金额</div></td>
<td width="102"><div align="center">地点</div></td>
<td width="152"><div align="center">科目</div></td>
<td width="269"><div align="center">心情</div></td>
<td width="34"> </td>
</tr>
<%
request.setCharacterEncoding("gb2312");
String strError = null;
String userid=(String)session.getAttribute("user");
float sum=0 , sramount=0;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:goodschaginfo");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select * from sr where regname like '%"+userid+"%'";
out.println("查询结果如下:");
ResultSet rs = stmt.executeQuery(sql);
String tmp = "";
while(rs.next())
{
tmp = rs.getString("sramount");
if (tmp == null || "".equals(tmp)){ tmp = 0;}
%>
<tr>
<td align="center"><%= rs.getString("srtitle") %></td>
<td height="53" align="center"><%= rs.getString("srdate") %></td>
<td height="53" align="center"><%= tmp %></td>
<td height="53" align="center"><%= rs.getString("srlocation") %></td>
<td align="center"><%= rs.getString("srkemu") %></td>
<td height="53" align="center"><%= rs.getString("srmood") %></td>
</tr>
<%
// 以下这段代码有错
sum += Float.parseFloat(tmp);
}
session.setAttribute("sum",sum);
rs.close();
stmt.close();
con.close();
}
catch(ClassNotFoundException e){
strError = e.toString();
}
catch(SQLException e){
strError = e.toString();
}
%>
<tr>
<td height="79" colspan="3" align="center">
<input type="button" name="Submit2" value="返回" onClick="window.history.go(-1);"> </td>
<td height="79" colspan="3" align="center"><div align="left">收入金额总计:<%=sum%></div></td>
<td height="79" align="center"> </td>
</tr>
</table>
</div>
</form>
</TD>
</td>
</tr>
</table>
</BODY></HTML>