问题阐述不清楚，麻烦您进来看看，谢谢！

microns 2008-09-08 05:23:31

public class search extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
private DBConnectionManager connMgr;
public void init(ServletConfig config) throws ServletException {
super.init(config);
connMgr=DBConnectionManager.getInstance();
}

public void service(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();

request.setCharacterEncoding("GBK");
Connection conn=connMgr.getConnection("oracle");
Statement stmt;

out.println("<html>");
out.println("<head><title>search</title></head>");
out.println("<body>");

try{
String search_name=request.getParameter("search_name");
stmt=conn.createStatement();
String sql="select frd.*,frdtype.* from friends frd,friend_type frdtype where frd.frd_type_id=frdtype.frd_type_id and frd_name like '%"+search_name+"%' ";
ResultSet rs=stmt.executeQuery(sql);
stmt.executeQuery();
int n=？？？？？？？？？？？？？？？？？;
if(n>0)
{
out.print("朋友清单");
out.print("<table border=1 align=center width=80%>");
out.print("<tr>");
out.print("<td>姓名</td><td>类型</td><td>电话</td><td>电子邮件</td>");
out.print("</tr>");
while (rs.next()) {
out.println("<tr>");
out.print("<td>");
out.print(rs.getString("frd_name"));
out.print("</td>");
out.print("<td>");
out.print(rs.getString("frd_type_name"));
out.print("</td>");
out.print("<td>");
out.print(rs.getString("frd_tele"));
out.print("</td>");
out.print("<td>");
out.print(rs.getString("frd_email"));
out.print("</td>");
out.print("</tr>");
}

}
else{
out.print("没有"+search_name+"的记录信息");
}

rs.close();
stmt.close();
conn.close();

}
catch(Exception e){
out.print("操作失败！");
e.printStackTrace();
}

out.println("</body></html>");
out.close();
}
}
我想给模糊查询加个条件，有数据记录的显示出来，没有数据记录的打印提示信息，rs记录了结果集，int n=（int） rs，这个要报错Error(41,21): cannot cast interface java.sql.ResultSet to int。这里的int n=什么啊？

...全文

41 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

suncf1985 2008-09-09

打赏
举报

建议你去一下数据库工具类 DBUtils 的类,这里边有封装好的方法!

比如:ResultSet --> ArrayList,List 这样方便一些!

qwj2006 2008-09-09

打赏
举报

结果集rs不可以直接转的。你的代码可以这样写阿！
ResultSet rs=stmt.executeQuery(sql);
stmt.executeQuery();
if(rs.next())
{
out.print(" 朋友清单 ");
out.print(" <table border=1 align=center width=80%>");
out.print(" <tr>");
out.print(" <td>姓名 </td> <td>类型 </td> <td>电话 </td> <td>电子邮件 </td>");
out.print(" </tr>");
while (rs.next()) {

}

}
else{
out.print("没有"+search_name+"的记录信息");
}

qwj2006 2008-09-09