Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.forgetmenot;
- import java.io.IOException;
- import java.io.OutputStreamWriter;
- import java.sql.Connection;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import javax.servlet.ServletException;
- import javax.servlet.annotation.WebServlet;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import org.json.simple.JSONArray;
- import org.json.simple.JSONObject;
- /**
- * Servlet implementation class GetTuttePiante
- */
- @WebServlet("/GetTuttePiante")
- public class GetTuttePiante extends HttpServlet {
- private static final long serialVersionUID = 1L;
- /**
- * @see HttpServlet#HttpServlet()
- */
- public GetTuttePiante() {
- super();
- // TODO Auto-generated constructor stub
- }
- /**
- * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
- */
- protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- // TODO Auto-generated method stub
- try{
- Connection con = ConnectionManager.getConnection();
- JSONArray a=new JSONArray();
- PreparedStatement stmt=con.prepareStatement("SELECT * FROM pianta ");
- ResultSet rs= stmt.executeQuery();
- //StringWriter out=new StringWriter();
- while(rs.next()){
- JSONObject obj=new JSONObject();
- obj.put("nome",rs.getString("nome"));
- obj.put("immagine",rs.getString("immagine"));
- a.add(obj);
- }
- String jsonText = a.toString();
- System.out.print(jsonText);
- OutputStreamWriter outR = new OutputStreamWriter(response.getOutputStream());
- outR.write(jsonText);
- outR.flush();
- outR.close();
- //out.close();
- rs.close();
- con.close();
- }
- catch(ClassNotFoundException e){
- }
- catch(SQLException e){
- }
- }
- /**
- * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
- */
- protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- // TODO Auto-generated method stub
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement