Java tutorial
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package com.dmr.project.controller; import java.io.IOException; import java.io.PrintWriter; import java.sql.ResultSet; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.google.gson.*; import com.dmr.project.dao.Transformers; import java.util.ArrayList; import java.sql.PreparedStatement; /** * * @author root */ public class TransformerHandler extends HttpServlet { /** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods. * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, SQLException { String[] area; area = request.getParameterValues("area[]"); Transformers transformersList = new Transformers(); ResultSet rs = transformersList.getTransformers(area); //String transformer = request.getParameter("transformer"); // for(int i=0;i < area.length;i++){ // System.out.println("ss" + area[i]); // } // Transformers transformersList = new Transformers(); // ResultSet rs = transformersList.getData(area); // JsonObject jsonResponse = new JsonObject(); JsonArray data = new JsonArray(); while (rs.next()) { JsonArray row = new JsonArray(); row.add(new JsonPrimitive(rs.getString("location"))); data.add(row); } jsonResponse.add("data", data); response.setContentType("application/json"); try (PrintWriter out = response.getWriter()) { out.print(jsonResponse); out.flush(); } // } // response.setContentType("text/html;charset=UTF-8"); // try (PrintWriter out = response.getWriter()) { // /* TODO output your page here. You may use following sample code. */ // out.println("<!DOCTYPE html>"); // out.println("<html>"); // out.println("<head>"); // out.println("<title>Servlet NewServlet</title>"); // out.println("</head>"); // out.println("<body>"); // out.println("Output"+area); // out.println(area.length); // //// for (int i = 0; i < area.length ; i++) { //// out.println(area[i]); //// } //// while(rs.next ()){ //// String temp = rs.getString("location"); //// out.println("Location: "+temp); //// } // // out.println("Output"+rs); // out.println("</body>"); // out.println("</html>"); // } } // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code."> /** * Handles the HTTP <code>GET</code> method. * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { processRequest(request, response); } catch (SQLException ex) { Logger.getLogger(TransformerHandler.class.getName()).log(Level.SEVERE, null, ex); } } /** * Handles the HTTP <code>POST</code> method. * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { processRequest(request, response); } catch (SQLException ex) { Logger.getLogger(TransformerHandler.class.getName()).log(Level.SEVERE, null, ex); } } /** * Returns a short description of the servlet. * * @return a String containing servlet description */ @Override public String getServletInfo() { return "Short description"; }// </editor-fold> }