packagedatabase;importjava.sql.*;/***@authorAdministrator
**/publicclassDBAccess {privateConnection m_conn;privateStatement m_stmt;
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;databasename=sc";
String uName="sa";
String uPwd="sa";/****/publicDBAccess() {this.setDriver(driver);this.setConnection(url, uName, uPwd);
}publicDBAccess(String driver, String url, String userName, String userPWD) {try{
m_conn=DriverManager.getConnection(url, userName, userPWD);
m_stmt=m_conn.createStatement();
}catch(SQLException e) {
e.printStackTrace();
}
}publicbooleansetDriver(String driver) {try{
Class.forName(driver);returntrue;
}catch(Exception e) {
e.printStackTrace();
}returnfalse;
}publicbooleansetConnection(String url, String userName, String userPWD) {try{
m_conn=DriverManager.getConnection(url, userName, userPWD);
m_stmt=m_conn.createStatement();returntrue;
}catch(Exception e) {
e.printStackTrace();
}returnfalse;
}//处理查询publicResultSet sendQuery(String sql) {try{
ResultSet m_rs=m_stmt.executeQuery(sql);returnm_rs;
}catch(SQLException e) {
e.printStackTrace();returnnull;
}
}//处理数据更新publicintsendUpdate(String sql) {try{returnm_stmt.executeUpdate(sql);
}catch(SQLException e) {
e.printStackTrace();return-1;
}
}//测试程序publicstaticvoidmain(String[] arg) {
DBAccess db=newDBAccess();
String sql="select * from Student";
ResultSet rs=db.sendQuery(sql);try{if(rs!=null) {while(rs.next()) {
System.out.println(rs.getInt("Sno")+""+rs.getString("Sname"));
}
}
}catch(SQLException e) {
e.printStackTrace();
}
}
}