Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- conn = ConnectionManager.getConnection();
- PreparedStatement stmt = conn.prepareStatement(queryElencoPiante);
- stmt.setInt(1, userID);
- ResultSet rs = stmt.executeQuery();
- JSONArray result = new JSONArray();
- JSONObject obj;
- while (rs.next()) {
- obj = new JSONObject();
- obj.put("ID", rs.getInt("id"));
- obj.put("nomeAssegnato", rs.getString("nomeAssegnato"));
- obj.put("nomePianta", rs.getString("nomePianta"));
- obj.put("immagine", rs.getString("immagine"));
- obj.put("livelloAcqua", Utils.calcolaLivello(rs.getLong("ultimaAcqua"), rs.getInt("intervalloAcqua")));
- obj.put("livelloConcimazione", Utils.calcolaLivello(rs.getLong("ultimoFertilizzante"), rs.getInt("intervalloConcimazione")));
- result.add(obj);
- }
- response.setContentType("application/json; charset=UTF-8");
- response.getWriter().write(result.toString());
- rs.close();
- stmt.close();
- conn.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement