URGENT.. HOW TO FIX THESE ERRORS..

Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException at hotelmanagement.reservation.autoID(reservation.java:52) at hotelmanagement.reservation.(reservation.java:31) at hotelmanagement.reservation$2.run(reservation.java:349) at java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:313) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:770) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715) at java.base/java.security.AccessController.doPrivileged(AccessController.java:389) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:740) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

This is the code.

6 package hotelmanagement; 7 10 8 import java.sql.Connection; 9 import java.sql.DriverManager; import java.sql. PreparedStatement; 11 import java.sql.ResultSet; import java.sql.SQLException; 13 import java.sql.statement; import java.util.logging. Level; import java.util.logging.Logger; 16 import javax.swing.table.DefaultTableModel; 12 14 15 17 18 public class reservation extends javax.swing.JFrame { 19 20 + .3 lines */ 23 24 /** Creates new form reservation public reservation() { initComponents(); autoID(); } 25 26 27 28 29 Connection c; PreparedStatement ps; DefaultTableModel d; 30 32 public void Connect() { //database method 33 34 35 36 GA try { class. forName ("com.mysql.jdbc.Driver");//database location c = DriverManager.getConnection("jdbc:mysql://localhost:3307/hotelmanagement", "root", ""); } catch (classNotFoundException ex) { Logger.getLogger (Roomnumber.class.getName()).log (Level. SEVERE, null, ex); } catch (SQLException ex) { Logger.getLogger (Roomnumber.class.getName()).log (Level.SEVERE, null, ex); 38 39 40 41 42 43 44 45 S = } private void autoID() { try { Statement c.createStatement (); ResultSet rs = s.executeQuery ("select MAX (reid) from reservation"); rs.next(); rs.getString ("MAX (reid) "); if (rs.getString ("MAX (reid)") == null) { 46 47 48 49 50 51 52 53 jLabel12.setText ("RE001"); } else { long id = Long-parselong(rs.getString ("MAX (reid)").substring (2, rs.getString ("MAX (reid)").length())); 8 8 56 id++; jLabel12.setText ("RE" + String.format("%03d", id)); 57 58 59 } catch (SQLException ex) { Logger.getLogger(Roomnumber.class.getName()).log(Level. SEVERE, null, ex); 60 61 62 63 68 /** This method is called from within the constructor to initialize the form ...5 lines */ @SuppressWarnings ("unchecked") Generated Code 69 303 304 + 307 308 309 330 331 /**...3 lines */ public static void main(String args[]) { /* Set the Nimbus look and feel */ Look and feel setting code (optional) 333 /* Create and display the form */ java.awt. EventQueue.invokelater(new Runnable() { @Override public void run() { new reservation ().setvisible(true); 335 336 337 338 }); 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 // Variables declaration do not modify private javax.swing.JButton jButtonl; private javax.swing.JButton jButton2; private javax.swing. JButton jButton3; private javax.swing. JButton jButton4; private javax.swing. JLabel jLabell; private javax.swing. JLabel jLabel10; private javax.swing.JLabel jLabelll; private javax.swing. JLabel jLabel12; private javax.swing.JLabel jLabel2; private javax.swing. JLabel jLabel3; private javax.swing. JLabel jLabel4; private javax.swing. JLabel jLabel5; private javax.swing. JLabel jLabel6; private javax.swing. JLabel jLabel7; private javax.swing. JLabel jLabel8; private javax.swing.JLabel jLabel9; private javax.swing.JPanel jPanell; private javax.swing.JScrollpane jscrollpanel; private javax.swing.JTable jTablel; private javax.swing.JTextField txtaddress; private javax.swing.JTextField txtamount; private javax.swing.JComboBox txtbtype; private com. toedter.calendar. JDateChooser txtcheckin; 356 357 358 359 360 361 362 363 mysql-coni mysql-coni - jcalendar- Absolutela DK 12 (DE Test Libraries Hotel 2 6 Source Packag - 18 Hotel_Mar - Hotel #Test Packages - Libraries #Absolute L #jcalendar- # DK 12 (DE La Test libraries 364 365 366 367 368 369 370 371 private com.toedter.calendar. JDateChooser txtcheckout; private javax.swing.JTextField txtmobile; private javax.swing.JTextField txtname; private javax.swing.JComboBox txtro; private javax.swing.JComboBox txtrtype; // End of variables declaration } 6 package hotelmanagement; 7 10 8 import java.sql.Connection; 9 import java.sql.DriverManager; import java.sql. PreparedStatement; 11 import java.sql.ResultSet; import java.sql.SQLException; 13 import java.sql.statement; import java.util.logging. Level; import java.util.logging.Logger; 16 import javax.swing.table.DefaultTableModel; 12 14 15 17 18 public class reservation extends javax.swing.JFrame { 19 20 + .3 lines */ 23 24 /** Creates new form reservation public reservation() { initComponents(); autoID(); } 25 26 27 28 29 Connection c; PreparedStatement ps; DefaultTableModel d; 30 32 public void Connect() { //database method 33 34 35 36 GA try { class. forName ("com.mysql.jdbc.Driver");//database location c = DriverManager.getConnection("jdbc:mysql://localhost:3307/hotelmanagement", "root", ""); } catch (classNotFoundException ex) { Logger.getLogger (Roomnumber.class.getName()).log (Level. SEVERE, null, ex); } catch (SQLException ex) { Logger.getLogger (Roomnumber.class.getName()).log (Level.SEVERE, null, ex); 38 39 40 41 42 43 44 45 S = } private void autoID() { try { Statement c.createStatement (); ResultSet rs = s.executeQuery ("select MAX (reid) from reservation"); rs.next(); rs.getString ("MAX (reid) "); if (rs.getString ("MAX (reid)") == null) { 46 47 48 49 50 51 52 53 jLabel12.setText ("RE001"); } else { long id = Long-parselong(rs.getString ("MAX (reid)").substring (2, rs.getString ("MAX (reid)").length())); 8 8 56 id++; jLabel12.setText ("RE" + String.format("%03d", id)); 57 58 59 } catch (SQLException ex) { Logger.getLogger(Roomnumber.class.getName()).log(Level. SEVERE, null, ex); 60 61 62 63 68 /** This method is called from within the constructor to initialize the form ...5 lines */ @SuppressWarnings ("unchecked") Generated Code 69 303 304 + 307 308 309 330 331 /**...3 lines */ public static void main(String args[]) { /* Set the Nimbus look and feel */ Look and feel setting code (optional) 333 /* Create and display the form */ java.awt. EventQueue.invokelater(new Runnable() { @Override public void run() { new reservation ().setvisible(true); 335 336 337 338 }); 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 // Variables declaration do not modify private javax.swing.JButton jButtonl; private javax.swing.JButton jButton2; private javax.swing. JButton jButton3; private javax.swing. JButton jButton4; private javax.swing. JLabel jLabell; private javax.swing. JLabel jLabel10; private javax.swing.JLabel jLabelll; private javax.swing. JLabel jLabel12; private javax.swing.JLabel jLabel2; private javax.swing. JLabel jLabel3; private javax.swing. JLabel jLabel4; private javax.swing. JLabel jLabel5; private javax.swing. JLabel jLabel6; private javax.swing. JLabel jLabel7; private javax.swing. JLabel jLabel8; private javax.swing.JLabel jLabel9; private javax.swing.JPanel jPanell; private javax.swing.JScrollpane jscrollpanel; private javax.swing.JTable jTablel; private javax.swing.JTextField txtaddress; private javax.swing.JTextField txtamount; private javax.swing.JComboBox txtbtype; private com. toedter.calendar. JDateChooser txtcheckin; 356 357 358 359 360 361 362 363 mysql-coni mysql-coni - jcalendar- Absolutela DK 12 (DE Test Libraries Hotel 2 6 Source Packag - 18 Hotel_Mar - Hotel #Test Packages - Libraries #Absolute L #jcalendar- # DK 12 (DE La Test libraries 364 365 366 367 368 369 370 371 private com.toedter.calendar. JDateChooser txtcheckout; private javax.swing.JTextField txtmobile; private javax.swing.JTextField txtname; private javax.swing.JComboBox txtro; private javax.swing.JComboBox txtrtype; // End of variables declaration }