Products

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;

 private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
        String query;
        try{
        Class.forName("java.sql.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost/mysql","root","admin");
        Statement stmt = con.createStatement();
        if(jRadioButton1.isSelected()){
        query = "select * from customers;";

        }
        else{
            String sq = jList1.getName();
            String cone = jComboBox1.getName();
            query = "select * from customers where " + sq+" " + cone + " ;" ;
            }
        ResultSet rs = stmt.executeQuery(query);


        while(rs.next()){
            String productCode = rs.getString("productCode");
            String productName = rs.getString("productName");
            String vendor = rs.getString("vendor");
            String description = rs.getString("description");
            String buyPrice = rs.getString("buyPrice");

            }
        rs.close();
        stmt.close();
        con.close();
        } catch(Exception e){
            JOptionPane.showMessageDialog(null, "Error in connectivity");

        }
    }