基于javaweb+mysql的springboot银行柜台管理系统(java+springboot+vue+element+mybaits+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Node.js≥10
开发工具
后端:eclipse/idea/myeclipse/sts等均可配置运行
前端:WebStorm/VSCode/HBuilderX等均可
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的SpringBoot银行柜台管理系统(java+springboot+vue+element+mybaits+mysql)
项目介绍
Springboot银行柜面管理系统主要分为管理员与用户两种角色。 管理员角色主要功能如下: 系统用户管理:管理员用户、修改密码; 用户管理:用户查询、新增、编辑、删除等; 取款管理:用户查询、新增、编辑、删除等; 存款管理:用户查询、新增、编辑、删除等; 转账管理:用户查询、新增、编辑、删除等;
普通用户主要功能如下: 个人资料管理:修改个人资料、修改密码; 取款管理:用户查询、新增、编辑、删除等; 存款管理:用户查询、新增、编辑、删除等; 转账管理:用户查询、新增、编辑、删除等;
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 4.数据库:MySql 5.7/8.0版本均可; 5.是否Maven项目:是;
技术栈
后端:SpringBoot+Mybaits
前端:Html+css+element+jquery+bootstrap+vue
使用说明
项目运行: 1. 使用Navicat或者其它工具,在mysql中创建对应sql文件名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中application.yml配置文件中的数据库配置改为自己的配置; 4. 运行项目,在浏览器中输入地址:http://localhost:8888/end/page/login.html 管理员账号、密码:hsg/hsg 普通用户账号、密码:001/001
String deptno = request.getParameter("deptno");
System.out.println(date+"-----");
System.out.println(deptno);
Map<String, String> map = new HashMap<String, String>();
map.put("date", date);
map.put("deptno", deptno);
if("0".equals(ym)){//月度
List<DataDetailModel> lists = datadetailservice.queryByDeptnoAndMonth(map);
mav.addObject("items", lists);
return mav;
/**
* 查询一年数据
* @param request
System.out.println("date:"+date);
Map<String, String> map = new HashMap<String, String>();
map.put("date", date);
List<DataDetailModel> datas = datadetailservice.queryByMonth(map);
result.setData(datas);
return result;
/**
* 点击表格加载详细数据--跳转子页面
* @param request
* @param response
* @return
public DataResult login(HttpServletRequest request,
HttpServletResponse response){
String username = request.getParameter("username");
String password = request.getParameter("password");
DataResult result = userService.checkLogin(username, password);
request.getSession().setAttribute("user", (User)result.getData());
return result;
/**
* 退出登录
* @param request
* @param response
* @return
try {
privilegeService.delPrivilegesWenDelRole(roleid);
int num = userInfoService.deleteRole(roleid);
if(num>0){
return ResultUtil.success();
}else {
privilegeService.addDefaultPrivilegesWhenAddRole(roleid);
return ResultUtil.unSuccess();
}catch (Exception e){
return ResultUtil.error(e);
@RequestMapping("/getRole/{id}")
public @ResponseBody Result getRoleById(@PathVariable String id){
}catch (Exception e){
return ResultUtil.error(e);
@RequestMapping("/role/add")
public @ResponseBody Result addRole(Role role){
try {
int num = userInfoService.addRole(role);
if(num>0){
privilegeService.addDefaultPrivilegesWhenAddRole(role.getRoleid().toString());
return ResultUtil.success();
}else {
return ResultUtil.unSuccess();
* 登录时将用户信息加入cookie中
* @param response
*/
private void setCookieUser(HttpServletRequest request, HttpServletResponse response){
UserInfo user = getSessionUser(request.getSession());
Cookie cookie = new Cookie(Config.CURRENT_USERNAME,user.getUsername()+"_"+user.getId());
//cookie 保存7天
cookie.setMaxAge(60*60*24*7);
response.addCookie(cookie);
/**
* 注销时删除cookie信息
* @param request
* @param response
* @return
*/
@RequestMapping("/queryByYear.do")
@ResponseBody
public DataResult queryByYear(HttpServletRequest request,HttpServletResponse response){
DataResult result = new DataResult();
String date = request.getParameter("date");
System.out.println("date:"+date);
Map<String, String> map = new HashMap<String, String>();
map.put("date", date);
List<DataDetailModel> lists = datadetailservice.queryByYear(map);
@ResponseBody
public Result getUserInfo(UserInfo userInfo, HttpServletRequest request, HttpServletResponse response){
boolean userIsExisted = userInfoService.userIsExisted(userInfo);
System.out.println(userIsExisted + " - " + request.getHeader("token"));
userInfo = getUserInfo(userInfo);
if("client".equals(request.getHeader("token")) && !userIsExisted){
//用户不存在
return ResultUtil.success(-1);
if (userIsExisted && userInfo == null){
return ResultUtil.unSuccess("用户名或密码错误!");
}else {
//将用户信息存入session
userInfo = setSessionUserInfo(userInfo,request.getSession());
//将当前用户信息存入cookie
*/
@RequestMapping("/logout.do")
public ModelAndView log(HttpServletRequest request,HttpServletResponse response){
ModelAndView mav = new ModelAndView();
mav.setViewName("login");
return mav;
/**
* 修改密码页面请求
* @param request
* @param response
* @return
*/
* @return
*/
public UserInfo setSessionUserInfo(UserInfo userInfo, HttpSession session){
List<Privilege> privileges = privilegeService.getPrivilegeByRoleid(userInfo.getRoleid());
userInfo.setPrivileges(privileges);
session.setAttribute(Config.CURRENT_USERNAME,userInfo);
return userInfo;
public UserInfo getUserInfo(UserInfo userInfo){
return userInfoService.getUserInfo(userInfo);
费用记录管理控制层:
@Controller
public @ResponseBody Result updateUser(UserInfo userInfo){
try {
int num = userInfoService.update(userInfo);
if(num>0){
return ResultUtil.success();
}else {
return ResultUtil.unSuccess();
}catch (Exception e){
return ResultUtil.error(e);
@RequestMapping("/user/del/{id}")
public @ResponseBody Result deleteUser(@PathVariable String id){
try {
int num = userInfoService.delete(id);
*/
@RequestMapping("/show.do")
public ModelAndView show(HttpServletRequest request,HttpServletResponse response){
ModelAndView mav = new ModelAndView("main_total");
List<Dept> depts = deptservice.loadAllDepts();
mav.addObject("depts", depts);
//默认先加载当前月所有数据
//获取当前月份
Date now = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM");
String date = sdf.format(now);
mav.addObject("now", date);
return mav;
List<Role> roles = userInfoService.getAllRoles();
if (roles.size()>0){
return ResultUtil.success(roles);
}else {
return ResultUtil.unSuccess();
}catch (Exception e){
return ResultUtil.error(e);
@RequestMapping("/role/add")
public @ResponseBody Result addRole(Role role){
try {
int num = userInfoService.addRole(role);
if(num>0){
privilegeService.addDefaultPrivilegesWhenAddRole(role.getRoleid().toString());
@RequestMapping("/user/del/{id}")
public @ResponseBody Result deleteUser(@PathVariable String id){
try {
int num = userInfoService.delete(id);
if(num>0){
return ResultUtil.success();
}else {
return ResultUtil.unSuccess();
}catch (Exception e){
return ResultUtil.error(e);
@RequestMapping("/getSessionUser")
@ResponseBody
public UserInfo getSessionUser(HttpSession session){
}else {
return ResultUtil.unSuccess();
}catch (Exception e){
return ResultUtil.error(e);
@RequestMapping("/user/del/{id}")
public @ResponseBody Result deleteUser(@PathVariable String id){
try {
int num = userInfoService.delete(id);
if(num>0){
return ResultUtil.success();
}else {
privilegeService.addDefaultPrivilegesWhenAddRole(role.getRoleid().toString());
return ResultUtil.success();
}else {
return ResultUtil.unSuccess();
}catch (Exception e){
return ResultUtil.error(e);
@RequestMapping("/role/update")
public @ResponseBody Result updateRole(Role role){
try {
int num = userInfoService.updateRole(role);
if(num>0){
return ResultUtil.success();
* @param request
* @param response
* @return
*/
@RequestMapping("/queryByMonth.do")
@ResponseBody
public DataResult queryByMonth(HttpServletRequest request,HttpServletResponse response){
DataResult result = new DataResult();
String date = request.getParameter("date");
System.out.println("date:"+date);
Map<String, String> map = new HashMap<String, String>();