test.sql

jsp设计网上选课系统

# Dumping data for table 'manager_info'
#

LOCK TABLES "manager_info" WRITE;
/*!40000 ALTER TABLE "manager_info" DISABLE KEYS;*/
REPLACE INTO "manager_info" ("mno", "mpassword", "mname", "mxibu") VALUES
	('1','C4CA4238A0B923820DCC509A6F75849B','刘志杰','计算机系');
REPLACE INTO "manager_info" ("mno", "mpassword", "mname", "mxibu") VALUES
	('2','C81E728D9D4C2F636F067F89CC14862C','黄勇','计算机系');
REPLACE INTO "manager_info" ("mno", "mpassword", "mname", "mxibu") VALUES
	('3','ECCBC87E4B5CE2FE28308FD9F2A7BAF3','吴川','经贸系');
/*!40000 ALTER TABLE "manager_info" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'public_info'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "public_info" (
  "pno" varchar(50) NOT NULL default '',
  "ptitle" varchar(50) default NULL,
  "pcontent" varchar(50) default NULL,
  "ptime" varchar(50) default NULL,
  PRIMARY KEY  ("pno")
) /*!40100 DEFAULT CHARSET=gb2312*/;



#
# Dumping data for table 'public_info'
#

LOCK TABLES "public_info" WRITE;
/*!40000 ALTER TABLE "public_info" DISABLE KEYS;*/
REPLACE INTO "public_info" ("pno", "ptitle", "pcontent", "ptime") VALUES
	('1','注意','用户名和密码都为你们的学号,所以请同学在第一次选课时,务必把自己的密码修改.','2008-9-1');
/*!40000 ALTER TABLE "public_info" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'student_info'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "student_info" (
  "sno" varchar(50) NOT NULL default '',
  "sname" varchar(50) NOT NULL,
  "spassword" varchar(50) NOT NULL,
  "sxibu" varchar(50) NOT NULL,
  "sbanji" varchar(50) NOT NULL,
  "sxianxuanshu" varchar(50) NOT NULL,
  "snianji" varchar(50) NOT NULL,
  "sid" varchar(50) NOT NULL,
  PRIMARY KEY  ("sno")
) /*!40100 DEFAULT CHARSET=gb2312 COMMENT='学生信息表'*/;



#
# Dumping data for table 'student_info'
#

LOCK TABLES "student_info" WRITE;
/*!40000 ALTER TABLE "student_info" DISABLE KEYS;*/
REPLACE INTO "student_info" ("sno", "sname", "spassword", "sxibu", "sbanji", "sxianxuanshu", "snianji", "sid") VALUES
	('0608060001','吴双龙','5D914BDDF26A4B3BC7B6E1EA21DE6375','计算机系','计算机应用技术班','1','2006','360111198909252179');
REPLACE INTO "student_info" ("sno", "sname", "spassword", "sxibu", "sbanji", "sxianxuanshu", "snianji", "sid") VALUES
	('0608060032','艾斌勇','6E0E501FB005AB0C42DA20C18D020B02','计算机系','计算机应用技术班','1','2007','360111198909252169');
REPLACE INTO "student_info" ("sno", "sname", "spassword", "sxibu", "sbanji", "sxianxuanshu", "snianji", "sid") VALUES
	('0608060033','熊刚','F78CADEFF0E7E8E9381119A740E0F88B','计算机系','计算机应用技术班','1','2006','360111198909252158');
REPLACE INTO "student_info" ("sno", "sname", "spassword", "sxibu", "sbanji", "sxianxuanshu", "snianji", "sid") VALUES
	('2006','熊刚','EA5A486C712A91E48443CD802642223D','工程系','机械制造与设计','1','2006','3601119890925269');
REPLACE INTO "student_info" ("sno", "sname", "spassword", "sxibu", "sbanji", "sxianxuanshu", "snianji", "sid") VALUES
	('2007','大二','A00E5EB0973D24649A4A920FC53D9564','计算机系','计算机软件开发班','1','2007','360111198909252158');
REPLACE INTO "student_info" ("sno", "sname", "spassword", "sxibu", "sbanji", "sxianxuanshu", "snianji", "sid") VALUES
	('2008','大一','EF8446F35513A8D6AA2308357A268A7E','计算机系','计算机多媒体班','1','2008','36011189846546565');
/*!40000 ALTER TABLE "student_info" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'teacher_info'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "teacher_info" (
  "tno" varchar(50) NOT NULL default '',
  "tname" varchar(50) NOT NULL,
  "tpassword" varchar(50) NOT NULL,
  "txibu" varchar(50) default NULL,
  "tjieshao" varchar(200) default NULL,
  PRIMARY KEY  ("tno")
) /*!40100 DEFAULT CHARSET=gb2312*/;



#
# Dumping data for table 'teacher_info'
#

LOCK TABLES "teacher_info" WRITE;
/*!40000 ALTER TABLE "teacher_info" DISABLE KEYS;*/
REPLACE INTO "teacher_info" ("tno", "tname", "tpassword", "txibu", "tjieshao") VALUES
	('1','罗海勇','C4CA4238A0B923820DCC509A6F75849B','计算机系','教授');
REPLACE INTO "teacher_info" ("tno", "tname", "tpassword", "txibu", "tjieshao") VALUES
	('10','赵霞','D3D9446802A44259755D38E6D163E820','人文系','教授');
REPLACE INTO "teacher_info" ("tno", "tname", "tpassword", "txibu", "tjieshao") VALUES
	('11','李阳','6512BD43D9CAA6E02C990B0A82652DCA','外语系','教授');
REPLACE INTO "teacher_info" ("tno", "tname", "tpassword", "txibu", "tjieshao") VALUES
	('12','廖丽琴','C20AD4D76FE97759AA27A0C99BFF6710','体育系','副教授');
REPLACE INTO "teacher_info" ("tno", "tname", "tpassword", "txibu", "tjieshao") VALUES
	('2','刘志杰','C81E728D9D4C2F636F067F89CC14862C','计算机系','教授');
REPLACE INTO "teacher_info" ("tno", "tname", "tpassword", "txibu", "tjieshao") VALUES
	('3','陈静','ECCBC87E4B5CE2FE28308FD9F2A7BAF3','外语系','副教授');
REPLACE INTO "teacher_info" ("tno", "tname", "tpassword", "txibu", "tjieshao") VALUES
	('4','周西柳','A87FF679A2F3E71D9181A67B7542122C','计算机系','副教授');
REPLACE INTO "teacher_info" ("tno", "tname", "tpassword", "txibu", "tjieshao") VALUES
	('5','邹国平','E4DA3B7FBBCE2345D7772B0674A318D5','计算机系','教授');
REPLACE INTO "teacher_info" ("tno", "tname", "tpassword", "txibu", "tjieshao") VALUES
	('6','黄勇','1679091C5A880FAF6FB5E6087EB1B2DC','计算机系','教授');
REPLACE INTO "teacher_info" ("tno", "tname", "tpassword", "txibu", "tjieshao") VALUES
	('7','黄健保','8F14E45FCEEA167A5A36DEDD4BEA2543','人文系','教授');
REPLACE INTO "teacher_info" ("tno", "tname", "tpassword", "txibu", "tjieshao") VALUES
	('8','方健新','C9F0F895FB98AB9159F51FD0297E236D','计算机系','教授');
REPLACE INTO "teacher_info" ("tno", "tname", "tpassword", "txibu", "tjieshao") VALUES
	('9','马云','45C48CCE2E2D7FBDEA1AFC51C7C6AD26','经贸系','教授');
/*!40000 ALTER TABLE "teacher_info" ENABLE KEYS;*/
UNLOCK TABLES;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE;*/
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;*/