代码中if (tmp == null || "".equals(tmp)){ tmp = 0;} 这一段中0这里有错误,显示cannot convert from int to string代码内容:
<%
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();
}
%>
<%
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();
}
%>
if (tmp == null || "".equals(tmp)){ tmp = "0";}
你应该是这样的吧tmp是个String型的