Ext+Dwr动态树(增删改)

<?xmlversion="1.0"encoding="UTF-8"?>
1. <web-appversion="2.4"
2. xmlns="http://java.sun.com/xml/ns/j2ee"
3. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4. xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
5. http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
6. servlet>
7. servlet-name>navigatejson</servlet-class com.demo.navigate.web.NavigateJsonServlet
8. >navigateedit com.demo.navigate.web.NavigateEditServlet
9. >navigatesave com.demo.navigate.web.NavigateSaveServlet
10. servlet-mappingurl-pattern>/navigatejson>/navigateedit>/navigatesave>dwr-invoker>uk.ltd.getahead.dwr.DWRServletinit-paramparam-name>debugparam-value>true allowGetForSafariButMakeForgeryEasier
11. load-on-startup>1>/dwr/*welcome-file-listwelcome-file>index.jspweb-app>

DWR配置:

<!DOCTYPEdwrPUBLIC"-//GetAheadLimited//DTDDirectWebRemoting2.0//EN""http://www.getahead.ltd.uk/dwr//dwr20.dtd"dwrallowcreatejavascript="NavigateManager"creator="new"paramname="class"
1. value="com.demo.navigate.service.NavigateManager"paramincludemethod="ajaxUpdateTitle"/>
2. includemethod="ajaxRemoveNode"/>
3. includemethod="ajaxMoveNode"create>

servlet程序:

packagecom.demo.navigate.web;
1. importjava.io.IOException;
2. importjavax.servlet.RequestDispatcher;
3. importjavax.servlet.ServletException;
4. importjavax.servlet.http.HttpServlet;
5. importjavax.servlet.http.HttpServletRequest;
6. importjavax.servlet.http.HttpServletResponse;
7. importcom.demo.navigate.model.Navigate;
8. importcom.demo.navigate.service.NavigateManager;
9. @SuppressWarnings("serial")
10. publicclassNavigateSaveServletextendsHttpServlet{
11. voiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
12. throwsServletException,IOException{
13. this.doPost(request,response);
14. voiddoPost(HttpServletRequestrequest,108); list-style:decimal-leading-zero outside; color:inherit; line-height:18px"> NavigateManagernavigateManager=newNavigateManager();
15. Navigateobj=null;
16. request.setCharacterEncoding("UTF-8");
17. Stringid=request.getParameter("id");
18. Stringnumber=request.getParameter("number");
19. StringparentId=request.getParameter("parentId");
20. Stringleaf=request.getParameter("leaf");
21. Stringtitle=request.getParameter("title");
22. Stringurl=request.getParameter("url");
23. null!=id&&!"".equals(id)){
24. obj=navigateManager.get(id);
25. if(obj==null){
26. RequestDispatcherdispatcher=request.getRequestDispatcher("/navigate/error.jsp");
27. dispatcher.forward(request,response);
28. return;
29. obj=newNavigate();
30. obj.setLeaf(newInteger(leaf));
31. obj.setParentId(newInteger(parentId));
32. obj.setNumber(newInteger(number));
33. obj.setTitle(title);
34. obj.setUrl(url);
35. null!=id&&!"".equals(id)){
36. navigateManager.update(obj);
37. navigateManager.save(obj);
38. RequestDispatcherdispatcher=request.getRequestDispatcher("/navigate/success.jsp");
39. dispatcher.forward(request,response);
40. }

importcom.demo.navigate.service.NavigateManager;
1. @SuppressWarnings("serial")
2. classNavigateJsonServletextendsHttpServlet{
3. NavigateManagernavigateManager=newNavigateManager();
4. request.setAttribute("list",navigateManager.getChildrenById(newInteger(request.getParameter("id"))));
5. RequestDispatcherdispatcher=request.getRequestDispatcher("/navigate/console-json.jsp");
6. }

classNavigateEditServlet Stringidstr=request.getParameter("id");
1. Stringnumber=request.getParameter("number");
2. Navigateobj=null;
3. null!=idstr){
4. obj=navigateManager.get(idstr);
5. obj=newNavigate();
6. request.setAttribute("obj",obj);
7. RequestDispatcherdispatcher=request.getRequestDispatcher("/navigate/console-edit.jsp");
8. }

service程序:

packagecom.demo.navigate.service;
1. importjava.io.Serializable;
2. importjava.util.List;
3. importcom.demo.navigate.dao.NavigateDao;
4. classNavigateManager{
5. privateNavigateDaodao=NavigateDao.getInstanece();
6. publicNavigateget(Serializableid){
7. returndao.get(id);
8. /**
9. *获得指定节点的所有儿子节点
10. *@paramid
11. */
12. @SuppressWarnings("unchecked")
13. publicList<Navigate>getChildrenById(Integerid){
14. returndao.getChildrenById(id);
15. *保存数据
16. *@paramobj
17. voidsave(Navigateobj){
18. dao.save(obj);
19. /**
20. *更新数据
21. *@paramobj
22. */
23. voidupdate(Navigateobj){
24. dao.update(obj);
25. *删除指定的一条数据
26. voidremoveById(Integerid){
27. dao.removeById(id);
28. *异步更新标题
29. *@paramid
30. *@paramtitle
31. *@returntrue-修改成功false-修改失败
32. publicBooleanajaxUpdateTitle(Integerid,Stringtitle){
33. returndao.ajaxUpdateTitle(id,title);
34. *异步删除数据，包括其子孙节点
35. *@paramtitle
36. voidajaxRemoveNode(Integerid){
37. Navigateobj=dao.get(id);
38. dao.downNode(obj.getParentId(),obj.getNumber(),-1);
39. dao.ajaxRemoveNode(id);
40. *异步移动指定节点
41. *@paramid指定的节点的id
42. *@paramoldParentId节点移动前所在的父节点
43. *@paramnewParentId节点移动后的目标父节点
44. *@paramnodeIndex节点移动后的目标位置
45. voidajaxMoveNode(intid,153); background-color:inherit; font-weight:bold">intoldParentId,153); background-color:inherit; font-weight:bold">intnewParentId,153); background-color:inherit; font-weight:bold">intnodeIndex){
46. dao.ajaxMoveNode(id,oldParentId,newParentId,nodeIndex);
47. }

model程序:

packagecom.demo.navigate.model;
1. classNavigate{
2. privateIntegerid;
3. privateIntegerparentId;
4. privateStringtitle;
5. privateIntegernumber;
6. privateIntegerleaf;
7. privateStringurl;
8. publicIntegergetId(){
9. returnid;
10. voidsetId(Integerid){
11. this.id=id;
12. publicIntegergetParentId(){
13. returnparentId;
14. voidsetParentId(IntegerparentId){
15. this.parentId=parentId;
16. publicStringgetTitle(){
17. returntitle;
18. voidsetTitle(Stringtitle){
19. this.title=title;
20. publicIntegergetNumber(){
21. returnnumber;
22. voidsetNumber(Integernumber){
23. this.number=number;
24. publicIntegergetLeaf(){
25. returnleaf;
26. voidsetLeaf(Integerleaf){
27. this.leaf=leaf;
28. publicStringgetUrl(){
29. returnurl;
30. voidsetUrl(Stringurl){
31. this.url=url;
32. }

Dao程序:

packagecom.demo.navigate.dao;
1. importjava.sql.Connection;
2. importjava.sql.ResultSet;
3. importjava.sql.SQLException;
4. importjava.sql.Statement;
5. importjava.util.ArrayList;
6. importjava.util.List;
7. importcom.demo.core.dao.DBConn;
8. importcom.demo.navigate.model.Navigate;
9. classNavigateDao{
10. privatestaticNavigateDaodao;
11. privateNavigateDao(){
12. staticNavigateDaogetInstanece(){
13. null==dao){
14. dao=newNavigateDao();
15. returndao;
16. *获得指定ID的数据
17. *@return
18. Connectionconection= Statementstmt= ResultSetrs=try{
19. conection=DBConn.getConnection();
20. stmt=conection.createStatement();
21. StringBuffersql=newStringBuffer("select*fromnavigatewhereid=");
22. sql.append(id);
23. rs=stmt.executeQuery(sql.toString());
24. if(rs.next())
25. {
26. obj.setId(rs.getInt("id"));
27. obj.setLeaf(rs.getInt("leaf"));
28. obj.setNumber(rs.getInt("number"));
29. obj.setParentId(rs.getInt("parentId"));
30. obj.setTitle(rs.getString("title"));
31. obj.setUrl(rs.getString("url"));
32. catch(Exceptione){
33. e.printStackTrace();
34. finally{
35. try{
36. if(rs!=null){
37. rs.close();
38. catch(SQLExceptione){
39. rs=if(stmt!= stmt.close();
40. catch(SQLExceptionsqlex){
41. stmt=if(conection!= conection.close();
42. catch(SQLExceptionsqlex){
43. conection=catch(Exceptione){
44. e.printStackTrace();
45. returnobj;
46. List<Navigate>list=newArrayList<Navigate>();
47. Connectionconection= Statementstmt= ResultSetrs=newStringBuffer("select*fromnavigatewhereparentId=");
48. sql.append("orderbynumber,id");
49. System.out.println("首页加载树SQL=="+sql.toString());
50. while(rs.next())
51. list.add(obj);
52. finally{
53. rs.close();
54. catch(SQLExceptione){
55. rs= stmt.close();
56. stmt= conection.close();
57. conection=returnlist;
58. *保存数据
59. voidsave(Navigateobj){
60. StringBuffersql=newStringBuffer("insertintonavigate(parentId,title,leaf,number,url)values(");
61. sql.append(obj.getParentId());
62. sql.append(",'");
63. sql.append(obj.getTitle());
64. sql.append("',");
65. sql.append(obj.getLeaf());
66. sql.append(obj.getNumber());
67. sql.append(obj.getUrl());
68. sql.append("')");
69. this.bulkUpdate(sql.toString());
70. *更新数据
71. voidupdate(Navigateobj){
72. newStringBuffer("updatenavigateset");
73. sql.append("parentId=");
74. sql.append("title='");
75. sql.append(obj.getTitle());
76. sql.append("',");
77. sql.append("leaf=");
78. sql.append("number=");
79. sql.append(obj.getNumber());
80. sql.append(",url='");
81. sql.append(obj.getUrl());
82. sql.append("'whereid=");
83. sql.append(obj.getId());
84. *异步更新标题
85. *@returntrue-修改成功false-修改失败
86. Booleanflag=this.get(id);
87. null!=obj){
88. newStringBuffer("updatenavigateset");
89. sql.append(title);
90. sql.append("'");
91. sql.append("whereid=");
92. sql.append(id);
93. this.bulkUpdate(sql.toString());
94. flag=returnflag;
95. newStringBuffer("deletefromnavigatewhereid=");
96. @SuppressWarnings("unchecked")
97. voidajaxRemoveNode(Integerid){
98. Listlist=this.getChildrenById(id);
99. for(Objectobject:list){
100. Navigateobj=(Navigate)object;
101. ajaxRemoveNode(obj.getId());
102. this.removeById(id);
103. *移动指定节点
104. *@paramid指定的节点的id
105. *@paramoldParentId节点移动前所在的父节点
106. *@paramnewParentId节点移动后的目标父节点
107. *@paramnodeIndex节点移动后的目标位置
108. intnodeIndex){
109. this.get(id);
110. intminIndex=obj.getNumber().intValue();
111. intmaxIndex=nodeIndex;
112. if(oldParentId==newParentId&&minIndex!=maxIndex){
113. //在同一个父节点下发生移动
114. if(minIndex<maxIndex){
115. //当要移动的节点的序号小于要移动到的目标序号，则下移
116. this.downNode(oldParentId,minIndex,maxIndex);
117. elseif(minIndex>maxIndex){
118. //当要移动的节点的序号大于要移动到的目标序号，则上移
119. maxIndex=minIndex;
120. minIndex=nodeIndex;
121. this.upNode(oldParentId,maxIndex);
122. //节点本身的序号设置成要移动到的目标序号
123. obj.setNumber(nodeIndex);
124. this.update(obj);
125. if(oldParentId!=newParentId){
126. //在不同父节点下发生移动
127. //1、相当于要移动的节点在原父节点下下移到最后再删除掉，因此要指定移动发生时节点所在的位置
128. 1);
129. //2、相当于要移动的节点在新父节点下上移到指定的位置，因此需要指定要移动到的位置
130. this.upNode(newParentId,maxIndex,108); list-style:decimal-leading-zero outside; color:inherit; line-height:18px"> obj.setParentId(newParentId);
131. this.update(obj);
132. *指定的节点下移
133. *@paramparentId指定范围内要移动的节点的父节点
134. *@paramminIndex指定节点移动发生时所在的位置
135. *@parammaxIndex指定节点要移动到的目标位置
136. voiddownNode(intparentId,153); background-color:inherit; font-weight:bold">intminIndex,153); background-color:inherit; font-weight:bold">intmaxIndex){
137. //指定的节点下移，意味着其范围内的节点各自减1
138. newStringBuffer("updatenavigatesetnumber=number-1whereparentId=");
139. sql.append(parentId);
140. if(maxIndex!=-1){
141. sql.append("andnumber<=");
142. sql.append(maxIndex);
143. if(minIndex!=- sql.append("andnumber>");
144. sql.append(minIndex);
145. *指定的节点上移
146. *@paramparentId指定范围内要移动的节点的父节点
147. *@paramminIndex指定节点要移动到的目标位置
148. *@parammaxIndex指定节点移动发生时所在的位置
149. voidupNode(intmaxIndex){
150. //指定的节点上移，意味着其范围内的节点各自加1
151. newStringBuffer("updatenavigatesetnumber=number+1whereparentId=");
152. sql.append(parentId);
153. 1){
154. sql.append("andnumber<");
155. sql.append(maxIndex);
156. sql.append("andnumber>=");
157. sql.append(minIndex);
158. *批量更新或删除操作
159. *@paramsql
160. voidbulkUpdate(Stringsql){
161. stmt.executeUpdate(sql);
162. copy
     packagecom.demo.core.dao;
     1. importjava.sql.Connection;
     2. importjava.sql.DriverManager;
     3. classDBConn{
     4. staticStringurl="jdbc:mysql://localhost:3306/langsin";
     5. staticStringusername="root";
     6. staticStringpassword="tiger";
     7. staticStringdriver="com.mysql.jdbc.Driver";
     8. staticConnectiongetConnection(){
     9. Connectionconn= Class.forName(driver);
     10. conn=DriverManager.getConnection(url,username,password);
     11. returnconn;
     12. }

     
     数据库脚本:
     

     [sql] copy
     createtablenavigate(
     1. idintprimarykeyauto_increment,108); list-style:decimal-leading-zero outside; color:inherit; line-height:18px"> leafintnotnull,248); line-height:18px"> number parentId titlevarchar(50) urlvarchar(200)null
     2. );

     
     页面:

     copy
     <%@pagecontentType="text/html;charset=UTF-8"%<%
     1. Stringpath=request.getContextPath();
     2. StringbasePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
     3. %>htmlheadtitle>导航控制linkrel="stylesheet"type="text/css"href="../scripts/ext/resources/css/ext-all.css"scripttype="text/javascript"src="<%=basePath%>/scripts/ext/adapter/ext/ext-base.js"scriptscripttype="text/javascript"src="<%=basePath%>/scripts/ext/ext-all.js"scripttype="text/javascript"src="<%=basePath%>/dwr/engine.js"scripttype="text/javascript"src="<%=basePath%>/dwr/util.js"scripttype="text/javascript"src="<%=basePath%>/dwr/interface/NavigateManager.js"scripttype="text/javascript" varglbRootPath="<%=basePath%>";
     4. scripttype="text/javascript"src="<%=basePath%>/scripts/navigate/console-index.js"body>

     （编辑：李大同）

     【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!