[jdbc] get mssql Connection

//jdk1.4
//需要sqlserver.jar

//jar包的下载地址参考：文章【ms sql server drive for java 下载地址 】
package com.sehz.skmps.db.mssql.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class GcsConnection {

 public Connection conn = null;
 
 public GcsConnection() {
  if(conn == null){
   try
   {
       this.conn = getDBConnection();
   }
   catch (SQLException se)
   {
    
   }
   catch (ClassNotFoundException ce)
   {
    
   }
  }
 }
 
 public GcsConnection(String user, String password) throws SQLException,ClassNotFoundException  {
  if(conn == null){
   this.conn = getDBConnection(user, password);
  }
 }
 
 public Connection getDBConnection() throws SQLException,ClassNotFoundException {
  return getDBConnection("sa", "1111");
 }
 
    public Connection getDBConnection(String user, String password) throws SQLException,ClassNotFoundException
    {
     if(this.conn == null){
      String strUrl = "jdbc:sqlserver://localhost:1433;DatabaseName=TEST";
 
         String strUser = user;
         String strPassword = password;
         //Connection conn = null;
         try
         {
             String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";//ojdbc14.jar
            
             Class.forName(driverName);
             this.conn = DriverManager.getConnection(strUrl, strUser, strPassword);
         }
         catch (SQLException e)
         {
             e.printStackTrace();
             throw e;
         }
         catch (ClassNotFoundException cnfe)
         {
          cnfe.printStackTrace();
          throw cnfe;
         }
     }
        return this.conn;
    }
 
 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO Auto-generated method stub

 }

}