发表于： 2018-03-02 23:10:54

今日完成：

1. 添加登陆web页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<div class="container">
    <h1>Welcome</h1>

    <form action="/school/check" method="post">
        <input name="name" type="text" placeholder="Username"><br/>
        <input name="password" type="password" placeholder="Password"><br/><br/>
        <button type="submit">Login</button>
        <br/>
        <br/>
        <br/>
        <br/>
    </form>
</div>

2. 在tiles中添加sign_in项目，使用index模板

<definition name="tiles_index_sign_in" extends="layout">
    <put-attribute name="title" value="登陆"/>
    <put-attribute name="header" value="/WEB-INF/views/index_sign_in_header.jsp"/>
    <put-attribute name="body" value="/WEB-INF/views/index_sign_in.jsp"/>
    <put-attribute name="footer" value="/WEB-INF/views/index_footer.jsp"/>
    <put-list-attribute name="cssPathList">
        <add-attribute value="/css/base.css"></add-attribute>
        <add-attribute value="/css/main.css"></add-attribute>
    </put-list-attribute>
</definition>

3. 修改数据库表和mapper，为学生表添加password

通过name查找password

<select id="findPasswordByName" resultType="java.lang.String" parameterType="java.lang.String">
select password
from students
where name = #{name, jdbcType=VARCHAR}
</select>

4. 创建一个md5类对密码进行加密

public class MD5 {
    public static final String KEY_MD5 = "MD5";

    public static String getResult(String inputStr) {
        BigInteger bigInteger = null;
        try {
            MessageDigest md = MessageDigest.getInstance(KEY_MD5);
            byte[] inputData = inputStr.getBytes();
            md.update(inputData);
            bigInteger = new BigInteger(md.digest());
        } catch (Exception e) {
            e.printStackTrace();
        }
        return bigInteger.toString(16);
    }
}

5. 在controller里添加一个跳转到登陆界面的地址

@RequestMapping("/sign_in")
public String signIn() {
return "tiles_index_sign_in";
}

6. 账号密码登陆检查

@RequestMapping(value = "/check", method = RequestMethod.POST)
public ModelAndView check(@RequestParam("name") String name, @RequestParam("password") String password) {
    ModelAndView mav = new ModelAndView();
    boolean check = false;
    if (null != name && null != password && "" != name && "" != null) {
        String md = MD5.getResult(password);
        System.out.println(md);
        check = schoolService.check(name, md);
    }
    mav.addObject("name", name);
    mav.addObject("check", check);
    mav.setViewName("checking");
    return mav;
}

排除null和空的情况，使用md5加密

7. 登陆跳转jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<html>
<head>
    <title>checking</title>
</head>
<body>
<c:if test="${true==check}">
    <script>
        alert("登陆成功");
        window.location.href = "/school/index";
    </script>
</c:if>
<c:if test="${false==check}">
    <script>
        alert("登陆失败");
        window.location.href = "/school/sign_in"
    </script>
</c:if>
</body>
</html>