ajax实现数据库批量删除 IUserInfoDao
public void deleteAll(List<Integer>ids);UserInfoMapper.xml进行实现
<delete id="deloteAll" parameterType="list"> delete from userinfo where id in <foreach collection="list" item="id" open="(" close=")" separator=","> #{id} </foreach> </delete>IUserInfoService和UserInfoServiceImpl文件
public void deleteAll(List<Integer>ids); public void deleteAll(List<Integer> ids) { userInfoDao.deleteAll(ids); }在webapp包中导入js包 aside.jsp文件
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" isELIgnored="false"%> <%@ taglib prefix="security" uri="http://www.springframework.org/security/tags" %> <aside class="main-sidebar"> <!-- sidebar: style can be found in sidebar.less --> <section class="sidebar"> <!-- Sidebar user panel --> <div class="user-panel"> <div class="pull-left image"> <img src="${pageContext.request.contextPath}/img/user2-160x160.jpg" class="img-circle" alt="User Image"> </div> <div class="pull-left info"> <p> <security:authentication property="principal.username"></security:authentication> </p> <a href="#"><i class="fa fa-circle text-success"></i> 在线</a> </div> </div> <!-- sidebar menu: : style can be found in sidebar.less --> <ul class="sidebar-menu"> <li class="header">菜单</li> <li id="admin-index"><a href="#"><i class="fa fa-dashboard"></i> <span>首页</span></a></li> <li class="treeview"><a href="#"> <i class="fa fa-cogs"></i> <span>系统管理</span> <span class="pull-right-container"> <i class="fa fa-angle-left pull-right"></i> </span> </a> <ul class="treeview-menu"> <li id="system-setting"> <security:authorize access="hasRole('ADMIN')"> <a href="${pageContext.request.contextPath}/user/findAll.do?page=1&size=5"> <i class="fa fa-circle-o"></i> 用户管理 </a> </security:authorize> </li> <li id="system-setting"><a href="${pageContext.request.contextPath}/user/toRolelist.do"> <i class="fa fa-circle-o"></i> 角色管理 </a></li> </ul> </li> </ul> </section> <!-- /.sidebar --> </aside>header.jsp
<%@ taglib prefix="security" uri="http://www.springframework.org/security/tags" %> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" isELIgnored="false"%> <!-- 页面头部 --> <header class="main-header"> <!-- Logo --> <a href="all-admin-index.html" class="logo"> <!-- mini logo for sidebar mini 50x50 pixels --> <span class="logo-mini"><b>数据</b></span> <!-- logo for regular state and mobile devices --> <span class="logo-lg">中软<b>ETC</b>用户管理系统</span> </a> <!-- Header Navbar: style can be found in header.less --> <nav class="navbar navbar-static-top"> <!-- Sidebar toggle button--> <a href="#" class="sidebar-toggle" data-toggle="offcanvas" role="button"> <span class="sr-only">Toggle navigation</span> </a> <div class="navbar-custom-menu"> <ul class="nav navbar-nav"> <li class="dropdown user user-menu"><a href="#" class="dropdown-toggle" data-toggle="dropdown"> <img src="${pageContext.request.contextPath}/img/user2-160x160.jpg" class="user-image" alt="User Image"> <span class="hidden-xs"> <security:authentication property="principal.username"></security:authentication> </span> </a> <ul class="dropdown-menu"> <!-- User image --> <li class="user-header"><img src="${pageContext.request.contextPath}/img/user2-160x160.jpg" class="img-circle" alt="User Image"></li> <!-- Menu Footer--> <li class="user-footer"> <div class="pull-left"> <a href="#" class="btn btn-default btn-flat">修改密码</a> </div> <div class="pull-right"> <a href="${pageContext.request.contextPath}/login.do" class="btn btn-default btn-flat">注销</a> </div> </li> </ul></li> </ul> </div> </nav> </header> <!-- 页面头部 /-->成果展示
