Delete_book

package bookshelf;
...

private void DeleteBtnMouseClicked(java.awt.event.MouseEvent evt) {
        try {
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Bookshelf", "root", "apple2473");
            Statement st = con.createStatement();
            int bid = Integer.parseInt(BID2.getText());
            String q1 = "Delete from basic where BID=" + bid + ";";
            st.executeUpdate(q1);
            JOptionPane.showMessageDialog(null, "Deleted");
            BID2.setText("");
            BN2.setText("");
            AN2.setText("");
            PN2.setText("");
            CLASCB2.setSelectedIndex(0);
            CATECB2.setSelectedIndex(0);
            SLFNO2.setText("");
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "" + e);
        }
    }