一.导入mysql包
mysql-connector-java-5.0.8-bin.jar
二.封装DButils
DButils类(关闭流和取得连接)
package util;
import java.sql.*;
public class DBUtil {
private static String driver = "com.mysql.jdbc.Driver";
private static String url ="jdbc:mysql://localhost:3306/javauseSSL=true&characterEncoding=utf-8";
private static String user="root";
private static String password="123456";
static {
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
// 创建连接
public static Connection get_Conn() throws SQLException {
Connection conn = DriverManager.getConnection(url, user, password);
System.out.println("数据路连接成功!");
return conn;
}
// 关闭连接
public static void get_CloseConn(ResultSet rs, PreparedStatement pstm, Connection conn) throws SQLException {
if(rs !=null){
rs.close();