SSM项目 增删改查 分页 条件搜索分页

（无mybatis-plus,jpa,springData）

大致的界面

 

下面我直接上代码了，

如何创建项目的过程参考下面这个

参考：https://www.cnblogs.com/yeya/p/10320885.html

目录

 

 配置

 

数据表（数据库：ssmdemo）

/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : 127.0.0.1:3306
 Source Schema         : ssmdemo

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 24/09/2021 14:47:49
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_course
-- ----------------------------
DROP TABLE IF EXISTS `t_course`;
CREATE TABLE `t_course`  (
  `course_id` int(11) NOT NULL AUTO_INCREMENT,
  `course_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程名称',
  PRIMARY KEY (`course_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '课程表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_course
-- ----------------------------
INSERT INTO `t_course` VALUES (1, '语文');
INSERT INTO `t_course` VALUES (2, '数学');
INSERT INTO `t_course` VALUES (3, '英语');

-- ----------------------------
-- Table structure for t_dept
-- ----------------------------
DROP TABLE IF EXISTS `t_dept`;
CREATE TABLE `t_dept`  (
  `dept_id` int(11) NOT NULL AUTO_INCREMENT,
  `dept_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称',
  PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_dept
-- ----------------------------
INSERT INTO `t_dept` VALUES (1, '技术部');
INSERT INTO `t_dept` VALUES (2, '市场部');
INSERT INTO `t_dept` VALUES (3, '营销部');

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user`  (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `user_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户邮箱',
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户昵称',
  `user_mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号码',
  `dept_id` int(11) NULL DEFAULT NULL COMMENT '部门ID',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES (1, '18811098964@163.com', '张三1', '18811098964', 1);
INSERT INTO `t_user` VALUES (2, '18811098964@163.com', '李四', '18811098964', 1);
INSERT INTO `t_user` VALUES (3, '18811098964@163.com', '王五', '18811098964', 1);
INSERT INTO `t_user` VALUES (4, '18811098964@163.com', '张三', '18811098964', 1);
INSERT INTO `t_user` VALUES (5, '18811098964@163.com', '李四', '18811098964', 1);
INSERT INTO `t_user` VALUES (6, '18811098964@163.com', '王五', '18811098964', 1);
INSERT INTO `t_user` VALUES (7, '18811098964@163.com', '张三', '18811098964', 1);
INSERT INTO `t_user` VALUES (8, '18811098964@163.com', '李四', '18811098964', 1);
INSERT INTO `t_user` VALUES (9, '18811098964@163.com', '王五', '18811098964', 2);
INSERT INTO `t_user` VALUES (10, '18811098964@163.com', '张三', '18811098964', 2);
INSERT INTO `t_user` VALUES (11, '18811098964@163.com', '李四', '18811098964', 2);
INSERT INTO `t_user` VALUES (12, '18811098964@163.com', '王五', '18811098964', 3);
INSERT INTO `t_user` VALUES (16, '11.com@qq.com', 'test1111', '18811098964', 3);
INSERT INTO `t_user` VALUES (21, '3.com@qq.com', '张三', '18811098964', 3);

-- ----------------------------
-- Table structure for t_user_course
-- ----------------------------
DROP TABLE IF EXISTS `t_user_course`;
CREATE TABLE `t_user_course`  (
  `user_course_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID',
  `course_id` int(11) NULL DEFAULT NULL COMMENT '课程ID',
  PRIMARY KEY (`user_course_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '学生课程关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_user_course
-- ----------------------------
INSERT INTO `t_user_course` VALUES (1, 1, 1);
INSERT INTO `t_user_course` VALUES (2, 1, 3);
INSERT INTO `t_user_course` VALUES (3, 2, 2);
INSERT INTO `t_user_course` VALUES (4, 2, 3);
INSERT INTO `t_user_course` VALUES (5, 3, 2);

SET FOREIGN_KEY_CHECKS = 1;

代码

UserController

package com.example.back.controller;

import com.example.back.entity.CourseEntity;
import com.example.back.entity.UserEntity;
import com.example.back.param.user.UserListParam;
import com.example.back.service.CourseService;
import com.example.back.service.UserCourseService;
import com.example.back.service.UserService;
import org.springframework.stereotype.Controller;
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.annotation.Resource;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Controller
@RequestMapping("/user")
public class UserController {
    @Resource
    UserCourseService userCourseService;
    @Resource
    CourseService courseService;
    @Resource
    private UserService userService;
    /**
    　　* @Description: 单条数据查询
    　　* @Param ${tags}
    　　* @Return ${return_type}
    　　* @Author chenyunfeng
    　　* @Date 2021/9/17 18:37
    　　*/
    @RequestMapping("/select")
    public ModelAndView selectUser() throws Exception {
        ModelAndView mv = new ModelAndView();
        UserEntity user = userService.selectUser(1);
        mv.addObject("user", user);
        mv.setViewName("index");
        return mv;
    }
    /**
     * http://localhost:8080/ssmdemo/user/page
    　　* @Description: 分页
    　　* @Param ${tags}
    　　* @Return ${return_type}
    　　* @Author chenyunfeng
    　　* @Date 2021/9/17 18:37
    　　*/
    @RequestMapping("/page")
    public ModelAndView userPage(UserListParam userListParam) {
        ModelAndView mv = new ModelAndView();
        Map<String,Object> map=new HashMap<String,Object>();
        Integer pageno = userListParam.getPageno();
        Integer pagesize = userListParam.getPagesize();
        String userName =   userListParam.getUserName();
        //分页查询
        map.put("start", (pageno-1)*pagesize);
        map.put("size", pagesize);
        map.put("userName", userName);
        //查询用户的信息
        List<UserEntity> userData= userService.pageQueryData(map);
        //总记录条数//查询用户信息的条数
        int totalsize= userService.pageQueryCount(map);
        int totalno=0;//总页码
        if(totalsize % pagesize==0) {
            totalno=totalsize/pagesize;
        }else {
            totalno=totalsize/pagesize+1;
        }
        //返回
        map.put("userlist",userData);
        map.put("totalno",totalno);
        map.put("pageno",pageno);//当前页
        map.put("pagesize",pagesize);//每页的记录条数
        mv.addObject("data", map);
        mv.setViewName("back/user/index");
        return mv;
    }
    /**
    　　* @Description: 添加
    　　* @Param ${tags}
    　　* @Return ${return_type}
    　　* @Author chenyunfeng
    　　* @Date 2021/9/17 18:37
    　　*/
    @RequestMapping("/add")
    public ModelAndView add() {
        ModelAndView mv = new ModelAndView();
        mv.setViewName("back/user/add");
        return mv;
    }
    @RequestMapping("/addDo")
    public String  addDo(UserEntity userEntity) {
        userService.insertUser(userEntity);
        return "redirect:/user/page";
    }
    /**
    　　* @Description: 删除
    　　* @Param ${tags}
    　　* @Return ${return_type}
    　　* @Author chenyunfeng
    　　* @Date 2021/9/17 18:37
    　　*/
    @RequestMapping("/deleteUser/{userId}")
    public String deleteUser(@PathVariable("userId") Integer userId){
        userService.deleteUser(userId);
        return "redirect:/user/page";
    }
    /**
    　　* @Description: 编辑
    　　* @Param ${tags}
    　　* @Return ${return_type}
    　　* @Author chenyunfeng
    　　* @Date 2021/9/17 18:37
    　　*/
//    @RequestMapping("/edittUser/{userId}")
//    public ModelAndView edittUser(@PathVariable("userId") Long userId) {

    @RequestMapping(value = "/edittUser/{userId}", method = RequestMethod.GET)
    public ModelAndView edittUser(@PathVariable("userId") Integer userId) {
        ModelAndView mv = new ModelAndView();
        UserEntity user = userService.selectUser(userId);
        mv.addObject("user", user);
        mv.setViewName("back/user/edit");
        return mv;
    }
    @RequestMapping("/editDo")
    public String editDo(UserEntity userEntity) {
         userService.updateUser(userEntity);
         return "redirect:/user/page";
    }
    /**
    　　* @Description: 详情
    　　* @Param ${tags}
    　　* @Return ${return_type}
    　　* @Author chenyunfeng
    　　* @Date 2021/9/22 10:32
    　　*/
    @RequestMapping(value = "/detailCourse/{userId}", method = RequestMethod.GET)
    public ModelAndView detailCourse(@PathVariable("userId") Integer userId) {
        ModelAndView mv = new ModelAndView();
        //查询当前人信息
        UserEntity userDetailCourse = userService.selectUser(userId);
        //查询当前人课程（一个人可选多个课程）
        List<CourseEntity> courseEntity = courseService.selectCourseByUserId(userId);
        userDetailCourse.setCourseEntity(courseEntity);
        mv.addObject("userDetailCourse", userDetailCourse);
        mv.setViewName("back/user/detailcourse");
        return mv;
    }




}

CourseDao

package com.example.back.dao;

import com.example.back.entity.CourseEntity;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface CourseDao {
    List<CourseEntity> selectCourseByUserId(Integer userId);
}

UserCourseDao

package com.example.back.dao;

import com.example.back.entity.UserCourseEntity;
import org.springframework.stereotype.Repository;

@Repository
public interface UserCourseDao {


    UserCourseEntity detailCourse(Integer userId);



}

UserDao

package com.example.back.dao;

import com.example.back.entity.UserEntity;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;
@Repository
public interface UserDao {


    UserEntity selectUser(Integer userId);

    List<UserEntity> pageQueryData(Map<String,Object> map);

    int pageQueryCount(Map<String,Object> map);

    int insertUser(UserEntity userEntity);

    int deleteUser(Integer userId);

    int updateUser(UserEntity addUser);


}

BaseEntity

package com.example.back.entity;

import java.io.Serializable;

public class BaseEntity implements Serializable
{
    private static final long serialVersionUID = 1L;

}

CourseEntity

package com.example.back.entity;

import lombok.Data;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Data
@Entity
@Table(name = "t_course")
public class CourseEntity extends BaseEntity {
    @Id
    @Column(name = "course_id")
    private long courseId;
    @Column(name = "course_name")
    private String courseName;

}

DeptEntity

package com.example.back.entity;

import lombok.Data;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.List;

@Data
@Entity
@Table(name = "t_dept")
public class DeptEntity extends BaseEntity {
    @Id
    @Column(name = "dept_id")
    private long deptId;
    @Column(name = "dept_name")
    private String deptName;
}

UserCourseEntity

package com.example.back.entity;

import lombok.Data;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Data
@Entity
@Table(name = "t_user_course")
public class UserCourseEntity  extends BaseEntity{
    @Id
    @Column(name = "user_course_id")
    private long userCourseId;
    @Column(name = "user_id")
    private String userId;
    @Column(name = "course_id")
    private String courseId;


}

UserEntity

package com.example.back.entity;

import lombok.Data;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.List;

@Data
@Entity
@Table(name = "t_user")
public class UserEntity extends BaseEntity {
    @Id
    @Column(name = "user_id")
    private long userId;
    @Column(name = "user_email")
    private String userEmail;
    @Column(name = "user_name")
    private String userName;
    @Column(name = "user_mobile")
    private String userMobile;
    //一对一(一个人只有一个部门)
    private DeptEntity dept;
    public DeptEntity getDept() {
        if (dept == null)
        {
            dept = new DeptEntity();
        }
        return dept;
    }
    public void setDept(DeptEntity dept) {
        this.dept = dept;
    }

    //一对多 (一个人学好几门课程)
    private List<CourseEntity> courseEntity;
    public List<CourseEntity> getCourseEntity() {
        return courseEntity;
    }
    public void setCourseEntity(List<CourseEntity> courseEntity) {
        this.courseEntity = courseEntity;
    }

}

UserListParam

package com.example.back.param.user;

import com.example.back.param.Page;
import lombok.Data;

@Data
public class UserListParam extends Page {
    private String userName;
}

Page

package com.example.back.param;

import lombok.Data;
@Data
public class Page {
    private Integer pageno = 1;
    private Integer pagesize = 3;

//    public Integer getPageno() {
//        return pageno;
//    }
//
//    public void setPageno(Integer pageno) {
//        this.pageno = pageno == null ? null : 1;
//    }
//
//    public Integer getPagesize() {
//        return pagesize;
//    }
//
//    public void setPagesize(Integer pagesize) {
//        this.pagesize = pagesize == null ? null : 10;
//
//    }
}

CourseServiceImpl

package com.example.back.service.impl;

import com.example.back.entity.CourseEntity;
import com.example.back.dao.CourseDao;
import com.example.back.service.CourseService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class CourseServiceImpl implements CourseService {
    @Autowired
    private CourseDao courseDao;

    @Override
    public List<CourseEntity> selectCourseByUserId(Integer userId) {
        return courseDao.selectCourseByUserId(userId);
    }

}

UserCourseServiceImpl

package com.example.back.service.impl;

import com.example.back.dao.UserCourseDao;
import com.example.back.service.UserCourseService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserCourseServiceImpl implements UserCourseService {
    @Autowired
    private UserCourseDao userCourseDao;

}

UserServiceImpl

package com.example.back.service.impl;

import com.example.back.dao.UserDao;
import com.example.back.entity.UserEntity;
import com.example.back.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
import java.util.Map;

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserDao userDao;

    @Override
    public UserEntity selectUser(Integer userId) {
        UserEntity userEntity= userDao.selectUser(userId);
        return userEntity;
    }

    @Override
    public List<UserEntity> pageQueryData(Map<String, Object> map) {
        return userDao.pageQueryData(map);
    }
    /**
     * 数量
     * @param map
     * @return
     */
    @Override
    public int pageQueryCount(Map<String, Object> map) {
        return userDao.pageQueryCount(map);
    }

    /**
     * 添加
     * @param
     */
    @Override
    public int insertUser(UserEntity userEntity) {
        return userDao.insertUser(userEntity);
    }
    /**
     * 删除
     * @param
     * @return
     */
    @Override
    public int deleteUser(Integer userId) {
        return userDao.deleteUser(userId);
    }
    /**
     * 编辑
     * @param
     * @return
     */
    @Override
    public int updateUser(UserEntity addUser) {
        return userDao.updateUser(addUser);
    }
}

CourseService

package com.example.back.service;

import com.example.back.entity.CourseEntity;

import java.util.List;

public interface CourseService {

    List<CourseEntity> selectCourseByUserId(Integer userId);
}

UserCourseService

package com.example.back.service;

public interface UserCourseService {


}

UserService

package com.example.back.service;

import com.example.back.entity.UserEntity;

import java.util.List;
import java.util.Map;

public interface UserService {

    public UserEntity selectUser(Integer userId);

    List<UserEntity> pageQueryData(Map<String, Object> map);

    int pageQueryCount(Map<String, Object> map);

    int insertUser(UserEntity userEntity);

    int deleteUser(Integer userId);

    int updateUser(UserEntity addUser);



}

JsonResult

package com.example.back.utils;
import lombok.Data;
import lombok.experimental.Accessors;
@Data
@Accessors(chain = true)
public class JsonResult<T> {
    private T data;
    private String code;
    private String msg;

    /**
     * 若没有数据返回，默认状态码为0，提示信息为：操作成功！
     */
    public JsonResult() {
        this.code = "0";
        this.msg = "操作成功！";
    }

    /**
     * 若没有数据返回，可以人为指定状态码和提示信息
     *
     * @param code
     * @param msg
     */
    public JsonResult(String code, String msg) {
        this.code = code;
        this.msg = msg;
    }

    /**
     * 有数据返回时，状态码为0，默认提示信息为：操作成功！
     *
     * @param data
     */
    public JsonResult(T data) {
        this.data = data;
        this.code = "0";
        this.msg = "操作成功！";
    }

    /**
     * 有数据返回，状态码为0，人为指定提示信息
     *
     * @param data
     * @param msg
     */
    public JsonResult(T data, String msg) {
        this.data = data;
        this.code = "0";
        this.msg = msg;
    }
    // 省略get和set方法
}

CourseMapper.xml

<?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">

<!-- 设置为Dao接口方法提供sql语句配置 -->
<mapper namespace="com.example.back.dao.CourseDao">
    <resultMap type="CourseEntity" id="BaseResultMap">
        <id property="courseId" column="course_id"/>
        <result property="courseName" column="course_name"/>
    </resultMap>

    <select id="selectCourseByUserId" parameterType="java.lang.Integer"  resultMap="BaseResultMap">
        SELECT * FROM t_course where course_id
        in ( SELECT course_id FROM t_user_course where user_id=#{userId} )
    </select>
</mapper>

DeptMapper.xml

<?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">

<!-- 设置为Dao接口方法提供sql语句配置 -->
<mapper namespace="com.example.back.dao.DeptDao">
    <resultMap type="com.example.back.entity.DeptEntity" id="BaseResultMap">
        <id property="deptId" column="dept_id"/>
        <result property="deptName" column="dept_name"/>
    </resultMap>
</mapper>

UserCourseMapper.xml

<?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">

<!-- 设置为Dao接口方法提供sql语句配置 -->
<mapper namespace="com.example.back.dao.UserCourseDao">




</mapper>

UserMapper.xml

<?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">

<!-- 设置为Dao接口方法提供sql语句配置 -->
<mapper namespace="com.example.back.dao.UserDao">
    <resultMap type="com.example.back.entity.UserEntity" id="BaseResultMap">
        <id property="userId" column="user_id"/>
        <result property="userEmail" column="user_email"/>
        <result property="userName" column="user_name"/>
        <result property="userMobile" column="user_mobile"/>
<!--        一对一-->
        <association property="dept"     column="dept_id" javaType="DeptEntity" resultMap="deptResult" />
<!--        一对多  注意javaType是list   《仅供学习 此处采用控制器set方式，不用xml关联这种方式》-->
<!--        <collection  property="courseEntity"   javaType="java.util.List"        resultMap="courseResult" />-->
    </resultMap>

    <resultMap id="deptResult" type="DeptEntity">
        <id     property="deptId"   column="dept_id"     />
        <result property="deptName" column="dept_name"   />
    </resultMap>
<!--    <resultMap id="courseResult" type="CourseEntity">-->
<!--        <id property="courseId" column="course_id"/>-->
<!--        <result property="courseName" column="course_name"/>-->
<!--    </resultMap>-->

    <insert id="insertUser" parameterType="com.example.back.entity.UserEntity" useGeneratedKeys="true" keyProperty="userId" >
        insert into t_user(
        <if test="userId != null and userId != ''">user_id,</if>
        <if test="userEmail != null and userEmail != ''">user_email,</if>
        <if test="userName != null and userName != ''">user_name,</if>
        <if test="userMobile != null and userMobile != ''">user_mobile</if>
        )values(
        <if test="userId != null and userId != ''">#{userId},</if>
        <if test="userEmail != null and userEmail != ''">#{userEmail},</if>
        <if test="userName != null and userName != ''">#{userName},</if>
        <if test="userMobile != null and userMobile != ''">#{userMobile}</if>
         )
    </insert>
    <delete id="deleteUser" parameterType="java.lang.Integer">
        delete from t_user where user_id = #{userId}
    </delete>
    <update id="updateUser" parameterType="com.example.back.entity.UserEntity">
        update t_user
        <set>
            <if test="userEmail != null and userEmail != ''">user_email = #{userEmail},</if>
            <if test="userName != null and userName != ''">user_name = #{userName},</if>
            <if test="userMobile != null and userMobile != ''">user_mobile = #{userMobile},</if>

        </set>
        where user_id = #{userId}
    </update>

    <select id="selectUser" parameterType="java.lang.Integer" resultMap="BaseResultMap" >
        select t_user.user_id, t_user.user_email, t_user.user_name, t_user.user_mobile,
        t_dept.dept_name
        from t_user
        INNER JOIN t_dept
        ON  t_user.dept_id =  t_dept.dept_id
         WHERE user_id = #{userId}
    </select>

    <!--条件分页-->
    <select id="pageQueryData" parameterType="java.util.Map" resultMap="BaseResultMap">
        select t_user.user_id, t_user.user_email, t_user.user_name, t_user.user_mobile,
        t_dept.dept_name
        from t_user
        INNER JOIN t_dept
        ON  t_user.dept_id =  t_dept.dept_id
        <where>
            1 = 1
            <if test="userName != null and userName != ''">
                AND t_user.user_name like concat('%', #{userName}, '%')
            </if>
        </where>
        order by t_user.user_id asc limit #{start},#{size}
    </select>
    <!--数量查询-->
    <select id="pageQueryCount" parameterType="java.util.Map" resultType="java.lang.Integer">
        select count(*) from  t_user
        <where>
            1 = 1
            <if test="userName != null and userName != ''">
                AND user_name like concat('%', #{userName}, '%')
            </if>
        </where>
    </select>




</mapper>

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
                        http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
                        http://www.springframework.org/schema/tx
                        http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

    <!-- 加载properties文件 -->
    <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:jdbc.properties"/>
    </bean>

    <!-- 配置数据源 -->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
    </bean>

    <!-- mybatis和spring完美整合，不需要mybatis的配置映射文件 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <!-- 扫描Entity包 -->
        <property name="typeAliasesPackage" value="com.example.back.entity"/>
        <!-- 扫描sql配置文件:mapper需要的xml文件-->
        <property name="mapperLocations" value="classpath:mapper/*.xml"/>
    </bean>

    <!-- Mapper动态代理开发，扫描dao接口包-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!-- 注入sqlSessionFactory -->
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        <!-- 给出需要扫描mapper接口包 -->
        <property name="basePackage" value="com.example.back.dao"/>
    </bean>

    <!-- 事务管理 -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <!--数据库连接池-->
        <property name="dataSource" ref="dataSource"/>
    </bean>
</beans>

jdbc.properties

driver=com.mysql.jdbc.Driver    
url=jdbc:mysql://127.0.0.1:3306/ssmdemo?characterEncoding=utf8&useSSL=false
#数据库的用户名
username=root
#数据库的密码，别像我一样不设置
password=123456
#定义初始连接数
initialSize=0
#定义最大连接数
maxActive=20
#定义最大空闲
maxIdle=20
#定义最小空闲
minIdle=1
#定义最长等待时间
maxWait=60000

log4j.properties

#日志输出级别
log4j.rootLogger=debug,stdout,D,E

#设置stdout的日志输出控制台
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
#输出日志到控制台的方式，默认为System.out
log4j.appender.stdout.Target = System.out
#设置使用灵活布局
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
#灵活定义输出格式
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss,SSS} -[%p]  method:[%c (%rms)] - %m%n

spring-mvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd
       http://www.springframework.org/schema/mvc
       http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">

    <!-- 扫描注解，这样com.xjt包下的文件都能被扫描 -->
    <context:component-scan base-package="com.example.back"/>

    <!-- 开启SpringMVC注解模式 -->
    <mvc:annotation-driven/>

    <!-- 静态资源默认servlet配置 -->
    <mvc:default-servlet-handler/>

    <!-- 配置返回视图的路径，以及识别后缀是jsp文件 -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
        <property name="prefix" value="/WEB-INF/jsp/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
</beans>

add.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>用户管理</title>
</head>
<body>
<div style="text-align: center;">
<form action="/ssmdemo/user/addDo" method="POST">
    <h2>信息添加</h2>
    用户邮箱<input type="email" name="userEmail"><br>
    用户昵称<input type="text" name="userName"><br>
    手机号码<input type="tel" name="userMobile"><br>
    <input type="submit" value="提交"><br>
</form>
</div>

</body>
</html>

detailcourse.jsp

没有

edit.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>用户管理</title>
</head>
<body>
<div style="text-align: center;">
<form action="/ssmdemo/user/editDo" method="POST">
    <h2>信息编辑</h2>
    <input type="hidden" name="userId" value="${requestScope.user.userId}"><br>
    用户邮箱<input type="email" name="userEmail" value="${requestScope.user.userEmail}"><br>
    用户昵称<input type="text" name="userName" value="${requestScope.user.userName}"><br>
    手机号码<input type="tel" name="userMobile" value="${requestScope.user.userMobile}"><br>
    <input type="submit" value="提交"><br>
</form>
</div>

</body>
</html>

index.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>用户管理</title>
    <style>
        li{
            list-style-type:none;
            width:75px;
            float: left;
        }
    </style>
</head>
<body>
<div style="text-align: center;">
    <div style="padding-left: 30%;">
        <a href="/ssmdemo/user/add" >添加</a><br>
    </div>
    <div style="padding-right: 45%;">
        <form action="/ssmdemo/user/page" method="POST" >
            用户昵称<input type="text" name="userName" value="${requestScope.data.userName}">
            <input  type="submit" value="搜索"><br>
        </form>
    </div>

<table  border="1" style="margin: auto;" width='60%'>
    <thead>
        <th>编号</th>
        <th>邮箱</th>
        <th>用户名</th>
        <th>手机号</th>
        <th>部门</th>
        <th>操作</th>
        <th>详情</th>
    </thead>
    <tbody>
        <c:forEach items="${requestScope.data.userlist}" var="u">
            <tr>
                <td>${u.userId}</td>
                <td>${u.userEmail}</td>
                <td>${u.userName}</td>
                <td>${u.userMobile}</td>
                <td>${u.dept.deptName}</td>
                <td>
                    <a href="/ssmdemo/user/edittUser/${u.userId}">编辑</a>
                |
                    <a href="/ssmdemo/user/deleteUser/${u.userId}">删除</a>
                </td>
                <td><a href="/ssmdemo/user/detailCourse/${u.userId}">详情</a></td>
            </tr>
        </c:forEach>
    </tbody>
</table>
    <br>
    <br>
<div style="display: flex;justify-content: flex-end; padding-right: 30%">
   <ul>
       <c:if test="${requestScope.data.pageno<=1}">
            <li><a href='/ssmdemo/user/page?pageno=1&userName=${requestScope.data.userName}'>←上一页</a></li>
       </c:if>
       <c:if test="${requestScope.data.pageno>1}">
           <li><a href='/ssmdemo/user/page?pageno=${requestScope.data.pageno-1}&userName=${requestScope.data.userName}'>←上一页</a></li>
       </c:if>
            <c:forEach varStatus="i" begin="1" end="${requestScope.data.totalno}">
                <c:choose>
                    <c:when test="${requestScope.data.pageno==i.count}">
                        <li class='disabled'>${i.count}</li>
                    </c:when>
                    <c:otherwise>
                        <li  class='active' style="color: red;"><a href='/ssmdemo/user/page?pageno=${i.count}&userName=${requestScope.data.userName}'>${i.count}</a></li>
                    </c:otherwise>
                </c:choose>
            </c:forEach>
<%--       <c:if test="${requestScope.data.pageno<requestScope.data.pageno.totalno}">--%>
       <c:if test="${requestScope.data.pageno<requestScope.data.totalno}">
            <li><a href='/ssmdemo/user/page?pageno=${requestScope.data.pageno+1}&userName=${requestScope.data.userName}'>下一页→</a></li>
       </c:if>
       <c:if test="${requestScope.data.pageno>=requestScope.data.totalno}">
           <li><a href='/ssmdemo/user/page?pageno=${requestScope.data.totalno}&userName=${requestScope.data.userName}'>下一页→</a></li>
       </c:if>
    </ul>
</div>

</div>

</body>
</html>

web.xml

<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
         version="3.1">

  <display-name>mvcDemo</display-name>
  <!--项目的欢迎页，项目运行起来后访问的页面-->
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>

  <!-- 注册ServletContext监听器，创建容器对象，并且将ApplicationContext对象放到Application域中 -->
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>

  <!-- 指定spring核心配置文件 -->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:applicationContext.xml</param-value>
  </context-param>

  <!-- 解决乱码的过滤器 -->
  <filter>
    <filter-name>CharacterEncodingFilter</filter-name>
    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    <init-param>
      <param-name>encoding</param-name>
      <param-value>utf-8</param-value>
    </init-param>

    <init-param>
      <param-name>forceEncoding</param-name>
      <param-value>true</param-value>
    </init-param>
  </filter>
  <filter-mapping>
    <filter-name>CharacterEncodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>

  <!-- 配置前端控制器 -->
  <servlet>
    <servlet-name>springmvc</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <!-- 指定配置文件位置和名称 如果不设置,默认找/WEB-INF/<servlet-name>-servlet.xml -->
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:spring-mvc.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
    <async-supported>true</async-supported>
  </servlet>

  <servlet-mapping>
    <servlet-name>springmvc</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>

</web-app>

index.jsp

<html>
<body>
<h2>Hello World!</h2>
${requestScope.user}
</body>
</html>

pom.xml

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>org.example</groupId>
  <artifactId>ssmDemo</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>ssmDemo Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.7</maven.compiler.source>
    <maven.compiler.target>1.7</maven.compiler.target>
    <!-- 用来设置版本号 -->
    <srping.version>4.0.2.RELEASE</srping.version>
    <mybatis.version>3.2.8</mybatis.version>
    <slf4j.version>1.7.12</slf4j.version>
    <log4j.version>1.2.17</log4j.version>
    <druid.version>1.0.9</druid.version>
  </properties>
  <!-- 用到的jar包 -->
  <dependencies>
    <!-- 单元测试 -->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <!-- 表示开发的时候引入，发布的时候不会加载此包 -->
      <scope>test</scope>
    </dependency>
    <!-- spring框架包 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>${srping.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>${srping.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-oxm</artifactId>
      <version>${srping.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>${srping.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${srping.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aop</artifactId>
      <version>${srping.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>${srping.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context-support</artifactId>
      <version>${srping.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-expression</artifactId>
      <version>${srping.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-orm</artifactId>
      <version>${srping.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>${srping.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${srping.version}</version>
    </dependency>
    <!-- spring框架包 -->
    <!-- mybatis框架包 -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>${mybatis.version}</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.2.2</version>
    </dependency>
    <!-- mybatis框架包 -->
    <!-- 数据库驱动 -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.35</version>
    </dependency>
    <!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 -->
    <dependency>
      <groupId>commons-dbcp</groupId>
      <artifactId>commons-dbcp</artifactId>
      <version>1.4</version>
    </dependency>
    <!-- jstl标签类 -->
    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>
    <!-- log -->
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>${log4j.version}</version>
    </dependency>
    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-api</artifactId>
      <version>${slf4j.version}</version>
    </dependency>
    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-log4j12</artifactId>
      <version>${slf4j.version}</version>
    </dependency>
    <!-- 连接池 -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>${druid.version}</version>
    </dependency>
      <dependency>
          <groupId>org.projectlombok</groupId>
          <artifactId>lombok</artifactId>
          <version>1.18.16</version>
          <scope>compile</scope>
      </dependency>
      <dependency>
          <groupId>javax.persistence</groupId>
          <artifactId>javax.persistence-api</artifactId>
          <version>2.2</version>
      </dependency>

    <!-- HttpServletRequest
    https://www.cnblogs.com/ningheshutong/p/6426159.html-->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>servlet-api</artifactId>
      <version>2.5</version>
      <scope>provided</scope>
    </dependency>

    <!-- @Entity和@Table注解该如何添加包？
    https://blog.csdn.net/ostar_liang/article/details/79918705-->
    <dependency>
      <groupId>javax.persistence</groupId>
      <artifactId>persistence-api</artifactId>
      <version>1.0</version>
    </dependency>

  </dependencies>

  <build>
    <!-- java编译插件,如果maven的设置里配置好jdk版本就不用 -->
    <finalName>ssmDemo</finalName>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.1.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
<!--        <plugin>-->
<!--          <artifactId>maven-compiler-plugin</artifactId>-->
<!--          <version>3.8.0</version>-->
<!--        </plugin>-->
        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.22.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <version>3.2.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
        <!-- java编译插件,如果maven的设置里配置好jdk版本就不用 -->
        <plugin>
          <groupId>org.apache.maven.plugins</groupId>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.2</version>
          <configuration>
            <source>1.8</source>
            <target>1.8</target>
            <encoding>UTF-8</encoding>
          </configuration>
        </plugin>

      </plugins>
    </pluginManagement>
  </build>
</project>

不懂的可以评论，也可以一起交流更好的搭建ssm项目结构，希望帮助到你。