功能演示
1：后台演示
2：客户端演示
一、项目介绍
要具有
1：考勤功能
2：平时成绩
3：平时成绩的计算
4：平时成绩百分制
5：作业，出勤
二、运行环境
1：客户端使用Android stuido进行开发；
2：服务端后台使用Myeclipse2014进行开发；
3：mysql数据库进行数据存储；
4：需要jdk1.7以上
5：使用雷电模拟器或者Androidstuio自带的模拟器进行运行
三、使用技术
总体设计逻辑和思路：
1：先设计数据库表文件
2：写服务端jsp页面以及写api接口给客户端提供数据
3：完成后台服务端的数据交互，也就是jsp页面数据的存储和显示
4：进行客户端页面的开发；
5：进行客户端对api接口的调用，也就是获取数据库的数据以及在客户端进行显示移动端：
1：使用android原生控件以及xml布局文件来完成界面的显示
2：使用java代码完成功能的数据和逻辑交互
3：使用http网络请求完成数据的请求；
4：使用json数据解析完成客户端数据的回调和显示服务端后台：
1：使用mysql完成数据的存储
2：使用jdbc完成数据库和代码的逻辑交互
3：使用jsp完成网页数据的显示
4：使用java代码完成api接口的编写以及以及数据的回调
四、数据库设计
/*Navicat MySQL Data TransferSource Server : mydbSource Server Version : 50528Source Host : localhost:3306Source Database : studydbTarget Server Type : MYSQLTarget Server Version : 50528File Encoding : 65001Date: 2020-02-27 19:00:53*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for classtb-- ----------------------------DROP TABLE IF EXISTS `classtb`;CREATE TABLE `classtb` (`classId` int(11) NOT NULL AUTO_INCREMENT,`className` varchar(255) DEFAULT NULL,`classTime` datetime DEFAULT NULL,PRIMARY KEY (`classId`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;-- ------------------------------ Records of classtb-- ----------------------------INSERT INTO `classtb` VALUES ('1', '计算机系一班', null);-- ------------------------------ Table structure for coursetb-- ----------------------------DROP TABLE IF EXISTS `coursetb`;CREATE TABLE `coursetb` (`courseId` int(11) NOT NULL AUTO_INCREMENT,`courseName` varchar(255) DEFAULT NULL,`courseAddress` varchar(255) DEFAULT NULL,`courseStart` varchar(255) DEFAULT NULL,`courseEnd` varchar(100) DEFAULT NULL,`courseUserId` varchar(100) DEFAULT NULL,`courseUserName` varchar(255) DEFAULT NULL,PRIMARY KEY (`courseId`)) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;-- ------------------------------ Records of coursetb-- ----------------------------INSERT INTO `coursetb` VALUES ('1', '计算机基础', '教学楼', '2020-01-22 16:46', '2020-02-27 14:52', '88', '王老师');INSERT INTO `coursetb` VALUES ('2', 'java基础', '一号教学楼', '2020-01-22 17:00', '2020-02-27 14:52', '88', '王老师');INSERT INTO `coursetb` VALUES ('3', 'android基础', '主教学楼201', '2020-01-30 18:42', '2020-02-27 14:52', '88', '王老师');INSERT INTO `coursetb` VALUES ('4', '历史课', '教学楼102', '2020-01-30 19:22', '2020-02-27 14:52', '88', '王老师');INSERT INTO `coursetb` VALUES ('5', '英语', '教学楼103', '2020-01-31 19:23', '2020-02-27 14:52', '88', '王老师');INSERT INTO `coursetb` VALUES ('6', 'android', '教学楼', '2020-02-27 14:21', '2020-02-27 15:21', '88', '王老师');INSERT INTO `coursetb` VALUES ('7', '计算机理论', '教学楼606', '2020-02-27 18:51', '2020-02-27 18:56', '88', '王老师');-- ------------------------------ Table structure for leavemsg-- ----------------------------DROP TABLE IF EXISTS `leavemsg`;CREATE TABLE `leavemsg` (`leaveId` int(50) NOT NULL AUTO_INCREMENT,`leaveUserId` varchar(100) DEFAULT NULL,`leaveUserName` varchar(255) DEFAULT NULL,`leaveTime` varchar(100) DEFAULT NULL,`leaveState` varchar(255) DEFAULT NULL,`leaveMessage` varchar(255) DEFAULT NULL,PRIMARY KEY (`leaveId`)) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;-- ------------------------------ Records of leavemsg-- ----------------------------INSERT INTO `leavemsg` VALUES ('1', '23', '小明', '2018-01-17 17:00', '1', '我生病了');INSERT INTO `leavemsg` VALUES ('2', '23', '小明', '2018-01-17 17:38', '3', '有事情要处理');INSERT INTO `leavemsg` VALUES ('3', '23', '小明', '2018-01-17 17:40', '2', '要回家');INSERT INTO `leavemsg` VALUES ('4', '26', '小花', '2018-01-17 18:57', '1', '休息');INSERT INTO `leavemsg` VALUES ('5', '27', '小宝宝', '2018-01-17 18:58', '1', '生病了');INSERT INTO `leavemsg` VALUES ('6', '23', '小明', '2018-04-28 17:10', '2', '我和');INSERT INTO `leavemsg` VALUES ('7', '23', '小明', '2018-05-11 14:23', '3', '注意');INSERT INTO `leavemsg` VALUES ('8', '23', '小明', '2018-05-10 14:27', '2', '哦哦哦');INSERT INTO `leavemsg` VALUES ('9', '90', 'Tomcat\'', '2020-02-27 15:22', '1', '身体不舒服');INSERT INTO `leavemsg` VALUES ('10', '90', 'Tomcat\'', '2020-02-27 15:30', '1', '生病了');INSERT INTO `leavemsg` VALUES ('11', '90', 'Tomcat\'', '2020-02-27 15:33', '1', '你好啊');INSERT INTO `leavemsg` VALUES ('12', '90', 'Tomcat\'', '2020-02-27 15:36', '1', '1111111111');INSERT INTO `leavemsg` VALUES ('13', '90', 'Tomcat\'', '2020-02-27 18:24', '1', '1111111111111111111');INSERT INTO `leavemsg` VALUES ('14', '90', 'Tomcat\'', '2020-02-27 18:33', '1', '1111111111');INSERT INTO `leavemsg` VALUES ('15', '90', 'Tomcat\'', '2020-02-27 18:33', '1', '1111111111');INSERT INTO `leavemsg` VALUES ('16', '94', '小明', '2020-02-27 18:57', '1', '你好啊');-- ------------------------------ Table structure for newstb-- ----------------------------DROP TABLE IF EXISTS `newstb`;CREATE TABLE `newstb` ( `newsId` int(11) NOT NULL AUTO_INCREMENT, `newsTitle` varchar(255) DEFAULT NULL, `newsMessage` varchar(255) DEFAULT NULL, `newsTeaId` int(11) DEFAULT NULL, `newsTeaName` varchar(255) DEFAULT NULL, `newsTime` varchar(100) DEFAULT NULL, PRIMARY KEY (`newsId`)) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;-- ------------------------------ Records of newstb-- ----------------------------INSERT INTO `newstb` VALUES ('7', '开班会', '通知所有家长在周一下午开班会，记得来参加;', '88', '王老师', '2020-02-27');INSERT INTO `newstb` VALUES ('8', '计算机基础编程', '使用java语言打印一个99乘法表出来;', '88', '王老师', '2020-02-27');INSERT INTO `newstb` VALUES ('9', '计算机', '使用java语言打印一个99乘法表出来;', '88', '王老师', '2020-02-27 ');INSERT INTO `newstb` VALUES ('10', '计算机作业', '使用java语言打印一个99乘法表出来;', '88', '王老师', '2020-02-27 ');INSERT INTO `newstb` VALUES ('11', '计算机基础编程', '使用java语言打印一个99乘法表出来;', '88', '王老师', '2020-02-27');-- ------------------------------ Table structure for replytb-- ----------------------------DROP TABLE IF EXISTS `replytb`;CREATE TABLE `replytb` ( `replyId` int(50) NOT NULL AUTO_INCREMENT, `replyAnswerId` int(11) DEFAULT NULL, `replyMessage` varchar(255) DEFAULT NULL, `replyUserId` int(11) DEFAULT NULL, `replyUserName` varchar(255) DEFAULT NULL, `replyCreatime` varchar(100) DEFAULT NULL, `replyTeaMessage` varchar(255) DEFAULT NULL, PRIMARY KEY (`replyId`)) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;-- ------------------------------ Records of replytb-- ----------------------------INSERT INTO `replytb` VALUES ('8', '7', '今天的作业信息应该这样子作答处理', '90', 'Tom', '2019-12-17 17:36', '111111111111');INSERT INTO `replytb` VALUES ('9', '7', '我来看看怎么回答', '91', 'jack', '2019-12-17 17:37', '-1');INSERT INTO `replytb` VALUES ('13', '8', '今天的作业信息应该这样子作答处理', '90', 'Tom', '2019-12-18 10:11', '565565656');INSERT INTO `replytb` VALUES ('14', '10', '这个是多多的回答信息', '92', 'duoduo', '2019-12-18 11:27', '111111111111111111111');-- ------------------------------ Table structure for scoretb-- ----------------------------DROP TABLE IF EXISTS `scoretb`;CREATE TABLE `scoretb` ( `scoreId` int(50) NOT NULL AUTO_INCREMENT, `scoreStuId` varchar(255) DEFAULT NULL, `scoreStuName` varchar(255) DEFAULT NULL, `scoreType` varchar(255) DEFAULT NULL, `scoreMessage` varchar(255) DEFAULT NULL, `scoreUserId` varchar(11) DEFAULT NULL, `scoreUserName` varchar(255) DEFAULT NULL, `scoreCreatime` varchar(100) DEFAULT NULL, PRIMARY KEY (`scoreId`)) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;-- ------------------------------ Records of scoretb-- ----------------------------INSERT INTO `scoretb` VALUES ('4', '90', 'Tom', 'java基础', '89', '88', '王老师', '2019-12-18 10:45');INSERT INTO `scoretb` VALUES ('5', '91', 'jack', 'ceshi', '88', '88', '王老师', '2019-12-18 11:02');INSERT INTO `scoretb` VALUES ('6', '92', 'duoduo', '测试考试信息', '89', '88', '王老师', '2019-12-18 11:26');-- ------------------------------ Table structure for signtb-- ----------------------------DROP TABLE IF EXISTS `signtb`;CREATE TABLE `signtb` ( `signId` int(11) NOT NULL AUTO_INCREMENT, `signCourseId` int(11) DEFAULT NULL, `signCourseName` varchar(255) DEFAULT NULL, `signStuId` int(11) DEFAULT NULL, `signStuName` varchar(255) DEFAULT NULL, `signTime` varchar(100) DEFAULT NULL, `signFlag` varchar(255) DEFAULT NULL, PRIMARY KEY (`signId`)) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;-- ------------------------------ Records of signtb-- ----------------------------INSERT INTO `signtb` VALUES ('1', '3', 'android基础', '88', '王老师', '2020-01-30 18:53', '2');INSERT INTO `signtb` VALUES ('2', '2', 'java基础', '88', '王老师', '2020-01-30 18:54', '3');INSERT INTO `signtb` VALUES ('3', '1', '计算机基础', '88', '王老师', '2020-01-30 18:54', '3');INSERT INTO `signtb` VALUES ('4', '3', 'android基础', '88', '王老师', '2020-01-30 18:55', '2');INSERT INTO `signtb` VALUES ('5', '3', 'android基础', '88', '王老师', '2020-01-30 18:55', '2');INSERT INTO `signtb` VALUES ('6', '3', 'android基础', '93', '小明', '2020-01-30 19:08', '2');INSERT INTO `signtb` VALUES ('7', '4', '历史课', '95', '小花', '2020-01-30 19:24', '2');INSERT INTO `signtb` VALUES ('8', '2', 'java基础', '95', '小花', '2020-01-30 19:24', '3');INSERT INTO `signtb` VALUES ('9', '6', 'android', '90', 'Tomcat\'', '2020-02-27 14:58', '2');INSERT INTO `signtb` VALUES ('10', '7', '计算机理论', '94', '小明', '2020-02-27 18:52', '2');INSERT INTO `signtb` VALUES ('11', '7', '计算机理论', '90', 'Tomcat\'', '2020-02-27 18:57', '3');-- ------------------------------ Table structure for token-- ----------------------------DROP TABLE IF EXISTS `token`;CREATE TABLE `token` ( `tid` int(100) NOT NULL AUTO_INCREMENT, `uid` varchar(100) CHARACTER SET utf8 NOT NULL, `utoken` varchar(500) CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`tid`)) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=latin1;-- ------------------------------ Records of token-- ----------------------------INSERT INTO `token` VALUES ('114', '88', 'CWYQpnKHA8IrG07bRBnYPjD73K3+3uRZGpOSjlb+djzTjCzhhIKUP2LX4XmUxsOzmBAEIFM2hwBBoI2bW00tFg==');INSERT INTO `token` VALUES ('115', '89', 'fQu2I17XIcBC/5UnSh9tmyvwBvuqr97RjQi5uLqItZQHbQeOQtvD7krqehqA4HcJdHBtHXsK1Nb4qW5FoOzRkw==');INSERT INTO `token` VALUES ('116', '90', 'SIaSaIKjHtlzWN8OHYArfCvwBvuqr97RjQi5uLqItZQHbQeOQtvD7lDnwz/G8Ma9R27fbsk8oS34qW5FoOzRkw==');INSERT INTO `token` VALUES ('117', '91', 'glROHWaqqwd0+Q+ZWmo2CCvwBvuqr97RjQi5uLqItZQHbQeOQtvD7gOVgk0Xa0UoOj43tCmRiKj4qW5FoOzRkw==');INSERT INTO `token` VALUES ('118', '92', '4LstZGuk9RUW4kjNTo/n5DD73K3+3uRZGpOSjlb+djzTjCzhhIKUP41AxGCz8s6uYsPfM6nhL1hBoI2bW00tFg==');INSERT INTO `token` VALUES ('119', '93', '+TySa07bkvmvMa5DFfnEvjD73K3+3uRZGpOSjlb+djyWr4Z+DF1Rwk0rthMIxYbxa7tQQFUJdRZBoI2bW00tFg==');INSERT INTO `token` VALUES ('120', '94', 'JeBvofU+UVG5Epuyu2FNCivwBvuqr97RjQi5uLqItZRX3RQx9HRsmAV1dV6+oNu8FO1ZdViOZ2f4qW5FoOzRkw==');-- ------------------------------ Table structure for topicvideotb-- ----------------------------DROP TABLE IF EXISTS `topicvideotb`;CREATE TABLE `topicvideotb` ( `topicvideoId` int(11) NOT NULL AUTO_INCREMENT, `topicvideoUserId` int(11) DEFAULT NULL, `topicvideoUserName` varchar(255) DEFAULT NULL, `topicvideoName` varchar(255) DEFAULT NULL, `topicvideoFile` varchar(255) DEFAULT NULL, `topicvideoTime` varchar(100) DEFAULT NULL, `topicvideoState` varchar(255) DEFAULT NULL, PRIMARY KEY (`topicvideoId`)) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;-- ------------------------------ Records of topicvideotb-- ----------------------------INSERT INTO `topicvideotb` VALUES ('10', '88', '王老师', '打探呀', 'city_xian_dayanta.mp4', '2019-12-16 16:27', '1');INSERT INTO `topicvideotb` VALUES ('11', '88', '王老师', '学习资料', 'city_xian_dayanta.mp4', '2019-12-18 11:25', '1');-- ------------------------------ Table structure for user-- ----------------------------DROP TABLE IF EXISTS `user`;CREATE TABLE `user` ( `uid` int(255) NOT NULL AUTO_INCREMENT, `uname` varchar(200) CHARACTER SET utf8 NOT NULL, `uno` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `uphone` varchar(100) CHARACTER SET utf8 NOT NULL, `uclass` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `upswd` varchar(200) CHARACTER SET utf8 NOT NULL, `utime` varchar(300) CHARACTER SET utf8 NOT NULL, `utype` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `uImg` varchar(1000) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`uid`)) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=latin1;-- ------------------------------ Records of user-- ----------------------------INSERT INTO `user` VALUES ('88', '王老师', '-1', '15249241001', '-1', '123456', '2020-02-27 14:52', '2', 'http://b-ssl.duitang.com/uploads/item/201701/14/20170114192031_SuVT2.thumb.700_0.jpeg');INSERT INTO `user` VALUES ('90', 'Tomcat\'', '1001', '15249242001', '计算机系一班', '123456', '2020-02-27 14:52', '1', 'https://ss1.bdstatic.com/70cFvXSh_Q1YnxGkpoWK1HF6hhy/it/u=3946329536,1567291919&fm=26&gp=0.jpg');INSERT INTO `user` VALUES ('91', 'jack', '1002', '15249242002', '计算机系一班', '123456', '2020-02-27 14:52', '1', 'https://ss1.bdstatic.com/70cFvXSh_Q1YnxGkpoWK1HF6hhy/it/u=3946329536,1567291919&fm=26&gp=0.jpg');INSERT INTO `user` VALUES ('92', 'duoduo1028', '1006', '15249242006', '计算机系一班', '123456', '2020-02-27 14:52', '1', 'https://ss1.bdstatic.com/70cFvXSh_Q1YnxGkpoWK1HF6hhy/it/u=3946329536,1567291919&fm=26&gp=0.jpg');INSERT INTO `user` VALUES ('93', '小裤裤', '1006', '15249246002', '计算机系一班', '123456', '2020-02-27 14:52', '1', 'https://ss1.bdstatic.com/70cFvXSh_Q1YnxGkpoWK1HF6hhy/it/u=3946329536,1567291919&fm=26&gp=0.jpg');INSERT INTO `user` VALUES ('94', '小明', '6003', '15249246003', '计算机系一般', '123456', '2020-02-27 18:52', '1', 'https://ss1.bdstatic.com/70cFvXSh_Q1YnxGkpoWK1HF6hhy/it/u=3946329536,1567291919&fm=26&gp=0.jpg');
221
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
