How to calculate the price of a reservation to insert later in the BB DD in DAO?

0

I'm doing a room booking system with Mysql, java and HTML.  I wanted to know How can you calculate the price of a room?   Depending on the days and the type of room, whether they have children or not.   And then as I insert it in the database. Or the best one for me to calculate the price in Java with the setter. The issue that in the DAO model should not use queries to the web page. Since I would have to put request.getParameter("tipodehabitacion") , for example, if I choose camadoble the price would be one and if it is camasimple the price would be another.

I have two tables in this case:

  

T_reservation

+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| fechaLlegada  | date         | YES  | MUL | NULL    |       |
| numNoches     | int(11)      | YES  |     | NULL    |       |
| numAdultos    | int(11)      | YES  |     | NULL    |       |
| numMenDos     | int(11)      | YES  |     | NULL    |       |
| numMenDosDoce | int(11)      | YES  |     | NULL    |       |
| localizador   | varchar(255) | NO   | PRI |         |       |
| observaciones | varchar(255) | YES  |     | NULL    |       |
| precio        | double       | YES  |     | NULL    |       |
| regimen       | varchar(255) | YES  |     | NULL    |       |
| codCliente    | varchar(255) | YES  | MUL | NULL    |       |
| codHotel      | varchar(255) | YES  | MUL | NULL    |       |
| tipoHab       | varchar(255) | YES  | MUL | NULL    |       |
+---------------+--------------+------+-----+---------+-------+
  

T_tiphab

+---------------+----------------+----------------+----------+--------+
| tipo          | numMaxPersonas | disponibilidad | codHotel | precio |
+---------------+----------------+----------------+----------+--------+
| camadoble     |              2 |              0 | 1        |    200 |
| camadoble     |              2 |              0 | 2        |    200 |
| camadoble     |              2 |              0 | 3        |    200 |
| camadoble     |              2 |              0 | 4        |    200 |
| camadoble     |              2 |              0 | 5        |    200 |
| camasimple    |              1 |              0 | 1        |    160 |
| camasimple    |              1 |              0 | 2        |    160 |
| camasimple    |              1 |              0 | 3        |    160 |
| camasimple    |              1 |              0 | 4        |    160 |
| camasimple    |              1 |              0 | 5        |    160 |
| doscamasdoble |              4 |              0 | 1        |    280 |
| doscamasdoble |              4 |              0 | 2        |    280 |
| doscamasdoble |              4 |              0 | 3        |    280 |
| doscamasdoble |              4 |              0 | 4        |    280 |
| doscamasdoble |              4 |              0 | 5        |    280 |
| doscamasimple |              2 |              0 | 1        |    200 |
| doscamasimple |              2 |              0 | 2        |    200 |
| doscamasimple |              2 |              0 | 3        |    200 |
| doscamasimple |              2 |              0 | 4        |    200 |
| doscamasimple |              2 |              0 | 5        |    200 |
+---------------+----------------+----------------+----------+--------+
    
asked by TOMAS 09.02.2018 в 19:09
source

0 answers