一个简单的管理系统，使用了hibernate+Struts2,数据库是mysql

/* Navicat MySQL Data Transfer Source Server : db2 Source Server Version : 50717 Source Host : 192.168.10.65:3306 Source Database : tbmaneger Target Server Type : MYSQL Target Server Version : 50717 File Encoding : 65001 Date: 2017-04-28 16:47:31 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `channels` -- ---------------------------- DROP TABLE IF EXISTS `channels`; CREATE TABLE `channels` ( `channels_id` int(11) NOT NULL AUTO_INCREMENT, `video_type` varchar(255) NOT NULL, `number` varchar(255) NOT NULL, `nvod_server_name` varchar(255) NOT NULL, PRIMARY KEY (`channels_id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of channels -- ---------------------------- INSERT INTO `channels` VALUES ('7', 'h264_HD', '1', 'TBServer'); INSERT INTO `channels` VALUES ('8', 'mpeg2_HD', '2', 'TBServer'); INSERT INTO `channels` VALUES ('9', 'h264_4K', '3', 'TBServer'); INSERT INTO `channels` VALUES ('10', 'h264_HD', '2', 'TBxxx'); INSERT INTO `channels` VALUES ('11', 'mpeg2_HD', '3', 'TBxxx'); INSERT INTO `channels` VALUES ('12', 'h264_4K', '4', 'TBxxx'); INSERT INTO `channels` VALUES ('13', 'h264_HD', '2', '52984'); INSERT INTO `channels` VALUES ('14', 'mpeg2_HD', '3', '52984'); INSERT INTO `channels` VALUES ('15', 'h264_4K', '4', '52984'); INSERT INTO `channels` VALUES ('16', 'AVS_HD', '3', 'tbtest2'); INSERT INTO `channels` VALUES ('17', 'mpeg2_HD', '2', 'tbtest2'); INSERT INTO `channels` VALUES ('18', 'h264_4K', '4', 'tbtest2'); -- ---------------------------- -- Table structure for `lisence` -- ---------------------------- DROP TABLE IF EXISTS `lisence`; CREATE TABLE `lisence` ( `lisenceid` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) NOT NULL, `lisence_name` varchar(255) NOT NULL, PRIMARY KEY (`lisenceid`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of lisence -- ---------------------------- INSERT INTO `lisence` VALUES ('15', 'ghhjhjhj', 'TBlisence'); INSERT INTO `lisence` VALUES ('16', 'ghhjhjhj', 'TBsss'); INSERT INTO `lisence` VALUES ('17', 'ghhjhjhj', 'test'); INSERT INTO `lisence` VALUES ('18', 'yuu', 'tbyyuh'); -- ---------------------------- -- Table structure for `middleware` -- ---------------------------- DROP TABLE IF EXISTS `middleware`; CREATE TABLE `middleware` ( `middleware_id` int(11) NOT NULL AUTO_INCREMENT, `middleware_mac` varchar(255) NOT NULL, `middleware_expiry_preid` varchar(255) NOT NULL, `lisence_name` varchar(255) NOT NULL, PRIMARY KEY (`middleware_id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of middleware -- ---------------------------- INSERT INTO `middleware` VALUES ('3', '******', '20880808', 'TBlisence'); INSERT INTO `middleware` VALUES ('4', '******', '20180808', 'TBsss'); INSERT INTO `middleware` VALUES ('5', '******', '1587448947', 'test'); INSERT INTO `middleware` VALUES ('6', '******', '20181212', 'tbyyuh'); -- ---------------------------- -- Table structure for `nvod_server` -- ---------------------------- DROP TABLE IF EXISTS `nvod_server`; CREATE TABLE `nvod_server` ( `nvod_server_id` int(11) NOT NULL AUTO_INCREMENT, `nvod_mac` varchar(255) NOT NULL, `nvod_expiry_perid` varchar(255) NOT NULL, `channels` int(11) NOT NULL, `lisence_name` varchar(255) NOT NULL, `nvod_server_name` varchar(255) NOT NULL, PRIMARY KEY (`nvod_server_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of nvod_server -- ---------------------------- INSERT INTO `nvod_server` VALUES ('2', '******', '20880808', '3', 'TBlisence', 'TBServer'); INSERT INTO `nvod_server` VALUES ('3', '******', '20180807', '3', 'TBsss', 'TBxxx'); INSERT INTO `nvod_server` VALUES ('4', '******', '154844', '3', 'test', '52984'); INSERT INTO `nvod_server` VALUES ('5', '******', '20181212', '3', 'tbyyuh', 'tbtest2'); -- ---------------------------- -- Table structure for `platform` -- ---------------------------- DROP TABLE IF EXISTS `platform`; CREATE TABLE `platform` ( `platform_id` int(11) NOT NULL AUTO_INCREMENT, `platform_mac` varchar(255) NOT NULL, `platform_expiry_perid` varchar(255) NOT NULL, `make_table_number` varchar(255) NOT NULL, `input_clips_number` varchar(255) NOT NULL, `play_ctrl_number` varchar(255) NOT NULL, `lisence_name` varchar(255) NOT NULL, PRIMARY KEY (`platform_id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of platform -- ---------------------------- INSERT INTO `platform` VALUES ('3', '******', '20881212', '3', '2', '3', 'TBlisence'); INSERT INTO `platform` VALUES ('4', '******', '20180808', '20180808', '2', '2', 'TBsss'); INSERT INTO `platform` VALUES ('5', '******', 'bhyb', 'bhyb', '485', '11', 'test'); INSERT INTO `platform` VALUES ('6', '******', '20181212', '20181212', '2', '3', 'tbyyuh'); -- ---------------------------- -- Table structure for `project` -- ---------------------------- DROP TABLE IF EXISTS `project`; CREATE TABLE `project` ( `project_id` int(11) NOT NULL AUTO_INCREMENT, `user_name` varchar(255) NOT NULL, `project_name` varchar(255) NOT NULL, `lisence_name` varchar(255) NOT NULL, PRIMARY KEY (`project_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of project -- ---------------------------- INSERT INTO `project` VALUES ('4', 'ghhjhjhj', 'TBdd', 'TBlisence'); INSERT INTO `project` VALUES ('5', 'ghhjhjhj', 'LL', 'TBsss'); INSERT INTO `project` VALUES ('6', 'ghhjhjhj', 'tbtest', 'test'); INSERT INTO `project` VALUES ('7', 'yuu', 'terfg', 'tbyyuh'); -- ---------------------------- -- Table structure for `user` -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `user_name` varchar(20) NOT NULL, `password` varchar(20) NOT NULL, `authorization` varchar(255) DEFAULT NULL, `creat_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `projects` int(11) DEFAULT NULL, `lisences` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES ('13', 'ghhjhjhj', 'jhjhhjj', null, '2017-04-20 17:46:40', '3', '0'); INSERT INTO `user` VALUES ('16', 'yuu', 'yu', null, '2017-04-22 11:34:04', '1', '0'); INSERT INTO `user` VALUES ('30', 'fg', 'hj', null, '2017-04-28 11:29:22', '0', '0'); INSERT INTO `user` VALUES ('31', 'gg', 'gg', null, '2017-04-28 11:40:39', '0', '0');