注册 登录
编程论坛 J2EE论坛

一个jsp界面不能同时有两个Statement对象????

zq1983 发布于 2007-04-09 17:19, 834 次点击

<%@ page language="java" contentType="text/html; charset=gbk"
pageEncoding="gbk"%>
<%@ page import="java.sql.*"%>
<%
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;

Statement stmtCount= conn1.createStatement();
ResultSet rsCount =stmtCount.executeQuery("select count(*) from dingdan");

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:firstdb";
conn = DriverManager.getConnection(url,"admin3","admin3");
stmt=conn.createStatement();
String sql="SELECT Top "+pageSize+" * FROM dingdan WHERE Id not in (select top "+startPos+" Id From dingdan Order By ID)Order By ID";
rs=stmt.executeQuery(sql);
while(rs.next()){
.............................................................
}
rs.close();
stmt.close();
conn.close();

%>
这是我的部分代码,运行后是"500错误",java.lang.NullPointerException

当我把stmtCount和rsCount删除后页面就能正常的显示了,我觉得是不是我用的驱动的问题.大家帮帮忙

3 回复
#2
风月_无边2007-04-09 17:38
你就没有建立连接,当然会事空指针异常了
#3
支离破碎2007-04-09 17:50
conn1哪来的
#4
zq19832007-04-09 18:28

那个conn1写错了,原因就象1楼说的,谢谢2位

1