student.txt

不错的代码,pb学生学籍管理,做毕业设计正好里面全是代码!

use master
go

if exists (select * from dbo.sysdatabases where name = 'pbstudent') 
drop database pbstudent
GO

create database pbstudent
go
use pbstudent
go

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bian]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[bian]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[chengfa]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[chengfa]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[cj]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cjb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[cjb]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fang]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[fang]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[jiangli]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[jiangli]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[jiben1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[jiben1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ke]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ke]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mima]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[mima]
GO

CREATE TABLE [dbo].[bian] (
	[xuehao] [char] (9) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[xingming] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[fangxiang] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [banming] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
        [xfangxiang] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [xbanming] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
        [yuanyin] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
        [beizhu] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
        [zhuangtai] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
        [shijian] [datetime]  NULL   
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[chengfa] (
	[xuehao] [char] (9) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[xingming] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[fangxiang] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [banming] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
        [cfm] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [shijian] [datetime]  NULL ,
        [yuanyin] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
        
        [beizhu] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
        [koufen] [char] (4) COLLATE Chinese_PRC_CI_AS NULL 
           
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cj] (
	[xuehao] [char] (9) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[kehao] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[keming] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [xingming] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
        [fangxiang] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        
        [banji] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
        [kc] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
        [leixing] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
        [xuefen] [numeric] (2,0) NULL ,
        [shijian] [datetime]  NULL ,
        [beizhu] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
        [chengji] [numeric] (3,1) NULL 
           
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cjb] (
	[xuehao] [char] (9) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[kehao] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[keming] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [xingming] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
        [fangxiang] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        
        [banji] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
        [kc] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
        [leixing] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
        [xuefen] [numeric] (2,0) NULL ,
        [shijian] [datetime]  NULL ,
        [beizhu] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
        [chengji] [numeric] (3,1) NULL 
           
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[fang] (
	 [fangxiang] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[banming] [varchar] (16) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jiangli] (
	[xuehao] [char] (9) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	
        [xingming] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
        [fangxiang] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [banming] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
        [jlm] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [shijian] [datetime]  NULL ,
        [yuanyin] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
       
        [beizhu] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
        [jiafen] [char] (4) COLLATE Chinese_PRC_CI_AS NULL  
           
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jiben1] (
	[xuehao] [char] (9) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	
        [xingming] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
        [xingbie] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
        [shengri] [datetime]  NULL ,
        [minzu] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
        [zzmm] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
        [jiguan] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
        [shenfenzheng] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
        [luquhao] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
        [nianji] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
        [banming] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
        [fangxiang] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [luqushijian] [datetime]  NULL ,
       
        [biezhu] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
        [yuanbiyexuexiao] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [dianhua] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
        
        [email] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
        [banji] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
        [gerenjianli] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
        [biyehao] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
        [biyeshijian] [datetime]  NULL ,
        [biyelunwen] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [biyecj] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
       
        [zyfx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL  
           
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ke] (
	[kehao] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	
        [keming] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
        [xuefen] [decimal] (2,0) NULL ,
        [xianxing] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
        [jianjie] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
        [jiaoshi] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
        [xueshi] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
       
        
        [jiaochai] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL  
           
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[mima] (
	[yonghu] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	
        [mima] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
       
           
) ON [PRIMARY]
GO