import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Properties;
import org.apache.log4j.PropertyConfigurator;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;
-----ConfigReader.java
import com.entity.JdbcConfig;/**
* 采用单例模式解析db.xml文件
*
* @author Administrator
*
*/
@SuppressWarnings("all")
public class ConfigReader {
protected static Properties pro = null;
protected static InputStream is = null;
protected static Connection conn = null;
/**
* 懒汉式(延迟加载lazy)
*/
private static ConfigReader instance = null;
public static synchronized ConfigReader getInstance() {
if (instance == null) {
instance = new ConfigReader();
}
return instance;
}
/**
* 返回jdbc相关配置
*
* @return
*/
public JdbcConfig getJdbcConfig() {
return jdbcConfig;
}
/**
* 保存jdbc相关配置信息
*/
private JdbcConfig jdbcConfig = new JdbcConfig();
private ConfigReader() {
SAXReader reader = new SAXReader();
InputStream in = Thread.currentThread().getContextClassLoader()
.getResourceAsStream("db.xml");
try {
Document doc = reader.read(in);
// 取得jdbc相关配置信息
Element driverNameElt = (Element) doc
.selectObject("/jdbc/jdbc-info/driver-class-name");
Element urlElt = (Element) doc.selectObject("/jdbc/jdbc-info/url");
Element userNameElt = (Element) doc
.selectObject("/jdbc/jdbc-info/username");
Element passwordElt = (Element) doc
.selectObject("/jdbc/jdbc-info/password");
// 设置jdbc相关的配置
jdbcConfig.setDriver(driverNameElt.getStringValue());
jdbcConfig.setUrl(urlElt.getStringValue());
jdbcConfig.setUsername(userNameElt.getStringValue());
jdbcConfig.setPassword(passwordElt.getStringValue());
System.out.println("读取jdbcConfig-->>" + jdbcConfig);
} catch (DocumentException e) {
e.printStackTrace();
}
}
/**
* 得到配置的key
* @param key
* @return
*/
public static String getConfigKey(String key) {
String strVal = "";
try {
//这里 是在src目录下建一个application文件夹和jdbc_config.properties
is = new FileInputStream(new File(
"src/application/jdbc_config.properties"));
pro = new Properties();
pro.load(is);
PropertyConfigurator.configure(pro);
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
strVal = (String) pro.getProperty(key);
return strVal;
}
}
-------------------------------------jdbc_config.properties-----
driver=com.mysql.jdbc.Driver
url=jdbc\:mysql\://localhost\:3306/test?useUnicode\=true&characterEncoding\=utf-8
username=root
password=root
#SqlServer DataBase Connection Config
#driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
#url=jdbc:sqlserver://localhost:1433;DatabaseName=jdbc
#username=sa
#password=sa
#Oracle DataBase Connection Config
#driver=oracle.jdbc.driver.OracleDriver
#url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
#username=scott
#password=scott
----------------------------.-------db.xml----------------------------.
<?xml version="1.0" encoding="UTF-8"?>
<jdbc>
<jdbc-info>
<driver-class-name>com.mysql.jdbc.Driver</driver-class-name>
<url>jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8</url>
<username>root</username>
<password>root</password>
</jdbc-info>
<!-- <beans> -->
<!-- <bean id="com.dao.UserDao" class="com.dao.UserDao"/> -->
<!-- <bean id="com.dao.impl.UserDaoImpl" class="com.dao.impl.UserDaoImpl"/> -->
<!-- </beans> -->
<!-- Oracle配置 -->
<!--
<jdbc-info>
<driver-class-name>oracle.jdbc.driver.OracleDriver</driver-class-name>
<url>jdbc:oracle:thin:@127.0.0.1:1521:orcl</url>
<username>scott</username>
<password>scott</password>
</jdbc-info>
-->
<!-- MSSQL配置 -->
<!--
<jdbc-info>
<driver-class-name>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class-name>
<url>jdbc:sqlserver://localhost:1433;DatabaseName=jdbc</url>
<username>sa</username>
<password>sa</password>
</jdbc-info>
-->
</jdbc>
JdbcDbHelper .java
package com.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcDbHelper {
/**
* 设置单例
*/
public static JdbcDbHelper instance = new JdbcDbHelper();
/**
* 设置单例的一个实例方法
*
* @return
*/
public static JdbcDbHelper getInstance() {
if (instance == null) {
synchronized (JdbcDbHelper.class) {
instance = new JdbcDbHelper();
}
}
return instance;
}
/**
* 得到MySql连接
*
* @return
*/
public static Connection getMySqlConnection() {
Connection conn = null;
String url = "jdbc:mysql://127.0.0.1:3306/ssh?useUnicode=true&characterEncoding=utf-8";
String user = "root";
String password = "root";
String driver="com.mysql.jdbc.Driver";
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
System.out.println("连接数据库出现异常" + e.getMessage());
}
return conn;
}
/**
* 得到MMSQL连接
* @return
*/
public static Connection getMMSQLConnection() {
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=jdbc";
String user = "sa";
String password = "sa";
String Driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
Connection conn = null;
try {
Class.forName(Driver);
conn = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
System.out.println("连接数据库出现异常" + e.getMessage());
}
return conn;
}
/**
* 得到Oracle连接
* @return
*/
public static Connection getOracleConnection() {
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
String user = "scott";
String password = "scott";
String Driver="oracle.jdbc.driver.OracleDriver";
Connection conn = null;
try {
Class.forName(Driver);
conn = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
System.out.println("连接数据库出现异常" + e.getMessage());
}
return conn;
}
/***
* 释放资源...
*
* @param rs
* @param st
* @param conn
*/
public static void Relesae(ResultSet rs, Statement st, Connection conn) {
try {
if (rs != null)
rs.close();
if (st != null)
st.close();
if (conn != null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}