java用配置文件怎么连接mysql_Java通过配置文件连接Mysql和Oracle数据库实例详解

Java通过配置文件连接Mysql和Oracle数据库实例详解

--------------------------------------------------

配置文件： db.properties

#Mysql parameter

mysqldriver=com.mysql.jdbc.Driver

mysqlurl=jdbc:mysql://127.0.0.1:3306/database

mysqluser=username

mysqlpassword=password

#Oracle Parameter

oracledriver=oracle.jdbc.driver.OracleDriver

oracleurl=jdbc:oracle:thin:@127.0.0.1:1521:ORCL

oracleuser=username

oraclepassword=password

---------------------------------------------------

package service;

import java.io.File;

import java.io.FileInputStream;

import java.io.IOException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.Properties;

public class DBManagerService {

private Properties prop;

private Connection conn;

public Connection getMyslqConnection(){

prop = new Properties();

try {

prop.load(new FileInputStream("config"+File.separator+"db.properties"));

// prop.load(this.getClass().getClassLoader().getResourceAsStream("config/db.properties"));

} catch (IOException e1) {

e1.printStackTrace();

}

/*two method to connect to Mysql

*

* String url ="jdbc:mysql://localhost/jeff?user=boehf&password=boehf&useUnicode=true&characterEncoding=8859_1";

* conn = DriverManager.getConnection(url);

*/

String driver = prop.getProperty("mysqldriver");

String url = prop.getProperty("mysqlurl");

String user = prop.getProperty("mysqluser");

String passwd = prop.getProperty("mysqlpassword");

try {

Class.forName(driver);

conn = DriverManager.getConnection(url, user, passwd);

System.out.println("Mysql Connected Success!");

} catch (SQLException e) {

System.err.println("sql exception:" + e.getMessage());

} catch (ClassNotFoundException e) {

System.err.println("Driver Class not found " + e.getMessage());

}

return conn;

}

public Connection getMOracleConnection(){

prop = new Properties();

try {

prop.load(new FileInputStream("config"+File.separator+"db.properties"));

} catch (IOException e1) {

e1.printStackTrace();

}

String driver = prop.getProperty("oracledriver");

String url = prop.getProperty("oracleurl");

String user = prop.getProperty("oracleuser");

String passwd = prop.getProperty("oraclepassword");

try {

Class.forName(driver);

conn = DriverManager.getConnection(url, user, passwd);

System.out.println("Oracle Connected Success!");

} catch (SQLException e) {

System.err.println("sql exception:" + e.getMessage());

} catch (ClassNotFoundException e) {

System.err.println("Driver Class not found " + e.getMessage());

}

return conn;

}

/**

* 关闭数据库连接

*

* @param connect

*/

public void closeConnection(Connection conn) {

try {

if (conn != null) {

/** 判断当前连接连接对象如果没有被关闭就调用关闭方法 */

if (!conn.isClosed())