基于微信小程序考研知識題庫在線學(xué)習(xí)系統(tǒng)設(shè)計與實現(xiàn)-計算機畢業(yè)設(shè)計源碼和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
瀏覽器：谷歌瀏覽器
小程序框架：uniapp
小程序開發(fā)軟件：HBuilder X
小程序運行軟件：微信開發(fā)者
數(shù)據(jù)庫：
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)建時間',
? `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 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 */;
/*!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 '新增時間',
? `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '過期時間',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 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,11,'學(xué)生學(xué)號1','xuesheng','學(xué)生','g8llculzf2r3san38bg6am1x7fajz65u','2022-02-21 08:47:37','2022-02-21 09:47:37');
/*!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 '新增時間',
? 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-02-21 08:35:17');
/*!40000 ALTER TABLE `users` 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)建時間',
? `xueshengxuehao` varchar(200) DEFAULT NULL COMMENT '學(xué)生學(xué)號',
? `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '學(xué)生姓名',
? `mima` varchar(200) DEFAULT NULL COMMENT '密碼',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '聯(lián)系電話',
? PRIMARY KEY (`id`),
? UNIQUE KEY `xueshengxuehao` (`xueshengxuehao`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='學(xué)生';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xuesheng`
--
邏輯代碼：
? ? /**
? ? ?* 后端列表
? ? ?*/
? ? @RequestMapping("/page")
? ? public R page(@RequestParam Map<String, Object> params,ShenqingjiangshiEntity shenqingjiangshi,?
HttpServletRequest request){
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("xuesheng")) {
shenqingjiangshi.setXueshengxuehao((String)request.getSession().getAttribute("username"));
}
? ? ? ? EntityWrapper<ShenqingjiangshiEntity> ew = new EntityWrapper<ShenqingjiangshiEntity>();
PageUtils page = shenqingjiangshiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, shenqingjiangshi), params), params));
? ? ? ? return R.ok().put("data", page);
? ? }
? ??
? ? /**
? ? ?* 前端列表
? ? ?*/
? ? @RequestMapping("/list")
? ? public R list(@RequestParam Map<String, Object> params,ShenqingjiangshiEntity shenqingjiangshi,?
HttpServletRequest request){
? ? ? ? EntityWrapper<ShenqingjiangshiEntity> ew = new EntityWrapper<ShenqingjiangshiEntity>();
PageUtils page = shenqingjiangshiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, shenqingjiangshi), params), params));
? ? ? ? return R.ok().put("data", page);
? ? }
/**
? ? ?* 列表
? ? ?*/
? ? @RequestMapping("/lists")
? ? public R list( ShenqingjiangshiEntity shenqingjiangshi){
? ? ? ? EntityWrapper<ShenqingjiangshiEntity> ew = new EntityWrapper<ShenqingjiangshiEntity>();
? ? ? ew.allEq(MPUtil.allEQMapPre( shenqingjiangshi, "shenqingjiangshi"));?
? ? ? ? return R.ok().put("data", shenqingjiangshiService.selectListView(ew));
? ? }
/**
? ? ?* 查詢
? ? ?*/
? ? @RequestMapping("/query")
? ? public R query(ShenqingjiangshiEntity shenqingjiangshi){
? ? ? ? EntityWrapper< ShenqingjiangshiEntity> ew = new EntityWrapper< ShenqingjiangshiEntity>();
? ew.allEq(MPUtil.allEQMapPre( shenqingjiangshi, "shenqingjiangshi"));?
ShenqingjiangshiView shenqingjiangshiView =? shenqingjiangshiService.selectView(ew);
return R.ok("查詢申請講師成功").put("data", shenqingjiangshiView);
? ? }
? ? /**
? ? ?* 后端詳情
? ? ?*/
? ? @RequestMapping("/info/{id}")
? ? public R info(@PathVariable("id") Long id){
? ? ? ? ShenqingjiangshiEntity shenqingjiangshi = shenqingjiangshiService.selectById(id);
? ? ? ? return R.ok().put("data", shenqingjiangshi);
? ? }
? ? /**
? ? ?* 前端詳情
? ? ?*/
? ? @RequestMapping("/detail/{id}")
? ? public R detail(@PathVariable("id") Long id){
? ? ? ? ShenqingjiangshiEntity shenqingjiangshi = shenqingjiangshiService.selectById(id);
? ? ? ? return R.ok().put("data", shenqingjiangshi);
? ? }
? ??
? ? /**
? ? ?* 后端保存
? ? ?*/
? ? @RequestMapping("/save")
? ? public R save(@RequestBody ShenqingjiangshiEntity shenqingjiangshi, HttpServletRequest request){
? ? shenqingjiangshi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
? ? //ValidatorUtils.validateEntity(shenqingjiangshi);
? ? ? ? shenqingjiangshiService.insert(shenqingjiangshi);
? ? ? ? return R.ok();
? ? }
? ??
