JSP新闻系统跟我学之一数据库设计

来源：互联网发布：88折话费源码编辑：程序博客网时间：2024/06/05 19:52

数据库设计;

Create database newsgouse newsgoCreate table t_user(id int identity(1,1)primary key,username varchar(20)unique not null,pwd varchar(20),email varchar(30),address varchar(50),hobby varchar(30))insert t_userselect 'admin','admin','admin@sohu.com','北京景山','paly' unionselect 'user','user','user@sohu.com','上海市浦东新区','swim' Create table t_topic(   id int identity(1,1)primary key,   tname varchar(50),   createtime datetime)insert t_topicselect '国际',GETDATE() unionselect '国内',GETDATE() unionselect '财经',GETDATE() unionselect '体育',GETDATE() unionselect '科技',GETDATE()select * from t_topicCreate table t_news(   id int identity(1,1)primary key,   tid int foreign key references t_topic(id),   title varchar(100),   author varchar(20),   createtime datetime,   ncontent nvarchar(2000),   modifytime datetime,   summary varchar(200),   pic varchar(50))select * from t_topicselect * from t_newsinsert t_newsselect 1,'人民币','央行',GETDATE(),'人民币利于出口',GETDATE(),'问题','' unionselect 2,'德国制造4.0','央行',GETDATE(),'制造业牛奔',GETDATE(),'制造','' unionselect 4,'苹果手机7','央行',GETDATE(),'三星手机爆炸，苹果手机出师不利',GETDATE(),'手机安全','' unionselect 5,'中国足球','足球',GETDATE(),'功利足球',GETDATE(),'加油','' Create table t_comment(id int identity(1,1)primary key,nid int foreign key references t_news(id),ccontent varchar(2000),createtime datetime,author varchar(20))

0 0