mssql-database-struts.sql

来自「JDBC封装之connectionFactory」· SQL 代码 · 共 39 行

/*==============================================================*/
/* Database name:  Demo                                         */
/* DBMS name:      Microsoft SQL Server 2000                    */
/* Created on:     2008-11-12 16:45:26                          */
/*==============================================================*/


use master
go
if db_id('demo')>0
drop database Demo
go
create database Demo
go

use Demo
go

/*==============================================================*/
/* Table: userinfo                                              */
/*==============================================================*/
create table userinfo (
   userid               int                  identity,
   username             varchar(20)          null,
   password             varchar(20)          null,
   birthday             datetime             null,
   address              varchar(200)         null,
   constraint PK_USERINFO primary key (userid)
)
go

insert into userinfo
select '杰克逊','123456','2008-8-8','美国' union
select '小明','654321','2001-1-1','北京' union
select '小徐','456789','1987-8-25','龙庙乡'
go

select * from userinfo
go