e)ExtJs动态树-拖曳节点
4、导航数据表结构：
5、源码结构图：
6、页面结构图：
二、实现流程 JAVA源码部分： 1、数据库连接 Java代码
1. package com.demo.core.dao; 2.
3. import java.sql.Connection; 4. import java.sql.DriverManager; 5.
6. public class DBConn { 7.
8. private static String url = \angsin\
9. private static String username = \10. private static String password = \
11. private static String driver = \12.
13. public static Connection getConnection(){ 14. Connection conn = null; 15. try{
16. Class.forName(driver);
17. conn = DriverManager.getConnection(url,username,password);
18. }catch(Exception e){ 19. e.printStackTrace(); 20. }
21. return conn; 22. } 23.}
2、dao层： Java代码
1. package com.demo.navigate.dao; 2.
3. import java.io.Serializable; 4. import java.sql.Connection; 5. import java.sql.ResultSet; 6. import java.sql.SQLException; 7. import java.sql.Statement; 8. import java.util.ArrayList; 9. import java.util.List; 10.
11.import com.demo.core.dao.DBConn;
12.import com.demo.navigate.model.Navigate; 13.
14.public class NavigateDao {
15. private static NavigateDao dao; 16. private NavigateDao(){ 17. }
18. public static NavigateDao getInstanece(){ 19. if(null == dao){
20. dao = new NavigateDao(); 21. }
22. return dao; 23. } 24. /**
25. * 获得指定ID的数据
26. * @param id 27. * @return 28. */
29. public Navigate get(Serializable id){ 30. Connection conection = null; 31. Statement stmt = null; 32. ResultSet rs = null; 33. Navigate obj = null; 34. try{
35. conection = DBConn.getConnection(); 36. stmt = conection.createStatement();
37. StringBuffer sql = new StringBuffer(\navigate where id = \38. sql.append(id);
39. rs = stmt.executeQuery(sql.toString()); 40. if(rs.next()) 41. {
42. obj = new Navigate();
43. obj.setId(rs.getInt(\44. obj.setLeaf(rs.getInt(\45. obj.setNumber(rs.getInt(\46. obj.setParentId(rs.getInt(\47. obj.setTitle(rs.getString(\48. obj.setUrl(rs.getString(\49. }
50. }catch(Exception e){
51. e.printStackTrace(); 52. }finally{ 53. try{
54. if(rs != null) { 55. try {
56. rs.close();
57. } catch (SQLException e) { 58. }
59. rs = null; 60. } 61. if (stmt != null) { 62. try {
63. stmt.close();
64. } catch (SQLException sqlex) { 65. }
66. stmt = null; 67. }
68. if (conection != null) {