USE [KimiExtjs] GO /****** Object: Table [dbo].[Trees] Script Date: 04/08/2010 22:12:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Trees]( [Tid] [varchar](40) COLLATE Chinese_PRC_CI_AS NOT NULL,---Node ID Primary Key Guid [ParentId ] [varchar](40) COLLATE Chinese_PRC_CI_AS NULL,---The parent node ID 0 is represented as the root directory [ContentText] [varchar](800) COLLATE Chinese_PRC_CI_AS NULL,---The actual content of the node [StrHref] [varchar](800) COLLATE Chinese_PRC_CI_AS NULL,---Node link address [hrefTarget] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,---Target CONSTRAINT [PK_Trees] PRIMARY KEY CLUSTERED ( [Tid] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF
Build After the data table, we will start the development of the application program. First, the page design, the html code is as follows: