java jdbc closed_Java开发网 - JDBC Object has been closed

Posted by:huajiazhou

Posted on:2005-05-21 23:55

ＪＡＶＡＢＥＡＮ连接数据库的代码！

import java.sql.*;

import java.lang.*;

public class sqlBean{

public Connection conn=null;

public ResultSet rs=null;

private String DatabaseDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";

private String DbConnStr="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mis";

private String User="sa";

private String Pswd="5696285";

public void setDatabaseDriver(String dbDriver){

this.DatabaseDriver=dbDriver;

}

public void setDatabaseConnStr(String ConnStr){

this.DbConnStr=ConnStr;

}

public void setUser(String user){

this.User=user;

}

public void setPassword(String pwd){

this.Pswd=pwd;

}

public String getDatabaseDriver(){

return (this.DatabaseDriver);

}

public String getDatabaseConnStr(){

return (this.DbConnStr);

}

// constructor

public sqlBean(){

try{

Class.forName(DatabaseDriver);//.newInstance();

}catch(ClassNotFoundException e){

System.out.println("Load DB Driver Error:"+e.getMessage());

}

try{

conn = DriverManager.getConnection(DbConnStr,User,Pswd);

}catch(Exception ex){

System.out.println("Query Error:"+ex.getMessage());

}

}

public int executeInsert(String sql){

int num=0;

try{

Statement stmt=conn.createStatement();

num=stmt.executeUpdate(sql);

}catch(SQLException ex){

System.out.println("Insert Data Error:"+ex.getMessage());

}

CloseDataBase();

return num;

}

public ResultSet executeQuery(String sql){

rs=null;

try{

Statement stmt=conn.createStatement();

rs=stmt.executeQuery(sql);

}catch(SQLException ex){

System.out.println("Query Error:"+ex.getMessage());

}

CloseDataBase();

return rs;

}

public int executeDelete(String sql){

int num=0;

try{

//conn = DriverManager.getConnection(DbConnStr,User,Pswd);

Statement stmt=conn.createStatement();

num=stmt.executeUpdate(sql);

}catch(SQLException ex){

System.out.println("Delete Data Error:"+ex.getMessage());

}

CloseDataBase();

return num;

}

// Close the DB

public void CloseDataBase(){

try{

conn.close();

}catch(Exception end){

System.out.println("Can not close the DB:"+end.getMessage());

}

}

}

编译没错，但是实际运用在ＪＳＰ里面后提示java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed. 的错误！

请大家指教啊！这个问题搞的我想自杀，一直解决不了！