基于分层设计的php员工管理系统.zip

-- phpMyAdmin SQL Dump -- version 3.0.1.1 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2012 年 12 月 13 日 10:10 -- 服务器版本: 5.1.29 -- PHP 版本: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- 数据库: `empmanage` -- -- -------------------------------------------------------- -- -- 表的结构 `admin` -- CREATE TABLE IF NOT EXISTS `admin` ( `id` int(11) NOT NULL, `name` varchar(32) NOT NULL, `password` varchar(128) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; -- -- 导出表中的数据 `admin` -- INSERT INTO `admin` (`id`, `name`, `password`) VALUES (100, 'admin', '21232f297a57a5a743894a0e4a801fc3'); -- -------------------------------------------------------- -- -- 表的结构 `emp` -- CREATE TABLE IF NOT EXISTS `emp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL, `grade` tinyint(4) DEFAULT NULL, `email` varchar(64) NOT NULL, `salary` float DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=371 ; -- -- 导出表中的数据 `emp` -- INSERT INTO `emp` (`id`, `name`, `grade`, `email`, `salary`) VALUES (5, '小明', 1, 'xiaoming@126.com', 800), (7, '大牛', 1, 'daniu@126.com', 680), (8, '张芳', 2, 'zhangfang@163.com', 880), (12, '小明', 1, 'xiafgang@126.com', 800), (14, '大牛', 1, 'daniu@126.com', 680), (15, '张芳', 2, 'zhangfang@163.com', 880), (17, '小丽', 2, 'xiaoli@126.com', 700), (18, '大牛', 1, 'daniu@126.com', 680), (19, '张芳', 2, 'zhangfang@163.com', 880), (20, '小明', 1, 'xiaoming@126.com', 800), (21, '小丽', 2, 'xiaoli@126.com', 700), (22, '大牛', 1, 'daniu@126.com', 680), (23, '张芳', 2, 'zhangfang@163.com', 880), (24, '小明', 1, 'xiaoming@126.com', 800), (25, '小丽', 2, 'xiaoli@126.com', 700), (26, '大牛', 1, 'daniu@126.com', 680), (27, '张芳', 2, 'zhangfang@163.com', 880), (28, '小明', 1, 'xiaoming@126.com', 800), (29, '小丽', 2, 'xiaoli@126.com', 700), (30, '大牛', 1, 'daniu@126.com', 680), (31, '张芳', 2, 'zhangfang@163.com', 880), (32, '小明', 1, 'xiaoming@126.com', 800), (33, '小丽', 2, 'xiaoli@126.com', 700), (34, '大牛', 1, 'daniu@126.com', 680), (35, '张芳', 2, 'zhangfang@163.com', 880), (51, '小明', 1, 'xiaoming@126.com', 800), (52, '小丽', 2, 'xiaoli@126.com', 700), (53, '大牛', 1, 'daniu@126.com', 680), (54, '张芳', 2, 'zhangfang@163.com', 880), (55, '小明', 1, 'xiaoming@126.com', 800), (56, '小丽', 2, 'xiaoli@126.com', 700), (57, '大牛', 1, 'daniu@126.com', 680), (58, '张芳', 2, 'zhangfang@163.com', 880), (59, '小明', 1, 'xiaoming@126.com', 800), (60, '小丽', 2, 'xiaoli@126.com', 700), (61, '大牛', 1, 'daniu@126.com', 680), (62, '张芳', 2, 'zhangfang@163.com', 880), (63, '小明', 1, 'xiaoming@126.com', 800), (64, '小丽', 2, 'xiaoli@126.com', 700), (65, '大牛', 1, 'daniu@126.com', 680), (66, '张芳', 2, 'zhangfang@163.com', 880), (67, '小明', 1, 'xiaoming@126.com', 800), (68, '小丽', 2, 'xiaoli@126.com', 700), (69, '大牛', 1, 'daniu@126.com', 680), (70, '张芳', 2, 'zhangfang@163.com', 880), (71, '小明', 1, 'xiaoming@126.com', 800), (72, '小丽', 2, 'xiaoli@126.com', 700), (73, '大牛', 1, 'daniu@126.com', 680), (74, '张芳', 2, 'zhangfang@163.com', 880), (75, '小明', 1, 'xiaoming@126.com', 800), (76, '小丽', 2, 'xiaoli@126.com', 700), (77, '大牛', 1, 'daniu@126.com', 680), (78, '张芳', 2, 'zhangfang@163.com', 880), (79, '小明', 1, 'xiaoming@126.com', 800), (80, '小丽', 2, 'xiaoli@126.com', 700), (81, '大牛', 1, 'daniu@126.com', 680), (82, '张芳', 2, 'zhangfang@163.com', 880), (114, '小明', 1, 'xiaoming@126.com', 800), (115, '小丽', 2, 'xiaoli@126.com', 700), (116, '大牛', 1, 'daniu@126.com', 680), (117, '张芳', 2, 'zhangfang@163.com', 880), (118, '小明', 1, 'xiaoming@126.com', 800), (119, '小丽', 2, 'xiaoli@126.com', 700), (120, '大牛', 1, 'daniu@126.com', 680), (121, '张芳', 2, 'zhangfang@163.com', 880), (122, '小明', 1, 'xiaoming@126.com', 800), (123, '小丽', 2, 'xiaoli@126.com', 700), (124, '大牛', 1, 'daniu@126.com', 680), (125, '张芳', 2, 'zhangfang@163.com', 880), (126, '小明', 1, 'xiaoming@126.com', 800), (127, '小丽', 2, 'xiaoli@126.com', 700), (128, '大牛', 1, 'daniu@126.com', 680), (129, '张芳', 2, 'zhangfang@163.com', 880), (130, '小明', 1, 'xiaoming@126.com', 800), (131, '小丽', 2, 'xiaoli@126.com', 700), (132, '大牛', 1, 'daniu@126.com', 680), (133, '张芳', 2, 'zhangfang@163.com', 880), (134, '小明', 1, 'xiaoming@126.com', 800), (135, '小丽', 2, 'xiaoli@126.com', 700), (136, '大牛', 1, 'daniu@126.com', 680), (137, '张芳', 2, 'zhangfang@163.com', 880), (138, '小明', 1, 'xiaoming@126.com', 800), (139, '小丽', 2, 'xiaoli@126.com', 700), (140, '大牛', 1, 'daniu@126.com', 680), (141, '张芳', 2, 'zhangfang@163.com', 880), (142, '小明', 1, 'xiaoming@126.com', 800), (143, '小丽', 2, 'xiaoli@126.com', 700), (144, '大牛', 1, 'daniu@126.com', 680), (145, '张芳', 2, 'zhangfang@163.com', 880), (146, '小明', 1, 'xiaoming@126.com', 800), (147, '小丽', 2, 'xiaoli@126.com', 700), (148, '大牛', 1, 'daniu@126.com', 680), (149, '张芳', 2, 'zhangfang@163.com', 880), (150, '小明', 1, 'xiaoming@126.com', 800), (151, '小丽', 2, 'xiaoli@126.com', 700), (152, '大牛', 1, 'daniu@126.com', 680), (153, '张芳', 2, 'zhangfang@163.com', 880), (154, '小明', 1, 'xiaoming@126.com', 800), (155, '小丽', 2, 'xiaoli@126.com', 700), (156, '大牛', 1, 'daniu@126.com', 680), (157, '张芳', 2, 'zhangfang@163.com', 880), (158, '小明', 1, 'xiaoming@126.com', 800), (159, '小丽', 2, 'xiaoli@126.com', 700), (160, '大牛', 1, 'daniu@126.com', 680), (161, '张芳', 2, 'zhangfang@163.com', 880), (162, '小明', 1, 'xiaoming@126.com', 800), (163, '小丽', 2, 'xiaoli@126.com', 700), (164, '大牛', 1, 'daniu@126.com', 680), (165, '张芳', 2, 'zhangfang@163.com', 880), (166, '小明', 1, 'xiaoming@126.com', 800), (167, '小丽', 2, 'xiaoli@126.com', 700), (168, '大牛', 1, 'daniu@126.com', 680), (169, '张芳', 2, 'zhangfang@163.com', 880), (170, '小明', 1, 'xiaoming@126.com', 800), (171, '小丽', 2, 'xiaoli@126.com', 700), (172, '大牛', 1, 'daniu@126.com', 680), (173, '张芳', 2, 'zhangfang@163.com', 880), (174, '小明', 1, 'xiaoming@126.com', 800), (175, '小丽', 2, 'xiaoli@126.com', 700), (176, '大牛', 1, 'daniu@126.com', 680), (177, '张芳', 2, 'zhangfang@163.com', 880), (241, '小明', 1, 'xiaoming@126.com', 800), (242, '小丽', 2, 'xiaoli@126.com', 700), (243, '大牛', 1, 'daniu@126.com', 680), (244, '张芳', 2, 'zhangfang@163.com', 880), (245, '小明', 1, 'xiaoming@126.com', 800), (246, '小丽', 2, 'xiaoli@126.com', 700), (247, '大牛', 1, 'daniu@126.com', 680), (248, '张芳', 2, 'zhangfang@163.com', 880), (249, '小明', 1, 'xiaoming@126.com', 800), (250, '小丽', 2, 'xiaoli@126.com', 700), (251, '大牛', 1, 'daniu@126.com', 680), (252, '张芳', 2, 'zhangfang@163.com', 880), (253, '小明', 1, 'xiaoming@126.com', 800), (254, '小丽', 2, 'xiaoli@126.com', 700), (255, '大牛', 1, 'daniu@126.com', 680), (256, '张芳', 2, 'zhangfang@163.com', 880), (257, '小明', 1, 'xiaoming@126.com', 800), (258, '小丽', 2, 'xiaoli@126.com', 700), (259, '大牛', 1, 'daniu@126.com', 680), (260, '张芳', 2, 'zhangfang@163.com', 880), (261, '小明', 1, 'xiaoming@126.com', 800), (262, '小丽', 2, 'xiaoli@126.com', 700), (263, '大牛', 1, 'daniu@126.com', 680), (264, '张芳', 2, 'zhangfang@163.com', 880), (265, '小明', 1, 'xiaoming@126.com', 800), (266, '小丽', 2, 'xiaoli@126.com', 700), (267, '大牛', 1, 'daniu@126.com', 680), (268, '张芳', 2, 'zhangfang@163.com', 880), (269, '小明', 1, 'xiaoming@126.com', 800), (270, '小丽', 2, 'xiaoli@126.com', 700), (271, '大牛', 1, 'daniu@126.com', 680), (272, '张芳', 2, 'zhangfang@163.com', 880), (273, '小明', 1, 'xiaoming@126.com', 800), (274, '小丽', 2, 'xiaoli@126.com', 700), (275, '大牛', 1, 'daniu@126.com', 680), (276, '张芳', 2, 'zhangfang@163.com', 880), (277, '小明', 1, 'xiaoming@126.com', 800), (278, '小丽', 2, 'xiaoli@126.com', 700), (279, '大牛', 1, 'daniu@126.com', 680),