package JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* @descibe
* @author xiaojian
* @date 2020年7月1日
*/
public class Dutil {
// 设置数据源的四要素 驱动 连接 账户 密码
private static final String Driver = "com.mysql.jdbc.Driver";
private static final String URL = "jdbc:mysql://localhost:3306/lol"; //lol是数据库名
private static final String UNAME = "root"; //root是MySQL账号
private static final String UPWD = "123456"; //数据库密码
/*
* 1. 加载数据库驱动
*/
static {
try {
Class.forName(Driver);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/*
* 2. 获得数据库连接
*/
//public static Connection getConnection() throws SQLException {
//return DriverManager.getConnection(URL, UNAME, UPWD);
//}
//Connection连接做一个优化,把异常解决掉
public static Connection getConnection() {
Connection conn = null;
try {
conn = DriverManager.getConnection(URL, NAME, PWD);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
/*
* 3. 关闭数据库连接释放资源
*/
public static void close(Connection conn, PreparedStatement ps, ResultSet rs) {
try {
if (conn != null) {
conn.close();
}
if (ps != null) {
ps.close();
}
if (rs != null) {
rs.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//重载close方法,不带查询传入值
public static void close(Connection conn, PreparedStatement ps) {
close(conn, ps, null);
}
public static void close(Connection conn) {
close(conn, null, null);
}
}
通过jdbc完成增删改查将在后续补充,敬请期待。