JdbcUtil类:
public class JdbcUtil {
private static String driverClass = null;
private static String url = null;
private static String username = null;
private static String password = null;
private static Properties prop = new Properties();
/*私有化构造方法,禁止创建对象*/
private JdbcUtil(){}
/*静态代码块,获取连接数据库所需信息及加载数据库驱动*/
static {
try {
InputStream inputStream = Thread.currentThread().getContextClassLoader().getResourceAsStream("db.properties");
prop.load(inputStream);
driverClass = prop.getProperty("driverClassName");
url = prop.getProperty("url");
username = prop.getProperty("username");
password = prop.getProperty("password");
//加载驱动
Class.forName(driverClass);
} catch (Exception e) {
e.printStackTrace();
}
}
/*获取连接*/
public static Connection getConnection() {
try {
return DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
/*释放连接*/
public static void close(Connection con, Statement ps, ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (ps != null) {
ps.close();
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (con != null) {
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
/*执行DQL操作*/
public static <T> T executeQuery(String sql, IResultSetHandler<T> handler,Object...params) {
Connection con = null