Advertisement
Guest User

Untitled

a guest
Apr 29th, 2016
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.93 KB | None | 0 0
  1. conn = ConnectionManager.getConnection();
  2.             PreparedStatement stmt = conn.prepareStatement(queryElencoPiante);
  3.             stmt.setInt(1, userID);
  4.             ResultSet rs = stmt.executeQuery();
  5.             JSONArray result = new JSONArray();
  6.             JSONObject obj;
  7.            
  8.             while (rs.next()) {
  9.                 obj = new JSONObject();
  10.                 obj.put("ID", rs.getInt("id"));
  11.                 obj.put("nomeAssegnato", rs.getString("nomeAssegnato"));
  12.                 obj.put("nomePianta", rs.getString("nomePianta"));
  13.                 obj.put("immagine", rs.getString("immagine"));
  14.                 obj.put("livelloAcqua", Utils.calcolaLivello(rs.getLong("ultimaAcqua"), rs.getInt("intervalloAcqua")));
  15.                 obj.put("livelloConcimazione", Utils.calcolaLivello(rs.getLong("ultimoFertilizzante"), rs.getInt("intervalloConcimazione")));
  16.                 result.add(obj);
  17.             }
  18.            
  19.             response.setContentType("application/json; charset=UTF-8");
  20.             response.getWriter().write(result.toString());
  21.            
  22.             rs.close();
  23.             stmt.close();
  24.             conn.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement