今天完成的事情：

模糊查询，解决昨天修改的时候不能单个修改的问题，看了一下restful风格，了解了动态SQL

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.DAO.StudentMapper">
    <!-- 根据ID查找用户 -->
    <select id="findUserById" parameterType="int" resultType="com.POJO.Student">
        select * from student where ID = #{id}
    </select>

    <!-- 根据姓名模糊查询 -->
    <select id="findUserByName" parameterType="java.lang.String" resultType="com.POJO.Student">
    select * from student where name like  '%${value}%'
    </select>

    <!-- 新增用户 -->
    <insert id="insertUser" parameterType="com.POJO.Student">
    insert into student(name,QQ,onlineNumber,enrollmentTime,professionType,dailyLink,promise,brotherName) values(#{name},#{QQ},#{onlineNumber},#{enrollmentTime},#{professionType},#{dailyLink},#{promise},#{brotherName})
    <selectKey keyProperty="ID" order="AFTER" resultType="java.lang.Integer">
    select last_insert_id()
    </selectKey>
    </insert>

    <!-- 根据ID删除用户 -->
    <delete id="deleteUser" parameterType="java.lang.Integer">
    delete from student where ID=#{id}
    </delete>

    <!-- 修改用户 -->
    <update id="updateUser" parameterType="com.POJO.Student">
        UPDATE student
        <set><!--set标签会去除只有最后一个条件的,-->
            <if test="name!= null and name!=''">name = #{name},</if>
            <if test="QQ!= null and QQ!=''">QQ = #{QQ},</if>
            <if test="onlineNumber!= null and onlineNumber!=''">onlineNumber = #{onlineNumber},</if>
            <if test="enrollmentTime!= null ">enrollmentTime = #{enrollmentTime},</if>
            <if test="professionType!= null and professionType!=''">professionType = #{professionType},</if>
            <if test="dailyLink!= null and dailyLink!=''">dailyLink = #{dailyLink},</if>
            <if test="promise!= null and promise!=''">promise = #{promise},</if>
            <if test="brotherName!= null and brotherName!=''">brotherName = #{brotherName},</if>
        </set>
        <where><!--where标签会去除第一个条件的and和or-->
            <if test="ID!=null">AND ID=#{ID}</if>
        </where>
    </update>
</mapper>

package com.controller;


import com.DAO.StudentMapper;
import com.POJO.Student;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

@Controller
@RequestMapping("/user")
public class mvcController {
    Student student;
    @Autowired
    StudentMapper studentMapper;
    @RequestMapping("/searchbyid")
    public String jumptosearchid( ) throws IOException {
        return "searchbyid";
    }
    /*
     * 根据ID查询信息
     *
     * */
    @RequestMapping(value = "/list",method = RequestMethod.GET)
    public String select( Integer ID, Model model) throws Exception {
        student = studentMapper.findUserById(ID);
        model.addAttribute("student", student);
        return "list";
    }
    /**
     * 新增用户
     */
    @RequestMapping("/new")
    public String turntoinsert( ) throws IOException {
        return "insert";
    }
    @RequestMapping(value = "/add")
    public String insert(Student newStudent,Model model) throws Exception {
        studentMapper.insertUser(newStudent);
        Integer a = newStudent.getID();
        model.addAttribute("message2",a);
        return "addcomplate";
    }
    /**
     * 删除用户
     */
    @RequestMapping(value = "/deletebyid/{ID}")
    public String delect(@PathVariable("ID") int ID, Model model) throws Exception {
        int a = studentMapper.deleteUser(ID);
        String message;
        if (a == 1) {
            message = "数据删除成功";
        } else {
            message = "数据删除失败";
        }
        model.addAttribute("message", message);
        return "deletebyid";
    }
    /**
     * 修改用户
     */
    @RequestMapping(value = "/list/{ID}",method = RequestMethod.GET)
    public String jumptoupdate(@PathVariable("ID") Integer ID, Model model) throws Exception {
        student = studentMapper.findUserById(ID);
        System.out.println(student);
        model.addAttribute("student", student);
        return "updatebyid";
    }
    @RequestMapping(value = "/updatecomplate")
    public String update(Student updatestudent,Model model) throws Exception {
        System.out.println(updatestudent);
        int s = studentMapper.updateUser(updatestudent);
        String message;
        if (s == 1) {
            message = "数据修改成功";
        } else {
            message = "数据修改失败";
        }
        model.addAttribute("message", message);
        return "updatecomplate";
    }
    /**
     * 根据姓名模糊查询
     */
    @RequestMapping(value = "/searchbyname")
    public String jumptosearchbyname() throws Exception {
        return "searchbyname";
    }
    @RequestMapping(value = "/listbyname",method = RequestMethod.GET)
    public String selectByName(String name, Model model) throws Exception {
        List<Student> studentlist = studentMapper.findUserByName(name);
        System.out.println(studentlist);
        model.addAttribute("lists",studentlist);
        return "listbyname";
    }
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>显示信息进行修改</title>
</head>
<body>
添加：
<br><form action="${pageContext.request.contextPath}/user/updatecomplate?ID=${student.ID}" method="post">
    姓名:<br><input type="text" name="name" value="${student.name}"><br>
    QQ:<br><input type="text" name="QQ" value="${student.QQ}"><br>
    线上学号:<br><input type="text" name="onlineNumber" value="${student.onlineNumber}"><br>
    毕业时间:<br><input type="text" name="enrollmentTime" value="${student.enrollmentTime}"><br>
    职业类型:<br><input type="text" name="professionType" value="${student.professionType}"><br>
    日报连接:<br><input type="text" name="dailyLink" value="${student.dailyLink}"><br>
    誓言:<br><input type="text" name="promise" value="${student.promise}"><br>
    师兄名称:<br><input type="text" name="brotherName" value="${student.brotherName}"><br>
    <input type="submit" value="提交">
</form><br>
<a href="/index.jsp">返回</a>
</body>
</html>

明天计划的事情：

完成时间格式转换 
遇到的问题：

 
收获：

大小写错误没有麻烦杨老师了，C标签记得引用