JDBC连接数据库小工具写法分享

import java.io.IOException;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.util.Properties;

 

public class JdbcUtils {

private static Properties props = null;

//只在

static{

//只在JdbcUtils类被加载时执行一次！

try{

//加载配置文件

InputStream in = JdbcUtils.class.getClassLoader()

.getResourceAsStream("dbconfig.properties");

props = new Properties();

props.load(in);

}catch(IOException e){

throw new RuntimeException(e);

}

try{

//加载驱动类

Class.forName(props.getProperty("driverClassName"));

}catch(ClassNotFoundException e){

throw new RuntimeException(e);

}

}

public static Connection getConnection() throws Exception{

/*

* 1.加载配置文件

* 2.加载驱动类

* 3.调用DriverManager.getConnection()

*/

//得到Connection

return DriverManager.getConnection(props.getProperty("url"),

props.getProperty("username"),

props.getProperty("password"));

}

}