.net 做的一个漂亮的留言本

create database shanhu use shanhu create table xinxi (ID int identity(1,1) primary key, userName varchar(20) not null, Sex varchar(40) not null , QQ varchar(30), url varchar(40), Email varchar(40), Content varchar(300) not null, Reply varchar(30), umageAddress varchar(30) not null, postTime datetime default (getdate()) ) select * from xinxi drop table xinxi insert into xinxi(userName,Sex, QQ, Content, umageAddress) values ('珊瑚辣椒','女','947405686','你来自哪里呢','girl.jpg') insert into xinxi(userName,Sex, QQ, Content, umageAddress) values('天山雪莲','男','773594807','你圣诞快乐吗？','boy.jpg') insert into xinxi (userName,Sex, QQ, Content, umageAddress) values('小叶子','女','123456','我来看你了','girl.jpg') insert into xinxi (userName,Sex, QQ, Content, umageAddress) values('柳丝','女','456123','你什么时候回家','girl.jpg') insert into xinxi(userName,Sex, QQ, Content, umageAddress) values('hehe','男','4589565','最近好吗','boy.girl') insert into xinxi(userName,Sex, QQ, Content, umageAddress) values('xxixi','男','4589565','最近好吗','boy.girl') insert into xinxi(userName,Sex, QQ, Content, umageAddress) values('ixi','男','4589565','最近好吗','boy.girl') select * from xinxi create table guanli ( UserId int primary key, UserName varchar(20) not null, userpwd varchar(30) , num int default (0) ) select * from guanli drop table guanli insert into guanli(UserId,Username, userpwd) values (1,'qianhaiyan','qianhaiyan')