我的备份.sql

学生管理系统 包括选课 查询 日志 管理员管理 分类查询等功能

-- MySQL dump 10.11
--
-- Host: localhost    Database: lizigan
-- ------------------------------------------------------
-- Server version	5.0.67-community-nt

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `guan`
--

DROP TABLE IF EXISTS `guan`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `guan` (
  `gid` char(10) NOT NULL,
  `pass` char(10) default NULL,
  PRIMARY KEY  (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `guan`
--

LOCK TABLES `guan` WRITE;
/*!40000 ALTER TABLE `guan` DISABLE KEYS */;
INSERT INTO `guan` VALUES ('12345','12345');
/*!40000 ALTER TABLE `guan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ncourse`
--

DROP TABLE IF EXISTS `ncourse`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ncourse` (
  `bid` char(20) NOT NULL,
  `bname` char(20) default NULL,
  `bdept` char(20) default NULL,
  `teacher` char(20) default NULL,
  `shu` char(20) default NULL,
  PRIMARY KEY  (`bid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `ncourse`
--

LOCK TABLES `ncourse` WRITE;
/*!40000 ALTER TABLE `ncourse` DISABLE KEYS */;
INSERT INTO `ncourse` VALUES ('100000','计算机','计科','张杰','必修'),('100001','数据结构','计科','张','必修'),('100002','编译原理','计科','杰','必修'),('100003','c语言','计科','李','必修'),('100004','编程实践','计科','刘','必修'),('100005','软件工程','计科','王','必修'),('100006','线性代数','数学','李','必修'),('100007','高等数学','数学','是','必修'),('100008','概率','数学','张','必修'),('100009','影视基础','影视','萨','必修'),('100010','舞蹈学习','舞蹈','盎','必修'),('100011','山居笔记','文学','阿','必修'),('100012','通信原理','通信','于','必修'),('100013','通信工程','通信','李','必修'),('100014','自动化原理','自动化','版','必修'),('100015','托福','自动化','峰','必修'),('100016','戏剧院里','喜剧','李','必修'),('100017','建筑学','建筑','丁','必修'),('100018','测控原理','测控','李','必修'),('100019','控制原理','测控','李','必修'),('100020','雅思','文学','李','必修');
/*!40000 ALTER TABLE `ncourse` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `student`
--

DROP TABLE IF EXISTS `student`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `student` (
  `sid` char(20) NOT NULL,
  `sname` char(20) default NULL,
  `sage` int(11) default NULL,
  `sex` char(6) default NULL,
  `sdept` char(20) default NULL,
  `password` char(20) default NULL,
  PRIMARY KEY  (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `student`
--

LOCK TABLES `student` WRITE;
/*!40000 ALTER TABLE `student` DISABLE KEYS */;
INSERT INTO `student` VALUES ('1','1',1,'1','100','1'),('123','123',11,'11','11','11'),('145','474747',5657,'35t','uyy','66'),('187','474747',5657,'35t','uyy','66'),('2','2',2,'2','2','2'),('200601','高鹏娟',20,'男','计科','000001'),('200602','123',2,'w','222','000002'),('200603','李峰',30,'男','计科','000003'),('200604','2',20,'3','1','000004'),('200605','1',20,'女','计科','200605'),('200606','康玉',20,'女','计科','000006'),('200607','4',20,'4','4','000007'),('200608','李',20,'nan','加法','000008'),('200610','陶婷婷',20,'女','计科','000010'),('200611','1',20,'女','建筑','000011'),('200612','赵梦',20,'男','自动化','000012'),('200613','杨丽萍',23,'男','舞蹈','000013'),('200614','é?¶',20,'ç?·','æ?°å­¦','000014'),('200615','1',24,'nan','计科','000015'),('200616','赵薇',25,'女','喜剧','000016'),('200617','黄晓明',20,'男','文学','000017'),('200618','刘涛',20,'男','计科','000018'),('200619','陆战',20,'女','自动化','000019'),('200620','1',20,'女','测控','000020'),('200621','小明',20,'男','测控','000021'),('200622','小红',20,'男','自动化','000022'),('200623','小丽',20,'女','计科','000023'),('200624','小娇',20,'女','计科','000024'),('200625','小幅',20,'女','通信','000025'),('200626','订单',20,'女','计科','000026'),('200627','陶婷',20,'女','计科','000027'),('200628','陶飞',20,'女','计科','000028'),('200629','陶婷',20,'女','计科','000029'),('200630','就婷',20,'女','计科','000030'),('4','4',4,'4','4','4'),('5','5',5,'5','5','5');
/*!40000 ALTER TABLE `student` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `study`
--

DROP TABLE IF EXISTS `study`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `study` (
  `sid` char(20) NOT NULL default '',
  `uid` char(20) NOT NULL default '',
  `grade` char(20) default NULL,
  PRIMARY KEY  (`sid`,`uid`),
  KEY `uid` (`uid`),
  CONSTRAINT `study_ibfk_1` FOREIGN KEY (`sid`) REFERENCES `student` (`sid`),
  CONSTRAINT `study_ibfk_2` FOREIGN KEY (`uid`) REFERENCES `ucourse` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `study`
--

LOCK TABLES `study` WRITE;
/*!40000 ALTER TABLE `study` DISABLE KEYS */;
INSERT INTO `study` VALUES ('200601','200001','21'),('200602','200002','21'),('200603','200001','0'),('200603','200003','34'),('200603','200005','77'),('200604','200001','0'),('200604','200004','1'),('200604','200007','0'),('200604','200008','0'),('200604','200009','0'),('200604','200010','0'),('200604','200011','0'),('200604','200013','0'),('200605','200001','0'),('200605','200004','0'),('200605','200006','87'),('200605','200008','0'),('200605','200012','0'),('200606','200005','21'),('200607','200002','21'),('200607','200007','0'),('200608','200004','21'),('200608','200008','0'),('200610','200013','21'),('200611','200001','0'),('200611','200004','0'),('200611','200005','0'),('200611','200006','88'),('200611','200008','0'),('200611','200009','0'),('200611','200010','0'),('200611','200011','0'),('200611','200013','0'),('200611','200014','21'),('200611','null','0'),('200612','200015','21'),('200613','200003','21'),('200614','200001','21'),('200614','200003','0'),('200614','200010','0'),('200615','200009','21'),('200616','200008','21'),('200617','200010','21'),('200618','200011','21'),('200619','200012','21'),('200620','200006','88'),('200621','200007','21'),('200622','200008','21'),('200623','200009','21'),('200624','200004','21'),('200625','200007','21'),('200626','200008','21'),('200627','200009','21'),('200628','200011','21');
/*!40000 ALTER TABLE `study` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `teacher`
--

DROP TABLE IF EXISTS `teacher`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `teacher` (
  `tid` char(20) NOT NULL,
  `tname` char(20) default NULL,
  `uid` char(20) default NULL,
  `password` char(20) default NULL,
  PRIMARY KEY  (`tid`),
  KEY `uid` (`uid`),
  CONSTRAINT `teacher_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `ucourse` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `teacher`
--

LOCK TABLES `teacher` WRITE;
/*!40000 ALTER TABLE `teacher` DISABLE KEYS */;
INSERT INTO `teacher` VALUES ('1','万','200001','1'),('10','到','200012','10'),('11','万对静','200013','11'),('12','产地','200014','12'),('13','西电','200015','13'),('3','刘','200003','3'),('4','lizigan','200005','4'),('5','2','200006','5'),('6','万静','200007','6'),('7','朱','200008','7'),('8','峰','200009','8'),('9','刻','200011','9');
/*!40000 ALTER TABLE `teacher` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ucourse`
--

DROP TABLE IF EXISTS `ucourse`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ucourse` (
  `uid` char(20) NOT NULL,
  `uname` char(20) default NULL,
  `udept` char(20) default NULL,
  `teacher` char(20) default NULL,
  `shu` char(20) default NULL,
  PRIMARY KEY  (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `ucourse`
--

LOCK TABLES `ucourse` WRITE;
/*!40000 ALTER TABLE `ucourse` DISABLE KEYS */;
INSERT INTO `ucourse` VALUES ('200001','vb','计科','万','选修'),('200002','netbean','计科','静','选修'),('200003','c#','计科','刘','选修'),('200004','达芬奇密码','计科','刘','选修'),('200005','数理统计','数学','数','选修'),('200006','2','7','带','选修'),('200007','承包','舞蹈','万静','选修'),('200008','风水','影视','朱','选修'),('200009','习惯','文学','峰','选修'),('200010','生活','建筑','万静','选修'),('200011','数据库','通信','刻','选修'),('200012','编译','通信','到','选修'),('200013','主演','测控','万对静','选修'),('200014','新托福','测控','产地','选修'),('200015','星火','自动化','西电','选修'),('null','null','null','null','null');
/*!40000 ALTER TABLE `ucourse` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-01-06  9:12:55