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
	}

}