import java.sql.*;
/**
* @function 建立与MSSQL数据连接
* @author 蝈蝈
* @date 2008-08-02
*/
public class MainConnection {
private static final String DRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
private static final String USER ="sa";
private static final String PASS = "";
private static Connection conn;
private Statement ps;
private ResultSet rs;
private int resultCount;
public void MainConnection(){
if(MainConnection.conn==null){
MainConnection.getConnection();
}
}
public static Connection getConnection(){
System.out.println("连接中...");
try {
Class.forName(MainConnection.DRIVER);
conn = DriverManager.getConnection(MainConnection.URL, MainConnection.USER, MainConnection.PASS);
System.out.println("成功连接");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void closeConnection(){
System.out.println("关闭连接中...");
try {
if (conn != null) {
conn.close();
System.out.println("已关闭Connection");
}
}catch(Exception e){
// TODO: handle exception
}
}
public ResultSet getResultSet(){
System.out.println("查询结果为:");
return rs;
}
public ResultSet getQuery(String sql){
System.out.println("执行select SQL语句中...");
try {
ps = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
rs = ps.executeQuery(sql);
System.out.println("执行完查询操作,结果已返回ResultSet集合");
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
public int getUpdate(String sql){
System.out.println("执行insert,update,delete SQL语句中...");
try {
ps = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
resultCount = ps.executeUpdate(sql);
System.out.println("执行完查询操作,结果已返回resultCount集合");
} catch (SQLException e) {
e.printStackTrace();
}
return resultCount;
}
public int getResultCount(){
return resultCount;
}
}