数据库连接模板

数据库连接模板

数据库连接模板，通过读取properties文件中的数据库连接信息，连接数据库，通过JDBCConnector获取连接，具体实现如下：
JDBCConfig.java从同路径下的jdbc.properties文件中读取配置

public class JDBCConfig {

    public String getUrl(){
        return this.getProperty("url");
    }

    public String getDriverClassName(){
        return this.getProperty("driver_class");
    }
    public String getUserName(){
        return this.getProperty("username");
    }
    public String getPassword(){
        return this.getProperty("password");
    }
    private String getProperty(String property){
        String resources="jdbc.properties";
        InputStream inputStream=this.getClass().getResourceAsStream(resources);
        Properties properties=new Properties();
        try {
            properties.load(inputStream);
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            try {
                inputStream.close();
            } catch (IOException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        property=properties.getProperty(property);
        return property;
    }
}

JDBCConnector.java通过读取的配置获取连接

public class JDBCConnector {
    public static Connection getConnection(){
        Connection conn=null;
        JDBCConfig jc=new JDBCConfig();
        String url=jc.getUrl();
        String username=jc.getUserName();
        String password=jc.getPassword();

        try {
            Class.forName(jc.getDriverClassName());
            conn=DriverManager.getConnection(url,username,password);

        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        return conn;
    }
}

方法调用：

Connection conn=null;
conn=JDBCConnector.getConnection();