package com.gdh.util;
import java.sql.*;
public class DBUtil {
private static String driverClassName="com.mysql.jdbc.Driver"; //数据库驱动类
private static String url="jdbc:mysql://localhost:3306/code?characterEncoding=utf-8";
private static String username="root";
private static String password="abc123";
static{
try {
Class.forName(driverClassName);
} catch (ClassNotFoundException e) { //如果找不到这个类,就执行下面异常处理
System.out.println("驱动程序配置未配置成功");
}
}
public static Connection getConnection(){ //创建连接
try {
return DriverManager.getConnection(url,username,password);
} catch (SQLException throwables) {
throwables.printStackTrace();
}
return null;
}
public static void close(ResultSet rs, PreparedStatement pstmt,Connection conn ){
try {
if (rs != null){
rs.close();
}
if (pstmt != null){
pstmt.close();
}
if (conn != null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(Connection conn, PreparedStatement pstmt){
try {
if (pstmt != null){
pstmt.close();
}
if (conn != null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
//测试连接是否成功
// public static void main(String[] args) {
// System.out.println(DBUtil.getConnection());
// }
}
DBUtils工具类
最新推荐文章于 2024-05-11 10:33:42 发布