SSM框架实现数据的增删查改+分页

准备工作：

1.修改pom文件

    <dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper</artifactId>
      <version>5.1.2</version>
    </dependency>

2.修改applicationContext.xml
在文件中添加以下代码：

       <property name="plugins">
            <array>
                <bean class="com.github.pagehelper.PageInterceptor">
                    <property name="properties">
                        <props>
                            <prop key="helperDialect">mysql</prop>
                            <prop key="reasonable">true</prop>
                        </props>
                    </property>
                </bean>
            </array>
        </property>

增加用户：

IUserInfoDao:

public void add(UserInfo userInfo);

UserInfoMapper.xml

<insert id="add" parameterType="com.zhongruan.bean.UserInfo">
        insert into userinfo (id,username,password) values(#{id},#{username},#{password})
    </insert>

IUserInfoService:

public void add(UserInfo userInfo);

IUserInfoServiceImpl:

public void add(UserInfo userInfo) {
        userInfoDao.add(userInfo);
    }

UserInfoController:

 @RequestMapping("add.do")
    public String add(UserInfo userInfo){
        userInfoService.add(userInfo);
        return "redirect:findAll.do";
    }

最后一句代码的作用是重定向，即再执行一次findAll.do
user-add.jsp

			<form action="${pageContext.request.contextPath}/user/add.do"
				method="post">
				<!-- 正文区域 -->
				<section class="content"> <!--产品信息-->

				<div class="panel panel-default">
					<div class="panel-heading">用户信息</div>
					<div class="row data-type">
						<div class="col-md-2 title">id</div>
						<div class="col-md-4 data">
							<input type="text" class="form-control" name="id"
								   placeholder="id" value="">
						</div>

						<div class="col-md-2 title">用户名称</div>
						<div class="col-md-4 data">
							<input type="text" class="form-control" name="username"
								placeholder="用户名称" value="">
						</div>
						<div class="col-md-2 title">密码</div>
						<div class="col-md-4 data">
							<input type="password" class="form-control" name="password"
								placeholder="密码" value="">
						</div>


					</div>
				</div>
				<!--订单信息/--> <!--工具栏-->
				<div class="box-tools text-center">
					<button type="submit" class="btn bg-maroon">保存</button>
					<button type="button" class="btn bg-default"
						onclick="history.back(-1);">返回</button>
				</div>
				<!--工具栏/--> </section>
				<!-- 正文区域 /-->
			</form>

实现效果:

修改用户

IUserInfoDao:

 public UserInfo selectById(int id);
 public void update(UserInfo userInfo);

UserInfoMapper.xml

    <select id="selectById" parameterType="int" resultType="com.zhongruan.bean.UserInfo">
        select * from userinfo where id=#{id}
    </select>
    <update id="update" parameterType="com.zhongruan.bean.UserInfo">
         update userinfo set username=#{username},password=#{password} where id=#{id}
    </update>

IUserInfoService:

public UserInfo selectById(int id);
public void update(UserInfo userInfo);

IUserInfoServiceImpl:

 @Override
    public UserInfo selectById(int id) {
        return userInfoDao.selectById(id);
    }

    @Override
    public void update(UserInfo userInfo) {
        userInfoDao.update(userInfo);
    }

UserInfoController:

@RequestMapping("toUpdate.do")
    public ModelAndView toUpdate(int id)
    {
        UserInfo userInfo=userInfoService.selectById(id);
        ModelAndView mv=new ModelAndView();
        mv.addObject("userInfo",userInfo);
        mv.setViewName("user-update");
        return mv;
    }
    @RequestMapping("update.do")
    public String update(UserInfo userInfo){
        userInfoService.update(userInfo);
        return "redirect:findAll.do";
    }

user-list.jsp:

tbody>
								    <c:forEach var="userInfo" items="${pageInfo.list}">
										<tr>
											<td><input name="ids" type="checkbox"></td>
											<td>${userInfo.id}</td>
											<td>${userInfo.username}</td>
											<td>${userInfo.password}</td>
											<td class="text-center">
												<a href="${pageContext.request.contextPath}/user/toUpdate.do?id=${userInfo.id}" class="btn bg-olive btn-xs">更新</a>
												<a href="${pageContext.request.contextPath}/user/delete.do?id=${userInfo.id}" class="btn bg-olive btn-xs">删除</a>
												<a href="#" class="btn bg-olive btn-xs">添加角色</a>
											</td>
										</tr>
									</c:forEach>
								</tbody>

实现效果：
更新前：

更新后：

删除用户

IUserInfoDao：

public void delete(int id);

UserInfoMapper.xml：

<delete id="delete" parameterType="int">
        delete from userinfo where id=#{id}
    </delete>

IUserInfoService：

public void delete(int id);

IUserInfoServiceImpl：

@Override
    public void delete(int id) {
        userInfoDao.delete(id);
    }

UserInfoController:

@RequestMapping("delete.do")
    public String delete(int id){
        userInfoService.delete(id);
        return "redirect:findAll.do";
    }

实现效果：
删除id为14的用户，删除前：

删除后：

分页

利用了PageHelper的插件：
在IUserInfoServiceImpl中添加如下代码：

 public List<UserInfo> findAll(int page,int size) {
        PageHelper.startPage(page,size);
        return userInfoDao.findAll();
    }

UserInfoController:

  public ModelAndView findAll(@RequestParam(defaultValue = "1") int page,@RequestParam(defaultValue = "5") int size)
    {
        ModelAndView mv=new ModelAndView();
        List<UserInfo> userInfos=userInfoService.findAll(page,size);
        PageInfo pageInfo=new PageInfo(userInfos);
        mv.addObject("pageInfo",pageInfo);
        mv.setViewName("user-list");
        return mv;
    }

user-list.jsp:

<div class="box-tools pull-right">
							<ul class="pagination">
								<li><a href="${pageContext.request.contextPath}/user/findAll.do?page=1&size=5" aria-label="Previous">首页</a></li>
								<li><a href="${pageContext.request.contextPath}/user/findAll.do?page=${pageInfo.pageNum-1}&size=5">上一页</a></li>
								<c:forEach begin="1" end="${pageInfo.pages}" var="pageNumber">
									<li><a href="${pageContext.request.contextPath}/user/findAll.do?page=${pageNumber}&size=5">">${pageNumber}</a></li>
								</c:forEach>
								<li><a href="${pageContext.request.contextPath}/user/findAll.do?page=${pageInfo.pageNum+1}&size=5">下一页</a></li>
								<li><a href="${pageContext.request.contextPath}/user/findAll.do?page=${pageInfo.pages}&size=5" aria-label="Next">尾页</a></li>
							</ul>
						</div>

实现效果：