每次连接数据库都要写一大段重复的代码,所以可以将重复的代码封装成一个JdbcUtils 类。
JdbcUtils 1.0版本(极简版,只实现简单的连接获取Connection对象)
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class JdbcUtils {
private static Properties properties = null;
//只加载一次,所以写在静态域中
static{
//读取配置文件
InputStream in = JdbcUtils.class.getClassLoader().getResourceAsStream("dbconfig.properties");
properties = new Properties();
try {
properties.load(in);
} catch (IOException e) {
throw new RuntimeException(e);
}
//加载驱动类
try{
Class.forName(properties.getProperty("driverClassName"));
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
public static Connection getConnection() throws SQLException{
return DriverManager.getConnection(
properties.getProperty("url"),
properties.getProperty("username"),
properties.getProperty("password"));
}
}