jdbc的封装
首先,我们回顾了jdbc连接数据库的7大步骤:
1.获取驱动
2.创建连接
3.编写sql
4.获取prepareStatement
5.执行sql语句,并返回结果
6.处理结果集
7.关闭资源
基于这个步骤,我们建立新类DBUtil将其封装
package util;
import java.sql.*;
//工具类
public class DBUtil
{
private static String driver = "com.mysql.jdbc.Driver";
private static String url = "jdbc:mysql://localhost:3306/java_3?useSSL=true&characterEncode=utf-8";
private static String user = "root";
private static String password = "123456";
static {
try { //获取驱动 Class.forName(driver);
} catch (Exception e) {
e.printStackTrace();
}
}
//2. 创建连接
public static Connection get_Conn() throws SQLException {
Connection conn = DriverManager.getConnection(url, user, password);
System.out.println("数据库连接成功!" + conn);
return conn;
}
//3.关闭资源
public static void get_CloseConn(ResultSet rs, PreparedStatement pstm, Connection conn) throws SQLException {
if (rs != null) {
rs.close();
}
if (pstm != null) {
pstm.close();
}
if (conn != null) {
conn.close();
}
} //单元测试 / 白盒测试
public static void main(String[] args) {
try{
get_Conn();
}
catch (SQLException e) {
e.printStackTrace();
}
}
}
了解ssm以及IDEA+Maven 整合
详细内容见如下链接:
https://blog.csdn.net/weixin_42747657/article/details/81160501