建立与MSSQL数据连接

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;
     }
}