connectpool.java

uliu liuoulo p hp pi ij jp

package conn;
import java.sql.*;
public class ConnectPool{
     private static Connection  con = null;
     private static final String url = "jdbc:microsoft:sqlserver://";
     private static final String serverName= "localhost";
     private static final String portNumber = "1898";
     private static final String databaseName= "user";
     private static final String userName = "sa";
     private static final String password = "LycGxy0422";
     private static final String selectMethod = "cursor";
     private ConnectPool(){}

     private static String getConnectionUrl(){
          return url+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectMethod+";";
     }

     public static Connection getConnection1(){
         if(con==null) {
	    	 try{
	        	  Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
	               con = java.sql.DriverManager.getConnection(getConnectionUrl(),userName,password);
	          }catch(Exception e){
	               e.printStackTrace();
	               System.out.println("Error Trace in getConnection() : " + e.getMessage());
	         }
         }
         return con;
      }

     public static void closeConnection(){
          try{
               if(con!=null)
                    con.close();
               con=null;
          }catch(Exception e){
               e.printStackTrace();
          }
     }
}