Java毕业设计（可运行）基于jsp的健身俱乐部会员系统论文+答辩PPT+源代码+数据库.zip

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50521 Source Host : localhost:3306 Source Database : db_jianshen2017_g Target Server Type : MYSQL Target Server Version : 50521 File Encoding : 65001 Date: 2017-02-19 17:46:32 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `t_card` -- ---------------------------- DROP TABLE IF EXISTS `t_card`; CREATE TABLE `t_card` ( `card_id` int(11) NOT NULL, `card_leixiong` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `card_guize` text CHARACTER SET utf8, `card_youhuizhengce` text CHARACTER SET utf8, `card_one1` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `card_one2` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `card_one3` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `card_one4` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `card_one5` int(11) DEFAULT NULL, `card_one6` int(11) DEFAULT NULL, `card_one7` datetime DEFAULT NULL, `card_one8` datetime DEFAULT NULL, PRIMARY KEY (`card_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of t_card -- ---------------------------- INSERT INTO `t_card` VALUES ('1', '普通卡', '普通卡普通卡普通卡', '普通卡普通卡普通卡', null, null, null, null, null, null, null, null); INSERT INTO `t_card` VALUES ('2', '白金卡', '白金卡白金卡', '白金卡白金卡', null, null, null, null, null, null, null, null); INSERT INTO `t_card` VALUES ('3', '钻石卡', '钻石卡钻石卡钻石卡', '钻石卡钻石卡钻石卡', null, null, null, null, null, null, null, null); INSERT INTO `t_card` VALUES ('4', '白金卡', '白金卡白金卡白金卡', '白金卡白金卡白金卡', null, null, null, null, null, null, null, null); -- ---------------------------- -- Table structure for `t_qicai` -- ---------------------------- DROP TABLE IF EXISTS `t_qicai`; CREATE TABLE `t_qicai` ( `qicai_id` int(11) NOT NULL, `qicai_name` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `qicai_goumairiqi` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `qicai_beizhu` text CHARACTER SET utf8, `qicai_one1` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `qicai_one2` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `qicai_one3` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `qicai_one4` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `qicai_one5` int(11) DEFAULT NULL, `qicai_one6` int(11) DEFAULT NULL, `qicai_one7` datetime DEFAULT NULL, `qicai_one8` datetime DEFAULT NULL, PRIMARY KEY (`qicai_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of t_qicai -- ---------------------------- INSERT INTO `t_qicai` VALUES ('2', '跑步机', '2010-06-01', '跑步机跑步机跑步机跑步机跑步机', null, null, null, null, null, null, null, null); INSERT INTO `t_qicai` VALUES ('3', '瑜伽器材', '2010-06-15', '瑜伽器材瑜伽器材', null, null, null, null, null, null, null, null); -- ---------------------------- -- Table structure for `t_user` -- ---------------------------- DROP TABLE IF EXISTS `t_user`; CREATE TABLE `t_user` ( `user_id` int(11) NOT NULL, `user_name` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_pw` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_type` int(11) DEFAULT NULL, `user_realname` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_address` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_sex` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_tel` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_email` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_qq` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_man` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_age` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_birthday` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_xueli` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_one1` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_one2` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_one3` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_one4` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_one5` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `user_one6` int(11) DEFAULT NULL, `user_one7` int(11) DEFAULT NULL, `user_one8` int(11) DEFAULT NULL, `user_one9` datetime DEFAULT NULL, `user_one10` datetime DEFAULT NULL, `user_one11` bigint(20) DEFAULT NULL, `user_one12` bigint(20) DEFAULT NULL, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of t_user -- ---------------------------- INSERT INTO `t_user` VALUES ('1', 'a', 'a', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `t_user` VALUES ('2', '刘光亮', null, '1', null, '青岛市', '男', '1322222222222', 'liu@yaoo.cn', '12345', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `t_user` VALUES ('3', '张三', null, '2', null, '青岛是四方区', '男', '1322222222222', 'zhangsan@yahooo.c', '111111', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `t_user` VALUES ('5', '马大哈', null, '8', null, '上海浦东', '男', '1322222222222', 'madaha@yahooo.cn', '124333', null, null, null, null, '白金卡', null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `t_user` VALUES ('6', '蔡依林', null, '8', null, '香港啥尖嘴', '女', '15054256789', 'caiyiling@163。com', '123456', null, null, null, null, '钻石卡', null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `t_user` VALUES ('8', 'dd', null, '1', null, 'dd', '男', '2222', '222', '222', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); -- ---------------------------- -- Table structure for `t_zhijiao` -- ---------------------------- DROP TABLE IF EXISTS `t_zhijiao`; CREATE TABLE `t_zhijiao` ( `zhijiao_id` int(11) NOT NULL, `zhijiao_jiaolian_id` int(11) DEFAULT NULL, `zhijiao_jiaolian_name` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `zhijiao_kecheng` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `zhijiao_huiyuan` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `zhijiao_one1` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `zhijiao_one2` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `zhijiao_one3` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `zhijiao_one4` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `zhijiao_one5` int(11) DEFAULT NULL, `zhijiao_one6` int(11) DEFAULT NULL, `zhijiao_one7` datetime DEFAULT NULL, `zhijiao_one8` datetime DEFAULT NULL, PRIMARY KEY (`zhijiao_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of t_zhijiao -- ---------------------------- INSERT INTO `t_zhijiao` VALUES ('3', null, 'df', 'df', 'df', null, null, null, null, null, null, null, null);