book_update

package bookshelf;
...

private void SearchBtnMouseClicked(java.awt.event.MouseEvent evt) {
        try {
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Bookshelf", "root", "apple2473");
            Statement st = con.createStatement();
            int id = Integer.parseInt(S_Search2.getText());
            String q1 = "Select * from basic where BID=" + id + ";";
            ResultSet rs = st.executeQuery(q1);
            while (rs.next()) {
                BID5.setText(rs.getString(1));
                BN5.setText(rs.getString(2));
                AN4.setText(rs.getString(3));
                PN4.setText(rs.getString(4));
                CATECB5.setSelectedItem(rs.getString(6));
                CLASCB4.setSelectedItem(rs.getString(5));
                SLFNO4.setText(rs.getString(7));
            }

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

private void EDITBtnMouseClicked(java.awt.event.MouseEvent evt) {
        try {
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Bookshelf", "root", "apple2473");
            Statement st = con.createStatement();
            int id = Integer.parseInt(BID5.getText());
            String bn = BN5.getText();
            String an = AN4.getText();
            String pn = PN4.getText();
            String clas = (String) CLASCB4.getSelectedItem();
            String cate = (String) CATECB5.getSelectedItem();
            int slfno = Integer.parseInt(SLFNO4.getText());
            String isue = "Not issued";
            String q1 = "Update basic set BN='" + bn + "',AN='" + an + "',PN='" + pn + "',CLAS='" + clas + "',CATE='" + cate + "',SLFNO=" + slfno + ",ISSUE='" + isue + "' where BID=" + id + ";";
            st.executeUpdate(q1);
            JOptionPane.showMessageDialog(null, "Values Updated");
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "" + e);
        }
    }