用完了不要关闭Connection,执行第二次sql语句,最后关闭Connection
解决方案 »
- 关于WebService的问题,都进来看看吧,不知道你们遇到过没有! 头都被它整大啦。
- Axis生成的报文不符合wsdl
- 网站之间是如何通信
- jsp显示图片问题
- 关于ajax,不进Action
- 求救高手:在jsp的表单</td></td>b表格设计中,input 的设置无效,整页的输入宽度一样长,急啊!!!!
- 在从数据库中取出一个字段,在表格中输出,我想控制一行5列的输出?请问如何可以做到?
- 如何在JB的project中添加jspsmartupload(急,在线等)
- 数据库中正常,在JSP中显示好象为十六进制数,帮忙解决
- 难道是我的jdk有问题,还是路径不对
- jsp数据库搜索代码
- 我刚学JSP,谁能告诉我JSP的编程环境?推荐给我几个!
偶买的那本书上只有:尽量不要同个页面使用多次recordset,可是米有演示代码说假如有怎么办
google搜索Connection,找了n页没发现类似代码下面偶的代码:
ResultSet rs=null;
rs=sql.executeQuery("select config_name,config_website from config ");
name=rs.getString("config_name");
website=rs.getString("config_website");
......以下省略中间的之后还是rs=sql.executeQuery("select * from mygb");
就出错
再次感谢楼上
是上面的1楼和2楼
faq区偶也大略找了一下,米发现:(((
rs=sql.executeQuery("select config_name,config_website from config ");
name=rs.getString("config_name");
website=rs.getString("config_website");
//关闭rs
rs.close();
//否则不能rs=sql.executeQuery("select * from mygb");
......以下省略中间的
rs=sql.executeQuery("select * from mygb");
.
.
.
rs.close()
//最后
conn.close()
rs=sql.executeQuery("select config_name,config_website from config ");
name=rs.getString("config_name");
website=rs.getString("config_website");
rs.close();
String mysql="select * from mygb";
rs=sql.executeQuery(mysql);
下面读取...还是8行
只用一个recordset的话就可以
这段代码在resin通过
94tomcat不行
<?xml version="1.0" encoding="GBK"?>
<%@ page contentType="text/xml;charset=GBK"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.sql.*"%>
<%//开始计时
long stime,etime,process,mypage,reccount,spage,pagecount;
Date stnow = new Date();
stime = stnow.getTime();
int recpre;
String book_id,book_type,book_name,book_sex,book_qq,book_icq,book_msn,book_email,book_hpage,book_face,book_head,book_ip,book_title,book_content,book_time,book_reply,book_replya,book_replytime,book_private;
String pages,gb_name,gb_skins,website,webname;
%>
<jsp:useBean id="sql" class="showo.showodb" scope="page"/>
<%
ResultSet rs=null;
rs=sql.executeQuery("select config_name,config_website,config_webname,config_skins,config_recpre,config_reccount from guest_config ");
gb_name=rs.getString("config_name");
gb_skins=rs.getString("config_skins");
website=rs.getString("config_website");
webname=rs.getString("config_webname");
recpre=rs.getInt("config_recpre");
reccount=rs.getInt("config_reccount");
pages=request.getParameter("page");
if (pages==null){//如果为空
mypage=1;
}
else{//转成整形
mypage=java.lang.Integer.parseInt(pages);
if (mypage<1) mypage=1;
}
//计算总页数
pagecount=(reccount+recpre-1)/recpre;
if (mypage>pagecount) mypage=pagecount;
spage=(mypage-1)*recpre;
%>
<?xml-stylesheet type='text/xsl' href='<%=gb_skins%>index.xsl'?>
<showo_gb reccount="<%=reccount%>" page="<%=mypage%>" recpre="<%=recpre%>" pagecount="<%=pagecount%>" gb_skins="<%=gb_skins%>" gb_name="<%=gb_name%>" website="<%=website%>" webname="<%=webname%>">
<%
rs.close();
String mysql="select book_id,book_type,book_name,book_sex,book_qq,book_icq,book_msn,book_email,book_hpage,book_face,book_head,book_ip,book_title,book_content,book_time,book_reply,book_replya,book_replytime,book_private from guest_book order by book_id desc limit "+ spage +","+ recpre;
rs=sql.executeQuery(mysql);
if(rs.wasNull())
{out.print("<record><id>1</id><liuyanzuozhe>酷酷叶</liuyanzuozhe><sex>男</sex><title>欢迎光临showo留言簿:)</title><reply>False</reply><homepage></homepage><email></email><qq>15031587</qq><address></address><dates>2003-11-13 11:50</dates><noopen>False</noopen></record>");}
else{
while(rs.next()) {
book_id=rs.getString("book_id");
book_name=rs.getString("book_name");
book_sex=rs.getString("book_sex");
book_title=rs.getString("book_title");
book_qq=rs.getString("book_qq");
book_time=rs.getString("book_time");
book_content=rs.getString("book_content");
book_reply=rs.getString("book_reply");
book_replya=rs.getString("book_replya");
book_replytime=rs.getString("book_replytime");
book_type=rs.getString("book_type");
%>
<gb_record>
<id><%=book_id%></id>
<type><%=book_type%></type>
<name><%=book_name%></name>
<sex><%=book_sex%></sex>
<qq><%=book_qq%></qq>
<icq></icq>
<msn></msn>
<email></email>
<hpage></hpage>
<face></face>
<head></head>
<ip></ip>
<title><![CDATA[<%=book_title%>]]></title>
<content><![CDATA[<%=book_content%>]]></content>
<time><%=book_time%></time>
<reply><%=book_reply%></reply>
<replya><![CDATA[<%=book_replya%>]]></replya>
<replytime><%=book_replytime%></replytime>
<private></private>
</gb_record>
<%}
}
sql.close();
rs.close();
Date etnow = new Date();
etime=etnow.getTime();
%>
<process><%=etime-stime%></process>
</showo_gb>
rs=sql.executeQuery("select config_name,config_website from config ");
rs.next()//这里是不是该写这个?要不然你能读出数据么?
name=rs.getString("config_name");
website=rs.getString("config_website");
rs.close();
String mysql="select * from mygb";
rs=sql.executeQuery(mysql);
其它的应该没有什么问题了,出错了,你看看错误信息怎么写的。
按照CoolAbu添加了rs.next()
还是出错
我都想把出错信息贴出来了
一想不对,没有;
写成rs.next();
之后执行正常
谢谢
可以结贴了:)
同时感谢其他的参与者,谢谢
等下我来发感谢分:)
rs.close(); 不是必须的,我del了还正常,不知道有没有什么影响???
rs.next();必须要,否则出错