JAVA讀取db.properties檔案

整理整理基礎，JAVA讀取db.properties檔案串連資料庫

1.PropUtil

package xxxx;import java.io.BufferedInputStream;import java.io.FileInputStream;import java.io.InputStream;import java.util.Properties;/** * PropUtil *  * put the DB.properties[many] under src folder *  * @since 2012.8.30 * @author dml *  */public class PropUtil {private String filePath = null;public PropUtil(String fileName) {this.filePath = getClass().getClassLoader().getResource("/").getPath()+ fileName;// fixed tomcat readpath problem dml@2012.9.12filePath = filePath.replaceAll("%20", " ");}public Properties getProp() {Properties prop = new Properties();try {InputStream in = new BufferedInputStream(new FileInputStream(filePath));prop.load(in);in.close();} catch (Exception err) {err.printStackTrace();}return prop;}}

2.DBUtil

package xxxx;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;/** *  * DBUtil *  * @author dml * @since2012.8.27 */public class DBUtil {public static Connection getConnect() {PropUtil pu = new PropUtil("DB.properties");Properties p = pu.getProp();Connection con = null;try {String url = p.getProperty("url");String Driver = p.getProperty("driver");String user = p.getProperty("userName");String pwd = p.getProperty("password");Class.forName(Driver);con = DriverManager.getConnection(url, user, pwd);if (con == null) {System.out.println("can not find con");}} catch (Exception e) {System.out.println("conn bad!");e.printStackTrace();}return con;}public static Connection getRomoteConnect() {PropUtil pu = new PropUtil("Romote_DB.properties");Properties p = pu.getProp();Connection con = null;try {String url = p.getProperty("url");String Driver = p.getProperty("driver");String user = p.getProperty("userName");String pwd = p.getProperty("password");Class.forName(Driver);con = DriverManager.getConnection(url, user, pwd);if (con == null) {System.out.println("can not find con");}} catch (Exception e) {System.out.println("conn bad!");e.printStackTrace();}return con;}public static void rsClose(ResultSet rs) {try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}public static void stmtClose(Statement stmt) {try {stmt.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}public static void connClose(Connection conn) {try {if (conn != null) {conn.close();}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}

3.db.properties

driver=com.microsoft.sqlserver.jdbc.SQLServerDriverurl=jdbc\:sqlserver\://127.0.0.1\:1433;databaseName\=masteruserName=sapassword=xxxx

4.xxxxHandle

package xxxx;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.logging.Logger;import xxxx.DBUtil;/** *  *  * <p> * Title: 組資訊 /p> *  * <p> * Description: 樣本 業務類 * </p> *  * <p> * Copyright: Copyright (c) 2012 * </p> *  * @author dml@2013-1-14 * @version 1.0 */public class GroupHandle {private static Connection conn = null;private static Statement stmt = null;private static ResultSet rs = null;private static Logger log = Logger.getLogger("log4j.properties");public static String queryGroupNum() {try {stmt = DBUtil.getConnect().createStatement();} catch (SQLException e) {e.printStackTrace();}String groupNum = "";String strSQL = "select count(*) as groupNum from xxxx";try {rs = stmt.executeQuery(strSQL);while (rs.next()) {groupNum = rs.getString("groupNum");}log.info(strSQL);} catch (SQLException e) {e.printStackTrace();} finally {DBUtil.rsClose(rs);DBUtil.stmtClose(stmt);DBUtil.connClose(conn);}return groupNum;}}

完

dml@2013.1.15