mysql的sqlbean_关于用javabean连接mysql的问题！急！！！！！在线等解答

做一个成绩管理系统，先登陆，然后通过servelt进行检查我觉得问题出现在了check.java里面的代码太长贴不上sqlbean.java的代码：packagebean;importjava.sql.*;importjava.io.*;public...

做一个成绩管理系统，先登陆，然后通过servelt进行检查

我觉得问题出现在了check.java里面的代码太长贴不上

sqlbean.java的代码：

package bean;

import java.sql.*;

import java.io.*;

public class sqlBean {

public Connection conn=null;

public ResultSet rs=null;

Statement st=null;

public sqlBean(){

try{

Class.forName("com.mysql.jdbc.Driver");

String url="jdbc:mysql://localhost:3306/stu_score_ms?user=root&password=root&useUnicode=true&characterEncoding=utf8";

conn=DriverManager.getConnection(url);

st=conn.createStatement(1004,1008);

}

catch(java.lang.ClassNotFoundException e){

System.err.println("加载驱动器有错误:"+e.getMessage());

System.out.print("执行插入有错误:"+e.getMessage());//输出到客户端

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public int executeInsert(String sql){

int num=0;

try{

num=st.executeUpdate(sql);

}

catch(SQLException e){

System.err.println("执行插入有错误:"+e.getMessage());

System.out.print("执行插入有错误:"+e.getMessage());

}

return num;

}

public ResultSet executeQuery(String sql){

rs=null;

try{

rs=st.executeQuery(sql);

}

catch(SQLException e){

System.err.println("执行查询有错误:"+e.getMessage());

System.out.print("执行查询有错误:"+e.getMessage());//输出到客户端

}

return rs;

}

public int Update(String sql){

int num=0;

try{

num=st.executeUpdate(sql);

}catch(SQLException ex){

System.err.println("执行修改有错误："+ex.getMessage());

System.out.print("执行修改有错误："+ex.getMessage());//输出到客户端

}

return num;

}

public int executeDelete(String sql){

int num=0;

try{

num=st.executeUpdate(sql);

}

catch(SQLException e){

System.err.println("执行删除有错误:"+e.getMessage());

System.out.print("执行删除有错误:"+e.getMessage());

}

CloseDataBase();

return num;

}

public void CloseDataBase(){

try{

conn.close();

st.close();

}

catch(Exception ex){

System.err.println("执行关闭Connection对象有错误:"+ex.getMessage());

System.out.print("执行关闭Connection对象有错误:"+ex.getMessage());

}

}

}

这是错误提示，请问怎么解决

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

java.lang.NullPointerException

bean.sqlBean.executeQuery(sqlBean.java:38)

servlet.check.doGet(check.java:61)

servlet.check.doPost(check.java:118)

javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.

展开