基于微信小程序考研知识题库在线学习系统设计与实现-计算机毕业设计源码和lw文档

开发语言：Java

框架：ssm

JDK版本：JDK1.8

服务器：tomcat7

数据库：mysql 5.7（一定要5.7版本）

数据库工具：Navicat11

开发软件：eclipse/myeclipse/idea

Maven包：Maven3.3.9

浏览器：谷歌浏览器

小程序框架：uniapp

小程序开发软件：HBuilder X

小程序运行软件：微信开发者

数据库：

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 '创建时间',

`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,'学生学号1','xuesheng','学生','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 '创建时间',

`xueshengxuehao` varchar(200) DEFAULT NULL COMMENT '学生学号',

`xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',

`mima` varchar(200) DEFAULT NULL COMMENT '密码',

`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',

`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',

PRIMARY KEY (`id`),

UNIQUE KEY `xueshengxuehao` (`xueshengxuehao`)

) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='学生';

/*!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();

}