DBHelper

package dbutils;

import java.sql.*;

public class DBHelper {
private static final String DB_CONN_RUL="jdbc:mysql://localhost:3306/course_design?useSSL" +
"=false";
private static final String DB_USER_NAME="root";
private static final String DB_PASSWORD="123456";
public static Connection getConnection(){
Connection connection=null;
try {
Class.forName("com.mysql.jdbc.Driver");
connection= DriverManager.getConnection(DB_CONN_RUL,DB_USER_NAME,DB_PASSWORD);
}catch (SQLException | ClassNotFoundException e){
e.printStackTrace();
}
return connection;
}
public static void closeAll(Connection connection,
PreparedStatement pstmt, ResultSet rs){
if (rs!=null){
try {
rs.close();
}catch (Exception e){
e.printStackTrace();
}
}
if (pstmt!=null){
try {
pstmt.close();
}catch (Exception e){
e.printStackTrace();
}
}
if (connection!=null){
try {
connection.close();
}catch (Exception e){
e.printStackTrace();
}
}}
}