做无级分类,表结构如何设计? 要一样表就行了??是不是把父类ID指向表本身类ID ??? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 id | fatherid | CatName1 0 xxx2 0 yyy3 2 zzz --建表if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[topmenu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[topmenu]GOCREATE TABLE [dbo].[topmenu] ( [ID] [int] NOT NULL , [parentId] [int] NOT NULL , [text] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL , [target] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [IsBoot] [int] NULL , [visible] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [status] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GO--插入测试数据insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])values(1,0,'深圳','http://singlepine.cnblogs.com/articles/259955.html','self',0,'false','深圳')insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])values(2,1,'南山','http://singlepine.cnblogs.com/articles/259955.html','self',1,'false','南山')insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])values(3,1,'福田','http://singlepine.cnblogs.com/articles/259955.html','self',1,'false','福田')insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])values(4,2,'科技园','http://singlepine.cnblogs.com/articles/259955.html','self',2,'false','科技园')insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])values(5,3,'塞格','http://singlepine.cnblogs.com/articles/259955.html','self',2,'false','塞格')insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])values(6,0,'广州','http://singlepine.cnblogs.com/articles/259955.html','self',0,'false','广州')insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])values(7,6,'广州火车站','http://singlepine.cnblogs.com/articles/259955.html','self',1,'false','广州火车站') 楼上的,表关系怎么做?是不是把父类ID指向表本身类ID ??? 字段名称 字段类型 作用Classid Int(4)自动id 分类IDClassName Nvarchar(20) 分类名称Parentid Int(4) 父级IDOrderid Int(4) 排序IDDepth Int(4) 分类等级Child Int(4) 含有子类个数LastNode bit 是否最后一个节点 字段分别为:id typename parentid level endflag WCF报错误:传入消息已超过远程通道的最大消息大小 把网站放到服务器上后就出错 导出Excel修改 保存时 可能含有与文本文件(制表符分割)分割不兼容问题 啥情况? 关闭浏览器,退出系统,清除COOKIE ASP。NET连接DB2 非常急的问题!!!!!!各位兄弟姐妹救急啊 求救求救!! 关于如何打印网页中数据的问题? 马上要面试了,大家救我,这是iis问题吗? firefox下怎么获取FileUpload的完整路径名 关于页面定位问题 怎么调用sql文件 asp.net的预览问题,在线等答案
1 0 xxx
2 0 yyy
3 2 zzz
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[topmenu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[topmenu]
GOCREATE TABLE [dbo].[topmenu] (
[ID] [int] NOT NULL ,
[parentId] [int] NOT NULL ,
[text] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[target] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[IsBoot] [int] NULL ,
[visible] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[status] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO--插入测试数据
insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])
values(1,0,'深圳','http://singlepine.cnblogs.com/articles/259955.html','self',0,'false','深圳')insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])
values(2,1,'南山','http://singlepine.cnblogs.com/articles/259955.html','self',1,'false','南山')insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])
values(3,1,'福田','http://singlepine.cnblogs.com/articles/259955.html','self',1,'false','福田')insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])
values(4,2,'科技园','http://singlepine.cnblogs.com/articles/259955.html','self',2,'false','科技园')insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])
values(5,3,'塞格','http://singlepine.cnblogs.com/articles/259955.html','self',2,'false','塞格')insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])
values(6,0,'广州','http://singlepine.cnblogs.com/articles/259955.html','self',0,'false','广州')insert into topmenu([ID],[parentId],[text],[url],[target],[IsBoot],[visible] ,[status])
values(7,6,'广州火车站','http://singlepine.cnblogs.com/articles/259955.html','self',1,'false','广州火车站')
Classid Int(4)自动id 分类ID
ClassName Nvarchar(20) 分类名称
Parentid Int(4) 父级ID
Orderid Int(4) 排序ID
Depth Int(4) 分类等级
Child Int(4) 含有子类个数
LastNode bit 是否最后一个节点
id typename parentid level endflag