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