JDBC工具类
- 使用JDBC连接数据库时经常会写许多重复的代码,将这些代码封装到一个工具类中,有利于我们提高写代码的效率。
封装一个JDBC工具类
public class JDBCUtils {
private static final Logger Log = Logger.getLogger(JDBCUtils.class);
private static String DRIVER;
private static String URL;
private static String USERNAME;
private static String PASSWORD;
static {
InputStream is = JDBCUtils.class.getResourceAsStream("/jdbc.properties");
Properties prop = new Properties();
try {
prop.load(is);
DRIVER = prop.getProperty("jdbc.driver");
URL = prop.getProperty("jdbc.url");
USERNAME = prop.getProperty("jdbc.username");
PASSWORD = prop.getProperty("jdbc.password");
} catch (Exception e) {
Log.error("配置文件加载异常:" + e);
}
}
private static Connection conn;
public JDBCUtils() {
}
public static Connection getConnection() {
try {
Class.forName(DRIVER);
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
} catch (Exception e) {
Log.error("建立链接失败:" + e);
}
return conn;
}
public static void releaseConn() {