use master
go
create database bookDB
go
use bookDB
go
create table guestInfo
(
ID int identity(1,1) primary key not null,
userName varchar(20) not null,
Sex varchar(4) not null,
QQ varchar(20),
Url varchar(40),
Email varchar(40),
Content varchar(300) not null,
Reply varchar(300),
imageAddress varchar(20) not null,
postTime datetime default(getdate())
)
go
update guestInfo set imageAddress = 'boy.GIF';
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥1','男','136598752','我喜欢美眉!!','boy.GIF')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥2','男','773657393','我喜欢美眉!!','boy.GIF')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥3','男','773657393','我喜欢美眉!!','boy.GIF')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥4','男','773657393','我喜欢美眉!!','boy.GIF')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥5','男','773657393','我喜欢美眉!!','boy.GIF')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥6','男','773657393','我喜欢美眉!!','boy.GIF')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥7','男','773657393','我喜欢美眉!!','boy.GIF')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥8','男','773657393','我喜欢美眉!!','boy.GIF')
go
create table adminInfo
(
userid int identity(1,1) primary key not null,
userName varchar(20) not null,
userPwd varchar(20) not null,
userNum varchar(10)
)
go
insert into adminInfo(userName,userPwd,userNum) values('admin','admin','0')
insert into adminInfo(userName,userPwd,userNum) values('zhou','123','0')
insert into adminInfo(userName,userPwd,userNUm) values('shu','123','0')
go
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女1','女','136598752','我喜欢帅哥!!','girl.gif')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女2','女','773657393','我喜欢帅哥!!','girl.gif')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女3','女','773657393','我喜欢帅哥!!','girl.gif')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女4','女','773657393','我喜欢帅哥!!','girl.gif')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女5','女','773657393','我喜欢帅哥!!','girl.gif')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女6','女','773657393','我喜欢帅哥!!','girl.gif')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女7','女','773657393','我喜欢帅哥!!','girl.gif')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女8','女','773657393','我喜欢帅哥!!','girl.gif')
go
--delete from guestInfo where userName = '美女1';
select * from guestInfo
select * from adminInfo
go
--select userNum from adminInfo
ASP.NET_简易留言板
需积分: 10 101 浏览量
2008-10-21
03:20:46
上传
评论
收藏 328KB RAR 举报
zhouxiang19890412
- 粉丝: 1
- 资源: 3
最新资源
- (大赛作品)STM32实现的F072RB NUCLEO智能家居控制.zip
- STM32实现的数字示波器源码+数字信号处理教程、配套实例.zip
- 【cookie续续】【cookie续续】【cookie续续】
- 低功耗STM32实现的F411开发板(原理图+PCB源文件+官方例程+驱动等).zip
- 基于stm32实现的 nucleo-L476的智能灯(操作说明+源码).zip
- 基于STM32实现的 NUCLEO板设计彩色LED照明灯(纯cubeMX开发).zip
- 基于STM32实现的 的联合调试侦听设备解决方案(原理图、PCB源文件、调试工具、视频).zip
- 基于STM32实现的 人群定位、调速智能风扇设计(程序、设计报告、视频演示).zip
- 哔哩下载姬(DownKyi)
- 千纬认字app再次更新,增加部首、笔画动画功能
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈