sql.txt

java学生管理系统

CREATE TABLE banji (
	bNo char(10) ,
	bName char(16),
	bManager char(10),
	bRenShu int,
	nNo char(10)   
) ON PRIMARY
GO

CREATE TABLE nianji (
	nNo char (10),
	nName char (16),
	zNo char(10)   
) ON PRIMARY
GO

CREATE TABLE userTable (
	UserName char (10),
	Password char (10),
	Power char(12)   
) ON PRIMARY
GO

CREATE TABLE xueqi(
	qName char (20),
	qxn char (16),
	qlx char (16),
	qdq char (2),
	qks datetime,
	qjs datetime  
) ON PRIMARY
GO

CREATE TABLE yuanxi (
xNo char(10),
	xName char(10),
	xManager char(10),
	xConnect char(12),
	xMessage char(40)   
) ON PRIMARY
GO

CREATE TABLE zhuanye (
	zNo char(10),
	zName char(10),
	zManager char(10),
	zMessage char(40),
	xNo char(10)     
) ON PRIMARY
GO