issue_book1

package bookshelf;
...

 private void SearchBookMouseClicked(java.awt.event.MouseEvent evt) {
        try {
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Bookshelf", "root", "apple2473");
            Statement st = con.createStatement();
            int lbcno = Integer.parseInt(LBCNO1.getText());
            String stn = Stname1.getText();
            String clas = (String) JCBCLAS1.getSelectedItem();
            String yea = YEAR1.getText();
            String q1 = "Update lbc_card set STNAME='" + stn + "',CLAS='" + clas + "',year='" + yea + "' where LBCNO=" + lbcno + ";";
            st.executeUpdate(q1);
            JOptionPane.showMessageDialog(null, "Values Updated");
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "" + e);
        }
    }

private void SearchIdMouseClicked(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_search.getText());
            String q1 = "Select * from lbc_card where LBCNO=" + id + ";";
            ResultSet rs = st.executeQuery(q1);
            while (rs.next()) {
                name.setText(rs.getString(2));
                lbc_no.setText(rs.getString(1));
                year.setText(rs.getString(4));
            }
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "" + e);
        }
    }

private void issueBtnMouseClicked(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(BID3.getText());
            int sid = Integer.parseInt(lbc_no.getText());
            String qq = "Select * from basic where BID=" + bid + ";";
            ResultSet rs = st.executeQuery(qq);
            while (rs.next()) {
                String inf = rs.getString(8);
                if (inf.equals("Not Issued")) {
                    String to = "Issued";
                    String q1 = "Update basic set ISSUE = '" + to + "' where BID=" + bid + ";";
                    String q2 = "insert into issue_check values(" + sid + "," + bid + ");";
                    st.executeUpdate(q1);
                    st.executeUpdate(q2);
                    JOptionPane.showMessageDialog(null, "Issued for 7 days");
                } else if (inf.equals("Issued")) {
                    JOptionPane.showMessageDialog(null, "Already Issued");
                }
                break;
            }
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "" + e);
        }
    }

 private void ReturnBtnMouseClicked(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(BID3.getText());
            int sid = Integer.parseInt(lbc_no.getText());
            String to = "Not Issued";
            String q1 = "Update basic set ISSUE = '" + to + "' where BID=" + bid + ";";
            String q2 = "Delete from issue_check where LBCNO=" + sid + ";";
            st.executeUpdate(q1);
            st.executeUpdate(q2);
            JOptionPane.showMessageDialog(null, "You can issue new book");
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "" + e);
        }
    }