BLUEJ PROGRAM FOR LIBRARY MANAGEMENT UPDATE
Int ans = JOptionPane.showConfirmDialog(null, "Do you want to update the record ?") JOptionPane.showMessageDialog(null, "Error in deletion !") JOptionPane.showMessageDialog(null, "Record successfully deleted.")
BLUEJ PROGRAM FOR LIBRARY MANAGEMENT CODE
String query = "DELETE FROM bookdatabase WHERE code = "+UniqueCodeTF1.getText()+" " Int res = JOptionPane.showConfirmDialog(null, "Do you want to delete the record ?") JOptionPane.showMessageDialog(null, "Error in Connectivity !") JOptionPane.showMessageDialog(null, "No such record found.") String query = "SELECT * FROM bookdatabase WHERE code="+UniqueCodeTF1.getText()+" " JOptionPane.showMessageDialog(null, "Error in database updatation !") JOptionPane.showMessageDialog(null, "Record successfully updated.") String sql = "INSERT INTO bookdatabase VALUES ("+UniqueCodeTF.getText()+",'"+BookNameTF.getText()+"','"+AuthorTF.getText()+"','"+PublisherTF.getText()+"','"+EditionTF.getText()+"')" Int ans = JOptionPane.showConfirmDialog(null, "Are you sure to add ?") JOptionPane.showMessageDialog(null, "Error in Connectivity") String Edition = rs.getString ("Edition") String Publisher = rs.getString ("Publisher") String BookName = rs.getString ("Book_Name") String query = "SELECT * FROM BookDatabase " StudentDatabase SD = new StudentDatabase() ĭefaultTableModel model = (DefaultTableModel)bkdb.getModel() Ĭonnection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Library_Management", "root", "") Steps with Source Code to Design the Program For teachers especially for the librarian can manage all the book records through this software. For students they can be able to know the works of Backend software(MySql) with Frontend software(Net Beans IDE). This JAVA Program is very useful for both students and the teachers. User can easily use this application as it is USER FRIENDLY. It consists of Books and Issuer's database so as to keep record of all the details of books and Issuers. This Java application named LIBRARY MANAGEMENT TOOL is a small and handy tool for school, private and public library.
0 kommentar(er)
