jsp+struts小项目-6

create database Test; use Test; if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_content_type]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[content] DROP CONSTRAINT FK_content_type GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[content]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[content] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[type]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[type] GO CREATE TABLE [dbo].[content] ( [name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [content] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL , [typeID] [int] NOT NULL , [sex] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[type] ( [typeID] [int] IDENTITY (1, 1) NOT NULL , [type] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO insert into type values('J2EE'); insert into type values('ASP.NET'); insert into type values('PHP');