?? dbconnectionmanager.java
字號:
package electric.electricUtils;import java.sql.*;import java.io.*;import java.util.*;public class DbConnectionManager { private static String propFileName = FinalConstants.PATH_DBPROP; private static Properties prop = new Properties(); private static String dbClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; private static String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=YWW"; private static String dbUsr = "sa"; private static String dbPwd = ""; private static void loadProperty() { try { prop.load(new FileInputStream(propFileName)); dbClassName = prop.getProperty("DB_CLASS_NAME"); dbUrl = prop.getProperty("DB_URL", "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=YWW"); dbUsr = prop.getProperty("DB_USR", "sa"); dbPwd = prop.getProperty("DB_PWD", ""); } catch (Exception e) { e.printStackTrace(); } } public static Connection getConnection() { Connection con = null; loadProperty(); try { Class.forName(dbClassName).newInstance(); con = DriverManager.getConnection(dbUrl, dbUsr, dbPwd); } catch (Exception ee) { ee.printStackTrace(); } if (con == null) { System.err.println( "警告: DbConnectionManager.getConnection() 獲得數據庫鏈接失敗.\r\n\r\n鏈接類型:" + dbClassName + "\r\n鏈接位置:" + dbUrl + "\r\n用戶/密碼" + dbUsr + "/" + dbPwd); } return con; }/* public static void main(String[] args) { Connection conn = getConnection(); System.out.println(conn.toString()); try { conn.close(); conn = null; } catch (Exception e) { } } */ }
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -