Easyui DataGrid use (Good)

Load the relevant JS and CSS, because Easyui relies on jquery, all load easyui before loading jquery, otherwise you will not be prompted to find the DataGrid

2. <!--load jquery--
4. <script type="Text/javascript" src="Plugins/jquery/jquery-1.4.2.min.js"> </Script>
6. <!--load Jquery-easyui --
8. <link rel="stylesheet" type= "text/css" href= "plugins/jquery/ Jquery-easyui-1.1.2/themes/default/easyui.css ">
10. <link rel="stylesheet" type= "text/css" href= "plugins/jquery/ Jquery-easyui-1.1.2/themes/icon.css ">
12. <script type="Text/javascript" src= "plugins/jquery/jquery-easyui-1.1.2/ Jquery.easyui.min.js "></script>

Interface Join

1. <table id="Cxdm"></table>

Load the DataGrid's JS code

2. Page load
4. $ (document). Ready (function () {
6. Loadgrid ();
8. });
12. Load table DataGrid
14. function Loadgrid ()
16. {
18. //Load Data
20. $ (' #cxdm '). DataGrid ({
22. Width: ' auto ',
24. Height:
26. Striped: true,
28. Singleselect: True,
30. URL:' getpsnewconsultlist.action ',
32. //queryparams:{},
34. Loadmsg:' data loading please later ... ',
36. Pagination: true,
38. Rownumbers: True,
40. columns:[[
42. {field:' Adviceid ', title: ' Communication number ', align: ' center ', width:getwidth (0.2)},
44. {field:' Consulter ', title: ' the ' align ', ' Center ', width:getwidth (0.45),
46. //Add super-chain and pass in the future as a parameter
48. Formatter:function (Val,rec) {
50. //alert (Rec.adviceid);
52. return "<a href= ' jsp/proposal/psconsultview.jsp?id=" +rec.adviceid+">" +val+"</a>";
54. }
56. },
58. {field:' content ', title: ' state ', align: ' center ', width:getwidth (0.2)},
60. {field:' Replynumber ', title: ' number of replies ', Align: ' center ', width:getwidth (0.05)}
62. ]]
64. });
66. }
70. Add parameters for Loadgrid ()
72. var queryparams = $ (' #cxdm '). DataGrid (' Options '). Queryparams;
74. queryparams.who = Who.value;
76. Queryparams.type = Type.value;
78. Queryparams.searchtype = Searchtype.value;
80. Queryparams.keyword = Keyword.value;
82. //Reload data for DataGrid
84. $ ("#cxdm"). DataGrid (' reload ');

How the DataGrid adds parameters

2. Add parameters for Loadgrid ()
4. var queryparams = $ (' #cxdm '). DataGrid (' Options '). Queryparams;
6. queryparams.who = Who.value;
8. Queryparams.type = Type.value;
10. Queryparams.searchtype = Searchtype.value;
12. Queryparams.keyword = Keyword.value;
14. //Reload data for DataGrid
16. $ ("#cxdm"). DataGrid (' reload ');

Or add them directly to the URL.

1. $ (' #repeatpspolal '). DataGrid ({
2. Title:' repeated proposals for the first minute ',
3. Loadmsg:"Data loading, please later ...",
4. Region:' North ',
5. URL:"getrepeatps.action?documentnumber=" +documentnumber+"&simdegree=" +simdegree,
6. 。。。。。。

Action Layer

2. Current page number
4. private int page;
6. .........
8. Comment Result set
10. Private list<object> rows;
12. ...........
16. @SuppressWarnings ("unchecked")
18. Public String getpsnewconsultlist () throws globalexception {
20. //Gets the number of rows displayed per page
22. int pagerows=10;
24. if (null!=request.getparameter ("Rows")) {
26. Pagerows=integer.parseint (Request.getparameter ("Rows"). toString ());
28. }
30. ...........
32. //Get result set
34. this.setrows (Proposalservice.getpsnewconsultlist (consulter,consultee,type,psid,pscontent,pagerows* (page-  1) +1,pagerows*page));
36. //Get the total number of records
38. this.settotal (100);
40. ...............
42. }

The page is passed in by the DataGrid, and when the user selects the number of rows displayed per page in the lower-left corner of the DataGrid, the DataGrid appends the value as an argument to the URL passed into the action, and the name is called page. Also, the total row count of results is passed to the DataGrid for paging

It is not known whether the DataGrid is misconfigured or the Bug,datagrid result set of the DataGrid and the number of rows displayed per page are called rows, with the same name.

As a workaround, the result set is still called rows, but the list type is changed to object instead of the entity type, and the number of rows displayed per page is obtained by request

When the action is configured, to inherit Json-default,json-default inherits from Struts-default, also configure the output result type to be JSON

2. <action name="getpsnewconsultlist" class="proposalconsultaction" method= "Getpsnewconsultlist" >
4. <result name="Success" type="json" >
6. <param name="Includeproperties" >
8. ^rows\[\d+\]\.\w+,total
10. </param>
12. <param name="NoCache" >true</param>
14. <param name="Ignorehierarchy" >false</param>
16. </result>
18. </action>

Service Layer

1. @SuppressWarnings ("unchecked")
2. Public List getpsnewconsultlist (String consulter,string consultee,string type,string psid,string pscontent, int pagerows,int page) throws Exception {
3. return Proposaldao.getpsnewconsultlist (consulter,consultee,type,psid,pscontent,pagerows,page);
4. }

The DAO layer simply joins the data loop in the resultset to the entity attribute and then joins the entity instance to the list, in the following form:

1. list<person> list=New arraylist<person> ();
2. person person=null;
3. while (Rs.next ())
4. {
5. person=new Person ();
6. Person.setid (i);
7. Person.setname ("name" +i);
8. List.add (person);
9. }
10. .........
11. return list;
    

Easyui DataGrid use (Good)