Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void consultaNiveisDeAgua(List<Reservatorio> reservatorios){
- ConDB conBD = dados.getConn();
- String selectStr = "Select * From reservatorio";
- PreparedStatement selectStmnt = null;
- try {
- selectStmnt = conBD.getConn().prepareStatement(selectStr);
- ResultSet rsSelect = selectStmnt.executeQuery();
- while(rsSelect.next()){
- int id = rsSelect.getInt("id");
- for(Reservatorio reservatorio : reservatorios){
- if(id==reservatorio.getId()){
- double nivel = rsSelect.getInt("nivel_atual");
- reservatorio.setNivelAtual(nivel);
- System.out.println("Reservatorio:"+id+"\n\tNivel Atualizado:"+nivel);
- }
- }
- }
- rsSelect.close();
- } catch (SQLException e) {
- System.err.println("selectIdDest:: Ocorreu um erro Sql: \n\t" + e);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement