基于JSP Servlet和EJB的学生教务管理系统

-- MySQL dump 10.11 -- -- Host: localhost Database: student -- ------------------------------------------------------ -- 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 `stu_course` -- DROP TABLE IF EXISTS `stu_course`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `stu_course` ( `courseID` int(11) NOT NULL auto_increment, `courseName` varchar(50) NOT NULL, `courseCredit` int(11) default NULL, `totalScore` int(11) default NULL, `remark` varchar(50) default NULL, PRIMARY KEY (`courseID`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `stu_course` -- LOCK TABLES `stu_course` WRITE; /*!40000 ALTER TABLE `stu_course` DISABLE KEYS */; INSERT INTO `stu_course` VALUES (1,'Java',4,100,'课程介绍'),(2,'JSP',4,100,'课程介绍'),(3,'JSF',2,100,'课程介绍'),(4,'Ajax',4,100,'课程介绍'),(5,'Struts',2,100,'课程介绍'); /*!40000 ALTER TABLE `stu_course` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stu_login` -- DROP TABLE IF EXISTS `stu_login`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `stu_login` ( `loginID` int(11) NOT NULL auto_increment, `roleID` int(11) NOT NULL, `loginName` varchar(50) NOT NULL, `loginPWD` varchar(50) NOT NULL, PRIMARY KEY (`loginID`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `stu_login` -- LOCK TABLES `stu_login` WRITE; /*!40000 ALTER TABLE `stu_login` DISABLE KEYS */; INSERT INTO `stu_login` VALUES (1,1,'admin','admin'),(2,2,'t001','t001'),(3,3,'s001','s001'); /*!40000 ALTER TABLE `stu_login` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stu_news` -- DROP TABLE IF EXISTS `stu_news`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `stu_news` ( `newsID` int(11) NOT NULL auto_increment, `newsTitle` varchar(50) NOT NULL, `newsContent` varchar(50) NOT NULL, `newsTime` datetime NOT NULL, `remark` varchar(50) default NULL, PRIMARY KEY (`newsID`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `stu_news` -- LOCK TABLES `stu_news` WRITE; /*!40000 ALTER TABLE `stu_news` DISABLE KEYS */; INSERT INTO `stu_news` VALUES (1,'news1','newsnewsnews1','2009-02-01 00:00:00',''),(2,'news2','newsnewsnews2','2009-02-01 00:00:00',''),(3,'news3','newsnewsnews4','2009-02-01 00:00:00',''),(4,'news4','newsnewsnews3','2009-02-02 00:00:00',''),(5,'news5','newsnewsnews5','2009-02-02 00:00:00',''),(6,'news6','newsnewsnews6','2009-02-02 00:00:00',''); /*!40000 ALTER TABLE `stu_news` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stu_stucourse` -- DROP TABLE IF EXISTS `stu_stucourse`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `stu_stucourse` ( `scid` int(11) NOT NULL auto_increment, `ID` int(11) default NULL, `courseID` int(11) default NULL, `score` int(11) default NULL, PRIMARY KEY (`scid`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `stu_stucourse` -- LOCK TABLES `stu_stucourse` WRITE; /*!40000 ALTER TABLE `stu_stucourse` DISABLE KEYS */; INSERT INTO `stu_stucourse` VALUES (1,1,1,90),(2,1,2,90),(3,1,3,90),(4,2,1,90),(5,2,2,90); /*!40000 ALTER TABLE `stu_stucourse` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stu_student` -- DROP TABLE IF EXISTS `stu_student`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `stu_student` ( `ID` int(11) NOT NULL auto_increment, `stuID` varchar(50) NOT NULL, `stuName` varchar(50) NOT NULL, `enterTime` datetime default NULL, `stuYear` varchar(50) default NULL, `address` varchar(50) default NULL, `tellphone` varchar(50) default NULL, `stuclass` varchar(50) default NULL, `remark` varchar(50) default NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `stu_student` -- LOCK TABLES `stu_student` WRITE; /*!40000 ALTER TABLE `stu_student` DISABLE KEYS */; INSERT INTO `stu_student` VALUES (1,'s001','aa','2006-09-10 00:00:00','四年制','北京市','010-\n\n12345678','1班',''),(2,'s002','bb','2006-09-10 00:00:00','四年制','北京市','010-\n\n56781234','1班',''),(4,'s004','dd','2007-09-10 00:00:00','四年制','北京市','010-\n\n12345678','2班',''),(5,'s005','ee','2007-09-10 00:00:00','四年制','北京市','010-\n\n56781234','2班',''); /*!40000 ALTER TABLE `stu_student` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stu_teacher` -- DROP TABLE IF EXISTS `stu_teacher`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `stu_teacher` ( `tID` int(11) NOT NULL auto_increment, `teacherID` varchar(50) NOT NULL, `teacherName` varchar(50) NOT NULL, `teacherInfo` varchar(50) default NULL, `remark` varchar(50) default NULL, PRIMARY KEY (`tID`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gb2312; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `stu_teacher` -- LOCK TABLES `stu_teacher` WRITE; /*!40000 ALTER TABLE `stu_teacher` DISABLE KEYS */; INSERT INTO `stu_teacher` VALUES (1,'t001','王老师','优秀教师',''),(2,'t002','韩老师','优秀教师',''),(3,'t003','张老师','优秀教师',''),(4,'t004','杨老师','优秀教师',''),(5,'t005','祝老师','优秀教师',''),(6,'t006','赵老师','优秀教师',''),(7,'t007','李老师','优秀教师',''); /*!40000 ALTER TABLE `stu_teacher` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stu_teacourse` -- DROP TABLE IF EXISTS `stu_teacourse`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `stu_teacourse` ( `tcid` int(11) NOT NULL auto_increment, `tID` int(11) default NULL, `courseID` int(11) default NULL, PRIMARY KEY (`tcid`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `stu_teacourse` -- LOCK TABLES `stu_teacourse` WRITE; /*!40000 ALTER TABLE `stu_teacourse` DISABLE KEYS */; INSERT INTO `stu_teacourse` VALUES (1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5); /*!40000 ALTER TABLE `stu_teacourse` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stu_words` -- DROP TABLE IF EXISTS `stu_words`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `stu_words` ( `wordsID` int(11) NOT NULL auto_increment, `wordsTitle` varchar(50) NOT NULL, `wordsContent` varchar(50) NOT NULL, `wordsTime` datetime NOT NULL, `personName` varchar(50) default NULL, `remark` varchar(50) default NULL, PRIMARY KEY (`wordsID`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=gb2312; SET character_set_clien