Advertisement
Guest User

Untitled

a guest
Oct 17th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.39 KB | None | 0 0
  1. public List<Motor> readByCriteria(Connection conn, Map<Long, Object> criteria) throws Exception {
  2. List<Motor> motorList = new ArrayList<>();
  3. String sql = "select * from motor where 1=1";
  4. Statement s = conn.createStatement();
  5. sql += applyCriteria(criteria);
  6. ResultSet rs = s.executeQuery(sql);
  7. Motor motor = null;
  8. while (rs.next()) {
  9. motor = new Motor();
  10. motor.setLigarVentilador(getCalendar(rs.getLong("mot_ligar_ventilador")));
  11. motor.setLigarCilindro(getCalendar(rs.getLong("mot_ligar_cilindro")));
  12. motor.setLigarAcimaDe(rs.getLong("mot_ligar_acima_de"));
  13. motor.setDesligarVentilador(getCalendar(rs.getLong("mot_desligar_ventilador")));
  14. motor.setDesligarCilindro(getCalendar(rs.getLong("mot_desligar_cilindro")));
  15. motor.setDesligarAbaixoDe(rs.getLong("mot_desligar_abaixo_de"));
  16. motor.setTipoEnumMotor(TipoEnumMotor.getEnumMotor(rs.getString("mot_tipo_enum_motor")));
  17. if (criteria.equals("semanal")) {
  18. DiaMotorDAO dmDao = new DiaMotorDAO();
  19. List<DiaMotor> diaMotorList = new ArrayList<>();
  20. diaMotorList = dmDao.readByCriteria(conn, criteria);
  21. motor.setDiaMotorList(diaMotorList);
  22. }
  23. motorList.add(motor);
  24. }
  25. return motorList;
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement