use master
go
if exists (select * from dbo.sysdatabases where name = 'Student')
drop database Student
GO
create database Student
go
use Student
go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[user_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[user_Info]
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
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[result_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[result_Info]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gradecourse_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[gradecourse_Info]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[course_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[course_Info]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[class_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[class_Info]
GO
CREATE TABLE [dbo].[user_Info] (
[user_ID] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[user_PWD] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[user_Des] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[student_Info] (
[student_ID] [int] NOT NULL ,
[student_Name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[student_Sex] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[born_Date] [datetime] NULL ,
[class_NO] [int] NULL ,
[tele_Number] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[ru_Date] [datetime] NULL ,
[address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[comment] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[result_Info] (
[exam_No] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[student_ID] [int] NOT NULL ,
[student_Name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[class_No] [int] NULL ,
[course_Name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[result] [float] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[gradecourse_Info] (
[grade] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[course_Name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[course_Info] (
[course_No] [int] NOT NULL ,
[course_Name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[course_Type] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[course_Des] [char] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[class_Info] (
[class_No] [int] NOT NULL ,
[grade] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[director] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[classroom_No] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
VB数据库系统开发源码之学生信息管理系统
需积分: 9 88 浏览量
2008-12-20
20:36:08
上传
评论
收藏 75KB RAR 举报
.rar （34个子文件） 
第三章学生信息管理系统 
frmAbout.frm 9KB FOXUSER.DBF 1001B frmLogin.frm 6KB Module1.bas 2KB frmAddresult.frx 16B Student_Mis.vbp 2KB frmModifycourseinfo.frm 16KB frmAddclassinfo.frm 8KB
Student_Mis.exe 208KB frmSetcourseinfo.frm 10KB frmInquireresult.frm 10KB frmModifysinfo.frx 4B frmAddsinfo.frx 8B SQL Student.sql 6KB frmAddresult.frm 12KB FRMABOUT.FRX 3KB frmabout.f2x 778B MSSCCPRJ.SCC 196B frmInquiresinfo.frm 10KB frmModifyclassinfo.frm 16KB frmAddsinfo.frm 9KB frmMain.frm 5KB frmModifysinfo.frm 24KB frmModifyresult.frm 20KB frmModifyuserinfo.frm 4KB Student_Mis.vbw 961B frmSetcourseinfo.frx 8B frmDocument.frx 152B frmModifyresult.frx 16B FRMABOUT.FRT 512B frmDocument.frm 2KB frmCourseinfo.frm 8KB frmAdduser.frm 6KB FOXUSER.FPT 5KB资源评论
