private void btnTestDbConnectionActionPerformed(java.awt.event.ActionEvent evt) {                                                    
    // TODO add your handling code here:
 
    String database = "acme_crm";
    String table    = "customer";
    String url      = "jdbc:mysql://localhost:3306/acme_crm";
    String username = "root";
    String password = "";
 
    System.out.println("Connecting to database " + database + "...");
 
    // Connect to DB
    try (Connection connection = (Connection) DriverManager.getConnection(url, username, password)) {
        System.out.println("Database connected!");
 
        String sql = "SELECT * FROM `" + table + "`";
        try {
            //PreparedStatement stmt = connection.prepareStatement(sql);
            Statement stmt = connection.createStatement();
            //stmt.execute(sql);
            ResultSet rs = stmt.executeQuery(sql);
 
            // Spit out data
            while (rs.next()) {
                int    id = rs.getInt("id");
                String account_number = rs.getString("account_number");
                String  company_name = rs.getString("company_name");
                System.out.println("[" + id + "] " + account_number + ": " + company_name);
            }
 
            stmt.close();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            connection.close();
        }
    } catch (SQLException e) {
        throw new IllegalStateException("Cannot connect to database " + database, e);
    }
 
}