java数据源的配置文件_通过读取properties文件的方式来建立JDBC数据源连接

1.Java读取properties文件建立数据源工具类：

package com.techstar.util;

import java.io.File;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.net.URL;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class DBUtil {

private static String propertyURL = "com/techstar/DBconfic/conn.property";

private static String driver = null;

private static String url = null;

private static String userName = null;

private static String pwd = null;

//初始化连接信息

static {

init();

}

static void init() {

URL connPropertyUrl = new DBUtil().getClass().getClassLoader()

.getResource(propertyURL);

java.util.Properties pros = new java.util.Properties();

try {

pros.load(new java.io.FileInputStream(new File(connPropertyUrl.getPath())));

driver = (String)pros.get("driver");

url = (String)pros.get("db.url");

userName = (String)pros.get("db.username");

pwd = (String)pros.get("db.password");

} catch (FileNotFoundException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

}

/**

* Get connection

* @return

*/

public static Connection getDBConnection() {

Connection con = null;

try {

Class.forName(driver);

con = DriverManager.getConnection(url, userName, pwd);

} catch (Exception ex) {

ex.printStackTrace();

}

return con;

}

/**

* Execute the sql

* @param sql

* @return

*/

public static String execute(String sql) {

Connection con = getDBConnection();

try {

java.sql.Statement st = con.createStatement();

java.sql.ResultSet rs = st.executeQuery(sql);

while (rs.next()) {

String lValue = rs.getString(1);

return lValue;

}

} catch (SQLException e) {

e.printStackTrace();

}

return "";

}

}

2.properties文件配置数据源：

db.dialect=org.hibernate.dialect.OracleDialect

db.driverClassName=oracle.jdbc.driver.OracleDriver

db.url=jdbc:oracle:thin:@127.0.0.1:1521:lrmora9

db.username=username

db.password=pw