test.sql

jsp设计网上选课系统

# HeidiSQL Dump 
#
# --------------------------------------------------------
# Host:                 127.0.0.1
# Database:             test
# Server version:       5.0.51b-community-nt
# Server OS:            Win32
# Target-Compatibility: Standard ANSI SQL
# HeidiSQL version:     3.2 Revision: 已导出
# --------------------------------------------------------

/*!40100 SET CHARACTER SET gbk;*/
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/


#
# Database structure for database 'test'
#

CREATE DATABASE /*!32312 IF NOT EXISTS*/ "test" /*!40100 DEFAULT CHARACTER SET gb2312 */;

USE "test";


#
# Table structure for table 'course_info'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "course_info" (
  "cno" varchar(50) NOT NULL default '',
  "cname" varchar(50) default NULL,
  "ctno" varchar(50) default NULL,
  "ctname" varchar(50) default NULL,
  "cxibu" varchar(50) default NULL,
  "cjieshao" varchar(200) default NULL,
  "ctime" varchar(50) default NULL,
  "caddress" varchar(50) default NULL,
  "cxianxuanshu" varchar(50) default NULL,
  "cxianxuannianji" varchar(50) default NULL,
  "cselectednum" varchar(50) default '0',
  PRIMARY KEY  ("cno")
) /*!40100 DEFAULT CHARSET=gb2312*/;



#
# Dumping data for table 'course_info'
#

LOCK TABLES "course_info" WRITE;
/*!40000 ALTER TABLE "course_info" DISABLE KEYS;*/
REPLACE INTO "course_info" ("cno", "cname", "ctno", "ctname", "cxibu", "cjieshao", "ctime", "caddress", "cxianxuanshu", "cxianxuannianji", "cselectednum") VALUES
	('1','Java程序设计','1','罗海勇','计算机系','该课程主要讲述关于JAVA的程序设计,是一门程序设计语言,简单易学.','星期天下午2:30-4:30','新楼大厅','3','2006','2');
REPLACE INTO "course_info" ("cno", "cname", "ctno", "ctname", "cxibu", "cjieshao", "ctime", "caddress", "cxianxuanshu", "cxianxuannianji", "cselectednum") VALUES
	('2','计算机组装与维护','2','刘志杰','计算机系','该课程主要讲述如何组装计算机以及如何维护计算机,在日常生活中如何解决一些计算机问题.该课程很基础的讲述计算机的各个部件,简单易学,深受同学们的喜欢.','星期天上午8:00-10:30','附楼一','300','2007','1');
REPLACE INTO "course_info" ("cno", "cname", "ctno", "ctname", "cxibu", "cjieshao", "ctime", "caddress", "cxianxuanshu", "cxianxuannianji", "cselectednum") VALUES
	('3','大学英语','3','陈静','外语系','该课程主要讲述关于英语的应用方面,扩展同学们在英语面,以及英语口语交际,学习英语高级语法,该课程深受同学们的追求.','星期天下午2:30-4:30','红楼一','300','2008','0');
REPLACE INTO "course_info" ("cno", "cname", "ctno", "ctname", "cxibu", "cjieshao", "ctime", "caddress", "cxianxuanshu", "cxianxuannianji", "cselectednum") VALUES
	('4','Access数据库设计','4','周西柳','计算机系','该课程主要讲述数据库的应用以及开发.在计算机各个领域都会运用到数据库,所以学好数据库设计是非常重要和必要的.该课程是简单的数据库设计.学好数据库设计主要就是学好SQL语言,因为SQL语言是任何一个数据库的精髓.','星期天晚上7:00-8:00','红楼二','300','2006','0');
REPLACE INTO "course_info" ("cno", "cname", "ctno", "ctname", "cxibu", "cjieshao", "ctime", "caddress", "cxianxuanshu", "cxianxuannianji", "cselectednum") VALUES
	('5','汇编语言','5','邹国平','计算机系','该课程主要讲述计算机汇编语言,是计算机语言设计初底层的语言设计,该课程较难学.要想从事硬件方面发展的同学一定要把这门语言学好,因为它是直接操作硬件的一门语言.','星期六晚上7:00-8:00','附楼四','300','2007','0');
REPLACE INTO "course_info" ("cno", "cname", "ctno", "ctname", "cxibu", "cjieshao", "ctime", "caddress", "cxianxuanshu", "cxianxuannianji", "cselectednum") VALUES
	('6','C#程序设计','6','黄勇','计算机系','该课程主要讲述由微软公司推出的高级程序设计,是当今世界最流行的面向对象的程序设计.简单易学,也易于开发Web.所以该课程深受计算机系同学们的喜爱.','星期五晚上7:00-8:00','实验楼S120','300','2008','0');
REPLACE INTO "course_info" ("cno", "cname", "ctno", "ctname", "cxibu", "cjieshao", "ctime", "caddress", "cxianxuanshu", "cxianxuannianji", "cselectednum") VALUES
	('7','大学语文','7','黄健保','人文系','该课程主要讲述古代文学、古代神话、古代人物、古代文言文.互动中国文学,很多同学都喜欢此课程.语文直接关系我们日常用语,所以此课程也受众多同学喜爱.','星期六下午2:30-4:30','计算机楼J500','300','2006','0');
REPLACE INTO "course_info" ("cno", "cname", "ctno", "ctname", "cxibu", "cjieshao", "ctime", "caddress", "cxianxuanshu", "cxianxuannianji", "cselectednum") VALUES
	('8','计算机操作系统','8','方健新','计算机系','该课程主要讲述计算机操作系统,一台计算机不能没有操作系统.操作系统管理计算机软硬件资源.学好操作系统很重要','星期天晚上7:00-8:00','红楼三','300','2007','0');
REPLACE INTO "course_info" ("cno", "cname", "ctno", "ctname", "cxibu", "cjieshao", "ctime", "caddress", "cxianxuanshu", "cxianxuannianji", "cselectednum") VALUES
	('9','市场营销','9','马云','经贸系','该课程主要讲述市场方面的知识,要想从事市场营销的同学一定要把此课程学好.该课程会讲述如何搞好市场营销,以及相关技巧.','星期六上午8:00-10:30','附楼五','300','2008','0');
REPLACE INTO "course_info" ("cno", "cname", "ctno", "ctname", "cxibu", "cjieshao", "ctime", "caddress", "cxianxuanshu", "cxianxuannianji", "cselectednum") VALUES
	('910','普通话','10','赵霞','人文系','该课程主要是教我们说我们的国语,现在我们国家都执行说普通话,普通话的好坏直接关系到你的工作.好的普通话能给人第一好印象.','星期六上午8:00-10:30','实验楼S100','300','2006','0');
REPLACE INTO "course_info" ("cno", "cname", "ctno", "ctname", "cxibu", "cjieshao", "ctime", "caddress", "cxianxuanshu", "cxianxuannianji", "cselectednum") VALUES
	('911','交际日语','11','李阳','外语系','该课和主要是教你说一些日常日语,当你在工作在沿海地区,也许你会遇到日本人,通过此门课程你能很好的掌握与日本人交流的机会.','星期五晚上7:00-9:30','附楼二','300','2007','0');
REPLACE INTO "course_info" ("cno", "cname", "ctno", "ctname", "cxibu", "cjieshao", "ctime", "caddress", "cxianxuanshu", "cxianxuannianji", "cselectednum") VALUES
	('912','羽毛球','12','廖丽琴','体育系','该课程主要是教你们怎样打羽毛球,怎样攻防,怎样双打,以及羽毛球一些规则.羽毛球是一项体育运动,同学在努力学习过程中,也注意自己的身体健康.通过打羽毛球能很好的锻炼身体.','星期六晚上7:00-9:30','附楼三','300','2008','0');
/*!40000 ALTER TABLE "course_info" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'elected_info'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "elected_info" (
  "esno" varchar(50) NOT NULL default '',
  "esname" varchar(50) default NULL,
  "esbanji" varchar(50) default NULL,
  "esxibu" varchar(50) default NULL,
  "ecno" varchar(50) default NULL,
  "ecname" varchar(50) default NULL,
  "etno" varchar(50) NOT NULL default '',
  "etname" varchar(50) default NULL,
  "ectime" varchar(50) default NULL,
  "ecaddress" varchar(50) default NULL,
  "echengji" varchar(50) default NULL,
  PRIMARY KEY  ("esno")
) /*!40100 DEFAULT CHARSET=gb2312*/;



#
# Dumping data for table 'elected_info'
#

LOCK TABLES "elected_info" WRITE;
/*!40000 ALTER TABLE "elected_info" DISABLE KEYS;*/
REPLACE INTO "elected_info" ("esno", "esname", "esbanji", "esxibu", "ecno", "ecname", "etno", "etname", "ectime", "ecaddress", "echengji") VALUES
	('0608060001','吴双龙','计算机应用技术班','计算机系','1','Java程序设计','1','罗海勇','星期天下午2:30-4:30','红楼大厅','85');
REPLACE INTO "elected_info" ("esno", "esname", "esbanji", "esxibu", "ecno", "ecname", "etno", "etname", "ectime", "ecaddress", "echengji") VALUES
	('0608060033','熊刚','计算机应用技术班','计算机系','1','Java程序设计','1','罗海勇','星期天下午2:30-4:30','新楼大厅',NULL);
REPLACE INTO "elected_info" ("esno", "esname", "esbanji", "esxibu", "ecno", "ecname", "etno", "etname", "ectime", "ecaddress", "echengji") VALUES
	('2007','大二','计算机软件开发班','计算机系','2','计算机组装与维护','2','刘志杰','星期天上午8:00-10:30','附楼一','75');
/*!40000 ALTER TABLE "elected_info" ENABLE KEYS;*/
UNLOCK TABLES;


#
# Table structure for table 'manager_info'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "manager_info" (
  "mno" varchar(50) NOT NULL default '',
  "mpassword" varchar(50) default NULL,
  "mname" varchar(50) default NULL,
  "mxibu" varchar(50) default NULL,
  PRIMARY KEY  ("mno")
) /*!40100 DEFAULT CHARSET=gb2312*/;



#