jsp实现梅花雪树 自动读取数据库

/* MySQL Data Transfer Source Host: localhost Source Database: test Target Host: localhost Target Database: test Date: 2009-9-30 11:27:56 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for tree -- ---------------------------- CREATE TABLE `tree` ( `id` int(11) NOT NULL, `parentId` int(11) default NULL, `text` varchar(50) default NULL, `hint` varchar(100) default NULL, `icon` varchar(20) default NULL, `data` varchar(20) default NULL, `url` varchar(50) default NULL, `target` varchar(20) default NULL, `method` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records -- ---------------------------- INSERT INTO `tree` VALUES ('1', '0', '1', '1', '1', '1', '1', '1', '1'); INSERT INTO `tree` VALUES ('2', '1', '1', '1', '1', null, '1', '1', '1'); INSERT INTO `tree` VALUES ('3', '2', '1', '1', '1', '1', '1', '1', '1');