基于ssm的班級事務(wù)管理系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
開發(fā)語言：Java
框架：ssm
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫腳本：
-- MySQL dump 10.13? Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost? ? Database: ssmn2tzw
-- ------------------------------------------------------
-- 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: `ssmn2tzw`
--
/*!40000 DROP DATABASE IF EXISTS `ssmn2tzw`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssmn2tzw` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `ssmn2tzw`;
--
-- Table structure for table `banfeitongzhi`
--
DROP TABLE IF EXISTS `banfeitongzhi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banfeitongzhi` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `xuehao` varchar(200) DEFAULT NULL COMMENT '學(xué)號',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `banji` varchar(200) DEFAULT NULL COMMENT '班級',
? `banfei` float DEFAULT NULL COMMENT '班費(fèi)',
? `shoujiaoyuanyin` longtext COMMENT '收繳原因',
? `banweizhanghao` varchar(200) DEFAULT NULL COMMENT '班委賬號',
? `banweixingming` varchar(200) DEFAULT NULL COMMENT '班委姓名',
? `tongzhiriqi` date DEFAULT NULL COMMENT '通知日期',
? `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646834134872 DEFAULT CHARSET=utf8 COMMENT='班費(fèi)通知';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `banfeitongzhi`
--
LOCK TABLES `banfeitongzhi` WRITE;
/*!40000 ALTER TABLE `banfeitongzhi` DISABLE KEYS */;
INSERT INTO `banfeitongzhi` VALUES (91,'2022-03-09 13:40:42','學(xué)號1','姓名1','班級1',1,'收繳原因1','班委賬號1','班委姓名1','2022-03-09','未支付'),(92,'2022-03-09 13:40:42','學(xué)號2','姓名2','班級2',2,'收繳原因2','班委賬號2','班委姓名2','2022-03-09','未支付'),(93,'2022-03-09 13:40:42','學(xué)號3','姓名3','班級3',3,'收繳原因3','班委賬號3','班委姓名3','2022-03-09','未支付'),(94,'2022-03-09 13:40:42','學(xué)號4','姓名4','班級4',4,'收繳原因4','班委賬號4','班委姓名4','2022-03-09','未支付'),(95,'2022-03-09 13:40:42','學(xué)號5','姓名5','班級5',5,'收繳原因5','班委賬號5','班委姓名5','2022-03-09','未支付'),(96,'2022-03-09 13:40:42','學(xué)號6','姓名6','班級6',6,'收繳原因6','班委賬號6','班委姓名6','2022-03-09','未支付'),(1646834134871,'2022-03-09 13:55:34','11','時(shí)代','2班',33,'地方第三方時(shí)代發(fā)送到發(fā)多少','22','地方','2022-03-09','已支付');
/*!40000 ALTER TABLE `banfeitongzhi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `banhuizuzhi`
--
DROP TABLE IF EXISTS `banhuizuzhi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banhuizuzhi` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `zuzhibianhao` varchar(200) DEFAULT NULL COMMENT '組織編號',
? `zuzhimingcheng` varchar(200) DEFAULT NULL COMMENT '組織名稱',
? `fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
? `chuangjianriqi` date DEFAULT NULL COMMENT '創(chuàng)建日期',
? `chuangjianren` varchar(200) DEFAULT NULL COMMENT '創(chuàng)建人',
? `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '聯(lián)系電話',
? `youxiang` varchar(200) DEFAULT NULL COMMENT '郵箱',
? `zuzhijieshao` longtext COMMENT '組織介紹',
? `thumbsupnum` int(11) DEFAULT '0' COMMENT '贊',
? `crazilynum` int(11) DEFAULT '0' COMMENT '踩',
? `clicktime` datetime DEFAULT NULL COMMENT '最近點(diǎn)擊時(shí)間',
? `clicknum` int(11) DEFAULT '0' COMMENT '點(diǎn)擊次數(shù)',
? PRIMARY KEY (`id`),
? UNIQUE KEY `zuzhibianhao` (`zuzhibianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1646834210841 DEFAULT CHARSET=utf8 COMMENT='班會(huì)組織';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `banhuizuzhi`
--
LOCK TABLES `banhuizuzhi` WRITE;
/*!40000 ALTER TABLE `banhuizuzhi` DISABLE KEYS */;
INSERT INTO `banhuizuzhi` VALUES (31,'2022-03-09 13:40:42','1111111111','組織名稱1','upload/banhuizuzhi_fengmian1.jpg','2022-03-03','創(chuàng)建人1','聯(lián)系電話1','郵箱1','<p>組織介紹1</p>',1,1,'2022-03-09 21:58:42',3),(32,'2022-03-09 13:40:42','2222222222','組織名稱2','upload/banhuizuzhi_fengmian2.jpg','2022-03-09','創(chuàng)建人2','聯(lián)系電話2','郵箱2','組織介紹2',2,2,'2022-03-09 21:40:42',2),(33,'2022-03-09 13:40:42','3333333333','組織名稱3','upload/banhuizuzhi_fengmian3.jpg','2022-03-09','創(chuàng)建人3','聯(lián)系電話3','郵箱3','組織介紹3',3,3,'2022-03-09 21:40:42',3),(34,'2022-03-09 13:40:42','4444444444','組織名稱4','upload/banhuizuzhi_fengmian4.jpg','2022-03-09','創(chuàng)建人4','聯(lián)系電話4','郵箱4','組織介紹4',4,4,'2022-03-09 21:58:44',5),(35,'2022-03-09 13:40:42','5555555555','組織名稱5','upload/banhuizuzhi_fengmian5.jpg','2022-03-09','創(chuàng)建人5','聯(lián)系電話5','郵箱5','組織介紹5',5,5,'2022-03-09 21:40:42',5),(36,'2022-03-09 13:40:42','6666666666','組織名稱6','upload/banhuizuzhi_fengmian6.jpg','2022-03-09','創(chuàng)建人6','聯(lián)系電話6','郵箱6','組織介紹6',6,6,'2022-03-09 21:40:42',6),(1646834210840,'2022-03-09 13:56:50','1646834195177','水電費(fèi)時(shí)代','upload/1646834197819.jpg','2022-03-09','地方給對方','1112223333','33@qq.com','<p>水電費(fèi)時(shí)代發(fā)送到發(fā)送到發(fā)送到發(fā)送到發(fā)送到發(fā)送到水電費(fèi)時(shí)代發(fā)送到發(fā)送到發(fā)送到發(fā)送到發(fā)送到發(fā)送到水電費(fèi)時(shí)代發(fā)送到發(fā)送到發(fā)送到發(fā)送到發(fā)送到發(fā)送到</p>',1,0,'2022-03-09 22:00:16',6);
/*!40000 ALTER TABLE `banhuizuzhi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `banwei`
--
DROP TABLE IF EXISTS `banwei`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banwei` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `banweizhanghao` varchar(200) NOT NULL COMMENT '班委賬號',
? `mima` varchar(200) NOT NULL COMMENT '密碼',
? `banweixingming` varchar(200) NOT NULL COMMENT '班委姓名',
? `nianling` int(11) DEFAULT NULL COMMENT '年齡',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `shouji` varchar(200) DEFAULT NULL COMMENT '手機(jī)',
? `banji` varchar(200) NOT NULL COMMENT '班級',
? `zhaopian` varchar(200) DEFAULT NULL COMMENT '照片',
? PRIMARY KEY (`id`),
? UNIQUE KEY `banweizhanghao` (`banweizhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1646833997855 DEFAULT CHARSET=utf8 COMMENT='班委';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `banwei`
--
LOCK TABLES `banwei` WRITE;
/*!40000 ALTER TABLE `banwei` DISABLE KEYS */;
INSERT INTO `banwei` VALUES (21,'2022-03-09 13:40:42','班委賬號1','123456','班委姓名1',1,'男','13823888881','班級1','upload/banwei_zhaopian1.jpg'),(22,'2022-03-09 13:40:42','班委賬號2','123456','班委姓名2',2,'男','13823888882','班級2','upload/banwei_zhaopian2.jpg'),(23,'2022-03-09 13:40:42','班委賬號3','123456','班委姓名3',3,'男','13823888883','班級3','upload/banwei_zhaopian3.jpg'),(24,'2022-03-09 13:40:42','班委賬號4','123456','班委姓名4',4,'男','13823888884','班級4','upload/banwei_zhaopian4.jpg'),(25,'2022-03-09 13:40:42','班委賬號5','123456','班委姓名5',5,'男','13823888885','班級5','upload/banwei_zhaopian5.jpg'),(26,'2022-03-09 13:40:42','班委賬號6','123456','班委姓名6',6,'男','13823888886','班級6','upload/banwei_zhaopian6.jpg'),(1646833997854,'2022-03-09 13:53:17','22','22','地方',22,'女','11122233334','2班','upload/1646834045852.jpg');
/*!40000 ALTER TABLE `banwei` 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 '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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/1646834300699.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dangyuanfazhan`
--
DROP TABLE IF EXISTS `dangyuanfazhan`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dangyuanfazhan` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `biaoti` varchar(200) NOT NULL COMMENT '標(biāo)題',
? `jianjie` longtext COMMENT '簡介',
? `fabushijian` date DEFAULT NULL COMMENT '發(fā)布時(shí)間',
? `fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
? `neirong` longtext COMMENT '內(nèi)容',
? `thumbsupnum` int(11) DEFAULT '0' COMMENT '贊',
? `crazilynum` int(11) DEFAULT '0' COMMENT '踩',
? `clicktime` datetime DEFAULT NULL COMMENT '最近點(diǎn)擊時(shí)間',
? `clicknum` int(11) DEFAULT '0' COMMENT '點(diǎn)擊次數(shù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646834233551 DEFAULT CHARSET=utf8 COMMENT='黨員發(fā)展';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dangyuanfazhan`
--
LOCK TABLES `dangyuanfazhan` WRITE;
/*!40000 ALTER TABLE `dangyuanfazhan` DISABLE KEYS */;
INSERT INTO `dangyuanfazhan` VALUES (51,'2022-03-09 13:40:42','標(biāo)題1','簡介1','2022-03-09','upload/dangyuanfazhan_fengmian1.jpg','內(nèi)容1',1,1,'2022-03-09 21:40:42',1),(52,'2022-03-09 13:40:42','標(biāo)題2','簡介2','2022-03-09','upload/dangyuanfazhan_fengmian2.jpg','內(nèi)容2',2,2,'2022-03-09 21:59:06',4),(53,'2022-03-09 13:40:42','標(biāo)題3','簡介3','2022-03-09','upload/dangyuanfazhan_fengmian3.jpg','內(nèi)容3',3,3,'2022-03-09 21:40:42',3),(54,'2022-03-09 13:40:42','標(biāo)題4','簡介4','2022-03-09','upload/dangyuanfazhan_fengmian4.jpg','內(nèi)容4',4,4,'2022-03-09 21:40:42',4),(55,'2022-03-09 13:40:42','標(biāo)題5','簡介5','2022-03-09','upload/dangyuanfazhan_fengmian5.jpg','內(nèi)容5',5,5,'2022-03-09 21:40:42',5),(56,'2022-03-09 13:40:42','標(biāo)題6','簡介6','2022-03-09','upload/dangyuanfazhan_fengmian6.jpg','內(nèi)容6',6,6,'2022-03-09 21:40:42',6),(1646834233550,'2022-03-09 13:57:13','水電費(fèi)時(shí)代','地方的鬼地方個(gè)的郭德綱地方給對方固定剛發(fā)的地方的鬼地方個(gè)的郭德綱地方給對方固定剛發(fā)的','2022-03-09','upload/1646834226362.jpeg','<p>地方的鬼地方個(gè)的郭德綱地方給對方固定剛發(fā)的地方的鬼地方個(gè)的郭德綱地方給對方固定剛發(fā)的地方的鬼地方個(gè)的郭德綱地方給對方固定剛發(fā)的地方的鬼地方個(gè)的郭德綱地方給對方固定剛發(fā)的地方的鬼地方個(gè)的郭德綱地方給對方固定剛發(fā)的地方的鬼地方個(gè)的郭德綱地方給對方固定剛發(fā)的地方的鬼地方個(gè)的郭德綱地方給對方固定剛發(fā)的</p>',0,0,'2022-03-09 21:59:12',2);
/*!40000 ALTER TABLE `dangyuanfazhan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dangyuanpeixun`
--
DROP TABLE IF EXISTS `dangyuanpeixun`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dangyuanpeixun` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `peixunbiaoti` varchar(200) NOT NULL COMMENT '培訓(xùn)標(biāo)題',
? `tupian` varchar(200) DEFAULT NULL COMMENT '圖片',
? `peixunshijian` datetime DEFAULT NULL COMMENT '培訓(xùn)時(shí)間',
? `jieshushijian` datetime DEFAULT NULL COMMENT '結(jié)束時(shí)間',
? `peixuntianshu` int(11) DEFAULT NULL COMMENT '培訓(xùn)天數(shù)',
? `fabushijian` date DEFAULT NULL COMMENT '發(fā)布時(shí)間',
? `peixunneirong` longtext COMMENT '培訓(xùn)內(nèi)容',
? `thumbsupnum` int(11) DEFAULT '0' COMMENT '贊',
? `crazilynum` int(11) DEFAULT '0' COMMENT '踩',
? `clicktime` datetime DEFAULT NULL COMMENT '最近點(diǎn)擊時(shí)間',
? `clicknum` int(11) DEFAULT '0' COMMENT '點(diǎn)擊次數(shù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='黨員培訓(xùn)';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dangyuanpeixun`
--
LOCK TABLES `dangyuanpeixun` WRITE;
/*!40000 ALTER TABLE `dangyuanpeixun` DISABLE KEYS */;
INSERT INTO `dangyuanpeixun` VALUES (61,'2022-03-09 13:40:42','培訓(xùn)標(biāo)題1','upload/dangyuanpeixun_tupian1.jpg','2022-03-09 21:40:42','2022-03-09 22:40:42',1,'2022-03-08','<p>培訓(xùn)內(nèi)容1水電費(fèi)時(shí)代發(fā)送到發(fā)多少發(fā)多少培訓(xùn)內(nèi)容1水電費(fèi)時(shí)代發(fā)送到發(fā)多少發(fā)多少培訓(xùn)內(nèi)容1水電費(fèi)時(shí)代發(fā)送到發(fā)多少發(fā)多少</p>',1,1,'2022-03-09 21:59:16',4),(62,'2022-03-09 13:40:42','培訓(xùn)標(biāo)題2','upload/dangyuanpeixun_tupian2.jpg','2022-03-09 21:40:42','2022-03-09 21:40:42',2,'2022-03-09','培訓(xùn)內(nèi)容2',2,2,'2022-03-09 21:40:42',2),(63,'2022-03-09 13:40:42','培訓(xùn)標(biāo)題3','upload/dangyuanpeixun_tupian3.jpg','2022-03-09 21:40:42','2022-03-09 21:40:42',3,'2022-03-09','培訓(xùn)內(nèi)容3',3,3,'2022-03-09 21:40:42',3),(64,'2022-03-09 13:40:42','培訓(xùn)標(biāo)題4','upload/dangyuanpeixun_tupian4.jpg','2022-03-09 21:40:42','2022-03-09 21:40:42',4,'2022-03-09','培訓(xùn)內(nèi)容4',4,4,'2022-03-09 21:40:42',4),(65,'2022-03-09 13:40:42','培訓(xùn)標(biāo)題5','upload/dangyuanpeixun_tupian5.jpg','2022-03-09 21:40:42','2022-03-09 21:40:42',5,'2022-03-09','培訓(xùn)內(nèi)容5',5,5,'2022-03-09 21:40:42',5),(66,'2022-03-09 13:40:42','培訓(xùn)標(biāo)題6','upload/dangyuanpeixun_tupian6.jpg','2022-03-09 21:40:42','2022-03-09 21:40:42',6,'2022-03-09','培訓(xùn)內(nèi)容6',6,6,'2022-03-09 21:40:42',6);
/*!40000 ALTER TABLE `dangyuanpeixun` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussbanhuizuzhi`
--
DROP TABLE IF EXISTS `discussbanhuizuzhi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussbanhuizuzhi` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646834339716 DEFAULT CHARSET=utf8 COMMENT='班會(huì)組織評論表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussbanhuizuzhi`
--
LOCK TABLES `discussbanhuizuzhi` WRITE;
/*!40000 ALTER TABLE `discussbanhuizuzhi` DISABLE KEYS */;
INSERT INTO `discussbanhuizuzhi` VALUES (131,'2022-03-09 13:40:42',1,1,'用戶名1','評論內(nèi)容1','回復(fù)內(nèi)容1'),(132,'2022-03-09 13:40:42',2,2,'用戶名2','評論內(nèi)容2','回復(fù)內(nèi)容2'),(133,'2022-03-09 13:40:42',3,3,'用戶名3','評論內(nèi)容3','回復(fù)內(nèi)容3'),(134,'2022-03-09 13:40:42',4,4,'用戶名4','評論內(nèi)容4','回復(fù)內(nèi)容4'),(135,'2022-03-09 13:40:42',5,5,'用戶名5','評論內(nèi)容5','回復(fù)內(nèi)容5'),(136,'2022-03-09 13:40:42',6,6,'用戶名6','評論內(nèi)容6','回復(fù)內(nèi)容6'),(1646834339715,'2022-03-09 13:58:58',1646834210840,1646833986396,'11','時(shí)代發(fā)送到','水電費(fèi)時(shí)代');
/*!40000 ALTER TABLE `discussbanhuizuzhi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussdangyuanfazhan`
--
DROP TABLE IF EXISTS `discussdangyuanfazhan`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussdangyuanfazhan` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8 COMMENT='黨員發(fā)展評論表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussdangyuanfazhan`
--
LOCK TABLES `discussdangyuanfazhan` WRITE;
/*!40000 ALTER TABLE `discussdangyuanfazhan` DISABLE KEYS */;
INSERT INTO `discussdangyuanfazhan` VALUES (141,'2022-03-09 13:40:42',1,1,'用戶名1','評論內(nèi)容1','回復(fù)內(nèi)容1'),(142,'2022-03-09 13:40:42',2,2,'用戶名2','評論內(nèi)容2','回復(fù)內(nèi)容2'),(143,'2022-03-09 13:40:42',3,3,'用戶名3','評論內(nèi)容3','回復(fù)內(nèi)容3'),(144,'2022-03-09 13:40:42',4,4,'用戶名4','評論內(nèi)容4','回復(fù)內(nèi)容4'),(145,'2022-03-09 13:40:42',5,5,'用戶名5','評論內(nèi)容5','回復(fù)內(nèi)容5'),(146,'2022-03-09 13:40:42',6,6,'用戶名6','評論內(nèi)容6','回復(fù)內(nèi)容6');
/*!40000 ALTER TABLE `discussdangyuanfazhan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussdangyuanpeixun`
--
DROP TABLE IF EXISTS `discussdangyuanpeixun`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussdangyuanpeixun` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8 COMMENT='黨員培訓(xùn)評論表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussdangyuanpeixun`
--
LOCK TABLES `discussdangyuanpeixun` WRITE;
/*!40000 ALTER TABLE `discussdangyuanpeixun` DISABLE KEYS */;
INSERT INTO `discussdangyuanpeixun` VALUES (151,'2022-03-09 13:40:42',1,1,'用戶名1','評論內(nèi)容1','回復(fù)內(nèi)容1'),(152,'2022-03-09 13:40:42',2,2,'用戶名2','評論內(nèi)容2','回復(fù)內(nèi)容2'),(153,'2022-03-09 13:40:42',3,3,'用戶名3','評論內(nèi)容3','回復(fù)內(nèi)容3'),(154,'2022-03-09 13:40:42',4,4,'用戶名4','評論內(nèi)容4','回復(fù)內(nèi)容4'),(155,'2022-03-09 13:40:42',5,5,'用戶名5','評論內(nèi)容5','回復(fù)內(nèi)容5'),(156,'2022-03-09 13:40:42',6,6,'用戶名6','評論內(nèi)容6','回復(fù)內(nèi)容6');
/*!40000 ALTER TABLE `discussdangyuanpeixun` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discusshuodongxinxi`
--
DROP TABLE IF EXISTS `discusshuodongxinxi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusshuodongxinxi` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8 COMMENT='活動(dòng)信息評論表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discusshuodongxinxi`
--
LOCK TABLES `discusshuodongxinxi` WRITE;
/*!40000 ALTER TABLE `discusshuodongxinxi` DISABLE KEYS */;
INSERT INTO `discusshuodongxinxi` VALUES (161,'2022-03-09 13:40:42',1,1,'用戶名1','評論內(nèi)容1','回復(fù)內(nèi)容1'),(162,'2022-03-09 13:40:42',2,2,'用戶名2','評論內(nèi)容2','回復(fù)內(nèi)容2'),(163,'2022-03-09 13:40:42',3,3,'用戶名3','評論內(nèi)容3','回復(fù)內(nèi)容3'),(164,'2022-03-09 13:40:42',4,4,'用戶名4','評論內(nèi)容4','回復(fù)內(nèi)容4'),(165,'2022-03-09 13:40:42',5,5,'用戶名5','評論內(nèi)容5','回復(fù)內(nèi)容5'),(166,'2022-03-09 13:40:42',6,6,'用戶名6','評論內(nèi)容6','回復(fù)內(nèi)容6');
/*!40000 ALTER TABLE `discusshuodongxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discusswenhuaxuexi`
--
DROP TABLE IF EXISTS `discusswenhuaxuexi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusswenhuaxuexi` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8 COMMENT='文化學(xué)習(xí)評論表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discusswenhuaxuexi`
--
LOCK TABLES `discusswenhuaxuexi` WRITE;
/*!40000 ALTER TABLE `discusswenhuaxuexi` DISABLE KEYS */;
INSERT INTO `discusswenhuaxuexi` VALUES (171,'2022-03-09 13:40:42',1,1,'用戶名1','評論內(nèi)容1','回復(fù)內(nèi)容1'),(172,'2022-03-09 13:40:42',2,2,'用戶名2','評論內(nèi)容2','回復(fù)內(nèi)容2'),(173,'2022-03-09 13:40:42',3,3,'用戶名3','評論內(nèi)容3','回復(fù)內(nèi)容3'),(174,'2022-03-09 13:40:42',4,4,'用戶名4','評論內(nèi)容4','回復(fù)內(nèi)容4'),(175,'2022-03-09 13:40:42',5,5,'用戶名5','評論內(nèi)容5','回復(fù)內(nèi)容5'),(176,'2022-03-09 13:40:42',6,6,'用戶名6','評論內(nèi)容6','回復(fù)內(nèi)容6');
/*!40000 ALTER TABLE `discusswenhuaxuexi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `huodongxinxi`
--
DROP TABLE IF EXISTS `huodongxinxi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huodongxinxi` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `huodongmingcheng` varchar(200) NOT NULL COMMENT '活動(dòng)名稱',
? `huodongleixing` varchar(200) NOT NULL COMMENT '活動(dòng)類型',
? `kaishishijian` date DEFAULT NULL COMMENT '開始時(shí)間',
? `jieshushijian` date DEFAULT NULL COMMENT '結(jié)束時(shí)間',
? `fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
? `huodongxiangqing` longtext COMMENT '活動(dòng)詳情',
? `thumbsupnum` int(11) DEFAULT '0' COMMENT '贊',
? `crazilynum` int(11) DEFAULT '0' COMMENT '踩',
? `clicktime` datetime DEFAULT NULL COMMENT '最近點(diǎn)擊時(shí)間',
? `clicknum` int(11) DEFAULT '0' COMMENT '點(diǎn)擊次數(shù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='活動(dòng)信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `huodongxinxi`
--
LOCK TABLES `huodongxinxi` WRITE;
/*!40000 ALTER TABLE `huodongxinxi` DISABLE KEYS */;
INSERT INTO `huodongxinxi` VALUES (81,'2022-03-09 13:40:42','活動(dòng)名稱1','班費(fèi)收集','2022-03-09','2022-03-09','upload/huodongxinxi_fengmian1.jpg','<p>活動(dòng)詳情1水電費(fèi)三房時(shí)代發(fā)送到發(fā)送到</p>',1,1,'2022-03-09 21:59:29',4),(82,'2022-03-09 13:40:42','活動(dòng)名稱2','學(xué)員黨史','2022-03-09','2022-03-09','upload/huodongxinxi_fengmian2.jpg','活動(dòng)詳情2',2,2,'2022-03-09 21:40:42',2),(83,'2022-03-09 13:40:42','水電費(fèi)時(shí)代發(fā)送到','學(xué)員黨史','2022-03-09','2022-03-09','upload/huodongxinxi_fengmian3.jpg','<p>活動(dòng)詳情3水電費(fèi)發(fā)送到發(fā)送到發(fā)送到</p>',3,3,'2022-03-09 21:57:54',4),(84,'2022-03-09 13:40:42','活動(dòng)名稱4','學(xué)員黨史','2022-03-09','2022-03-09','upload/huodongxinxi_fengmian4.jpg','活動(dòng)詳情4',4,4,'2022-03-09 21:40:42',4),(85,'2022-03-09 13:40:42','活動(dòng)名稱5','學(xué)員黨史','2022-03-09','2022-03-09','upload/huodongxinxi_fengmian5.jpg','活動(dòng)詳情5',5,5,'2022-03-09 21:40:42',5),(86,'2022-03-09 13:40:42','活動(dòng)名稱6','學(xué)員黨史','2022-03-09','2022-03-09','upload/huodongxinxi_fengmian6.jpg','活動(dòng)詳情6',6,6,'2022-03-09 21:40:42',6);
/*!40000 ALTER TABLE `huodongxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiankangdangan`
--
DROP TABLE IF EXISTS `jiankangdangan`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiankangdangan` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `xuehao` varchar(200) DEFAULT NULL COMMENT '學(xué)號',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `nianling` varchar(200) DEFAULT NULL COMMENT '年齡',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `manxingjibing` varchar(200) DEFAULT NULL COMMENT '慢性急病',
? `jiazubingshi` varchar(200) DEFAULT NULL COMMENT '家族病史',
? `yaowuguomin` varchar(200) DEFAULT NULL COMMENT '藥物過敏',
? `zhongdabingshi` varchar(200) DEFAULT NULL COMMENT '重大病史',
? `richangyinshi` longtext COMMENT '日常飲食',
? `beizhu` longtext COMMENT '備注',
? `dengjiriqi` date DEFAULT NULL COMMENT '登記日期',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646834032330 DEFAULT CHARSET=utf8 COMMENT='健康檔案';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiankangdangan`
--
LOCK TABLES `jiankangdangan` WRITE;
/*!40000 ALTER TABLE `jiankangdangan` DISABLE KEYS */;
INSERT INTO `jiankangdangan` VALUES (41,'2022-03-09 13:40:42','學(xué)號1','姓名1','年齡1','性別1','有','有','有','有','日常飲食1','備注1','2022-03-09'),(42,'2022-03-09 13:40:42','學(xué)號2','姓名2','年齡2','性別2','有','有','有','有','日常飲食2','備注2','2022-03-09'),(43,'2022-03-09 13:40:42','學(xué)號3','姓名3','年齡3','性別3','有','有','有','有','日常飲食3','備注3','2022-03-09'),(44,'2022-03-09 13:40:42','學(xué)號4','姓名4','年齡4','性別4','有','有','有','有','日常飲食4','備注4','2022-03-09'),(45,'2022-03-09 13:40:42','學(xué)號5','姓名5','年齡5','性別5','有','有','有','有','日常飲食5','備注5','2022-03-09'),(46,'2022-03-09 13:40:42','學(xué)號6','姓名6','年齡6','性別6','有','有','有','有','日常飲食6','備注6','2022-03-09'),(1646834032329,'2022-03-09 13:53:51','11','時(shí)代','11','女','無','無','無','無','蓄勢待發(fā)時(shí)代發(fā)生發(fā)送到發(fā)送到發(fā)送到','水電費(fèi)時(shí)代發(fā)送到發(fā)送到發(fā)送到發(fā)送到發(fā)送到發(fā)送到','2022-03-09');
/*!40000 ALTER TABLE `jiankangdangan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `title` varchar(200) NOT NULL COMMENT '標(biāo)題',
? `introduction` longtext COMMENT '簡介',
? `picture` varchar(200) NOT NULL COMMENT '圖片',
? `content` longtext NOT NULL COMMENT '內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 COMMENT='通知公告';
/*!40101 SET character_set_client = @saved_cs_client */;
--
DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `refid` bigint(20) DEFAULT NULL COMMENT '收藏id',
? `tablename` varchar(200) DEFAULT NULL COMMENT '表名',
? `name` varchar(200) NOT NULL COMMENT '收藏名稱',
? `picture` varchar(200) NOT NULL COMMENT '收藏圖片',
? `type` varchar(200) DEFAULT '1' COMMENT '類型(1:收藏,21:贊,22:踩)',
? `inteltype` varchar(200) DEFAULT NULL COMMENT '推薦類型',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646834377884 DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `storeup`
--
LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
INSERT INTO `storeup` VALUES (1646834332800,'2022-03-09 13:58:51',1646833986396,1646834210840,'banhuizuzhi','水電費(fèi)時(shí)代','upload/1646834197819.jpg','1',NULL),(1646834335064,'2022-03-09 13:58:54',1646833986396,1646834210840,'banhuizuzhi','水電費(fèi)時(shí)代','upload/1646834197819.jpg','21',NULL);
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `token`
--
DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `username` varchar(100) NOT NULL COMMENT '用戶名',
? `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
? `role` varchar(100) DEFAULT NULL COMMENT '角色',
? `token` varchar(200) NOT NULL COMMENT '密碼',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增時(shí)間',
? `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '過期時(shí)間',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `token`
--
LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
INSERT INTO `token` VALUES (1,1646833986396,'11','xuesheng','學(xué)生','owzzm9q08c49r3obpypyciq05stz1do2','2022-03-09 13:53:22','2022-03-09 15:00:16'),(2,1646833997854,'22','banwei','班委','w7b7dffr5soy2d28teg5e5ax9z3pexa4','2022-03-09 13:53:59','2022-03-09 15:00:23'),(3,1,'abo','users','管理員','vado10mi85khwkt0loep2xrrhfqfolzv','2022-03-09 13:56:01','2022-03-09 15:00:00');
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `username` varchar(100) NOT NULL COMMENT '用戶名',
? `password` varchar(100) NOT NULL COMMENT '密碼',
? `role` varchar(100) DEFAULT '管理員' COMMENT '角色',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增時(shí)間',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用戶表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'abo','abo','管理員','2022-03-09 13:40:42');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wenhuaxuexi`
--
DROP TABLE IF EXISTS `wenhuaxuexi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wenhuaxuexi` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `biaoti` varchar(200) NOT NULL COMMENT '標(biāo)題',
? `jianjie` longtext COMMENT '簡介',
? `fabushijian` date DEFAULT NULL COMMENT '發(fā)布時(shí)間',
? `fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
? `neirong` longtext COMMENT '內(nèi)容',
? `thumbsupnum` int(11) DEFAULT '0' COMMENT '贊',
? `crazilynum` int(11) DEFAULT '0' COMMENT '踩',
? `clicktime` datetime DEFAULT NULL COMMENT '最近點(diǎn)擊時(shí)間',
? `clicknum` int(11) DEFAULT '0' COMMENT '點(diǎn)擊次數(shù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646834293408 DEFAULT CHARSET=utf8 COMMENT='文化學(xué)習(xí)';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wenhuaxuexi`
--
LOCK TABLES `wenhuaxuexi` WRITE;
/*!40000 ALTER TABLE `wenhuaxuexi` DISABLE KEYS */;
INSERT INTO `wenhuaxuexi` VALUES (101,'2022-03-09 13:40:42','標(biāo)題1','簡介1','2022-03-09','upload/wenhuaxuexi_fengmian1.jpg','內(nèi)容1',1,1,'2022-03-09 21:40:42',1),(102,'2022-03-09 13:40:42','標(biāo)題2','簡介2','2022-03-09','upload/wenhuaxuexi_fengmian2.jpg','內(nèi)容2',2,2,'2022-03-09 21:40:42',2),(103,'2022-03-09 13:40:42','標(biāo)題3','簡介3','2022-03-09','upload/wenhuaxuexi_fengmian3.jpg','內(nèi)容3',3,3,'2022-03-09 21:40:42',3),(104,'2022-03-09 13:40:42','標(biāo)題4','簡介4','2022-03-09','upload/wenhuaxuexi_fengmian4.jpg','內(nèi)容4',4,4,'2022-03-09 21:40:42',4),(105,'2022-03-09 13:40:42','標(biāo)題5','簡介5','2022-03-09','upload/wenhuaxuexi_fengmian5.jpg','內(nèi)容5',5,5,'2022-03-09 21:40:42',5),(106,'2022-03-09 13:40:42','標(biāo)題6','簡介6','2022-03-09','upload/wenhuaxuexi_fengmian6.jpg','內(nèi)容6',6,6,'2022-03-09 21:40:42',6),(1646834293407,'2022-03-09 13:58:12','水電費(fèi)時(shí)代','時(shí)代發(fā)多少發(fā)送到發(fā)送到發(fā)送到','2022-03-09','upload/1646834288628.jpeg','<p>時(shí)代發(fā)多少發(fā)多少發(fā)送到發(fā)送到發(fā)送到時(shí)代</p>',0,0,'2022-03-09 21:59:53',4);
/*!40000 ALTER TABLE `wenhuaxuexi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xuesheng`
--
DROP TABLE IF EXISTS `xuesheng`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xuesheng` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `xuehao` varchar(200) NOT NULL COMMENT '學(xué)號',
? `mima` varchar(200) NOT NULL COMMENT '密碼',
? `xingming` varchar(200) NOT NULL COMMENT '姓名',
? `nianling` int(11) DEFAULT NULL COMMENT '年齡',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `shouji` varchar(200) DEFAULT NULL COMMENT '手機(jī)',
? `banji` varchar(200) NOT NULL COMMENT '班級',
? `zhaopian` varchar(200) DEFAULT NULL COMMENT '照片',
? PRIMARY KEY (`id`),
? UNIQUE KEY `xuehao` (`xuehao`)
) ENGINE=InnoDB AUTO_INCREMENT=1646833986397 DEFAULT CHARSET=utf8 COMMENT='學(xué)生';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xuesheng`
--
LOCK TABLES `xuesheng` WRITE;
/*!40000 ALTER TABLE `xuesheng` DISABLE KEYS */;
INSERT INTO `xuesheng` VALUES (11,'2022-03-09 13:40:42','學(xué)號1','123456','姓名1',1,'男','13823888881','班級1','upload/xuesheng_zhaopian1.jpg'),(12,'2022-03-09 13:40:42','學(xué)號2','123456','姓名2',2,'男','13823888882','班級2','upload/xuesheng_zhaopian2.jpg'),(13,'2022-03-09 13:40:42','學(xué)號3','123456','姓名3',3,'男','13823888883','班級3','upload/xuesheng_zhaopian3.jpg'),(14,'2022-03-09 13:40:42','學(xué)號4','123456','姓名4',4,'男','13823888884','班級4','upload/xuesheng_zhaopian4.jpg'),(15,'2022-03-09 13:40:42','學(xué)號5','123456','姓名5',5,'男','13823888885','班級5','upload/xuesheng_zhaopian5.jpg'),(16,'2022-03-09 13:40:42','學(xué)號6','123456','姓名6',6,'男','13823888886','班級6','upload/xuesheng_zhaopian6.jpg'),(1646833986396,'2022-03-09 13:53:06','11','11','時(shí)代',11,'女','11122211111','2班','upload/1646834009640.jpg');
/*!40000 ALTER TABLE `xuesheng` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xueshengchengji`
--
DROP TABLE IF EXISTS `xueshengchengji`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xueshengchengji` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
? `xuehao` varchar(200) DEFAULT NULL COMMENT '學(xué)號',
? `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
? `banji` varchar(200) DEFAULT NULL COMMENT '班級',
? `chengji` varchar(200) DEFAULT NULL COMMENT '成績',
? `pingyu` longtext COMMENT '評語',
? `dengjiriqi` date DEFAULT NULL COMMENT '登記日期',
? `banweizhanghao` varchar(200) DEFAULT NULL COMMENT '班委賬號',
? `banweixingming` varchar(200) DEFAULT NULL COMMENT '班委姓名',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1646834060992 DEFAULT CHARSET=utf8 COMMENT='學(xué)生成績';
/*!40101 SET character_set_client = @saved_cs_client */;
