JSP+Servlet信息发布平台

/* SQLyog Enterprise Trial - MySQL GUI v6.04 Host - 5.0.45-community-nt : Database - lab ********************************************************************* Server version : 5.0.45-community-nt */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; create database if not exists `lab`; USE `lab`; /*!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' */; /*Table structure for table `admin` */ DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `name` varchar(16) default NULL, `password` varchar(16) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `admin` */ insert into `admin`(`name`,`password`) values ('dd','dd'),('admin','admin'); /*Table structure for table `enrol` */ DROP TABLE IF EXISTS `enrol`; CREATE TABLE `enrol` ( `class_id` varchar(32) default NULL, `stu_id` varchar(32) default NULL, `accept` varchar(32) default NULL, `score` varchar(32) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `enrol` */ /*Table structure for table `grade` */ DROP TABLE IF EXISTS `grade`; CREATE TABLE `grade` ( `id` int(8) NOT NULL, `grade` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `grade` */ insert into `grade`(`id`,`grade`) values (1,'2005'),(2,'2006'),(3,'2007'),(4,'2008'); /*Table structure for table `news` */ DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `id` int(8) NOT NULL auto_increment, `title` varchar(60) default NULL, `content` varchar(60) default NULL, `datetime` varchar(60) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*Data for the table `news` */ insert into `news`(`id`,`title`,`content`,`datetime`) values (1,'平台试运行','进入开始平台试运行,欢迎大家访问! ','2007-7-2 21:45:38'),(2,'获奖通知','xx,获得 先进青年称号 ','2007-7-2 21:43:57'); /*Table structure for table `note` */ DROP TABLE IF EXISTS `note`; CREATE TABLE `note` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) default NULL, `author` varchar(255) default NULL, `content` varchar(255) default NULL, `datetime` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `note` */ insert into `note`(`id`,`title`,`author`,`content`,`datetime`) values (1,'note1','fra','note1 is note 1','21:52'); /*Table structure for table `project` */ DROP TABLE IF EXISTS `project`; CREATE TABLE `project` ( `id` int(11) NOT NULL, `name` varchar(64) default NULL, `info` varchar(255) default NULL, `time` varchar(16) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `project` */ insert into `project`(`id`,`name`,`info`,`time`) values (1,'关于开发教育项目',' 关于开发一个关于基于J2ee平台的教育项目\r\n \r\n ','2007-9-2'),(2,'企业黄页项目',' 接交委通知,开发一个企业黄页项目\r\n \r\n ','2007-111-1'),(3,'财政项目',' 我们与省公司签定一了财政项目\r\n \r\n ','2007-12-14'); /*Table structure for table `student` */ DROP TABLE IF EXISTS `student`; CREATE TABLE `student` ( `id` int(11) NOT NULL auto_increment, `name` varchar(16) default NULL, `grade_id` int(11) default NULL, `image` varchar(50) default NULL, `sex` char(4) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; /*Data for the table `student` */ insert into `student`(`id`,`name`,`grade_id`,`image`,`sex`) values (1,'dsdsd',3,'2-1.gif','女'),(2,'fdf',2,'pinfo.gif','男'),(3,'dsd',3,'xong7.gif','男'),(4,'张貉',3,'2-3.gif','女'); /*Table structure for table `teacher` */ DROP TABLE IF EXISTS `teacher`; CREATE TABLE `teacher` ( `id` int(11) NOT NULL auto_increment, `name` varchar(32) default NULL, `sex` char(4) default NULL, `zhicheng` varchar(32) default NULL, `image` varchar(50) default NULL, `info` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*Data for the table `teacher` */ insert into `teacher`(`id`,`name`,`sex`,`zhicheng`,`image`,`info`) values (2,'李老师','女','会计师','s10.gif',' 她有光荣的历史 \r\n \r\n \r\n \r\n \r\n '),(3,'李老师','男','教授','xong6.gif','来自广州\r\n \r\n \r\n '); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;