JAVA读取db.properties文件
整理整理基础,JAVA读取db.properties文件连接数据库
1.PropUtil
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