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();
}
