基于java的贪吃蛇，完整毕设，包括论文

/* Navicat MySQL Data Transfer Source Server : local-mysql Source Server Version : 50714 Source Host : localhost:3306 Source Database : onlinestudy Target Server Type : MYSQL Target Server Version : 50714 File Encoding : 65001 Date: 2017-05-08 11:59:09 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `os_resource` -- ---------------------------- DROP TABLE IF EXISTS `os_resource`; CREATE TABLE `os_resource` ( `id` varchar(32) NOT NULL, `name` varchar(200) DEFAULT NULL, `renames` varchar(300) DEFAULT NULL, `personid` varchar(32) DEFAULT NULL, `updatetime` datetime DEFAULT NULL, `size` varchar(50) DEFAULT NULL, `type` varchar(50) DEFAULT NULL, `description` varchar(300) DEFAULT NULL, `title` varchar(200) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of os_resource -- ---------------------------- INSERT INTO `os_resource` VALUES ('402800815b421d81015b422407d60003', '第39讲_文化-5.flv', '20170406152148.flv', '1', '2017-04-06 15:21:49', '47281KB', 'shipin', 'aa', 'a'); INSERT INTO `os_resource` VALUES ('402800815b421d81015b42240afc0004', '第39讲_文化-5.flv', '20170406152149.flv', '1', '2017-04-06 15:21:50', '47281KB', 'shipin', 'aa', 'a'); -- ---------------------------- -- Table structure for `sys_authorinfo` -- ---------------------------- DROP TABLE IF EXISTS `sys_authorinfo`; CREATE TABLE `sys_authorinfo` ( `Id` varchar(32) NOT NULL, `copyrightInfo` varchar(32) DEFAULT NULL, `designMake` varchar(32) DEFAULT NULL, `version` varchar(32) DEFAULT NULL, `contectEmail` varchar(32) DEFAULT NULL, `contectQQ` varchar(32) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of sys_authorinfo -- ---------------------------- INSERT INTO `sys_authorinfo` VALUES ('1', '版权', 'shiyue', '1.1beta', '1287641592@qq.com', '1287641592'); -- ---------------------------- -- Table structure for `sys_loginlog` -- ---------------------------- DROP TABLE IF EXISTS `sys_loginlog`; CREATE TABLE `sys_loginlog` ( `id` varchar(32) NOT NULL, `USERNAME` varchar(32) DEFAULT NULL, `PASSWORD` varchar(32) DEFAULT NULL, `DESCRIPTION` varchar(200) DEFAULT NULL, `STATE` varchar(32) DEFAULT NULL, `LOGINTIME` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='登录日志'; -- ---------------------------- -- Records of sys_loginlog -- ---------------------------- INSERT INTO `sys_loginlog` VALUES ('402880e65b415fa6015b4160da0b0002', 'admin', '123456', '没有该用户！', '失败', '2017-04-06 11:48:38'); INSERT INTO `sys_loginlog` VALUES ('402880e65b416408015b41656d440002', 'admin', 'admin', '没有该用户！', '失败', '2017-04-06 11:53:37'); INSERT INTO `sys_loginlog` VALUES ('402880e65b416408015b4165a1780003', 'admin', '123456', '验证码错误！', '失败', '2017-04-06 11:53:51'); INSERT INTO `sys_loginlog` VALUES ('', null, null, null, null, null); INSERT INTO `sys_loginlog` VALUES ('402880e65b416408015b41758dff0004', 'admin', '111111', '没有该用户！', '失败', '2017-04-06 12:11:14'); INSERT INTO `sys_loginlog` VALUES ('402880e65b417918015b41796d910002', 'admin', '******', '登录成功', '成功', '2017-04-06 12:15:28'); INSERT INTO `sys_loginlog` VALUES ('402880e65b417f6c015b418197460002', 'student', '******', '登录成功', '成功', '2017-04-06 12:24:23'); INSERT INTO `sys_loginlog` VALUES ('402880e65b417f6c015b41821b010003', 'student', '111111', '密码不正确！', '失败', '2017-04-06 12:24:57'); INSERT INTO `sys_loginlog` VALUES ('402880e65b417f6c015b4182522e0004', 'student', '******', '登录成功', '成功', '2017-04-06 12:25:11'); INSERT INTO `sys_loginlog` VALUES ('402880e65b417f6c015b4188d0b00005', 'admin', '******', '登录成功', '成功', '2017-04-06 12:32:17'); INSERT INTO `sys_loginlog` VALUES ('402880e65b419463015b41949fc90002', 'admin', '******', '登录成功', '成功', '2017-04-06 12:45:10'); INSERT INTO `sys_loginlog` VALUES ('402800815b421d81015b4222a6c90002', 'admin', '******', '登录成功', '成功', '2017-04-06 15:20:18'); INSERT INTO `sys_loginlog` VALUES ('402800815b421d81015b422597b90005', 'student', '******', '登录成功', '成功', '2017-04-06 15:23:31'); INSERT INTO `sys_loginlog` VALUES ('402800815b421d81015b422e026b0006', 'student', '******', '登录成功', '成功', '2017-04-06 15:32:43'); INSERT INTO `sys_loginlog` VALUES ('402800815b58066f015b58089af60002', 'student', '******', '登录成功', '成功', '2017-04-10 21:23:30'); INSERT INTO `sys_loginlog` VALUES ('402800815b58066f015b580d2a670003', 'admin', '111111', '验证码错误！', '失败', '2017-04-10 21:28:29'); INSERT INTO `sys_loginlog` VALUES ('402800815b58066f015b580d58bb0004', 'admin', '******', '登录成功', '成功', '2017-04-10 21:28:41'); -- ---------------------------- -- Table structure for `sys_person` -- ---------------------------- DROP TABLE IF EXISTS `sys_person`; CREATE TABLE `sys_person` ( `Id` varchar(32) NOT NULL, `userName` varchar(32) DEFAULT NULL, `name` varchar(32) DEFAULT NULL, `sex` varchar(4) DEFAULT NULL, `birth` datetime DEFAULT NULL, `cardId` varchar(18) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `selfDescription` varchar(200) DEFAULT NULL, `telephone` varchar(20) DEFAULT NULL, `otherconnect` varchar(20) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of sys_person -- ---------------------------- INSERT INTO `sys_person` VALUES ('1', 'admin', '系统管理员', '男', '2011-03-27 01:00:00', '123', '北京王府井', '我是一个牛人55555555555555555123123123333333333', '138381111', '其他'); INSERT INTO `sys_person` VALUES ('4028e48d2f098ce3012f09a6ec74000e', 'student', '学生', '男', '2011-03-17 00:00:00', '123', '北京', 'hello i\'m student', '22', ''); INSERT INTO `sys_person` VALUES ('4028e48d2f098ce3012f09a745b00010', 'teacher', '教师', '男', '2011-03-24 00:00:00', '321', '西安', '', '333', '111'); -- ---------------------------- -- Table structure for `sys_user` -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `ID` varchar(32) NOT NULL, `USERNAME` varchar(32) DEFAULT NULL, `PASSWORD` varchar(32) DEFAULT NULL, `TYPE` varchar(32) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户表'; -- ---------------------------- -- Records of sys_user -- ---------------------------- INSERT INTO `sys_user` VALUES ('1', 'admin', '96e79218965eb72c92a549dd5a330112', '3'); INSERT INTO `sys_user` VALUES ('2', 'student', 'e10adc3949ba59abbe56e057f20f883e', '1'); INSERT INTO `sys_user` VALUES ('3', 'teacher', '96e79218965eb72c92a549dd5a330112', '2'); INSERT INTO `sys_user` VALUES ('402880e65b417f6c015b4189d3af0006', 'fx', '96e79218965eb72c92a549dd5a330112', '1');