public static List<PernottamentoEntity> searchByCityDate( String city, String checkInDateStr, String checkOutDateStr) { List<PernottamentoEntity> pernottamentoList; java.util.Date checkInDate, checkOutDate; SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy"); SimpleDateFormat sdfSQL = new SimpleDateFormat("yyyy/MM/dd"); try { checkInDate = sdf.parse(checkInDateStr); checkInDateStr = sdfSQL.format(checkInDate); checkOutDate = sdf.parse(checkOutDateStr); checkOutDateStr = sdfSQL.format(checkOutDate); } catch (ParseException e) { e.printStackTrace(); } String query = "where città like '" + city + "' AND " + "data_inizio < '" + checkOutDateStr + " 00:00:00' AND " + "data_finale > '" + checkInDateStr + " 00:00:00'"; DAO dao = PernottamentoDaoHibernate.instance(); DBManager.initHibernate(); pernottamentoList = (List<PernottamentoEntity>) dao.getByCriteria(query); DBManager.shutdown(); return pernottamentoList; }
public static PernottamentoEntity getHotelById(String id) { List<PernottamentoEntity> pernottamentoList; String query = "where id =" + id + "'"; DAO dao = PernottamentoDaoHibernate.instance(); DBManager.initHibernate(); pernottamentoList = (List<PernottamentoEntity>) dao.getByCriteria(query); DBManager.shutdown(); return pernottamentoList.get(0); }
public static List<PernottamentoEntity> searchByCity(String city) { List<PernottamentoEntity> pernottamentoList; String query = "where città like '" + city + "'"; DAO dao = PernottamentoDaoHibernate.instance(); DBManager.initHibernate(); pernottamentoList = (List<PernottamentoEntity>) dao.getByCriteria(query); DBManager.shutdown(); return pernottamentoList; }