jsp+struts小项目-2

create database Test; use Test; if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_testInfos_courses]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[testInfos] DROP CONSTRAINT FK_testInfos_courses GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[courses]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[courses] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[testInfos]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[testInfos] GO CREATE TABLE [dbo].[courses] ( [subjectID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [subjectName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[testInfos] ( [studentID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [testSubjectID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [testGrade] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [password] [int] IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO insert into courses values('SA01','初级软件工程师'); insert into courses values('SA02','软件开发工程师'); insert into courses values('SA03','高级软件设计工程师');