{"id":17076,"date":"2013-09-09T01:00:53","date_gmt":"2013-09-08T22:00:53","guid":{"rendered":"http:\/\/www.javacodegeeks.com\/?p=17076"},"modified":"2013-09-08T22:13:19","modified_gmt":"2013-09-08T19:13:19","slug":"how-to-create-jquery-datatable-using-json-and-servlet","status":"publish","type":"post","link":"https:\/\/www.javacodegeeks.com\/2013\/09\/how-to-create-jquery-datatable-using-json-and-servlet.html","title":{"rendered":"How to create JQuery DataTable using JSON and servlet"},"content":{"rendered":"

In this article I\u2019ll introduce the basic coding that require to create JQuery DataTable using JSON passed by simple servlet. DataTable is very powerful JQuery based grid with advance features which can be build in short span of time with customize features.
\n 
\n 
\n 
\n 
\n 
\n <\/p>\n

Installation<\/h2>\n
    \n
  1. Download Latest JQuery DataTable download<\/a><\/li>\n
  2. Above download will provide two JQuery plugin jquery.js and queryTables.js\n
    <script type=\"text\/javascript\"\r\ncharset=\"utf-8\" src=\"\/DataTables\/media\/js\/jquery.js\"><\/script>\r\n<script type=\"text\/javascript\"\r\ncharset=\"utf-8\" src=\"\/DataTables\/media\/js\/jquery.dataTables.js\"><\/script><\/pre>\n<\/li>\n
  3. Default stylesheet which shipped with latest DataTable download package\n
    <style type=\"text\/css\" title=\"currentStyle\">\r\n @import \"..\/resources\/css\/demo_table.css\";\r\n<\/style><\/pre>\n<\/ol>\n
    Note:You can download full source code from Github link<\/a><\/em><\/strong><\/li>\n
    Creating the DataTable<\/h2>\n
    We can write below code to create the basic DataTable with data<\/p>\n
    feedSummary.jsp<\/h4>\n
    <script type=\"text\/javascript\" charset=\"utf-8\">\r\n$(document).ready(function() {\r\nvar oTable = $('#tableId').dataTable( {\r\n\"processing\": true,\r\n\"ajax\": {\r\n\"url\": \"\/FeedSummaryUpdate\/FeedServlet\",\r\n\"dataSrc\": \"demo\",\r\n\"type\": \"GET\"\r\n}\r\n} );\r\n} );\r\n<\/script><\/pre>\n
    $(document).ready will ready to execute the javascript and var oTable = $(\u2018#tableId\u2019).dataTable says that write DataTable on tableId place.
     
    <\/div> <\/div><\/p>\n
    DataTables will adding sorting, filtering, paging and information to your table by default, providing the end user of your web-site with the ability to control the display of the table and find the information that they want from it as quickly as possible.<\/p>\n
    The pointer tableId and column name will be defined in table tag as below<\/p>\n
    feedSummary.jsp<\/h4>\n
    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\"\r\nid=\"tableId\">\r\n<thead>\r\n<tr>\r\n<th width=\"10%\">First Name<\/th>\r\n<th width=\"10%\">Last Name<\/th>\r\n<th width=\"10%\">Address 1<\/th>\r\n<th width=\"10%\">Address 2<\/th>\r\n<\/tr>\r\n<\/thead>\r\n<\/table><\/pre>\n
    Above DataTable code invoke FeedServlet which will return JSON string as defined below<\/p>\n
    FeedServlet.java<\/h4>\n
    protected void doPost(HttpServletRequest request,\r\nHttpServletResponse response) throws ServletException, IOException {\r\nPrintWriter out = response.getWriter();\r\nString json = \"{ \\\"demo\\\":[[\\\"First Name\\\",\\\"Last Name\\\",\"+\r\n+\\\"Address1\\\",\\\"Address2\\\"],[\\\"First Name\\\",\\\"Last Name\\\",\\\"Address1\\\",\\\"Address2\\\"]]}\";\r\nout.println(json);\r\n}<\/pre>\n
    Now either we can use servlet annotation or web.xml as below to register above FeedServlet<\/p>\n
    Web.xml<\/h4>\n
    <servlet>\r\n<description><\/description>\r\n<display-name>FeedServlet<\/display-name>\r\n<servlet-name>FeedServlet<\/servlet-name>\r\n<servlet-class>FeedServlet<\/servlet-class>\r\n<\/servlet>\r\n<servlet-mapping>\r\n<servlet-name>FeedServlet<\/servlet-name>\r\n<url-pattern>\/FeedServlet<\/url-pattern>\r\n<\/servlet-mapping><\/pre>\n
    Running<\/h2>\n
    Incorporate the above point and deploy with server to view the result as follows: http:\/\/localhost:8080\/ExampleDataTableJSON\/feedSummary.jsp<\/a><\/p>\n
    JQuery DataTable Image<\/h2>\n
    \"jquery-datatabl\"<\/a><\/p>\n
    Conclusion<\/h2>\n
    You can download full source code from Github link<\/a> and most welcome to fork or update the same.<\/p>\n
    Resources: <\/strong><\/p>\n