public static Map<String, Table> mapTableReserver(DAOFactory daoFactory, long id)
throws SQLException {
String SQL_SELECT_PAR_ID =
"SELECT * FROM reservation_tb,table_tb WHERE reservation_tb.idtable = table_tb.id AND reservation_tb.id = ?";
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
Map<String, Table> tables = null;
tables = new HashMap<String, Table>();
try {
connection = daoFactory.getConnection();
preparedStatement = initialisationRequetePreparee(connection, SQL_SELECT_PAR_ID, false, id);
resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
Table table = new Table();
table.setId(resultSet.getLong("idtable"));
table.setNom(resultSet.getString("nom"));
table.setNbrePlace(resultSet.getLong("nbreplace"));
table.setNbrePlaceDipso(resultSet.getLong("nbreplacedispo"));
tables.put(resultSet.getString("nom"), table);
}
} catch (SQLException e) {
throw new DAOException(e);
} finally {
fermeturesSilencieuses(resultSet, preparedStatement, connection);
}
return tables;
}
/*
* Simple méthode utilitaire permettant de faire la correspondance(le
* mapping) entre une ligne issue de la table des places assises du restaurant (un
* ResultSet) et un bean Table.
*/
public static Table mapTable(ResultSet resultSet) throws SQLException {
Table table = new Table();
table.setId(resultSet.getLong("id"));
table.setNom(resultSet.getString("nom"));
table.setNbrePlace(resultSet.getLong("nbreplace"));
table.setNbrePlaceDipso(resultSet.getLong("nbrepacedispo"));
return table;
}