基于java的出租公司管理系统(源代码+讲解视频+数据库).zip

/* Navicat MySQL Data Transfer Source Server : eee Source Server Version : 50617 Source Host : localhost:3306 Source Database : didi Target Server Type : MYSQL Target Server Version : 50617 File Encoding : 65001 Date: 2018-01-14 19:31:12 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `t_a_type` -- ---------------------------- DROP TABLE IF EXISTS `t_a_type`; CREATE TABLE `t_a_type` ( `a_t_id` int(11) NOT NULL AUTO_INCREMENT, `a_t_name` varchar(20) DEFAULT NULL, PRIMARY KEY (`a_t_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_a_type -- ---------------------------- INSERT INTO `t_a_type` VALUES ('1', '系统管理员'); INSERT INTO `t_a_type` VALUES ('2', '普通管理员'); INSERT INTO `t_a_type` VALUES ('3', '公司管理员'); -- ---------------------------- -- Table structure for `t_admin` -- ---------------------------- DROP TABLE IF EXISTS `t_admin`; CREATE TABLE `t_admin` ( `a_id` int(11) NOT NULL AUTO_INCREMENT, `a_t_id` int(11) DEFAULT NULL, `a_count` varchar(20) NOT NULL, `a_password` varchar(15) NOT NULL, PRIMARY KEY (`a_id`), KEY `FK_a_t_a` (`a_t_id`), CONSTRAINT `FK_a_t_a` FOREIGN KEY (`a_t_id`) REFERENCES `t_a_type` (`a_t_id`) ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_admin -- ---------------------------- INSERT INTO `t_admin` VALUES ('1', '1', 'admin', 'admin'); INSERT INTO `t_admin` VALUES ('2', '2', 'admin123', 'admin123'); INSERT INTO `t_admin` VALUES ('3', '3', 'nanchang', 'nanchang'); INSERT INTO `t_admin` VALUES ('4', '3', 'nanchang2', 'nanchang2'); INSERT INTO `t_admin` VALUES ('5', '2', 'admin2', 'admin2'); INSERT INTO `t_admin` VALUES ('6', '3', 'beijing', 'beijing'); INSERT INTO `t_admin` VALUES ('7', '2', '333', '444'); INSERT INTO `t_admin` VALUES ('8', '3', '555', '666'); INSERT INTO `t_admin` VALUES ('9', '2', '666', '777'); INSERT INTO `t_admin` VALUES ('10', '3', '888', '999'); INSERT INTO `t_admin` VALUES ('11', '3', '1010', '1010'); INSERT INTO `t_admin` VALUES ('13', '2', '1313', '1313'); INSERT INTO `t_admin` VALUES ('14', '1', '3434', '3434'); INSERT INTO `t_admin` VALUES ('15', '1', '4545', '4545'); INSERT INTO `t_admin` VALUES ('16', '1', '45456', '45456'); INSERT INTO `t_admin` VALUES ('17', '1', '454567', '454567'); INSERT INTO `t_admin` VALUES ('18', '1', '4545678', '454567'); INSERT INTO `t_admin` VALUES ('20', '1', '1234', '1234'); INSERT INTO `t_admin` VALUES ('21', '1', '12345', '12345'); INSERT INTO `t_admin` VALUES ('22', '1', '123456', '12345'); INSERT INTO `t_admin` VALUES ('24', '1', '1111', '1111'); -- ---------------------------- -- Table structure for `t_allocation` -- ---------------------------- DROP TABLE IF EXISTS `t_allocation`; CREATE TABLE `t_allocation` ( `allo_id` int(11) NOT NULL AUTO_INCREMENT, `c_id` int(11) DEFAULT NULL, `u_id` int(11) DEFAULT NULL, PRIMARY KEY (`allo_id`), KEY `FK_a_c_a` (`c_id`), KEY `FK_e_a_e` (`u_id`), CONSTRAINT `FK_a_c_a` FOREIGN KEY (`c_id`) REFERENCES `t_cpn_car` (`c_id`), CONSTRAINT `FK_e_a_e` FOREIGN KEY (`u_id`) REFERENCES `t_employee` (`u_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_allocation -- ---------------------------- -- ---------------------------- -- Table structure for `t_c_type` -- ---------------------------- DROP TABLE IF EXISTS `t_c_type`; CREATE TABLE `t_c_type` ( `c_t_id` int(11) NOT NULL AUTO_INCREMENT, `c_t_name` varchar(20) DEFAULT NULL, PRIMARY KEY (`c_t_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_c_type -- ---------------------------- INSERT INTO `t_c_type` VALUES ('1', '小轿车'); -- ---------------------------- -- Table structure for `t_car` -- ---------------------------- DROP TABLE IF EXISTS `t_car`; CREATE TABLE `t_car` ( `c_id` int(11) NOT NULL AUTO_INCREMENT, `c_t_id` int(11) DEFAULT NULL, `c_plate_number` varchar(8) DEFAULT NULL, `c_buy_time` date DEFAULT NULL, `c_brand` varchar(20) DEFAULT NULL, `c_color` varchar(10) DEFAULT NULL, `c_max_number` int(11) DEFAULT '5', `c_picture` varchar(100) DEFAULT NULL, `c_state` int(11) DEFAULT '3', PRIMARY KEY (`c_id`), KEY `FK_c_t_c` (`c_t_id`), CONSTRAINT `FK_c_t_c` FOREIGN KEY (`c_t_id`) REFERENCES `t_c_type` (`c_t_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_car -- ---------------------------- INSERT INTO `t_car` VALUES ('1', '1', 'aaaa', '2018-01-11', '', null, '5', null, '3'); INSERT INTO `t_car` VALUES ('2', '1', 'eeee', '2018-01-12', '大众', '白', '5', null, '3'); -- ---------------------------- -- Table structure for `t_comment` -- ---------------------------- DROP TABLE IF EXISTS `t_comment`; CREATE TABLE `t_comment` ( `m_id` int(11) NOT NULL AUTO_INCREMENT, `u_id` int(11) DEFAULT NULL, `p_id` int(11) DEFAULT NULL, `m_content` text, `m_pub_time` datetime DEFAULT NULL, `m_target` int(11) DEFAULT NULL, PRIMARY KEY (`m_id`), KEY `FK_p_m_p` (`p_id`), KEY `FK_u_m_u` (`u_id`), CONSTRAINT `FK_p_m_p` FOREIGN KEY (`p_id`) REFERENCES `t_post` (`p_id`), CONSTRAINT `FK_u_m_u` FOREIGN KEY (`u_id`) REFERENCES `t_user` (`u_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_comment -- ---------------------------- INSERT INTO `t_comment` VALUES ('1', null, null, '鹅鹅鹅鹅', null, null); -- ---------------------------- -- Table structure for `t_company` -- ---------------------------- DROP TABLE IF EXISTS `t_company`; CREATE TABLE `t_company` ( `cpn_id` int(11) NOT NULL AUTO_INCREMENT, `cpn_name` varchar(50) DEFAULT NULL, `cpn_ico` varchar(100) DEFAULT '/didi/images/user_default_pic.jpg', PRIMARY KEY (`cpn_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_company -- ---------------------------- INSERT INTO `t_company` VALUES ('1', '南昌出租车公司', '/didi/images/user_default_pic.jpg'); INSERT INTO `t_company` VALUES ('2', '北京出租车公司', '/didi/images/user_default_pic.jpg'); -- ---------------------------- -- Table structure for `t_cpn_admin` -- ---------------------------- DROP TABLE IF EXISTS `t_cpn_admin`; CREATE TABLE `t_cpn_admin` ( `a_id` int(11) NOT NULL, `cpn_id` int(11) DEFAULT NULL, PRIMARY KEY (`a_id`), KEY `FK_cpn_a_cpn` (`cpn_id`), CONSTRAINT `FK_a_cpn_a` FOREIGN KEY (`a_id`) REFERENCES `t_admin` (`a_id`), CONSTRAINT `FK_cpn_a_cpn` FOREIGN KEY (`cpn_id`) REFERENCES `t_company` (`cpn_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_cpn_admin -- ---------------------------- INSERT INTO `t_cpn_admin` VALUES ('3', '1'); INSERT INTO `t_cpn_admin` VALUES ('4', '1'); INSERT INTO `t_cpn_admin` VALUES ('10', '1'); INSERT INTO `t_cpn_admin` VALUES ('11', '1'); INSERT INTO `t_cpn_admin` VALUES ('6', '2'); INSERT INTO `t_cpn_admin` VALUES ('8', '2'); -- ---------------------------- -- Table structure for `t_cpn_car` -- ---------------------------- DROP TABLE IF EXISTS `t_cpn_car`; CREATE TABLE `t_cpn_car` ( `c_id` int(11) NOT NULL, `cpn_id` int(11) DEFAULT NULL, PRIMARY KEY (`c_id`), KEY `FK_cpn_c_cpn` (`cpn_id`), CONSTRAINT `FK_cpn_c_cpn` FOREIGN KEY (`cpn_id`) REFERENCES `t_company` (`cpn_id`), CONSTRAINT `FK_c_cpn_c` FOREIGN KEY (`c_id`) REFERENCES `t_car` (`c_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_cpn_car -- ---------------------------- INSERT INTO `t_cpn_car` VALUES ('1', '1'); -- ---------------------------- -- Table structure for `t_driver` -- ---------------------------- DROP TABLE IF EXISTS `t_driver`; CREATE TABLE `t_driver` ( `u_id` int(11) NOT NULL AUTO_INCREMENT, `d_real_name` varchar(20) NOT NULL, `d_car_class` char(2) DEFAULT NULL, `d_first_issue`