login.java

固定资产管理系统 固定资产管理系统 固定资产管理系统gudingzichanguanlixitong

import java.sql.*;

public class login {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:bookserver";
Connection conn = null;
ResultSet rs = null;

public login() {
try {
Class.forName(sDBDriver); 
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("数据库连接问题：" + e.getMessage());
}
}

public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr,"sa","zst"); 
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
} catch(SQLException ex) { 
System.err.println("数据库操作问题: " + ex.getMessage());
}
return rs;
}

}