JSON Array and JSON Object

JSON Array and JSON Object.java

package examadmin;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.json.JSONArray;
import org.json.JSONObject;

public class fetchPlanDetails extends HttpServlet 
{
	private static final long serialVersionUID = 1L;
	Connection conn;
	ResultSet rs,rs1,rs2;
	PreparedStatement ps,ps1,ps2;
	
    public fetchPlanDetails() 
    {
        super();
        conn = ExamConnection.getConnection();
        System.out.println("connection successfully");
    }
    
    public void process(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
    {
    	try
    	{
    		JSONArray jarray=new JSONArray();
    		PrintWriter out = response.getWriter();
    		 
    		String planId=request.getParameter("planId");     		

			String SelectQuery=" select kp.stream,kp.set_for,kp.kpa_period,kp.plan_Date "+
							   " from kpa_plan kp "+
							   " where kp.Kpa_Plan_Id="+planId; 
			 
			ps = conn.prepareStatement(SelectQuery);
    		rs= ps.executeQuery();
    		 
    		rs.last();
    		int size=rs.getRow(); 
   			rs.beforeFirst();  
   			 
			jarray.put(size); 
			
    		while(rs.next())
    		{ 
    			JSONObject jobj = new JSONObject();
    			jobj.putOpt("stream", rs.getString("stream"));
    			jobj.putOpt("plan_Date", rs.getString("plan_Date"));
    			jobj.putOpt("Set_for_Type", rs.getString("set_for")); 
    			jobj.putOpt("Appraisal_Period_Type", rs.getString("kpa_period"));
    			jarray.put(jobj);
    		}
    		
    		out.print(jarray);          		
     	}
    	catch(SQLException e) 
    	{ 
    		System.out.println(e);
    	}
    }

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{
		this.process(request, response);
	}
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{
		this.process(request, response);
	}
}