PreparedStatement ps2 = conn.prepareStatement(
"UPDATE HotelAvailability SET rooms_available = " +
"(rooms_available - ?) WHERE hotel_id = ? " +
"AND booking_date BETWEEN ? AND ?");
-- ��コード例��動的パラメータ�
-- プãƒã‚°ãƒ©ãƒ 変数ã?®å€¤ã‚’代入ã?—ã?¾ã?™ã€‚
ps2.setInt(1, numberRooms);
ps2.setInt(2, theHotel.hotelId);
ps2.setDate(3, arrival);
ps2.setDate(4, departure);
updateCount = ps2.executeUpdate();