Library Management
JAVA & MY SQL PROGRRAMING
import javax.swing.table.*; import java.sql.*; import javax.swing.JOptionPane; private void formWindowGainedFocus(java.awt.event.WindowEvent evt) { int rows = model.getRowCount(); if (rows > 0) {for (int i = 0; i < rows; i++) { model.removeRow(0);char st = 'Y'; // Lib table String query = "SELECT * FROM Lib WHERE status = '" + st + "';"; try { ResultSet rs = stmt.executeQuery(query);// Iterate through the result and display on screen while (rs.next()) {} private void cmdIssueActionPerformed(java.awt.event.ActionEvent evt) { MyDialog.setVisible(true); } DefaultTableModel Dmodel = (DefaultTableModel) jTable2.getModel(); // Clear the existing table int rows = Dmodel.getRowCount(); if (rows > 0) { for (int i = 0; i < rows; i++) { Dmodel.remove } while (rs.next()) { String Acno = rs.getString("acc_no"); String bTitle = rs.getString("btitle"); String Auth1 = rs.getString("author1"); String Price = rs.getString("price"); String edition = rs.getString("edition"); //System.out.println(Acno + "|" + bTitle + "|" + Auth1 + "|" + Price + "|" + edition); model.addRow(new Object[] {Acno, bTitle, Auth1, Price, edition} } catch (Exception e) { public static void main(String args[]) { java.awt.EventQueue.invokeLater(new Runnable() { jLabel6 = new javax.swing.JLabel(); cmdIssue = new javax.swing.JButton(); jLabel13 = new javax.swing.JLabel(); txtIDate = new javax.swing.JTextField(); jLabel11.setFont(new java.awt.Font("Helvetica", 1, 12)); // NOI18N jLabel11.setText("Select a Book"); jLabel1.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N jLabel1.setText("Member No."); jLabel2.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N jLabel2.setText("Name"); txtMStatus.setFont(new java.awt.Font("Arial", 1, 10)); // NOI18N jLabel5.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N jLabel5.setText("Status"); jLabel7.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N jLabel7.setText("Membership txtMDate.setFont(new java.awt.Font("Arial", 1, 10)); // NOI18N jLabel3.setText("Accession No."); jLabel4.setText("Book Title) jLabel12.setText("Pub ID.") jLabel8.setText("Author) jLabel9.setText("Status"); cmdExit.setText("Exit"); cmdExit.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { cmdExitActionPerformed(evt); jList2.setModel(new DefaultListModel()); jList2.addMouseListener(new java.awt.event.MouseAdapter() jLabel13.setText("Enter Issue Date :");javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) addGroup(layout.createSequentialGroup() ) .addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, 605, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(txtStatus, javax.swing.GroupLayout.PREFERRED_SIZE, 24, javax.swing.GroupLayout.PREFERRED_SIZE))) .addComponent(txtIDate, javax.swing.GroupLayout.PREFERRED_SIZE, 112, javax.swing.GroupLayout.PREFERRED_SIZE)))) . .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup() .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel3) .addComponent(txtAcno, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(11, 11, 11) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel4) .addComponent(txtBTitle, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) . .addComponent(jLabel8) .addComponent(txtAuth1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel12) .addComponent(jLabel9) .addComponent(txtStatus, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(txtPID, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))) .addGap(12, 12, 12) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel13) .addComponent(txtIDate, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(cmdExit) .addComponent(cmdIssue)) .addGap(23, 23, 23)) ); pack(); }// </editor-fold> ResultSet rs = null; char st1 = 'N'; char ms = 'N'; String SQL = "SELECT * FROM Member WHERE mem_issue = '" + st1 + "' and mem_status ='" + ms + "'"; Statement stmt1 = null; ResultSet rs1 = null; char st = 'Y'; // Lib table String SQL1 = "SELECT * FROM Lib WHERE status = '" + st + "';";statement stmt2 = null; ResultSet rs2 = null; String SQL2 = "SELECT * FROM Missue"; Statement stmt3 = null; ResultSet rs3 = null; String SQL3 = "SELECT * FROM Tissue"; String MembNo = (String) jList1.getSelectedValue(); // String Mno =MembNo.trim().substring(0, 3); String query = "SELECT * FROM Member WHERE memb_no = " + (Mno) + ";"; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); // Create SQL statement and execute query. stmt = con.createStatement(); rs = stmt.executeQuery(query); if (rs.next()) { String MName = rs.getString("memb_name"); String MDate = rs.getString("mdate"); String MStatus = rs.getString("mem_status"); txtMNo.setText(Mno); txtMName.setText(MName); txtMDate.setText(MDate); txtMStatus.setText(MStatus); } else { JOptionPane.showMessageDialog(null, "Record does not found in Member table"); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } private void formWindowGainedFocus(java.awt.event.WindowEvent evt) { txtMNo.setEditable(false); txtMName.setEditable(false); txtMDate.setEditable(false); txtMStatus.setEditable(false); txtAcno.setEditable(false); txtBTitle.setEditable(false); txtAuth1.setEditable(false); txtPID.setEditable(false); txtStatus.setEditable(fars = stmt.executeQuery(SQL); while (rs.next()) { String Mno = rs.getString("memb_no"); String MName = rs.getString("memb_name"); if (Mno.length() < 4) { int x = Mno.length(); int nl = 4 - x; while (nl > 0){ Mno = Mno + " "; nl--dModel.addElement(Mno + "- " + MName); } jList1.setModel(dModel)stmt1 = con.createStatement(); rs1 = stmt1.executeQuery(SQL1); while (rs1.next()) { String Ano = rs1.getString("acc_no"); String BTitle = rs1.getString("btitle"); if (Ano.length() < 4) { int x = Ano.length(); int nl = 4 - x; while (nl > 0){ Ano = Ano + " "; nl--; } } cModel.addElement(Ano + "- " + BTitle); } jList2.setModel(cModel) } catch (Exception e) { JOptionPane.showMessageDialog(this,e.getMessage()); e.printStackTrace(); private void txtMNameActionPerformed(java.awt.event.ActionEvent e String Acno =MBook.trim().substring(0, 3); String query = "SELECT * FROM Lib WHERE acc_no = " + Acno + ";"; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); // Create SQL statement and execute query. stmt1 = con.createStatement(); rs1 = stmt1.executeQuery(query); if (rs1.next()) { String bTitle = rs1.getString("btitle"); String Auth1 = rs1.getString("author1"); String PID = rs1.getString("pub_id"); String PStatus = rs1.getString("status"); // Displaying the contents in respective text boxes. txtAcno.setText(Acno); txtBTitle.setText(bTitle); txtAuth1.setText(Auth1); txtPID.setText(PID); txtStatus.setText(PStatus); } else { JOptionPane.showMessageDialog(null, "Record does not found in Libdent table"); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } private void cmdIssueActionPerformed(java.awt.event.ActionEvent evt) { try { Class.forName("com.mysql.jdbc.Driver"); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); // Missue table stmt2 = con.createStatement(); rs2 = stmt.executeQuery(SQL); // Tissue table stmt3 = con.createStatement(); rs3 = stmt.executeQuery(SQL); int Acno = Integer.parseInt(txtAcno.getText().trim()); int Mno = Integer.parseInt(txtMNo.getText().trim()); String idt = txtIDate.getText(); String rdt = idt; // Temporarily assigned for testing purpose int code = JOptionPane.showConfirmDialog(this, "Are you sure to add?", "Confirmation Dialog Box", JOptionPane.YES_NO_CANCEL_OPTION, JOptionPane.INFORMATION_MESSAGE); if (code == JOptionPane.YES_OPTION) { // Record updated into Missue and Tissue tables String strSQL = "INSERT INTO Missue(acc_no, memb_no, idate, rdate) VALUES ("+(Acno)+", "+(Mno)+", '"+(idt)+"', '"+(rdt)+"')"; String strSQL1 = "INSERT INTO Tissue(acc_no, memb_no, idate, rdate) VALUES ("+(Acno)+", "+(Mno)+", ' jLabel6.setFont(new java.awt.Font("Helvetica", 1, 12)); // NOI18N jLabel6.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); jLabel6.setText("Select a Member"); jList1.setModel(new DefaultListModel()); jList1.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jList1MouseClicked(evt); } }); jScrollPane1.setViewportView(jList1) jLabel11.setFont(new java.awt.Font("Helvetica", 1, 12)); // jLabel11.setText("Select a Book"); jLabel1.setFont(new java.awt.Font("Arial", 1, 12));jLabel1.setText("Member No.") jLabel3.setText("Accession’) jLabel4.setText("Book Title"); jLabel12.setText("Pub ID."); jLabel8.setText("Authors"); jLabel9.setText("Status"); jLabel13.setText("Enter Issue Date :"); pack(); ResultSet rs = null; char st1 = 'N'; char ms = 'N'; String SQL = "SELECT * FROM Member WHERE mem_issue = '" + st1 + "' and mem_status ='" + ms + "'"; String Mno = rs.getString("memb_no"); String MName = rs.getString("memb_name"); // To make the Member no. as 4 digit because we will extract 4 digit from list value // in mouse click event. if (Mno.length() < 4) { int x = Mno.length(); int nl = 4 - x; while (nl > 0){ Mno = Mno + " "; // Listing books stmt1 = con.createStatement(); rs1 = stmt1.executeQuery(SQL1); while (rs1.next()) { String Ano = rs1.getString("acc_no"); String BTitle = rs1.getString("btitle"); // To make the Accession no. as 4 digit because we will extract 4 digit from list value // in mouse click event. if (Ano.length() < 4) { int x = Ano.length(); int nl = 4 - x; while (nl > 0){ Ano = Ano + " "; nl--; } } cModel.addElement(Ano + "- " + BTitle); } jList2.setModel(cModel); } catch (Exception e) { JOptionPane.showMessageDialog(this,e.getMessage()); e.printStackTrace(); } } private void jList2MouseClicked(java.awt.event.MouseEvent evt) { // getSelectedValue() method extracts the current cursor location value into a variable String MBook = (String) jList2.getSelectedValue(); // Extract the first 4 characters as Accession number into a variable String Acno =MBook.trim().substring(0, 3); String query = "SELECT * FROM Lib WHERE acc_no = " + Acno + ";"; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); // Create SQL statement and execute query. stmt1 = con.createStatement(); rs1 = stmt1.executeQuery(query); if (rs1.next()) { String bTitle = rs1.getString("btitle"); String Auth1 = rs1.getString("author1"); String PID = rs1.getString("pub_id"); String PStatus = rs1.getString("status"); // Displaying the contents in respective text boxes. txtAcno.setText(Acno); txtBTitle.setText(bTitle); txtAuth1.setText(Auth1); txtPID.setText(PID); txtStatus.setText(PStatus); } else { JOptionPane.showMessageDialog(null, "Record does not found in Libdent table"); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } int code = JOptionPane.showConfirmDialog(this, "Are you sure to add?", "Confirmation Dialog Box", JOptionPane.YES_NO_CANCEL_OPTION, JOptionPane.INFORMATION_MESSAGE); if (code == JOptionPane.YES_OPTION) { // Record updated into Missue and Tissue tables String strSQL = "INSERT INTO Missue(acc_no, memb_no, idate, rdate) VALUES ("+(Acno)+", "+(Mno)+", '"+(idt)+"', '"+(rdt)+"')"; String strSQL1 = "INSERT INTO Tissue(acc_no, memb_no, idate, rdate) VALUES ("+(Acno)+", "+(Mno)+", '"+(idt)+"', '"+(rdt)+"')"; } */ .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addComponent(cmdUpdate) .addGap(59, 59, 59) .addComponent(cmdExit) .addGap(115, 115, 115)))) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(layout.createSequentialGroup() .addGap(26, 26, 26) .addComponent(jLabel11) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 230, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup() .addGap(25, 25, 25) ); pack(); }// </editor-fold> private void cmdUpdateActionPerformed(java.awt.event.ActionEvent evt) { try { Class.forName("com.mysql.jdbc.Driver"); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); stmt = con.createStatement(); rs = stmt.executeQuery(SQL); int Acno = Integer.parseInt(txtAcno.getText().trim() String bTitle = txtBTitle.getText(); String Auth1 = txtAuth1.getText(); String Auth2 = txtAuth2.getText(); // Creating a String object pName float Price = Float.parseFloat(txtPrice.getText()); int pages = Integer.parseInt(txtPages.getText()); int edition = Integer.parseInt(txtEdition.getText()); String Pdate = txtPDate.getText(); String BStatus = txtStatus.getText(); String strSQL = "Update Lib set btitle ='"+(bTitle)+"', author1 = '"+(Auth1)+"', author2 = '"+(Auth2)+"', pub_id = "+(PID)+", price = "+(Price)+", pdate = '"+(Pdate)+"', pages = "+(pages)+ ", edition = "+(edition)+", status = '"+(BStatus)+"' where acc_no = " + (Acno); int rowsEffected = stmt.executeUpdate(strSQL); if (rowsEffected == 0) JOptionPane.showMessageDialog(this, "Record does not exists"); else JOptionPane.showMessageDialog(this,"Record modified"); } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } private void formWindowGainedFocus(java.awt.event.WindowEvent evt) { txtAcno.setEditable(false); txtPID.setEditable(false); txtStatus.setEditable(false); Class.forName("com.mysql.jdbc.Driver"); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); stmt = con.createStatement(); rs = stmt.executeQuery(SQL); while (rs.next()) { String Ano = rs.getString("acc_no"); String BTitle = rs.getString("btitle"); // To make the Accession no. as 4 digit because we will extract 4 digit from list value // in mouse click event. int x = Ano.length(); int nl = 4 - x; while (nl > 0){ Ano = Ano + " "; nl--; } } dModel.addElement(Ano + "- " + BTitle); } String pubno = rs1.getString("pub_id"); String pubName = rs1.getString("pub_name"); // To make the publisher no. as 4 digit because we will extract 4 digit from list value // in mouse click event txtStatus.setText("Y"); // Because it is a new book, when it will be issue, // it's status will be N. if (pubno.length() < 4) { int x = pubno.length(); Acno + ";"; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); // Create SQL statement and execute query. stmt = con.createStatement(); rs = stmt.executeQuery(query); if (rs.next()) { String bTitle = rs.getString("btitle"); String Auth1 = rs.getString("author1"); String Auth2 = rs.getString("author2"); String PID = rs.getString("pub_id"); String Price = rs.getString("price"); String PDate = rs.getString("pdate"); String pages = rs.getString("pages"); String edition = rs.getString("edition"); String PStatus = rs.getString("status"); // Displaying the contents in respective text boxes. txtAcno.setText(Acno);txtBTitle.setText(bTitltxtAuth1.setText(Auth1); txtAuth2.setText(Auth2); txtPID.setTexxtPrice.setText(Price); txtPDate.setTextxtPages.setText(pages); txtEdition.setText(edition); txtStatus.setText(PStatus); stmt.close(); rs.close(); } else { JOptionPane.showMessageDialog(null, "Record does not found in Student table"); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } @SuppressWarnings("unchecked") // for table Lib Statement stmt = null; ResultSet rs = null; String SQL = "SELECT * FROM Lib"; // for table Publisher Statement stmt1 = null; ResultSet rs1 = null; String SQL1 = "SELECT * FROM publisher"; // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { cmdExit = new javax.swing.JButton(); cmdEdit = new javax.swing.JButton(); cmdSave = new javax.swing.JButton(); cmdNew = new javax.swing.JButton(); cmdClear = new javax.swing.JButton(); jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); jLabel5 = new javax.swing.JLabel(); jLabel6 = new javax.swing.JLabel(); jLabel7 = new javax.swing.JLabel(); jLabel8 = new javax.swing.JLabel(); jLabel9 = new javax.swing.JLabel(); txtAcno = new javax.swing.JTextField(); txtBTitle = new javax.swing.JTextField(); txtAuth1 = new javax.swing.JTextField(); txtAuth2 = new javax.swing.JTextField(); jComboBox1 = new javax.swing.JComboBox(); txtPrice = new javax.swing.JTextField(); txtPages = new javax.swing.JTextField(); txtEdition = new javax.swing.JTextField(); txtPDate = new javax.swing.JTextField(); txtStatus = new javax.swing.JTextField(); cmdDelete = new javax.swing.JButton(); jLabel10 = new javax.swing.JLabel(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); setTitle("Libary Console"); addWindowFocusListener(new java.awt.event.WindowFocusListener() { public void windowGainedFocus(java.awt.event.WindowEvent evt) { formWindowGainedFocus(evt); } public void windowLostFocus(java.awt.event.WindowEvent evt) { } }); cmdExit.setText("Exit"); cmdExit.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { cmdExitActionPerformed(evt); } }); cmdEdit.setText("Edit"); cmdEdit.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { cmdEditActionPerformed(evt); } }); cmdSave.setText("Save"); cmdSave.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { cmdSaveActionPerformed(evt); } }); cmdNew.setText("New"); cmdNew.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { cmdNewActionPerformed(evt); } });jLabel1.setText("Accession No."); jLabel2.setText("Book TitjLabel3.setText("Authors"); jLabel4.setText("Publisher");jLabel5.setText("Price"); jLabel6.setText("Purchase Dat)jLabel7.setText("Pages");jLabel8.setText("Editi) jLabel9.setText("Status"); } String PubNo = String.valueOf(pName.substring(0, 3).trim()); int pno = Integer.parseInt(PubNo); jLabel10.setText(""+pno); float Price = Float.parseFloat(txtPrice.getText()); int pages = Integer.parseInt(txtPages.getText()); int edition = Integer.parseInt(txtEdition.getText()); String Pdate = txtPDate.getText(); char BStatus = 'Y'; int code = JOptionPane.showConfirmDialog(this, "Are you sure to add?", "Confirmation Dialog Box", JOptionPane.YES_NO_CANCEL_OPTION, JOptionPane.INFORMATION_MESSAGE); if (code == JOptionPane.YES_OPTION) { String strSQL = "INSERT INTO Lib(acc_no, btitle, author1, author2, pub_id, price, pdate, pages, edition, status) VALUES ("+(Acno)+", '"+(bTitle)+"', '"+(Auth1)+"', '"+(Auth2)+"', "+(pno)+", "+(Price)+", '"+(Pdate)+"', "+(pages)+", "+(edition)+", '"+(BStatus)+"')"; int rowsEffected = stmt.executeUpdate(strSQL); JOptionPane.showMessageDialog(this, "Record added successfully into Lib table"); } cmdSave.setEnabled(false); } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } while (nl > 0){ pubno = pubno + " "; nl--; } } cModel.addElement(pubno + "- " + pubName); } } catch (Exception e) { JOptionPane.showMessageDialog(this,e.getMessage()); e.printStackTrace(); } } cmdSave.setEnabled(false); } private void cmdDeleteActionPerformed(java.awt.event.ActionEvent evt) { this.setVisible(false); new LibDelUI().setVisible(true); } } int rows = model.getRowCount(); if (rows > 0) { for (int i = 0; i < rows; i++) { model.removeRow(0); } } // SQL Query String query = "SELECT * FROM Member"; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); // Create SQL statement and execute query. ResultSet rs = stmt.executeQuery(qu) while (rs.next()) { String Mno = rs.getString("memb_no"); String MName = rs.getString("memb_name"); String MAdd = rs.getString("memb_add"); String MPh1 = rs.getString("memb_phone"); String MDate = rs.getString("mdate"); //System.out.println(Mno + "|" + MName + "|" + MAdd + "|" + MPh1 + "|" + MDate); model.addRow(new Object[] {Mno, MName, MAdd, MPh1, MDate}); String Mno =MembNo.trim().substring(0, 3); String query = "SELECT * FROM Member WHERE memb_no = " + (Mno) + ";"; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); // Create SQL statement and execute query. stmt = con.createStatement(); rs = stmt.executeQuery(query); String MName = rs.getString("memb_name"); String MAdd = rs.getString("memb_add"); String MPh1 = rs.getString("memb_phone"); String MDate = rs.getString("mdate"); String MEDate = rs.getString("medate"); String MFee = rs.getString("mfee"); String MStatus = rs.getString("mem_status"); String MIssue = rs.getString("mem_issue"); txtMNo.setText(Mno); txtMName.setText(MName); txtMAdd.setText(MAdd); txtMPh.setText(MPh1); txtMDate.setText(MDate); txtMFee.setText(MFee); txtMStatus.setText(MStatus); txtMStatus.setEditable(false); } else { JOptionPane.showMessageDialog(null, "Record does not found in Member table"); DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); stmt = con.createStatement(); rs = stmt.executeQuery(SQL); int Mno = Integer.parseInt(txtMNo.getText().trim()); // Steps to confirm deletion int opt = JOptionPane.showConfirmDialog(null, "Are you sure to delete this record ?"); if (opt == JOptionPane.YES_OPTION) { try { char stb = 'N'; // Member table String strSQL = "Update Member set mem_status ='"+(stb)+"' where memb_no = " + (Mno); int rowsEffected = stmt.executeUpdate(strSQL); if (rowsEffected == 0) JOptionPane.showMessageDialog(this, "Record does not exists"); else { JOptionPane.showMessageDialog(this,"Record Deleted"); // Text boxes cleared txtMNo.setText(""); txtMName.setText(""); txtMAdd.setText(""); txtMPh.setText(""); txtMDate.setText(""); txtMFee.setText(""); txtMStatus.setText(""); } } catch (Exception e) { JOptionPane.showMessageDialog(null, "Unable to del)while (rs.next()) { String Mno = rs.getString("memb_no"); String MName = rs.getString("memb_name"); // To make the Member no. as 4 digit because we will extract 4 digit from list value // in mouse click event. if (Mno.length() < 4) { int x = Mno.length(); int nl = 4 - x; while (nl > 0){ Mno = Mno + " "; nl--; } } dModel.addElement(Mno + "- " + MName); } jList1.setModel(dModel); } catch (Exception e) { JOptionPane.showMessageDialog(this,e.getMessage()); e.printStackTrace(); String SQL = "SELECT * FROM Member" Class.forName("com.mysql.jdbc.Driver"); DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); if (rs.previous()) { String Mno = rs.getString("memb_no"); String MName = rs.getString("memb_name"); String MAdd = rs.getString("memb_add"); String MPh1 = rs.getString("memb_phone"); String MDate = rs.getString("mdate"); String MEDate = rs.getString("medate"); String MFee = rs.getString("mfee"); String MStatus = rs.getString("mem_status"); String MIssue = rs.getString("mem_issue"); // Displaying the contents in respective text boxes. DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); if (rs.last()) { String Mno = rs.getString("memb_no"); String MName = rs.getString("memb_name"); String MAdd = rs.getString("memb_add"); String MPh1 = rs.getString("memb_phone"); String MDate = rs.getString("mdate"); String MEDate = rs.getString("medate"); String MFee = rs.getString("mfee"); String MStatus = rs.getString("mem_status"); String MIssue = rs.getString("mem_issue"); // Displaying the contents in respective text boxes. cmdFirst.setEnabled(true); cmdNext.setEnabled(false); cmdPrev.setEnabled(true); cmdLast.setEnabled(false); } else { JOptionPane.showMessageDialog(this, "You are already at last record", "Student",0); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } private void formWindowGainedFocus(java.awt.event.WindowEvent evt) { disable_textfields(); try { Class.forName("com.mysql.jdbc.Driver"); Connection con = (Connection) cmdEdit public void actionPerformed(java.awt.event.ActionEvent evt) { txtMNameActionPerformed(evt); } }); txtMName } }); txtMName.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { txtMNameKeyPressed(evt); } }); jLabel1.setFont(new java.awt.Font("Arial", 1, 12)); jLabel1.setText("Member No."); cmdSave.setText("Save"); cmdSave.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { cmdSaveActionPerformed(evt); pack(); }// </editor-fold> Statement stmt = null; ResultSet rs = null; // ResultSet for publisher table. String SQL = "SELECT * FROM Member"; "); while (rs.next()) { MNO = rs.getInt("memb_no"); } MNO++; Mno = MNO; txtMNo.setText(Integer.toString(Mno)); txtMName.setFocusable(true); } catch (Exception e) { JOptionPane.showMessageDialog(this,e.getMessage()); e.printStackTrace(); } } ); pack(); }// </editor-fold> Statement stmt = null; ResultSet rs = null; String SQL = "SELECT * FROM Publisher"; private void cmdDeleteActionPerformed(java.awt.event.ActionEvent evt) { try { Class.forName("com.mysql.jdbc.Driver"); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); stmt = con.createStatement(); rs = stmt.executeQuery(SQL); int pno = Integer.parseInt(txtPno.getText().trim()); // Steps to confirm deletion int opt = JOptionPane.showConfirmDialog(null, "Are you sure to delete this record ?"); if (opt == JOptionPane.YES_OPTION) { try { char stb = 'N'; // Member table String strSQL = "Update publisher set status ='"+(stb)+"' where pub_id = " + (pno); int rowsEffected = stmt.executeUpdate(strSQL); } } dModel.addElement(Pno + "- " + PName); } jList1.setModel(dModel); con.close(); } catch (Exception e) { JOptionPane.showMessageDialog(this,e.getMessage()); e.printStackTrace(); jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); jLabel1.setText("Select a Publisher"); jLabel3.setFont(new java.awt.Font("Arial", 1, 12)); jLabel3.setText("Address’’) jLabel4.setFont(new java.awt.Font("Arial", 1, 12)); jLabel4.setText("Phone/Mobile") jLabel5.setFont(new java.awt.Font("Arial", 1, 12)); jLabel5.setText("Pbone/Mobile"); jLabel2.setFont(new java.awt.Font("Arial", 1, 12))jLabel2.setText("Publisher No./ID"); jLabel6.setFont(new java.awt.Font("Arial", 1, 12)); jLabel6.setText("Name");jLabel7.setText("Status"); cmdUpdate.setText("Update"); ResultSet rs = null; String SQL = "SELECT * FROM Publisher"; stmt = con.createStatement(); rs = stmt.executeQuery(SQL); while (rs.next()) { String Pno = rs.getString("pub_id"); String PName = rs.getString("pub_name"); // To make the publisher no. as 4 digit because we will extract 4 digit from list value // in mouse click event. if (Pno.length() < 4) { int x = Pno.length(); int nl = 4 - x; while (nl > 0){ Pno = Pno + " "; nl--; } } dModel.addElement(Pno + "- " + PName); } jList1.setModel(dModel); con.close(); } catch (Exception e) { JOptionPane.showMessageDialog(this,e.getMessage()); e.printStackTrace(); } } private void jList1MouseClicked(java.awt.event.MouseEvent evt) { // getSelectedValue() method extracts the current cursor location value into a variable String MPub = (String) jList1.getSelectedValue(); // Extract the first 4 characters as publisher ID into a variable String PubN =MPub.trim().substring(0, 3); String query = "SELECT * FROM Publisher WHERE pub_Id = " + PubN + ";"; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); // Create SQL statement and execute query. Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(query); if (rs.next()) { //PubN = rs.getString("pub_no"); String PubName = rs.getString("pub_name"); String PubAdd = rs.getString("pub_address"); String PubPh1 = rs.getString("pub_phone1"); String PubPh2 = rs.getString("pub_phone2"); String PStatus = rs.getString("status"); // Displaying the contents in respective text boxes. txtPno.setText(PubN); txtPName.setText(PubName); txtPAdd.setText(PubAdd); txtPh1.setText(PubPh1); txtPh2.setText(PubPh2); txtStatus.setText(PStatus); txtPno.setEditable(false); // Close the operational object for Student con.close(); stmt.close(); rs.close(); } else { JOptionPane.showMessageDialog(null, "Record does not found in Publisher table"); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); //new MainUI().setVisible(true); } private void cmdUpdateActionPerformed(java.awt.event.ActionEvent evt) { try { // Connect to MySQL database // Don't forget to import the two packages // import java.sql.*; // import javax.swing.JOptionPane; Class.forName("com.mysql.jdbc.Driver"); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); Statement stmt = null; ResultSet rs = null; String SQL = "SELECT * FROM Publisher"; stmt = con.createStatement(); rs = stmt.executeQuery(SQL); int pno = Integer.parseInt(txtPno.getText().trim()); String PubName = txtPName.getText(); String PubAdd = txtPAdd.getText(); String PubPh1 = txtPh1.getText(); String PubPh2 = txtPh2.getText(); String PStatus = txtStatus.getText(); String strSQL = "Update publisher set pub_name ='"+(PubName)+"',pub_address = '"+(PubAdd)+"', pub_phone1 = '"+(PubPh1)+"', pub_phone2 = '"+(PubPh2)+"', status = '"+(PStatus)+"' where pub_id = " + (pno); int rowsEffected = stmt.executeUpdate(strSQL); if (rowsEffected == 0) JOptionPane.showMessageDialog(this, "Record does not exists"); else JOptionPane.showMessageDialog(this,"Record modified"); con.close(); stmt.close(); rs.close(); } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } Global variables Statement stmt = null; ResultSet rs = null; String SQL = "SELECT * FROM publisher"; public void disable_textfields() { txtPno.setEditable(false); txtPName.setEditable(false); txtPAdd.setEditable(false); txtPh1.setEditable(false); txtPh2.setEditable(false); txtStatus.setEditable(false); } private void txtPNameActionPerformed(java.awt.event.ActionEvent evt) { } private void txtPNamePropertyChange(java.beans.PropertyChangeEvent evt) { } private void txtPNameKeyPressed(java.awt.event.KeyEvent evt) { } private void cmdFirstActionPerformed(java.awt.event.ActionEvent evt) { try { Class.forName("com.mysql.jdbc.Driver"); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); if (rs.first()) { String PubN = rs.getString("pub_id"); String PubName = rs.getString("pub_name"); String PubAdd = rs.getString("pub_address"); String PubPh1 = rs.getString("pub_phone1"); String PubPh2 = rs.getString("pub_phone2"); String PStatus = rs.getString("status"); // Displaying the contents in respective text boxes. txtPno.setText(PubN); txtPName.setText(PubName); txtPAdd.setText(PubAdd); txtPh1.setText(PubPh1); txtPh2.setText(PubPh2); txtStatus.setText(PStatus); cmdFirst.setEnabled(false); cmdNext.setEnabled(true); cmdPrev.setEnabled(false); cmdLast.setEnabled(true); } else { cmdFirst.setEnabled(false); cmdNext.setEnabled(false); cmdPrev.setEnabled(false); cmdLast.setEnabled(false); JOptionPane.showMessageDialog(this, "Rhere is no record in table", "Student",0); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } private void cmdNextActionPerformed(java.awt.event.ActionEvent evt) { try { Class.forName("com.mysql.jdbc.Driver"); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); if (rs.next()) { String PubN = rs.getString("pub_id"); String PubName = rs.getString("pub_name"); String PubAdd = rs.getString("pub_address"); String PubPh1 = rs.getString("pub_phone1"); String PubPh2 = rs.getString("pub_phone2"); String PStatus = rs.getString("status"); // Displaying the contents in respective text boxes. txtPno.setText(PubN); txtPName.setText(PubName); txtPAdd.setText(PubAdd); txtPh1.setText(PubPh1); txtPh2.setText(PubPh2); txtStatus.setText(PStatus); cmdFirst.setEnabled(true); cmdNext.setEnabled(true); cmdPrev.setEnabled(true); cmdLast.setEnabled(true); } else { cmdNext.setEnabled(false); JOptionPane.showMessageDialog(this, "You are at last record position", "Student",0); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } private void cmdExitActionPerformed(java.awt.event.ActionEvent evt) { this.setVisible(false); } private void cmdPrevActionPerformed(java.awt.event.ActionEvent evt) { try { Class.forName("com.mysql.jdbc.Driver"); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); if (rs.previous()) { String PubN = rs.getString("pub_id"); String PubName = rs.getString("pub_name"); String PubAdd = rs.getString("pub_address"); String PubPh1 = rs.getString("pub_phone1"); String PubPh2 = rs.getString("pub_phone2"); String PStatus = rs.getString("status"); // Displaying the contents in respective text boxes. txtPno.setText(PubN); txtPName.setText(PubName); txtPAdd.setText(PubAdd); txtPh1.setText(PubPh1); txtPh2.setText(PubPh2); txtStatus.setText(PStatus); cmdFirst.setEnabled(true); cmdNext.setEnabled(true); cmdPrev.setEnabled(true); cmdLast.setEnabled(true); } else { cmdPrev.setEnabled(false); JOptionPane.showMessageDialog(this, "You are at first position", "Student",0); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } private void cmdLastActionPerformed(java.awt.event.ActionEvent evt) { try { Class.forName("com.mysql.jdbc.Driver"); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); if (rs.last()) { String PubN = rs.getString("pub_id"); String PubName = rs.getString("pub_name"); String PubAdd = rs.getString("pub_address"); String PubPh1 = rs.getString("pub_phone1"); String PubPh2 = rs.getString("pub_phone2"); String PStatus = rs.getString("status"); // Displaying the contents in respective text boxes. txtPno.setText(PubN); txtPName.setText(PubName); txtPAdd.setText(PubAdd); txtPh1.setText(PubPh1); txtPh2.setText(PubPh2); txtStatus.setText(PStatus); cmdFirst.setEnabled(true); cmdNext.setEnabled(false); cmdPrev.setEnabled(true); cmdLast.setEnabled(false); } else { JOptionPane.showMessageDialog(this, "You are already at last record", "Student",0); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } private void formWindowGainedFocus(java.awt.event.WindowEvent evt) { disable_textfields(); try { // Connect to MySQL database // Don't forget to import the two packages // import java.sql.*; // import javax.swing.JOptionPane; Class.forName("com.mysql.jdbc.Driver"); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); stmt = con.createStatement(); rs = stmt.executeQuery(SQL); if (rs.first()) { String PubN = rs.getString("pub_id"); String PubName = rs.getString("pub_name"); String PubAdd = rs.getString("pub_address"); String PubPh1 = rs.getString("pub_phone1"); String PubPh2 = rs.getString("pub_phone2"); String PStatus = rs.getString("status"); // Displaying the contents in respective text boxes. txtPno.setText(PubN); txtPName.setText(PubName); txtPAdd.setText(PubAdd); txtPh1.setText(PubPh1); txtPh2.setText(PubPh2); txtStatus.setText(PStatus); cmdFirst.setEnabled(false); cmdNext.setEnabled(true); cmdPrev.setEnabled(false); cmdLast.setEnabled(true); } else { cmdFirst.setEnabled(false); cmdNext.setEnabled(false); cmdPrev.setEnabled(false); cmdLast.setEnabled(false); JOptionPane.showMessageDialog(this, "Rhere is no record in table", "Student",0); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } }); } @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jLabel1 = new javax.swing.JLabel(); txtMName = new javax.swing.JTextField(); txtMNo = new javax.swing.JTextField(); jLabel2 = new javax.swing.JLabel(); txtMStatus = new javax.swing.JTextField(); jLabel5 = new javax.swing.JLabel(); jLabel7 = new javax.swing.JLabel(); txtMDate = new javax.swing.JTextField(); jScrollPane1 = new javax.swing.JScrollPane(); jList1 = new javax.swing.JList(); jLabel6 = new javax.swing.JLabel(); cmdExit = new javax.swing.JButton(); jLabel3 = new javax.swing.JLabel(); jSeparator1 = new javax.swing.JSeparator(); txtAcno = new javax.swing.JTextField(); jLabel4 = new javax.swing.JLabel(); txtBTitle = new javax.swing.JTextField(); jLabel8 = new javax.swing.JLabel(); txtAuth = new javax.swing.JTextField(); cmdReturn = new javax.swing.JButton(); jLabel9 = new javax.swing.JLabel(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); setTitle("Library book return form"); addWindowFocusListener(new java.awt.event.WindowFocusListener() { public void windowGainedFocus(java.awt.event.WindowEvent evt) { formWindowGainedFocus(evt); } public void windowLostFocus(java.awt.event.WindowEvent evt) { } }); jLabel1.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N jLabel1.setText("Member No."); txtMName.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { txtMNameActionPerformed(evt); } }); txtMName.addPropertyChangeListener(new java.beans.PropertyChangeListener() { public void propertyChange(java.beans.PropertyChangeEvent evt) { txtMNamePropertyChange(evt); } }); txtMName.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { txtMNameKeyPressed(evt); } }); jLabel2.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N jLabel2.setText("Name"); txtMStatus.setFont(new java.awt.Font("Arial", 1, 10)); // NOI18N jLabel5.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N jLabel5.setText("Status"); jLabel7.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N jLabel7.setText("Membership Date"); txtMDate.setFont(new java.awt.Font("Arial", 1, 10)); // NOI18N jList1.setModel(new DefaultListModel()); jList1.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jList1MouseClicked(evt); } }); jScrollPane1.setViewportView(jList1); jLabel6.setFont(new java.awt.Font("Helvetica", 1, 12)); // NOI18N jLabel6.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); jLabel6.setText("Select a Member"); cmdExit.setText("Exit"); cmdExit.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { cmdExitActionPerformed(evt); } }); jLabel3.setText("Accession No. "); jLabel4.setText("Title"); jLabel8.setText("Author"); cmdReturn.setText("Return"); cmdReturn.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { cmdReturnActionPerformed(evt); } }); jLabel9.setFont(new java.awt.Font("Arial", 1, 12)); // NOI18N javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(26, 26, 26) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.L) String Mno =MembNo.trim().substring(0, 3); String query = "SELECT * FROM Member WHERE memb_no = " + (Mno) + ";"; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); // Create SQL statement and execute query. stmt = con.createStatement(); rs = stmt.executeQuery(query); if (rs.next()) { String MName = rs.getString("memb_name"); String MDate = rs.getString("mdate"); String MStatus = rs.getString("mem_status"); // Displaying the contents in respective text boxes. txtMNo.setText(Mno); txtMName.setText(MName); txtMDate.setText(MDate); txtMStatus.setText(MStatus); } else { JOptionPane.showMessageDialog(null, "Record does not found in Member table"); } String query1 = "SELECT * FROM Tissue WHERE memb_no = " + (Mno) + ";"; // Create SQL statement and execute query. stmt3 = con.createStatement(); rs3 = stmt3.executeQuery(query1); int ACno = 0; if (rs3.next()) { ACno = rs3.getInt("acc_no"); txtAcno.setText(String.valueOf(ACno)); } // Extrating the Library details for Acc_no from Lib table String query2 = "SELECT * FROM Lib WHERE acc_no = " + (ACno) + ";"; // Create SQL statement and execute query. stmt1 = con.createStatement(); rs1 = stmt1.executeQuery(query2); String BTitle, Auth; if (rs1.next()) { BTitle = rs1.getString("btitle"); Auth = rs1.getString("author1"); txtBTitle.setText(BTitle); txtAuth.setText(Auth); jLabel9.setText("Issued"); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); } } rs = stmt.executeQuery(SQL); while (rs.next()) { String Mno = rs.getString("memb_no"); String MName = rs.getString("memb_name"); // To make the Member no. as 4 digit because we will extract 4 digit from list value // in mouse click event. if (Mno.length() < 4) { int x = Mno.length(); int nl = 4 - x; while (nl > 0){ Mno = Mno + " "; nl--; } } dModel.addElement(Mno + "- " + MName); } jList1.setModel(dModel); } catch (Exception e) { JOptionPane.showMessageDialog(this,e.getMessage()); e.printStackTrace(); } try { Class.forName("com.mysql.jdbc.Driver"); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); // Missue table int Mno = 0, Acno = 0; Mno = Integer.parseInt(txtMNo.getText().trim()); Acno = Integer.parseInt(txtAcno.getText().trim()); // Steps to confirm return int opt = JOptionPane.showConfirmDialog(null, "Are you sure to return this book ?"); if (opt == JOptionPane.YES_OPTION) { String strSQLr = "Delete from Tissue where memb_no = " + (Mno); stmt3.executeUpdate(strSQLr); // Change the status as library book issued char sta = 'Y'; // Lib table String strSQLa = "Update Lib set status ='"+(sta)+"' where acc_no = " + (Acno); stmt1.executeUpdate(strSQLa); // Change the status as Member has a book char stb = 'N'; // Member table String strSQLb = "Update Member set mem_issue ='"+(stb)+"' where memb_no = " + (Mno); stmt.executeUpdate(strSQLb); JOptionPane.showMessageDialog(this, "Thanks for returning book"); } } catch (Exception e) { JOptionPane.showMessageDialog(this, e.getMessage()); }); jLabel6.setFont(new java.awt.Font("VAGRounded BT", 1, 14)); jLabel6.setForeground(new java.awt.Color(0, 153, 153)); jLabel6.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); jLabel6.setText("PUBLISHER INFORMATION"); cmdClear.setText("Clear"); cmdClear.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { cmdClearActionPerformed(evt); } }); cmdEdit.setText("Edit"); cmdEdit.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { cmdEditActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() this.setVisible(false); new MainUI().setVisible(true); } private void formWindowGainedFocus(java.awt.event.WindowEvent evt) { txtPno.setEditable(false); // Deactivate the Save button when form loads stmt = con.createStatement(); // Connection string for ResultSet - rs. rs = stmt.executeQuery(SQL); int pno = 1; int PID=0; while (rs.next()) { PID = rs.getInt("pub_id"); pno++; } PID++; pno = PID; txtPno.setText(Integer.toString(pno)); txtPName.setFocusable(true); con.close(); rs.close(); stmt.close(); } catch (Exception e) { JOptionPane.showMessageDialog(this,e.getMessage()); e.printStackTrace(); Class.forName("com.mysql.jdbc.Driver"); Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Library","root","reeta"); int code = JOptionPane.showConfirmDialog(this, "Are you sure to add?", "Confirmation Dialog Box", JOptionPane.YES_NO_CANCEL_OPTION, JOptionPane.INFORMATION_MESSAGE); if (code == JOptionPane.YES_OPTION) { String strSQL = "INSERT INTO Publisher(pub_id, pub_name, pub_address, pub_phone1, pub_phone2, status) VALUES ("+(Pno)+", '"+(PName)+"', '"+(PAdd)+"', '"+(Pph1)+"', '"+(Pph2)+"', '"+(PStatus)+"')"; int rowsEffected = stmt.executeUpdate(strSQL); JOptionPane.showMessageDialog(this, "Record added successfully into Publisher table"); } con.close(); stmt.close(); rs.close(); cmdSave.setEnabled(false); } |
LIBRARY MANAGEMENT
NAME : ...........
CLASS: XII SECTION: A ACADEMIC YEAR: 2015-2016 BOARD ROLL NO. : NAME OF THE SCHOOL: WORLDPROSMS SCHOOL NAME OF THE GUIDE TEACHER: Mr. .... OUTPUT Click to Link
INTRODUCTION
‘LIBRARY MANAGEMENT SYSTEM’ is a computer programming language which is use for maintaining the records of the book in the library. It is use to keep all the information of the book like code no. , price, and many more. DECLARATION
Certified that the project entitled, ‘LIBRARY MANAGEMENT’ which is being submitted by me is a record of my own work carried out by me. This is to further certify that I have worked on this project during the session 2015-2016. STUDENT’S SIGNATUE SIGNATURE OF GUIDE TEACHER DATE : DATE : BOARD ROLL NO. : DECLARATION
|