userlogin.java

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

package test;
import java.sql.*;

public class userlogin {
String sDBDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String sConnStr = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=travel ";
Connection conn = null;
ResultSet rs = null;
int rs1;
public userlogin() {
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","sa"); 
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
} 
catch(SQLException ex) { 
System.err.println("执行SQL语句错误: " + ex.getMessage());
}
return rs;
}

public int executeUpdate(String sql) {
try {
conn = DriverManager.getConnection(sConnStr,"sa","sa"); 
Statement stmt = conn.createStatement();
rs1=stmt.executeUpdate(sql);
} 
catch(SQLException ex) { 
System.err.println("执行SQL语句错误: " + ex.getMessage());
}
return rs1;
}

}