Advertisement
Guest User

Untitled

a guest
Apr 17th, 2014
41
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.83 KB | None | 0 0
  1. var oTable;
  2. $(function(){
  3. oTable = $('#data').dataTable({
  4. "sDom": 'TC<"clear">lfrtip',
  5. "processing": true,
  6. "serverSide": true,
  7. "bJQueryUI":true,
  8. "sPaginationType": "full_numbers",
  9. "ajax": {
  10. url: 'worldCheck',
  11. type: 'GET'
  12. },
  13. (...)
  14. });
  15. });
  16.  
  17. @WebServlet("/worldCheck")
  18. public class worldCheck extends HttpServlet {
  19. private static final long serialVersionUID = 1L;
  20.  
  21.  
  22. protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  23. int rows;
  24. JSONObject obj = new JSONObject();
  25. JSONArray back = new JSONArray();
  26. try{
  27. Class.forName("com.mysql.jdbc.Driver");
  28. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/check","****","****");
  29. Statement stmt = con.createStatement();
  30. ResultSet rs = stmt.executeQuery("SELECT UID,LastName,FirstName,BDay FROM worldCheck");
  31. ResultSetMetaData meta = rs.getMetaData();
  32. rows = meta.getColumnCount();
  33.  
  34. while(rs.next())
  35. {
  36. JSONArray array = new JSONArray();
  37. array.put(rs.getString("UID"));
  38. array.put(rs.getString("LastName"));
  39. array.put(rs.getString("FirstName"));
  40. array.put(rs.getString("BDay"));
  41. back.put(array);
  42. }
  43.  
  44. obj.put("data", back);
  45. obj.put("draw", 1);
  46. obj.put("recordsTotal", rows);
  47. obj.put("recordsFiltered", rows);
  48. response.setContentType("application/json");
  49. PrintWriter out = response.getWriter();
  50. out.print(obj);
  51.  
  52. con.close();
  53. }catch(Exception e)
  54. {
  55. e.printStackTrace();
  56. }
  57. }
  58.  
  59.  
  60. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  61. doGet(request, response);
  62. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement