动态配置文件写法

src根目录下写一个自定义属性文件：test.properties

dbName = org.postgresql.DriverURL = jdbc:postgresql://192.168.13.47:5432/pdosmodname = postgrespass = postgres

 

利用Java自带的util读文件

package com.nfschina.test;import java.io.IOException;import java.util.Properties;public class ReadPorperties {public static String CLASSNAME;public static String DBURL;public static String USERNAME;public static String PASSWORD;public static Properties properties;static {properties = new Properties();try {properties.load(Object.class.getResourceAsStream("/connection.properties"));} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}CLASSNAME = (String) properties.get("dbName");DBURL = (String) properties.get("URL");USERNAME = (String) properties.get("name");PASSWORD = (String) properties.get("pass");}}  

用个java引用该文件就OK了

Just Easy.

package com.nfschina.test;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class DBUtil {public static Connection getConnection() throws SQLException {System.out.println(ReadPorperties.CLASSNAME);try {Class.forName(ReadPorperties.CLASSNAME);} catch (ClassNotFoundException e) {e.printStackTrace();}return DriverManager.getConnection(ReadPorperties.DBURL, ReadPorperties.USERNAME,ReadPorperties.PASSWORD);}public static void closeConnection(Connection conn) throws SQLException {conn.close();}public static void main(String[] args) {try {String sql = "SELECT * FROM message";Connection conn = getConnection();Statement st = conn.createStatement();ResultSet rs = st.executeQuery(sql);while (rs.next()) {System.out.println(rs.getString("m_message"));}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}