其实教育培训网站源码分享系统登录的问题并不复杂,但是又很多的朋友都不太了解教育培训机构管理系统源码,因此呢,今天小编就来为大家分享教育培训网站源码分享系统登录的一些知识,希望可以帮助到大家,下面我们一起来看看这个问题的分析吧!
小程序开发说明
开发语言:Java
框架:ssm
JDK版本:JDK1.8
服务器:tomcat7
数据库:mysql5.7(一定要5.7版本)
数据库工具:Navicat11
开发软件:eclipse/myeclipse/idea
Maven包:Maven3.3.9
浏览器:谷歌浏览器
小程序框架:uniapp
小程序开发软件:HBuilderX
小程序运行软件:微信开发者
数据库:
DROPTABLEIFEXISTS`storeup`;
/*!40101SET@saved_cs_client=@@character_set_client*/;
/*!40101SETcharacter_set_client=utf8*/;
CREATETABLE`storeup`(
`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,
`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,
`userid`bigint(20)NOTNULLCOMMENT&39;,
`refid`bigint(20)DEFAULTNULLCOMMENT&39;,
`tablename`varchar(200)DEFAULTNULLCOMMENT&39;,
`name`varchar(200)NOTNULLCOMMENT&39;,
`picture`varchar(200)NOTNULLCOMMENT&39;,
`type`varchar(200)DEFAULT&39;COMMENT&39;,
`inteltype`varchar(200)DEFAULTNULLCOMMENT&39;,
PRIMARYKEY(`id`)
)ENGINE=InnoDBAUTO_INCREMENT=1648964400963DEFAULTCHARSET=utf8COMMENT=&39;;
/*!40101SETcharacter_set_client=@saved_cs_client*/;
—
–Dumpingdatafortable`storeup`
—
LOCKTABLES`storeup`WRITE;
/*!40000ALTERTABLE`storeup`DISABLEKEYS*/;
INSERTINTO`storeup`VALUES(1648964342185,&39;,1648964299666,34,&39;,&39;,&39;,&39;,NULL),(1648964400962,&39;,1648964299666,1648964187595,&39;,&39;,&39;,&39;,NULL);
/*!40000ALTERTABLE`storeup`ENABLEKEYS*/;
UNLOCKTABLES;
—
–Tablestructurefortable`token`
—
DROPTABLEIFEXISTS`token`;
/*!40101SET@saved_cs_client=@@character_set_client*/;
/*!40101SETcharacter_set_client=utf8*/;
CREATETABLE`token`(
`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,
`userid`bigint(20)NOTNULLCOMMENT&39;,
`username`varchar(100)NOTNULLCOMMENT&39;,
`tablename`varchar(100)DEFAULTNULLCOMMENT&39;,
`role`varchar(100)DEFAULTNULLCOMMENT&39;,
`token`varchar(200)NOTNULLCOMMENT&39;,
`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,
`expiratedtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,
PRIMARYKEY(`id`)
)ENGINE=InnoDBAUTO_INCREMENT=4DEFAULTCHARSET=utf8COMMENT=&39;;
/*!40101SETcharacter_set_client=@saved_cs_client*/;
—
–Dumpingdatafortable`token`
—
LOCKTABLES`token`WRITE;
/*!40000ALTERTABLE`token`DISABLEKEYS*/;
INSERTINTO`token`VALUES(1,1648964148538,&39;,&39;,&39;,&39;,&39;,&39;),(2,1,&39;,&39;,&39;,&39;,&39;,&39;),(3,1648964299666,&39;,&39;,&39;,&39;,&39;,&39;);
/*!40000ALTERTABLE`token`ENABLEKEYS*/;
UNLOCKTABLES;
—
–Tablestructurefortable`users`
—
DROPTABLEIFEXISTS`users`;
/*!40101SET@saved_cs_client=@@character_set_client*/;
/*!40101SETcharacter_set_client=utf8*/;
CREATETABLE`users`(
`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,
`username`varchar(100)NOTNULLCOMMENT&39;,
`password`varchar(100)NOTNULLCOMMENT&39;,
`role`varchar(100)DEFAULT&39;COMMENT&39;,
`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,
PRIMARYKEY(`id`)
)ENGINE=InnoDBAUTO_INCREMENT=2DEFAULTCHARSET=utf8COMMENT=&39;;
/*!40101SETcharacter_set_client=@saved_cs_client*/;
—
–Dumpingdatafortable`users`
—
LOCKTABLES`users`WRITE;
/*!40000ALTERTABLE`users`DISABLEKEYS*/;
INSERTINTO`users`VALUES(1,&39;,&39;,&39;,&39;);
/*!40000ALTERTABLE`users`ENABLEKEYS*/;
UNLOCKTABLES;
—
–Tablestructurefortable`xuesheng`
—
DROPTABLEIFEXISTS`xuesheng`;
/*!40101SET@saved_cs_client=@@character_set_client*/;
/*!40101SETcharacter_set_client=utf8*/;
CREATETABLE`xuesheng`(
`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,
`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,
`xuehao`varchar(200)NOTNULLCOMMENT&39;,
`mima`varchar(200)NOTNULLCOMMENT&39;,
`xingming`varchar(200)NOTNULLCOMMENT&39;,
`xingbie`varchar(200)DEFAULTNULLCOMMENT&39;,
`shouji`varchar(200)DEFAULTNULLCOMMENT&39;,
`touxiang`varchar(200)DEFAULTNULLCOMMENT&39;,
PRIMARYKEY(`id`),
UNIQUEKEY`xuehao`(`xuehao`)
)ENGINE=InnoDBAUTO_INCREMENT=1648964299667DEFAULTCHARSET=utf8COMMENT=&39;;
/*!40101SETcharacter_set_client=@saved_cs_client*/;
—
–Dumpingdatafortable`xuesheng`
—
LOCKTABLES`xuesheng`WRITE;
/*!40000ALTERTABLE`xuesheng`DISABLEKEYS*/;
INSERTINTO`xuesheng`VALUES(11,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(12,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(13,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(14,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(15,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(16,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(1648964299666,&39;,&39;,&39;,&39;,&39;,&39;,&39;);
/*!40000ALTERTABLE`xuesheng`ENABLEKEYS*/;
UNLOCKTABLES;
/*!40103SETTIME_ZONE=@OLD_TIME_ZONE*/;
代码:
/**
*登录相关
*/
@RequestMapping(&34;)
@RestController
publicclassUserController{
@Autowired
privateUserServiceuserService;
@Autowired
privateTokenServicetokenService;
/**
*登录
*/
@IgnoreAuth
@PostMapping(value=&34;)
publicRlogin(Stringusername,Stringpassword,Stringcaptcha,HttpServletRequestrequest){
UserEntityuser=userService.selectOne(newEntityWrapper<UserEntity>().eq(&34;,username));
if(user==null||!user.getPassword().equals(password)){
returnR.error(&34;);
}
Stringtoken=tokenService.generateToken(user.getId(),username,&34;,user.getRole());
returnR.ok().put(&34;,token);
}
/**
*注册
*/
@IgnoreAuth
@PostMapping(value=&34;)
publicRregister(@RequestBodyUserEntityuser){
//ValidatorUtils.validateEntity(user);
if(userService.selectOne(newEntityWrapper<UserEntity>().eq(&34;,user.getUsername()))!=null){
returnR.error(&34;);
}
userService.insert(user);
returnR.ok();
}
/**
*退出
*/
@GetMapping(value=&34;)
publicRlogout(HttpServletRequestrequest){
request.getSession().invalidate();
returnR.ok(&34;);
}
/**
*密码重置
*/
@IgnoreAuth
@RequestMapping(value=&34;)
publicRresetPass(Stringusername,HttpServletRequestrequest){
UserEntityuser=userService.selectOne(newEntityWrapper<UserEntity>().eq(&34;,username));
if(user==null){
returnR.error(&34;);
}
user.setPassword(&34;);
userService.update(user,null);
returnR.ok(&34;);
}
/**
*列表
*/
@RequestMapping(&34;)
publicRpage(@RequestParamMap<String,Object>params,UserEntityuser){
EntityWrapper<UserEntity>ew=newEntityWrapper<UserEntity>();
PageUtilspage=userService.queryPage(params,MPUtil.sort(MPUtil.between(MPUtil.allLike(ew,user),params),params));
returnR.ok().put(&34;,page);
}
/**
*列表
*/
@RequestMapping(&34;)
publicRlist(UserEntityuser){
EntityWrapper<UserEntity>ew=newEntityWrapper<UserEntity>();
ew.allEq(MPUtil.allEQMapPre(user,&34;));
returnR.ok().put(&34;,userService.selectListView(ew));
}
/**
*信息
*/
@RequestMapping(&34;)
publicRinfo(@PathVariable(&34;)Stringid){
UserEntityuser=userService.selectById(id);
returnR.ok().put(&34;,user);
}
/**
*获取用户的session用户信息
*/
@RequestMapping(&34;)
publicRgetCurrUser(HttpServletRequestrequest){
Longid=(Long)request.getSession().getAttribute(&34;);
UserEntityuser=userService.selectById(id);
returnR.ok().put(&34;,user);
}
文章到此结束,如果本次分享的教育培训网站源码分享系统登录和教育培训机构管理系统源码的问题解决了您的问题,那么我们由衷的感到高兴!
