栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

简易的echarts+java可视化展示平台

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

简易的echarts+java可视化展示平台

目录

entity层

User

People

 dao层

UserDao

 PeopleDao

 service层

UserService

 PeopleService

 service层实现类

UserServiceImpl

 PeopleServiceImpl

 dto层

requestDto

LoginRequestDto

 PasswordRequestDto

 RegistRequestDto

responseDto

LoginResponseDto

 controller层

BaseController

 EchartsController

LoginController

PeopleController

 RegistController

UserController

interceptor登陆拦截器

LoginInterceptor

config配置类

SwaggerConfig

util工具类

CodeUtil

Md5Util  

mybatis映射文件

PeopleDao.xml

UserDao.xml

 spring配置文件

application.xml

 数据库配置文件

jdbc.properties

sql 


 源码下载地址:

https://download.csdn.net/download/q1425857916/85663959https://download.csdn.net/download/q1425857916/85663959

GitHub - jingningbl/echartsContribute to jingningbl/echarts development by creating an account on GitHub.https://github.com/jingningbl/echarts

 

 

 

entity层

User
package com.echarts.entity;

import java.io.Serializable;


public class User implements Serializable {
    private static final long serialVersionUID = 627029103871267959L;
    
    private Integer id;
    
    private String username;
    
    private String password;


    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

}

People
package com.echarts.entity;

import java.io.Serializable;


public class People implements Serializable {
    private static final long serialVersionUID = -60863944794822282L;
    
    private Integer id;
    
    private String province;
    
    private Integer number;


    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getProvince() {
        return province;
    }

    public void setProvince(String province) {
        this.province = province;
    }

    public Integer getNumber() {
        return number;
    }

    public void setNumber(Integer number) {
        this.number = number;
    }

}

 dao层

UserDao
package com.echarts.dao;

import com.echarts.dto.responseDto.LoginResponseDto;
import com.echarts.entity.User;
import org.apache.ibatis.annotations.Param;
import java.util.List;


public interface UserDao {

    
    User queryById(Integer id);

    
    List queryAllByLimit(@Param("offset") int offset, @Param("limit") int limit);


    
    List queryAll(User user);

    
    int insert(User user);

    
    int insertBatch(@Param("entities") List entities);

    
    int insertOrUpdateBatch(@Param("entities") List entities);

    
    int update(User user);

    
    int deleteById(Integer id);

    LoginResponseDto getUserInfoByUsernameAndPassword(@Param("username") String username,
                                                      @Param("password") String password);

    User queryByUsername(String username);

    void updatePassword(@Param("username") String userName,@Param("password") String newPassword);
}

 PeopleDao
package com.echarts.dao;

import com.echarts.entity.People;
import org.apache.ibatis.annotations.Param;

import java.util.List;


public interface PeopleDao {

    People queryById(Integer id);

    List queryAll();

    List queryAllBySort();

    int update(@Param("province") String province, @Param("number") Integer number);

    Double queryNumber(@Param("province") String province);

}

 service层

UserService
package com.echarts.service;

import com.echarts.dto.responseDto.LoginResponseDto;
import com.echarts.entity.User;
import java.util.List;


public interface UserService {

    
    User queryById(Integer id);

    
    List queryAllByLimit(int offset, int limit);

    
    User insert(User user);

    
    User update(User user);

    
    boolean deleteById(Integer id);

    LoginResponseDto getUserInfoByUsernameAndPassword(String username, String password);

    User queryByUsername(String username);

    void updatePassword(String userName, String newPassword);
}

 PeopleService
package com.echarts.service;

import com.echarts.entity.People;
import io.swagger.models.auth.In;

import java.util.List;


public interface PeopleService {

    People queryById(Integer id);

    List queryAll();

    List queryAllBySort();

    Integer update(String province,Integer number);

    Double queryNumber(String province);
}

 service层实现类

UserServiceImpl
package com.echarts.service.impl;

import com.echarts.dto.responseDto.LoginResponseDto;
import com.echarts.entity.User;
import com.echarts.dao.UserDao;
import com.echarts.service.UserService;
import com.echarts.util.Md5Util;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;


@Service("userService")
public class UserServiceImpl implements UserService {
    @Resource
    private UserDao userDao;

    
    @Override
    public User queryById(Integer id) {
        return this.userDao.queryById(id);
    }

    
    @Override
    public List queryAllByLimit(int offset, int limit) {
        return this.userDao.queryAllByLimit(offset, limit);
    }

    
    @Override
    public User insert(User user) {
        this.userDao.insert(user);
        return user;
    }

    
    @Override
    public User update(User user) {
        this.userDao.update(user);
        return this.queryById(user.getId());
    }

    
    @Override
    public boolean deleteById(Integer id) {
        return this.userDao.deleteById(id) > 0;
    }

    @Override
    public LoginResponseDto getUserInfoByUsernameAndPassword(String username, String password) {
        return userDao.getUserInfoByUsernameAndPassword(username, Md5Util.getMd5(password));
    }

    @Override
    public User queryByUsername(String username) {
        return userDao.queryByUsername(username);
    }

    @Override
    public void updatePassword(String userName, String newPassword) {
        userDao.updatePassword(userName,Md5Util.getMd5(newPassword));
    }
}

 PeopleServiceImpl
package com.echarts.service.impl;

import com.echarts.entity.People;
import com.echarts.dao.PeopleDao;
import com.echarts.service.PeopleService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;


@Service("peopleService")
public class PeopleServiceImpl implements PeopleService {
    @Resource
    private PeopleDao peopleDao;

    @Override
    public People queryById(Integer id) {
        return this.peopleDao.queryById(id);
    }

    @Override
    public List queryAll() {
        return peopleDao.queryAll();
    }

    @Override
    public List queryAllBySort() {
        return peopleDao.queryAllBySort();
    }

    @Override
    public Integer update(String province,Integer number) {
        return peopleDao.update(province,number);
    }

    @Override
    public Double queryNumber(String province) {
        return peopleDao.queryNumber(province);
    }
}

 dto层

requestDto

LoginRequestDto
package com.echarts.dto.requestDto;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;

import java.io.Serializable;


@ApiModel(value = "登录",description = "用户登录dto")
public class LoginRequestDto implements Serializable {

    private static final long serialVersionUID = 2259675252596867416L;

    @ApiModelProperty(value = "用户名", required = true, example = "lisi")
    private String username;

    @ApiModelProperty(value = "密码", required = true, example = "1513")
    private String password;

    @ApiModelProperty(value = "验证码是否需要校验", required = false, example = "false")
    private Boolean needVerify;

    @ApiModelProperty(value = "验证码", required = false)
    private String verifyCodeActual;

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public Boolean getNeedVerify() {
        return needVerify;
    }

    public void setNeedVerify(Boolean needVerify) {
        this.needVerify = needVerify;
    }

    public String getVerifyCodeActual() {
        return verifyCodeActual;
    }

    public void setVerifyCodeActual(String verifyCodeActual) {
        this.verifyCodeActual = verifyCodeActual;
    }

    @Override
    public String toString() {
        return "LoginRequestDto{" +
                "username='" + username + ''' +
                ", password='" + password + ''' +
                ", needVerify=" + needVerify +
                ", verifyCodeActual='" + verifyCodeActual + ''' +
                '}';
    }
}

 PasswordRequestDto
package com.echarts.dto.requestDto;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;

import java.io.Serializable;


@ApiModel(value = "用户",description = "用户dto")

public class PasswordRequestDto implements Serializable {

    private static final long serialVersionUID = -5777813532773470194L;

    @ApiModelProperty(value = "旧密码", required = true, example = "1513")
    private String oldPassword;

    @ApiModelProperty(value = "新密码", required = true, example = "1513")
    private String newPassword;

    @ApiModelProperty(value = "确认密码", required = true, example = "1513")
    private String rePassword;

    public String getOldPassword() {
        return oldPassword;
    }

    public void setOldPassword(String oldPassword) {
        this.oldPassword = oldPassword;
    }

    public String getNewPassword() {
        return newPassword;
    }

    public void setNewPassword(String newPassword) {
        this.newPassword = newPassword;
    }

    public String getRePassword() {
        return rePassword;
    }

    public void setRePassword(String rePassword) {
        this.rePassword = rePassword;
    }
}

 RegistRequestDto
package com.echarts.dto.requestDto;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;

import java.io.Serializable;


@ApiModel(value = "注册",description = "用户注册dto")
public class RegistRequestDto implements Serializable {

    private static final long serialVersionUID = 6124069851392868773L;

    @ApiModelProperty(value = "用户名", required = true, example = "lisi")
    private String username;

    @ApiModelProperty(value = "密码", required = true, example = "1513")
    private String password;

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "RegistRequestDto{" +
                "username='" + username + ''' +
                ", password='" + password + ''' +
                '}';
    }
}

responseDto

LoginResponseDto
package com.echarts.dto.responseDto;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;

import java.io.Serializable;


@ApiModel(value = "登录",description = "用户登录dto")
public class LoginResponseDto implements Serializable {

    private static final long serialVersionUID = -5205628512118749168L;

    @ApiModelProperty(value = "主键id")
    private Integer id;

    @ApiModelProperty(value = "姓名")
    private String userName;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    @Override
    public String toString() {
        return "LoginResponseDto{" +
                "id=" + id +
                ", userName='" + userName + ''' +
                '}';
    }
}

 controller层

BaseController
package com.echarts.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;

import javax.servlet.http.HttpServletRequest;


@Controller
public class BaseController {

    @Autowired
    HttpServletRequest request;
}

 EchartsController
package com.echarts.controller;

import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;


@Api(tags = "Echarts路由")
@Controller
public class EchartsController extends BaseController{

    @ApiOperation(value = "echarts1")
    @GetMapping("echarts1")
    public String echarts1() {
        request.getSession().setAttribute("pageName", "Echarts示例");
        return "echarts1";
    }

    @ApiOperation(value = "echarts2")
    @GetMapping("echarts2")
    public String echarts2() {
        request.getSession().setAttribute("pageName", "Echarts树图");
        return "echarts2";
    }

    @ApiOperation(value = "echarts3")
    @GetMapping("echarts3")
    public String echarts3() {
        request.getSession().setAttribute("pageName", "人口普查");
        return "echarts3";
    }
}

LoginController
package com.echarts.controller;

import com.echarts.dto.requestDto.LoginRequestDto;
import com.echarts.dto.responseDto.LoginResponseDto;
import com.echarts.entity.User;
import com.echarts.service.UserService;
import com.echarts.util.CodeUtil;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.HashMap;
import java.util.Map;


@Api(tags = "登陆登出")
@Controller
public class LoginController extends BaseController {

    @Autowired
    private UserService userService;


    @ApiOperation(value = "登录页面")
    @GetMapping("login")
    public String login() {
        return "login";
    }

    @ApiOperation(value = "跳转主页面")
    @GetMapping("main")
    public String toMain() {
        request.getSession().setAttribute("pageName", "Echarts官网");
        return "main";
    }

    @ApiOperation(value = "登录验证")
    @PostMapping("/checkLogin")
    @ResponseBody
    public Map checkLogin(@RequestBody LoginRequestDto loginRequestDto) {
        Map modelMap = new HashMap<>();
        //是否需要校验验证码
        Boolean needVerify = loginRequestDto.getNeedVerify();
        //获取验证码
        String verifyCodeActual = loginRequestDto.getVerifyCodeActual();
        //获取用户名
        String username = loginRequestDto.getUsername();
        //获取密码
        String password = loginRequestDto.getPassword();
        if (needVerify && !CodeUtil.checkVerifyCode(request, verifyCodeActual)) {
            //验证码错误
            modelMap.put("success", false);
            modelMap.put("errMsg", "验证码错误");
            return modelMap;
        }
        if ("".equals(username) || "".equals(password)) {
            modelMap.put("success", false);
            modelMap.put("errMsg", "用户名或密码不可为空");
        } else {
            //通过用户名密码查库
            LoginResponseDto userInfo = userService.getUserInfoByUsernameAndPassword(username, password);
            if (null != userInfo) {
                //userInfo不为空,登陆成功
                modelMap.put("success", true);
                modelMap.put("username", userInfo.getUserName());
                //将信息存入到session
                request.getSession().setAttribute("userInfo", userInfo);
            } else {
                User user = userService.queryByUsername(username);
                modelMap.put("success", false);
                if (null != user){
                    modelMap.put("errMsg", "用户名或者密码错误");
                }else {
                    modelMap.put("errMsg", "用户不存在");
                }
            }
        }
        return modelMap;
    }

    @ApiOperation(value = "退出登录")
    @PostMapping("logout")
    @ResponseBody
    public Map logout() {
        Map modelMap = new HashMap<>();
        request.getSession().setAttribute("userInfo", null);
        modelMap.put("success", true);
        return modelMap;
    }
}

PeopleController
package com.echarts.controller;

import com.echarts.entity.People;
import com.echarts.service.PeopleService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


@Api(tags = "人口普查")
@Controller
@RequestMapping("people")
public class PeopleController {
    
    @Autowired
    private PeopleService peopleService;

    @ApiOperation("人口普查")
    @PostMapping("/chinaPeople")
    @ResponseBody
    public Map> chinaPeople() {
        Map> chinaMap = new HashMap<>();
        List peopleList = peopleService.queryAll();
        List province = new ArrayList<>();
        List number = new ArrayList<>();
        List id = new ArrayList<>();
        for (People people : peopleList) {
            province.add(people.getProvince());
            number.add(people.getNumber().toString());
            id.add(people.getId().toString());
        }
        chinaMap.put("province", province);
        chinaMap.put("number", number);
        chinaMap.put("id", id);
        return chinaMap;
    }

    @ApiOperation("数据修改")
    @PostMapping("/peopleList")
    @ResponseBody
    public Map> peopleList() {
        Map> chinaMap = new HashMap<>();
        List peopleList = peopleService.queryAll();
        chinaMap.put("peopleList", peopleList);
        return chinaMap;
    }

    @ApiOperation("数据修改")
    @PostMapping("/updatePeople")
    @ResponseBody
    public void updatePeople(@RequestBody People people) {
        peopleService.update(people.getProvince(),people.getNumber());
    }

    @ApiOperation("人口普查")
    @PostMapping("/sortPeople")
    @ResponseBody
    public Map> sortPeople() {
        Map> chinaMap = new HashMap<>();
        List peopleList = peopleService.queryAllBySort();
        List province = new ArrayList<>();
        List number = new ArrayList<>();
        List id = new ArrayList<>();
        for (People people : peopleList) {
            province.add(people.getProvince());
            number.add(people.getNumber().toString());
            id.add(people.getId().toString());
        }
        chinaMap.put("province", province);
        chinaMap.put("number", number);
        chinaMap.put("id", id);
        return chinaMap;
    }
}

 RegistController
package com.echarts.controller;

import com.echarts.dto.requestDto.RegistRequestDto;
import com.echarts.dto.responseDto.LoginResponseDto;
import com.echarts.entity.User;
import com.echarts.service.UserService;
import com.echarts.util.Md5Util;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.HashMap;
import java.util.Map;


@Api(tags = "注册")
@Controller
public class RegistController extends BaseController {

    @Autowired
    private UserService userService;

    @ApiOperation(value = "注册页面")
    @GetMapping("regist")
    public String login() {
        return "regist";
    }


    @ApiOperation(value = "注册验证")
    @PostMapping("/checkRegist")
    @ResponseBody
    public Map checkRegist(@RequestBody RegistRequestDto registRequestDto) {
        Map modelMap = new HashMap<>();
        //获取用户名
        String username = registRequestDto.getUsername();
        //获取密码
        String password = registRequestDto.getPassword();
        if ("".equals(username) || "".equals(password)) {
            modelMap.put("success", false);
            modelMap.put("errMsg", "用户名或密码不可为空");
        } else {
            //通过用户名密码查库
            LoginResponseDto userInfo = userService.getUserInfoByUsernameAndPassword(username, password);
            if (null != userInfo) {
                modelMap.put("success", false);
                modelMap.put("errMsg", "用户已存在");
            } else {
                modelMap.put("success", true);
                User user = new User();
                user.setUsername(username);
                user.setPassword(Md5Util.getMd5(password));
                userService.insert(user);
            }
        }
        return modelMap;
    }
}

UserController
package com.echarts.controller;

import com.echarts.dto.requestDto.PasswordRequestDto;
import com.echarts.dto.responseDto.LoginResponseDto;
import com.echarts.entity.User;
import com.echarts.service.UserService;
import com.echarts.util.Md5Util;
import io.swagger.annotations.ApiOperation;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.util.HashMap;
import java.util.Map;


@Controller
@RequestMapping("user")
public class UserController extends LoginController {
    
    @Resource
    private UserService userService;

    
    @GetMapping("selectOne")
    public User selectOne(Integer id) {
        return this.userService.queryById(id);
    }

    @ApiOperation(value = "用户信息")
    @GetMapping("userInfo")
    public String userInfo() {
        request.getSession().setAttribute("pageName", "个人信息");
        return "userInfo";
    }

    @ApiOperation(value = "修改密码")
    @GetMapping("userPassword")
    public String userPassword() {
        request.getSession().setAttribute("pageName", "修改密码");
        return "userPassword";
    }

    @PostMapping("queryUser")
    @ApiOperation(value = "查看指定用户信息")
    @ResponseBody
    public Map queryUserByUsername() {
        Map map = new HashMap<>();
        User user = null;
        try {
            LoginResponseDto userInfo = (LoginResponseDto) request.getSession().getAttribute("userInfo");
            String username = userInfo.getUserName();
            user = userService.queryByUsername(username);
        } catch (Exception e) {
            map.put("success", false);
            map.put("errMsg", e.getMessage());
            return map;
        }
        map.put("success", true);
        map.put("data", user);
        return map;
    }

    @PostMapping("editPassword")
    @ApiOperation(value = "修改指定用户信息")
    @ResponseBody
    public Map editPassword(@RequestBody PasswordRequestDto requestDto) {
        Map map = new HashMap<>();
        String oldPassword = requestDto.getOldPassword();
        String newPassword = requestDto.getNewPassword();
        String rePassword = requestDto.getRePassword();
        LoginResponseDto userInfo = (LoginResponseDto) request.getSession().getAttribute("userInfo");
        String userName = userInfo.getUserName();
        User user = userService.queryByUsername(userName);
        String resultPassword = user.getPassword();
        if (resultPassword.equals(Md5Util.getMd5(oldPassword))) {
            if (!oldPassword.equals(newPassword)) {
                if (newPassword.equals(rePassword)) {
                    try {
                        userService.updatePassword(userName, newPassword);
                    } catch (Exception e) {
                        map.put("success", false);
                        map.put("errMsg", e.getMessage());
                        return map;
                    }
                } else {
                    map.put("success", false);
                    map.put("errMsg", "确认密码不一致");
                    return map;
                }
            } else {
                map.put("success", false);
                map.put("errMsg", "不能与初始密码相同");
                return map;
            }
        } else {
            map.put("success", false);
            map.put("errMsg", "旧密码错误");
            return map;
        }
        map.put("success", true);
        return map;
    }
}

interceptor登陆拦截器

LoginInterceptor
package com.echarts.interceptor;

import com.echarts.dto.responseDto.LoginResponseDto;
import org.springframework.web.servlet.handler.HandlerInterceptorAdapter;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class LoginInterceptor extends HandlerInterceptorAdapter {

    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
        Object userObject = request.getSession().getAttribute("userInfo");
        if (userObject != null) {
            LoginResponseDto userInfo = (LoginResponseDto) userObject;
            if (userInfo.getId() != null) {
                //如果用户已经登录,url为/login或者/,就自动跳转/main
                if (request.getRequestURI().toLowerCase().contains("login") || "/".equals(request.getRequestURI())) {
                    response.sendRedirect("/main");
                    return false;
                }
                return true;
            }
        }
        if (request.getRequestURI().toLowerCase().contains("login") || "/".equals(request.getRequestURI())) {
            return true;
        }
        response.sendRedirect("login");
        return false;
    }
}

config配置类

SwaggerConfig
package com.echarts.config;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import springfox.documentation.builders.ApiInfoBuilder;
import springfox.documentation.builders.PathSelectors;
import springfox.documentation.builders.RequestHandlerSelectors;
import springfox.documentation.service.ApiInfo;
import springfox.documentation.spi.DocumentationType;
import springfox.documentation.spring.web.plugins.Docket;
import springfox.documentation.swagger2.annotations.EnableSwagger2;


@Configuration
@EnableSwagger2
public class SwaggerConfig {

    @Bean
    public Docket api() {
        return new Docket(DocumentationType.SWAGGER_2)
                .apiInfo(apiInfo())
                .select()
                .apis(RequestHandlerSelectors.any())
                .paths(PathSelectors.any())
                .build();

    }

    private ApiInfo apiInfo() {
        return new ApiInfoBuilder()
                .title("Echarts")
                .version("v1.0")
                .termsOfServiceUrl("http://localhost:8080/main")
                .build();
    }
}

util工具类

CodeUtil
package com.echarts.util;

import com.google.code.kaptcha.Constants;

import javax.servlet.http.HttpServletRequest;


public class CodeUtil {
    
    public static boolean checkVerifyCode(HttpServletRequest request, String verifyCodeActual) {
        //生成的验证码
        String verifyCodeExpected = (String) request.getSession().getAttribute(Constants.KAPTCHA_SESSION_KEY);
        //用户输入验证码
        verifyCodeActual = verifyCodeActual.toUpperCase();
        if (verifyCodeActual == null || !verifyCodeExpected.equalsIgnoreCase(verifyCodeActual)){
            return false;
        }
        return true;
    }
}

Md5Util  

package com.echarts.util;

import java.security.MessageDigest;


public class Md5Util {

    public static String getMd5(String origin) {

        //自定义数组,相当于盐
        char[] hexArray = {
                '5', 'a', '4', 'b', '9', '6', '8', 'f', 'e', '2', '2', '7', 'e', 'o', 'g', '0'
        };
        try {
            byte[] originBytes = origin.getBytes();
            //md5加密实例
            MessageDigest md5Instance = MessageDigest.getInstance("MD5");
            md5Instance.update(originBytes);
            //加密后数组
            byte[] digest = md5Instance.digest();
            //加盐数组
            char[] str = new char[digest.length * 2];
            int k = 0;
            //对加密数组加盐
            //判断数组长度,遍历数组,对每个数组进行移位运算(二进制)
            for (byte b : digest) {
                //0xf(16进制):1111(2进制)
                str[k++] = hexArray[b >>> 4 & 0xf];
                str[k++] = hexArray[b & 0xf];
            }
            return new String(str);
        } catch (Exception e) {
            e.printStackTrace();
            return "123456";
        }
    }

    public static void main(String[] args) {
        System.out.println(Md5Util.getMd5("1513"));
    }
}

mybatis映射文件

PeopleDao.xml




    
        
        
        
    

    
    
        select id, province, number
        from echarts.people
    

    
        select id, province, number
        from echarts.people
        order by number desc
    

    
    
        update echarts.people
        set number = #{number}
        where province = #{province}
    


UserDao.xml





    
        
        
        
    

    
    
        select id,
               username,
               password
        from echarts.user
        limit #{offset}, #{limit}
    

    
    
        select id, username, password
        from echarts.user
        where username = #{username}
          and password = #{password}
    
    

 spring配置文件

application.xml


    
    
        
        
    
    
    
        
            
                
                    
                        text/html;charset=UTF-8
                        application/json;charset=UTF-8
                    
                
            
        
    
    
    
        
        
            
                UTF-8
            
        
    
    
        
        
        
    
    
        
            
            
            
            
            
            
            
            
            
            
            
            
            
            
            
            
            
        
    
    
        
    
    
        
        
    
    
        
    

 数据库配置文件

jdbc.properties
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/echarts?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false
jdbc.username=root
jdbc.password=1513

sql 
use echarts;
drop table if exists user;
create table user(
    id integer primary key auto_increment,
    username varchar(20),
    password varchar(20)
);
drop table if exists people;
create table people(
    id integer primary key auto_increment,
    province varchar(20),
    number integer
);
insert into people(province, number) values('北京','1961');
insert into people(province, number) values('辽宁','4374');
insert into people(province, number) values('吉林','2745');
insert into people(province, number) values('黑龙江','3831');
insert into people(province, number) values('四川','8041');
insert into people(province, number) values('湖北','5723');
insert into people(province, number) values('福建','3689');
insert into people(province, number) values('广东','10432');
insert into people(province, number) values('重庆','2884');
insert into people(province, number) values('湖南','6570');
insert into people(province, number) values('上海','2301');
insert into people(province, number) values('江苏','7866');
insert into people(province, number) values('浙江','5442');
insert into people(province, number) values('安徽','5950');
insert into people(province, number) values('天津','1293');
insert into people(province, number) values('山东','9579');
insert into people(province, number) values('山西','3571');
insert into people(province, number) values('河南','9402');
insert into people(province, number) values('河北','7185');
insert into people(province, number) values('内蒙古','2470');
insert into people(province, number) values('江西','4456');
insert into people(province, number) values('贵州','3474');
insert into people(province, number) values('云南','4596');
insert into people(province, number) values('西藏','300');
insert into people(province, number) values('陕西','3732');
insert into people(province, number) values('甘肃','2557');
insert into people(province, number) values('青海','562');
insert into people(province, number) values('宁夏','630');
insert into people(province, number) values('新疆','2181');
insert into people(province, number) values('广西','4602');
insert into people(province, number) values('海南','867');
insert into people(province, number) values('台湾','2356');

前端代码省略

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/978873.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号