dbfactory.java

来自「该源代码实现乐拖拽树的功能」· Java 代码 · 共 60 行

package com.dt.test.mytree;

import java.io.BufferedReader;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBFactory {
	
	public DBFactory(){}
	
	public static Connection getConn(){
		
		String jdbcURL=null;
		String jdbcDriver=null;
		String user=null;
		String password=null;
		BufferedReader reader=null;
		Connection conn=null;
		
		try {
			reader=new BufferedReader(new FileReader("D:/workspace/richfaces4/dbconfig.properties"));
			jdbcURL=reader.readLine();
			jdbcDriver=reader.readLine();
			user=reader.readLine();
			password=reader.readLine();
			Class.forName(jdbcDriver);
			conn=DriverManager.getConnection(jdbcURL, user, password);
		} catch (Exception e) {
			e.printStackTrace();
			try {
				reader.close();
			} catch (IOException e1) {
				e1.printStackTrace();
			}
		}finally{
			try {
				reader.close();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		return conn;
	}
	
	public static void closeConn(Connection conn){
		if(conn!=null){
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
}