Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public List<Motor> readByCriteria(Connection conn, Map<Long, Object> criteria) throws Exception {
- List<Motor> motorList = new ArrayList<>();
- String sql = "select * from motor where 1=1";
- Statement s = conn.createStatement();
- sql += applyCriteria(criteria);
- ResultSet rs = s.executeQuery(sql);
- Motor motor = null;
- while (rs.next()) {
- motor = new Motor();
- motor.setLigarVentilador(getCalendar(rs.getLong("mot_ligar_ventilador")));
- motor.setLigarCilindro(getCalendar(rs.getLong("mot_ligar_cilindro")));
- motor.setLigarAcimaDe(rs.getLong("mot_ligar_acima_de"));
- motor.setDesligarVentilador(getCalendar(rs.getLong("mot_desligar_ventilador")));
- motor.setDesligarCilindro(getCalendar(rs.getLong("mot_desligar_cilindro")));
- motor.setDesligarAbaixoDe(rs.getLong("mot_desligar_abaixo_de"));
- motor.setTipoEnumMotor(TipoEnumMotor.getEnumMotor(rs.getString("mot_tipo_enum_motor")));
- if (criteria.equals("semanal")) {
- DiaMotorDAO dmDao = new DiaMotorDAO();
- List<DiaMotor> diaMotorList = new ArrayList<>();
- diaMotorList = dmDao.readByCriteria(conn, criteria);
- motor.setDiaMotorList(diaMotorList);
- }
- motorList.add(motor);
- }
- return motorList;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement