请各位帮帮忙.这是源码:
package bean.db.common;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class dbOpertaion {
/**
* ִ��SQL��ѯ���
*/
public ResultSet executeQuery(String sqlString){
if(sqlString==null) return null;
Connection conn=openDB();
ResultSet rs=null;//����¼��
Statement sql=null;//SQL������
try{
sql=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery(sqlString);
return rs;
} catch (SQLException e) {
e.printStackTrace();
rs=null;
}
closeDB(conn);
return rs;
}
/**
* ִ��SQL�������,����Ӱ�������
*/
public int executeUpdate(String sqlString){
if(sqlString==null) return 0;
Connection conn=openDB();
Statement sql=null;//SQL������
int i=0;//Ӱ�������
try{
sql=conn.createStatement();
i=sql.executeUpdate(sqlString);
} catch (SQLException e) {
e.printStackTrace();
i=0;
}
closeDB(conn);
return i;
}
/**
* ����ݿ�l��
*/
public Connection openDB(){
dbconn dbconnOBject=new dbconn();//��ݿ�l�Ӷ���
Connection dbconn=dbconnOBject.getDBConn();//�õ���ݿ�l��
return dbconn;
}
/**
* �ر���ݿ�l��
*/
public void closeDB(Connection conn){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
运行之后报错:java.lang.NullPointerException
bean.db.common.dbOpertaion.executeQuery(dbOpertaion.java:17)
bean.db.bookTypeOPBean.<init>(bookTypeOPBean.java:18)
org.apache.jsp.banner_jsp._jspService(banner_jsp.java:105)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
org.apache.jsp.index_jsp._jspService(index_jsp.java:81)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
package bean.db.common;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class dbOpertaion {
/**
* ִ��SQL��ѯ���
*/
public ResultSet executeQuery(String sqlString){
if(sqlString==null) return null;
Connection conn=openDB();
ResultSet rs=null;//����¼��
Statement sql=null;//SQL������
try{
sql=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery(sqlString);
return rs;
} catch (SQLException e) {
e.printStackTrace();
rs=null;
}
closeDB(conn);
return rs;
}
/**
* ִ��SQL�������,����Ӱ�������
*/
public int executeUpdate(String sqlString){
if(sqlString==null) return 0;
Connection conn=openDB();
Statement sql=null;//SQL������
int i=0;//Ӱ�������
try{
sql=conn.createStatement();
i=sql.executeUpdate(sqlString);
} catch (SQLException e) {
e.printStackTrace();
i=0;
}
closeDB(conn);
return i;
}
/**
* ����ݿ�l��
*/
public Connection openDB(){
dbconn dbconnOBject=new dbconn();//��ݿ�l�Ӷ���
Connection dbconn=dbconnOBject.getDBConn();//�õ���ݿ�l��
return dbconn;
}
/**
* �ر���ݿ�l��
*/
public void closeDB(Connection conn){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
运行之后报错:java.lang.NullPointerException
bean.db.common.dbOpertaion.executeQuery(dbOpertaion.java:17)
bean.db.bookTypeOPBean.<init>(bookTypeOPBean.java:18)
org.apache.jsp.banner_jsp._jspService(banner_jsp.java:105)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
org.apache.jsp.index_jsp._jspService(index_jsp.java:81)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
解决方案 »
- 关于spring mvc事务管理
- jstl循环一行两列求解
- 公司物流系统数据库该如何选择?
- html 小问题,file标签
- jsp页面中的下拉框在选择刷新后如何定位到刷新前的那个值呀??
- 如何一次操作页面上的相同元素?
- 急啊!!!一个菜鸟问题昨天提了没人回答!再发一遍,摆托!!!一定要帮忙啊!!!
- java 用RSA解码 .net发送过来的密文 报:Data must start with zero
- 疯了……,用jsp连接SQL SERVER数据库问题,请大家帮忙,不然真的疯了,广州就又多了一个精神病患者。
- 一个关于链接的小问题
- 已经搞了两天,MyEclipse里开发struts,总是找不到标签文件
- 怎样使Applet在IE中不加任何插件能正常运行?
executeQuery()方法17行出错,应该是你的sql 连接没获取到
在那里看看有无能回答你的,谢谢,LZ,甭忘了给俺分哦,谢谢LZ