根据网上学习教程所来
使用前请先在mysql 自行创建一个名为 test的数据库
package com.itheima.utils;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ResourceBundle;
public class JDBCUtil {
//使用ResourceBundle读取资源文件
private static ResourceBundle bundle = ResourceBundle.getBundle("dbconfig");
private static String driver;
private static String url;
private static String user;
private static String password;
/*
* 静态代码块以优化
程序性能。static块可以置于类中的任何地方，类中可以有多个static
块。在类初次被加载的时候，会按照static块的顺序来执行每个static
块，并且只会执行一次。
* */
//使用静态代码块进行赋值
static {
driver = bundle.getString("DRIVER");
url = bundle.getString("URL");
user = bundle.getString("USER");
password = bundle.getString("PASSWORD");
}
/*
*
* 获取连接
*
* */
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
return conn;
}catch(Exception e) {
e.printStackTrace();
throw new RuntimeException(e);
}
}
public static void release(ResultSet rs,Statement st,Connection conn) {
if(rs!=null) {
try {
rs.close();
}catch(Exception e) {
e.printStackTrace();
}
}
if(st!=null) {
try {
st.close();
}catch(Exception e) {
e.printStackTrace();
}
}
if(conn!=null) {
try {
conn.close();
}catch(Exception e) {
e.printStackTrace();
}
}
}
}
资源文件列表
day65_ee287/.classpath , 383
day65_ee287/.project , 387
day65_ee287/.settings/org.eclipse.jdt.core.prefs , 598
day65_ee287/bin/com/itheima/dataSource/MyDataSource$1.class , 1324
day65_ee287/bin/com/itheima/dataSource/MyDataSource.class , 1697
day65_ee287/bin/com/itheima/test/DataSourceTest.class , 1198
day65_ee287/bin/com/itheima/utils/JDBCUtil.class , 1905
day65_ee287/bin/dbconfig.properties , 207
day65_ee287/lib/mysql-connector-java-5.0.0-beta-bin.jar , 474964
day65_ee287/src/com/itheima/dataSource/MyDataSource.java , 1481
day65_ee287/src/com/itheima/test/DataSourceTest.java , 656
day65_ee287/src/com/itheima/utils/JDBCUtil.java , 1635
day65_ee287/src/dbconfig.properties , 207