public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException { String fName = req.getParameter("fName"); String lName = req.getParameter("lName"); String party = req.getParameter("party"); String area = req.getParameter("area"); Connection c = null; try { DriverManager.registerDriver(new AppEngineDriver()); c = DriverManager.getConnection( "jdbc:google:rdbms://netivalimised2013:netivalimised/evalimised"); String statement; if ((fName.equals("") || fName == null) && (lName.equals("") || lName == null) && (party.equals("") || party == null) && (area.equals("") || area == null)) { System.out.println("Getting all candidates"); statement = "SELECT Person.FirstName, Person.LastName, Party.PartyName, Area.AreaName " + "FROM Person JOIN Party ON Person.PartyID = Party.Party_Id JOIN Area ON Person.AreaID = Area.Area_Id"; } else statement = createQuery(fName, lName, party, area); PreparedStatement stmt = c.prepareStatement(statement); ResultSet rs = stmt.executeQuery(); String jsonData = createJSON(rs, party, area); resp.setContentType("application/json"); resp.setCharacterEncoding("UTF-8"); resp.getWriter().write(jsonData); } catch (SQLException e) { e.printStackTrace(); } finally { if (c != null) { try { c.close(); } catch (SQLException ignore) { } } } // resp.setHeader("Refresh","3; url=/evalimised.jsp"); }