Book_Search

package bookshelf;
...

private void jLabel107MouseClicked(java.awt.event.MouseEvent evt) {
        try {
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Bookshelf", "root", "apple2473");
            Statement st = con.createStatement();
            DefaultTableModel model = (DefaultTableModel) JTABL1.getModel();
            String csc = (String) CSC.getSelectedItem();
            switch (csc) {
                case "Choose search criteria":
                    JOptionPane.showMessageDialog(null, "Select a valid criteria");
                    break;
                case "Class":
                    String id = M_Search.getText();
                    Op_Menu.setVisible(true);
                    String q1 = "Select * from basic where clas='" + id + "';";
                    ResultSet r1 = st.executeQuery(q1);
                    while (r1.next()) {
                        model.addRow(new Object[]{r1.getString(1), r1.getString(2), r1.getString(3), r1.getString(4), r1.getString(5), r1.getString(6), r1.getString(7)});
                    }
                case "Authour":
                    String an = M_Search.getText();
                    Op_Menu.setVisible(true);
                    String q2 = "Select * from basic where AN='" + an + "';";
                    ResultSet r2 = st.executeQuery(q2);
                    while (r2.next()) {
                        model.addRow(new Object[]{r2.getString(1), r2.getString(2), r2.getString(3), r2.getString(4), r2.getString(5), r2.getString(6), r2.getString(7)});
                    }
                case "Publication":
                    String pn = M_Search.getText();
                    Op_Menu.setVisible(true);
                    String q3 = "Select * from basic where PN='" + pn + "';";
                    ResultSet r3 = st.executeQuery(q3);
                    while (r3.next()) {
                        model.addRow(new Object[]{r3.getString(1), r3.getString(2), r3.getString(3), r3.getString(4), r3.getString(5), r3.getString(6), r3.getString(7)});
                    }
                case "Name":
                    String name = M_Search.getText();
                    Op_Menu.setVisible(true);
                    String q4 = "Select * from basic where BN='" + name + "';";
                    ResultSet r4 = st.executeQuery(q4);
                    while (r4.next()) {
                        model.addRow(new Object[]{r4.getString(1), r4.getString(2), r4.getString(3), r4.getString(4), r4.getString(5), r4.getString(6), r4.getString(7)});
                    }
                case "Issued":
                    String is = M_Search.getText();
                    Op_Menu.setVisible(true);
                    String q5 = "Select * from basic where BN='" + is + "';";
                    ResultSet r5 = st.executeQuery(q5);
                    while (r5.next()) {
                        model.addRow(new Object[]{r5.getString(1), r5.getString(2), r5.getString(3), r5.getString(4), r5.getString(5), r5.getString(6), r5.getString(7)});
                    }
            }

        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "" + e);
        }
    }