安卓APP项目-基于Android的签到系统--论文-适合计算机毕设、实训项目、大作业学习.rar

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: ssm895w7 -- ------------------------------------------------------ -- Server version 5.7.31 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `ssm895w7` -- /*!40000 DROP DATABASE IF EXISTS `ssm895w7`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssm895w7` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `ssm895w7`; -- -- Table structure for table `banjixinxi` -- DROP TABLE IF EXISTS `banjixinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `banjixinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `banji` varchar(200) DEFAULT NULL COMMENT '班级', `banjirenshu` int(11) DEFAULT NULL COMMENT '班级人数', `banzhuren` varchar(200) DEFAULT NULL COMMENT '班主任', `fengmian` varchar(200) DEFAULT NULL COMMENT '封面', `weizhi` varchar(200) DEFAULT NULL COMMENT '位置', `xiangqing` longtext COMMENT '详情', PRIMARY KEY (`id`), UNIQUE KEY `banji` (`banji`) ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='班级信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `banjixinxi` -- LOCK TABLES `banjixinxi` WRITE; /*!40000 ALTER TABLE `banjixinxi` DISABLE KEYS */; INSERT INTO `banjixinxi` VALUES (61,'2022-03-12 10:50:00','3班',10,'班主任1','upload/banjixinxi_fengmian1.jpg','位置1','<p>详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 详情1时代否 </p>'),(62,'2022-03-12 10:50:00','班级2',2,'班主任2','upload/banjixinxi_fengmian2.jpg','位置2','详情2'),(63,'2022-03-12 10:50:00','班级3',3,'班主任3','upload/banjixinxi_fengmian3.jpg','位置3','详情3'),(64,'2022-03-12 10:50:00','班级4',4,'班主任4','upload/banjixinxi_fengmian4.jpg','位置4','详情4'),(65,'2022-03-12 10:50:00','班级5',5,'班主任5','upload/banjixinxi_fengmian5.jpg','位置5','详情5'),(66,'2022-03-12 10:50:00','班级6',6,'班主任6','upload/banjixinxi_fengmian6.jpg','位置6','详情6'); /*!40000 ALTER TABLE `banjixinxi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `config` -- DROP TABLE IF EXISTS `config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) NOT NULL COMMENT '配置参数名称', `value` varchar(100) DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `config` -- LOCK TABLES `config` WRITE; /*!40000 ALTER TABLE `config` DISABLE KEYS */; INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg'); /*!40000 ALTER TABLE `config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jiaoshi` -- DROP TABLE IF EXISTS `jiaoshi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jiaoshi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `jiaoshizhanghao` varchar(200) NOT NULL COMMENT '教师账号', `mima` varchar(200) NOT NULL COMMENT '密码', `jiaoshixingming` varchar(200) NOT NULL COMMENT '教师姓名', `nianling` int(11) NOT NULL COMMENT '年龄', `gongling` varchar(200) NOT NULL COMMENT '工龄', `xingbie` varchar(200) DEFAULT NULL COMMENT '性别', `shouji` varchar(200) NOT NULL COMMENT '手机', `zhaopian` varchar(200) DEFAULT NULL COMMENT '照片', PRIMARY KEY (`id`), UNIQUE KEY `jiaoshizhanghao` (`jiaoshizhanghao`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='教师'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jiaoshi` -- LOCK TABLES `jiaoshi` WRITE; /*!40000 ALTER TABLE `jiaoshi` DISABLE KEYS */; INSERT INTO `jiaoshi` VALUES (31,'2022-03-12 10:50:00','教师账号1','123456','教师姓名1',1,'工龄1','男','13823888881','upload/jiaoshi_zhaopian1.jpg'),(32,'2022-03-12 10:50:00','教师账号2','123456','教师姓名2',2,'工龄2','男','13823888882','upload/jiaoshi_zhaopian2.jpg'),(33,'2022-03-12 10:50:00','教师账号3','123456','教师姓名3',3,'工龄3','男','13823888883','upload/jiaoshi_zhaopian3.jpg'),(34,'2022-03-12 10:50:00','教师账号4','123456','教师姓名4',4,'工龄4','男','13823888884','upload/jiaoshi_zhaopian4.jpg'),(35,'2022-03-12 10:50:00','教师账号5','123456','教师姓名5',5,'工龄5','男','13823888885','upload/jiaoshi_zhaopian5.jpg'),(36,'2022-03-12 10:50:00','教师账号6','123456','教师姓名6',6,'工龄6','男','13823888886','upload/jiaoshi_zhaopian6.jpg'); /*!40000 ALTER TABLE `jiaoshi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jinggaoxinxi` -- DROP TABLE IF EXISTS `jinggaoxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jinggaoxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `kechengmingcheng` varchar(200) NOT NULL COMMENT '课程名称', `fengmian` varchar(200) DEFAULT NULL COMMENT '封面', `jinggaoneirong` longtext NOT NULL COMMENT '警告内容', `jinggaoshijian` datetime DEFAULT NULL COMMENT '警告时间', `xuehao` varchar(200) DEFAULT NULL COMMENT '学号', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `jiaoshizhanghao` varchar(200) DEFAULT NULL COMMENT '教师账号', `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名', `userid` bigint(20) DEFAULT NULL COMMENT '用户id', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='警告信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jinggaoxinxi` -- LOCK TABLES `jinggaoxinxi` WRITE; /*!40000 ALTER TABLE `jinggaoxinxi` DISABLE KEYS */; INSERT INTO `jinggaoxinxi` VALUES (101,'2022-03-12 10:50:00','课程名称1','upload/jinggaoxinxi_fengmian1.jpg','<p>你改签到了</p><p>你改签到了</p><p>你改签到了</p><p>你改签到了</p><p>你改签到了</p><p>你改签到了</p><p>你改签到了</p><p>你改签到了</p><p>你改签到了</p><p>你改签到了</p><p>你改签到了</p><p>你改签到了</p><p>你改签到了</p><p>你改签到了</p><p><br></p>','2022-03-12 18:50:00','11','时代','教师账号1','教师姓名1',1),(102,'2022-03-12 10:50:00','课程名称2','upload/jinggaoxinxi_fengmian2.jpg','警告内容2','2022-03-12 18:50:00','学号2','姓名2','教师账号2','教师姓名2',2),(103,