import java.sql.*;
public class DataBaseManager
{
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=sxgj";
String userName = "sa";
String userPwd = "";
Connection con;
ResultSet rs;
Statement stmt;
public DataBaseManager()
{
try{
Class.forName(driverName);
con=DriverManager.getConnection(dbURL, userName, userPwd);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
}
catch ( ClassNotFoundException cnfex ) {
System.err.println("Failed To Connect DataBase." );
cnfex.printStackTrace();
System.exit( 1 ); // terminate program
}
catch(SQLException sqle)
{
System.out.println(sqle.toString());
}
}
public ResultSet getResult(String strSQL)
{
try{
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余2页未读,立即下载