simpledbsource.java

来自「有关java学习技巧的课件」· Java 代码 · 共 38 行

package onlyfun.caterpillar;

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 SimpleDBSource implements DBSource {
    private Properties props;
    private String url;
    private String user;
    private String passwd;

    public SimpleDBSource() throws IOException, ClassNotFoundException {
        this("jdbc.properties");
    }
	
    public SimpleDBSource(String configFile) throws IOException, ClassNotFoundException {
        props = new Properties();
        props.load(new FileInputStream(configFile));
		
        url = props.getProperty("onlyfun.caterpillar.url");
        user = props.getProperty("onlyfun.caterpillar.user");
        passwd = props.getProperty("onlyfun.caterpillar.password");
		
        Class.forName(props.getProperty("onlyfun.caterpillar.driver"));
	}

    public Connection getConnection() throws SQLException {
        return DriverManager.getConnection(url, user, passwd);
    }
    
	public void closeConnection(Connection conn) throws SQLException {
		conn.close();
    }
}