java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.解决方法!
package fixedassets;
import java.sql.*;
import javax.swing.tree.DefaultMutableTreeNode;
public class JDBC {
Statement st=null;
ResultSet rs2=null;
ResultSet rs=null;
public JDBC() {
try {
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ");
Connection con = DriverManager.getConnection( "jdbc:microsoft:sqlserver://localhost:1433;databaseName=AssetsManage ", "sa ", "sa ");
st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
} catch (Exception ex) {
ex.printStackTrace();
}
}
public ResultSet yan(String s,String s1) {//验证用户名和密码
ResultSet rsa=null;
try {
rsa = st.executeQuery( "select *from operater where ID= ' "+s+ " 'and PassWord= ' "+s1+ " ' ");
} catch (SQLException ex) {
ex.printStackTrace();
}
return rsa;
}
public int chaxun(String s,int i) {//查询数据
try {
if(i==0) {//以资产编号查询
clear();
rs = st.executeQuery( "select *from asset where aId= "+s);
}else if(i==1) {//以资产名称查询
clear();
rs = st.executeQuery( "select *from asset where aName= ' "+s+ " ' ");
}
if(rs.next()) {
zhi();
}
} catch (SQLException ex) {
ex.printStackTrace();
}
return 0;
}
/*错误就在这个方法里,上面的chaxun()方法调用本方法来把查询出来的信息显示在文本框内,第一次调用时信息都可以提出来没问题,但是我想做一个导航条,可以通过按钮点击来查看数据,所以我在另外一个类里做了一个按钮事件,当点击时就zhi()这个方法,就在这里就报异常了,异常如下:
