private void cmd_checkoutActionPerformed( java.awt.event.ActionEvent evt) { // GEN-FIRST:event_cmd_checkoutActionPerformed // TODO add your handling code here: if (txt_id.getText().length() == 0) { JOptionPane.showMessageDialog(null, "Please select a room"); } else { int p = JOptionPane.showConfirmDialog( null, "Are you sure you want to procee to Checkout?", "Checkout", JOptionPane.YES_NO_OPTION); if (p == 0) { String sql = "Update rooms set available=? where roomid=?"; try { pst = conn.prepareStatement(sql); pst.setString(1, "Yes"); pst.setString(2, tableindex); pst.execute(); } catch (Exception e) { JOptionPane.showMessageDialog(null, e); } String sql2 = "Update checkIn set status=? where id=?"; try { pst = conn.prepareStatement(sql2); pst.setString(1, "out"); pst.setString(2, id); pst.execute(); } catch (Exception e) { JOptionPane.showMessageDialog(null, e); } JOptionPane.showMessageDialog(null, "Done Checkout"); Update_table(); txt_customer.setText(""); txt_id.setText(""); txt_price.setText(""); txt_roomdescription.setText(""); txt_roomname.setText(""); } } } // GEN-LAST:event_cmd_checkoutActionPerformed
public CheckOut() { initComponents(); conn = javaconnect.ConnecrDb(); Update_table(); }