读书人

JAVA读取db.properties资料

发布时间: 2013-01-19 11:41:36 作者: rapoo

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



读书人网 >其他数据库

热点推荐