学生信息管理系统B/S模式

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'mydata') DROP DATABASE [mydata] GO CREATE DATABASE [mydata] ON (NAME = N'mydata_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\mydata_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'mydata_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\mydata_Log.LDF' , SIZE = 1, FILEGROWTH = 10%) COLLATE Chinese_PRC_CI_AS GO exec sp_dboption N'mydata', N'autoclose', N'false' GO exec sp_dboption N'mydata', N'bulkcopy', N'false' GO exec sp_dboption N'mydata', N'trunc. log', N'false' GO exec sp_dboption N'mydata', N'torn page detection', N'true' GO exec sp_dboption N'mydata', N'read only', N'false' GO exec sp_dboption N'mydata', N'dbo use', N'false' GO exec sp_dboption N'mydata', N'single', N'false' GO exec sp_dboption N'mydata', N'autoshrink', N'false' GO exec sp_dboption N'mydata', N'ANSI null default', N'false' GO exec sp_dboption N'mydata', N'recursive triggers', N'false' GO exec sp_dboption N'mydata', N'ANSI nulls', N'false' GO exec sp_dboption N'mydata', N'concat null yields null', N'false' GO exec sp_dboption N'mydata', N'cursor close on commit', N'false' GO exec sp_dboption N'mydata', N'default to local cursor', N'false' GO exec sp_dboption N'mydata', N'quoted identifier', N'false' GO exec sp_dboption N'mydata', N'ANSI warnings', N'false' GO exec sp_dboption N'mydata', N'auto create statistics', N'true' GO exec sp_dboption N'mydata', N'auto update statistics', N'true' GO use [mydata] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[admin_info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[admin_info] GO CREATE TABLE [dbo].[admin_info] ( [admin_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [admin_password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[kecheng_info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[kecheng_info] GO CREATE TABLE [dbo].[kecheng_info] ( [kecheng_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [kecheng_id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [kecheng_if] [int] NULL , [kecheng_xuefen] [float] NULL , [id] [int] NOT NULL ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[scord_info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[scord_info] GO CREATE TABLE [dbo].[scord_info] ( [unid] [int] NOT NULL , [kecheng_id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [kecheng_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [kecheng_if] [int] NULL , [student_id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [student_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [student_yuan] [int] NULL , [student_xi] [int] NULL , [student_class] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [kecheng_scord] [int] NULL , [scord_time] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [scord_teacher] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [kecheng_xuefen] [float] NULL ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[student_info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[student_info] GO CREATE TABLE [dbo].[student_info] ( [student_id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [student_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [student_home_address] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [student_sex] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [student_in_school] [datetime] NULL , [student_shengri] [datetime] NULL , [student_mianmao] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [student_yuan] [int] NULL , [student_xi] [int] NULL , [student_class] [nvarchar] (50) COLLATE Chinese_PRC�