NetBeans创建项目1

在NetBeans中创建Java项目，连接MySQL数据库，连接文件如下：
public class DBHelper {

private static final String DRIVER = "com.mysql.cj.jdbc.Driver";
private static final String URL = "jdbc:mysql://localhost:3306/cars?useSSL=true&serverTimezone=UTC";//cars为数据库的名称
private static final String USER = "root"; //用户名
private static final String PASSWORD = "123456";//密码
private static Connection conn = null; //连接

public DBHelper() {
    conn = null;
}

//创建数据库连接对象Connection
private static void getConnection() {
    if (conn != null) {
        return;
    }
    try {
        Class.forName(DRIVER);
        Connection con = DriverManager.getConnection(URL, USER, PASSWORD);
        conn = con;
        DriverManager.getConnection("jdbc:mysql://localhost:3306/cars?useSSL=true&serverTimezone=UTC", "root", "123456");

    } catch (ClassNotFoundException ex) {
        Logger.getLogger(DBHelper.class.getName()).log(Level.SEVERE, null, ex);
    } catch (SQLException ex) {
        Logger.getLogger(DBHelper.class.getName()).log(Level.SEVERE, null, ex);
    }
}

//查询数据库,返回结果集 对象ResultSet    
public ResultSet executeQuery(String sql) {

    Statement s;
    ResultSet rs = null;
    if (conn == null) {
        getConnection();
    }
    try {

        s = conn.createStatement();
        rs = s.executeQuery(sql);
    } catch (SQLException ex) {
        Logger.getLogger(DBHelper.class.getName()).log(Level.SEVERE, null, ex);
    }
    return rs;
}

// 插入数据  
public void insert(String sql) {
    if (conn == null) {
        getConnection();
    }
    Statement stat = null;
    try {
        stat = conn.createStatement();
        stat.executeUpdate(sql);
    } catch (SQLException ex) {
        Logger.getLogger(DBHelper.class.getName()).log(Level.SEVERE, null, ex);
    }

}

//修改
public int update(String sqlStr) {
    if (conn == null) {
        getConnection();
    }
    Statement stat = null;

    int num = -1;
    try {
        stat = conn.createStatement();
        num = stat.executeUpdate(sqlStr);
    } catch (SQLException ex) {
        Logger.getLogger(DBHelper.class.getName()).log(Level.SEVERE, null, ex);
    }
    return num;
}

//关闭数据库连接    
public static void close() {
    try {
        if (conn != null) {
            conn.close();
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

}