table_sql.txt

实现JSP开发的BBS源码

1.创建数据库：

create database BSMS;

2.修改数据库属性：


3.备份数据库BSMS：

backup database test_DB to disk='g:\BSMS\backup\BSMS.bak' with init;

4.创建表：

 (1) drop table admintable;

     create table admintable(
                             adminname char(16)
                            ,code char(8)
     );
     insert into adminTable values('Admin','12345678');
     insert into adminTable values('yukechao','12345678');

 (2) drop table cardtable;

     create table cardTable(
                            userCardNum char(19) primary key
                           ,balance char(8)
                           ,code char(8) not null
                   
                      
     );


 (3) drop table userTable;


     create table userTable(
                            userID char(8) primary key
                           ,userIDCard char(18) not null
                           ,userName char(16) not null
                           ,birthday char(10) 
                           ,sex char(6) not null
                           ,addr char(50) not null
                           ,tel char(11)
                           ,userCardNum char(19)
     );

5.查询结果：


select * from admintable

select * from usertable;

select * from cardtable;

6.在图形用户界面操作
 参见“测试数据”

7.备份日志

backup log DBMS to disk='g:\BSMS\backup\log\BSMS.logs' with init;

8.退数据库BSMS,做数据库完全恢复

restore database BSMS from disk='g:\BSMS\backup\BSMS.bak' with norecovery

9.用日志恢复到时间点
restore log test_DB from disk='g:\BSMS\log\BSMS.logs' with recovery ,stopat='mm/dd/yyyy hh:mm';

10.查看结果

11.演示结束，谢谢！