深入浅出Java Dom4j读取XML(二)

定义的实体集的类：JdbcConfig.java

package conn.lishehe.drp.util;
/**
 * Jdbc
 * @author lishe
 *
 */
public class JdbcConfig {
	
	private String driverName;
	public String getDriverName() {
		return driverName;
	}
	public void setDriverName(String driverName) {
		this.driverName = driverName;
	}
	public String getUrl() {
		return url;
	}
	public void setUrl(String url) {
		this.url = url;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	private String url;
	private String userName;
	private String password;
	@Override
	public String toString() {
		return this.getClass().getCanonicalName() + "{driverName:" + driverName + ", url:" + url + ", userName:" + userName + "}";
	}

}

数据处理层：DbUtil.java

package conn.lishehe.drp.util;

import java.sql.Connection;
import java.sql.DriverManager;

/**
 * 封装数据库常用操作
 * @author 李社河
 */
public class DbUtil {
	/**
	 * 取得Connection
	 * @return
	 * @throws ClassNotFoundException 
	 */
	public static Connection getConnection() throws ClassNotFoundException{
	/*	Connection conn = null;
	try {
		Class.forName("oracle.jdbc.driver.OracleDriver");
		String url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
		String username = "";
		String password = "";
		conn = DriverManager.getConnection(url, username,password);
		
	} catch (Exception e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
		return conn;*/
		Connection conn = null;
		try {
			JdbcConfig jdbcConfig = XmlConfigReader.getInstance().getJdbcConfig();
			Class.forName(jdbcConfig.getDriverName());

			conn = DriverManager.getConnection(jdbcConfig.getUrl(), jdbcConfig.getUserName(),jdbcConfig.getPassword());
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
			return conn;
		
	}
	public static void main(String[] args){
		try {
			//测试获取到相应的配置文件的信息，打出来
			System.out.println(DbUtil.getConnection());
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
		

}