Extjs动态树的实现以及节点拖拽(2)

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) {

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库Extjs动态树的实现以及节点拖拽(2)在线全文阅读。