基于微信小程序考研知识题库在线学习系统设计与实现(微信小程序考什么挣钱)--考研网上

开发语言：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 ,
? `refid` bigint(20) default null comment ,
? `tablename` varchar(200) default null comment ,
? `name` varchar(200) not null comment ,
? `picture` varchar(200) not null comment ,
? `type` varchar(200) default ,
? `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 ,
? `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=
/*!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,
/*!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 ,
? `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,
/*!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()
? ? public r page(@requestparam map<string, object> params,shenqingjiangshientity shenqingjiangshi,?
httpservletrequest request){

string tablename = request.getsession().getattribute(
if(tablename.equals()) {
shenqingjiangshi.setxueshengxuehao((string)request.getsession().getattribute(
}
? ? ? ? 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(
? ? }
? ??
? ? /**
? ? ?* 前端列表
? ? ?*/
? ? @requestmapping()
? ? 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(
? ? }

/**
? ? ?* 列表
? ? ?*/
? ? @requestmapping()
? ? public r list( shenqingjiangshientity shenqingjiangshi){
? ? ? ?entitywrapper<shenqingjiangshientity> ew = new entitywrapper<shenqingjiangshientity>();
? ? ? ew.alleq(mputil.alleqmappre( shenqingjiangshi, ?
? ? ? ? return r.ok().put(
? ? }

/**
? ? ?* 查询
? ? ?*/
? ? @requestmapping()
? ? public r query(shenqingjiangshientity shenqingjiangshi){
? ? ? ? entitywrapper< shenqingjiangshientity> ew = new entitywrapper< shenqingjiangshientity>();
?ew.alleq(mputil.alleqmappre( shenqingjiangshi, ?
shenqingjiangshiview shenqingjiangshiview =? shenqingjiangshiservice.selectview(ew);
return r.ok(
? ? }

? ? /**
? ? ?* 后端详情
? ? ?*/
? ? @requestmapping()
? ? public r info(@pathvariable() long id){
? ? ? ? shenqingjiangshientity shenqingjiangshi = shenqingjiangshiservice.selectbyid(id);
? ? ? ? return r.ok().put(
? ? }

? ? /**
? ? ?* 前端详情
? ? ?*/
? ? @requestmapping()
? ? public r detail(@pathvariable() long id){
? ? ? ? shenqingjiangshientity shenqingjiangshi = shenqingjiangshiservice.selectbyid(id);
? ? ? ? return r.ok().put(
? ? }
? ??

? ? /**
? ? ?* 后端保存
? ? ?*/
? ? @requestmapping()
? ? public r save(@requestbody shenqingjiangshientity shenqingjiangshi, httpservletrequest request){
? ? s

henqingjiangshi.setid(new date().gettime()+new double(math.floor(math.random()*1000)).longvalue());
? ? //validatorutils.validateentity(shenqingjiangshi);

? ? ? ? shenqingjiangshiservice.insert(shenqingjiangshi);
? ? ? ? return r.ok();
? ? }
? ??

未经允许不得转载：考研网上 - 考研网上辅导班有用吗 > 基于微信小程序考研知识题库在线学习系统设计与实现(微信小程序考什么挣钱)