2025-02-10

package db;
import java.sql.*;
import java.io.*;
import java.util.Properties;
public class DBUtil{
 
 private static final String CONFIG_FILE = “db.properties”;
 private static final String SERVER_NAME = “SqlServer.Host”;
 private static final String SERVER_PORT = “SqlServer.Port”;
 private static final String SERVER_INSTANCE = “SqlServer.InstanceName”;
 private static final String SERVER_DBNAME = “SqlServer.DatabaseName”;
 private static final String SERVER_USER = “SqlServer.UserName”;
 private static final String SERVER_PWD = “SqlServer.Password”;
 private static final String SERVER_DOMAIN = “SqlServer.Domain”;
    
 private static Connection conn = null;
 private static String strHost = “”;
 private static String strInstance = “”;
 private static String strPort = “1433”;
 private static String strDbName = “”;
 private static String strUser = “”;
 private static String strPassword = “”;
 private static String strDomain = “”;
 
 
 public DBUtil(){
  Properties prop = new Properties();
  try {
      prop.load(new FileInputStream(CONFIG_FILE));
      strHost = prop.getProperty(SERVER_NAME);
      strPort = prop.getProperty(SERVER_PORT);
      strInstance = prop.getProperty(SERVER_INSTANCE);
      strDbName = prop.getProperty(SERVER_DBNAME);
      strUser = prop.getProperty(SERVER_USER);
      strPassword = prop.getProperty(SERVER_PWD);
      strDomain = prop.getProperty(SERVER_DOMAIN);
  } catch (IOException e) {
   e.printStackTrace();
  }
 
 }
 
 public void aquireConnect() throws Exception{
  try{
   Class.forName(“net.sourceforge.jtds.jdbc.Driver”);   
         conn = DriverManager.getConnection(getConnectionString());          
     }
     catch (Exception e)
     {
      System.out.println(“Connection db faild with connection string:”
             getConnectionString());
         e.printStackTrace();
        
         throw e;
     }
 }
 public void close() throws SQLException{
  conn.close();
  conn = null;
 }
 public String getConnectionString(){
  //jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;…]]
  String strConn = “jdbc:jtds:sqlserver://” strHost “:” strPort “/” strDbName;
  if(strInstance != null && strInstance.length()> 0 )
   strConn = “;instance=” strInstance “;user=” strUser “;password=” strPassword;
  else
   strConn = “;user=” strUser “;password=” strPassword;
  if(strDomain != null && strDomain.length() > 0)
   strConn = “;domain=” strDomain;
  return strConn;
 }
}

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *