Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- protected void processRequest(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
- response.setContentType("text/html;charset=UTF-8");
- String searchQuery = "select * from jobs";
- DbUtil dbUtil = new DbUtil();
- ResultSet rs = DbUtil.readData(searchQuery);
- JSONArray listJobs = new JSONArray();
- try{
- while(rs.next()){
- //Retrieve by col and set to json obe
- JSONObject tempJob = new JSONObject();
- tempJob.put("jobCategory",jobCategory);
- listJobs.put(tempJob);
- }
- try (PrintWriter out = response.getWriter()) {
- /* TODO output your page here. You may use following sample code. */
- response.setContentType("application/json");
- response.getWriter().print(listJobs);
- //out.print(listJobs);
- response.sendRedirect("searchresult.html");
- }
- <html>
- <script src="http://code.jquery.com/jquery-latest.min.js"></script>
- <script type="text/javascript">
- $(document).ready(function() {
- $.get('JobSearch',function(responseJson) {
- if(responseJson!=null){
- $("#countrytable").find("tr:gt(0)").remove();
- var table1 = $("#countrytable");
- $.each(responseJson, function(key,value) {
- var rowNew = $("<tr><td></td><td></td>/tr>");
- rowNew.children().eq(0).text(value['jobPosition']);
- rowNew.children().eq(1).text(value['jobCountry']);
- rowNew.appendTo(table1);
- });
- }
- });
- $("#tablediv").show();
- });
- </script>
- <body>
- <div id="tablediv">
- <table cellspacing="0" id="countrytable">
- <tr>
- <th scope="col">Code</th>
- <th scope="col">Name</th>
- </tr>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement