(免费分享)基于jsp,javaweb敬老院管理系统-027

/* SQLyog Community Edition- MySQL GUI v6.54 MySQL - 5.5.25a : Database - yanglaoyuan ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!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' */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`yanglaoyuan` /*!40100 DEFAULT CHARACTER SET gb2312 */; USE `yanglaoyuan`; /*Table structure for table `admin` */ DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int(4) NOT NULL AUTO_INCREMENT, `username` varchar(50) DEFAULT NULL, `password` varchar(50) DEFAULT NULL, `realname` varchar(50) DEFAULT NULL, `sex` varchar(50) DEFAULT NULL, `age` varchar(50) DEFAULT NULL, `address` varchar(50) DEFAULT NULL, `tel` varchar(50) DEFAULT NULL, `addtime` varchar(50) DEFAULT NULL, `sf` varchar(50) DEFAULT '普通管理员', UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=gb2312; /*Data for the table `admin` */ insert into `admin`(`id`,`username`,`password`,`realname`,`sex`,`age`,`address`,`tel`,`addtime`,`sf`) values (1,'admin','111','陈道明','男','25','成都市金牛区','13900000000','2016-03-09 22:59:56','系统管理员'),(12,'111','111','奥巴马','男','22','洪山区珞喻路吴家湾','13800000000','2016-03-18 02:07:31','普通管理员'); /*Table structure for table `fy` */ DROP TABLE IF EXISTS `fy`; CREATE TABLE `fy` ( `id` int(4) NOT NULL AUTO_INCREMENT, `lr` varchar(500) DEFAULT NULL, `fy` varchar(500) DEFAULT NULL, `kc` varchar(500) DEFAULT NULL, `zt` varchar(500) DEFAULT NULL, `xx` varchar(500) DEFAULT NULL, `sji` varchar(500) DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; /*Data for the table `fy` */ insert into `fy`(`id`,`lr`,`fy`,`kc`,`zt`,`xx`,`sji`) values (1,'张三丰','1900','200','未付','test','1700.0'); /*Table structure for table `hgqj` */ DROP TABLE IF EXISTS `hgqj`; CREATE TABLE `hgqj` ( `id` int(4) NOT NULL AUTO_INCREMENT, `lr` varchar(500) DEFAULT NULL, `sj` varchar(500) DEFAULT NULL, `xx` varchar(500) DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; /*Data for the table `hgqj` */ insert into `hgqj`(`id`,`lr`,`sj`,`xx`) values (1,'111','2016-03-19','家里有事'); /*Table structure for table `lr` */ DROP TABLE IF EXISTS `lr`; CREATE TABLE `lr` ( `id` int(4) NOT NULL AUTO_INCREMENT, `xm` varchar(500) DEFAULT NULL, `xb` varchar(500) DEFAULT NULL, `nl` varchar(500) DEFAULT NULL, `st` varchar(500) DEFAULT NULL, `hj` varchar(500) DEFAULT NULL, `sfz` varchar(500) DEFAULT NULL, `lxr` varchar(500) DEFAULT NULL, `dh` varchar(500) DEFAULT NULL, `zz` varchar(500) DEFAULT NULL, `cw` varchar(500) DEFAULT NULL, `hg` varchar(500) DEFAULT NULL, `rz` varchar(500) DEFAULT NULL, `cy` varchar(500) DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; /*Data for the table `lr` */ insert into `lr`(`id`,`xm`,`xb`,`nl`,`st`,`hj`,`sfz`,`lxr`,`dh`,`zz`,`cw`,`hg`,`rz`,`cy`) values (1,'张三丰','男','78','健康良好','湖北武汉','211220199009091234','张四丰','0278888888','武汉市洪山区珞瑜路吴家湾','9','111','2016-03-02','2016-03-31'); /*Table structure for table `qj` */ DROP TABLE IF EXISTS `qj`; CREATE TABLE `qj` ( `id` int(4) NOT NULL AUTO_INCREMENT, `lr` varchar(500) DEFAULT NULL, `sj` varchar(500) DEFAULT NULL, `xx` varchar(500) DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; /*Data for the table `qj` */ insert into `qj`(`id`,`lr`,`sj`,`xx`) values (1,'张三丰','2016-03-19','请假出去玩两天'); /*Table structure for table `sg` */ DROP TABLE IF EXISTS `sg`; CREATE TABLE `sg` ( `id` int(4) NOT NULL AUTO_INCREMENT, `lr` varchar(500) DEFAULT NULL, `sj` varchar(500) DEFAULT NULL, `xx` varchar(500) DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; /*Data for the table `sg` */ insert into `sg`(`id`,`lr`,`sj`,`xx`) values (1,'张三丰','2016-03-01','勾搭老太太'); /*Table structure for table `xz` */ DROP TABLE IF EXISTS `xz`; CREATE TABLE `xz` ( `id` int(4) NOT NULL AUTO_INCREMENT, `lr` varchar(500) DEFAULT NULL, `fy` varchar(500) DEFAULT NULL, `kc` varchar(500) DEFAULT NULL, `zt` varchar(500) DEFAULT NULL, `xx` varchar(500) DEFAULT NULL, `sji` varchar(50) DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; /*Data for the table `xz` */ insert into `xz`(`id`,`lr`,`fy`,`kc`,`zt`,`xx`,`sji`) values (1,'111','3500','150','已发','请假误工','3350.0'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;