db.sql

jsp学习 jsp编程白例源代码此部分是指文件夹名为第1～9章中的内容（如表1）

CREATE DATABASE newsmanage 
	ON (NAME = 'newsmanage_Data', 
	FILENAME = 'd:\Program Files\Microsoft SQL Server\MSSQL\data\newsmanage_Data.MDF' , 
	SIZE = 1, 
	FILEGROWTH = 10%) 
	LOG ON (NAME = 'newsmanage_Log', 
	FILENAME = 'd:\Program Files\Microsoft SQL Server\MSSQL\data\newsmanage_Log.LDF' , 
	SIZE = 1, 
	FILEGROWTH = 10%)
GO

use newsmanage
GO

CREATE TABLE [dbo].[article] (
	[ID] [int] IDENTITY (1, 1) NOT NULL PRIMARY KEY,
	[TITLE] [varchar] (100) NOT NULL ,
	[BODY] [varchar] (8000) NOT NULL ,
	[ADDDATE] [varchar] (30) NOT NULL ,
	[ADDUSER] [varchar] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[userpassword] (
	[ID] [int] IDENTITY (1, 1) NOT NULL PRIMARY KEY,
	[USER_ID] [varchar] (15) NOT NULL ,
	[USER_PASSWORD] [varchar] (15) NOT NULL ,
	[ISMASTER] [char] (1) NOT NULL ,
	[USER_NAME] [varchar] (10) NULL 
) ON [PRIMARY]
GO

INSERT INTO userpassword (USER_ID, USER_PASSWORD, ISMASTER, USER_NAME)
		VALUES ('admin', '8888', 'Y', '戴志军')