博客

黑马视频数据后台管理系统，功能包括增删用户，增删角色(职称)，只放逻辑代码

页面预览:

先配置web.xml:

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

<web-app version="2.4"
         xmlns="http://java.sun.com/xml/ns/j2ee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>
    <!--  spring listener-->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

    <!--  spring mvc controller-->
    <servlet>
        <servlet-name>dispatcherServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring-mvc.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>dispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
<!--    解决乱码过滤器-->
    <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>
    </filter>
    <filter-mapping>
        <filter-name>CharacterEncodingFilter</filter-name>
<!--        所有请求都通过这个过滤器-->
        <url-pattern>/*</url-pattern>
    </filter-mapping>

</web-app>

再配置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:context="http://www.springframework.org/schema/context"
       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">

    <!--    1.加载jdbc.properties文件-->
    <context:property-placeholder location="classpath:jdbc.properties"/>
    <!--    2.配置数据源对象-->
   <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
       <property name="driverClass" value="${jdbc.driver}"/>
       <property name="jdbcUrl" value="${jdbc.url}"/>
       <property name="user" value="${jdbc.username}"/>
       <property name="password" value="${jdbc.password}"/>
   </bean>
    <!--    3.配置JDBC模板(JdbcTemplate)对象-->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>

<!--    配置RoleDao-->
    <bean id="roleDao" class="com.uncleChen.dao.impl.RoleDaoImpl">
        <property name="template" ref="jdbcTemplate"/>
    </bean>
<!--    配置RoleService-->
    <bean id="roleService" class="com.uncleChen.service.impl.RoleServiceImpl">
        <property name="roleDao" ref="roleDao"/>
    </bean>

<!--    配置UserDao-->
    <bean id="userDao" class="com.uncleChen.dao.impl.UserDaoImpl">
        <property name="template" ref="jdbcTemplate"/>
    </bean>
<!--配置UserService-->
    <bean id="userService" class="com.uncleChen.service.impl.UserServiceImpl">
        <property name="userDao" ref="userDao"/>
        <property name="roleDao" ref="roleDao"/>
    </bean>
</beans>

再配置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:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

    <!--配置mvc注解驱动(把Json自动解析)-->
    <mvc:annotation-driven/>
    <!--配置内部资源(jsp不可以直接被浏览器访问)视图解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/pages/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
<!--    配置静态资源的访问权限开放-->
    <mvc:default-servlet-handler/>
<!--    配置组件扫描,扫描Controller-->
    <context:component-scan base-package="com.uncleChen.controller"/>
</beans>

实现第一个功能——角色查询

首先创建Controller

@RequestMapping("role")
@Controller
public class RoleController {
    @Autowired
    private RoleService roleService;

    @RequestMapping(value = "list")
    public ModelAndView list() {
        List<Role> list = roleService.list();
        ModelAndView modelAndView = new ModelAndView();
        //设置模型
        modelAndView.addObject("roleList", list);
        //设置视图,这个role-list页面取到视图对象的list进行展示
        modelAndView.setViewName("role-list");
        return modelAndView;
    }
}

RoleService Interface:

public interface RoleService {
public List<Role> list();
}

RoleServiceImpl:

public class RoleServiceImpl implements RoleService {

    private RoleDao roleDao;

    public List<Role> list() {
        return roleDao.findAll();
    }
}

RoleDao Interface:

public interface RoleDao {
    List<Role> findAll();
}

public class RoleDaoImpl implements RoleDao {
    private JdbcTemplate template;
public List<Role> findAll() {
        String sql = "select * from sys_role";
        //创建集合存储查询到的数据
        List<Role> roleList = null;
        try {
            roleList = template.query(sql, new BeanPropertyRowMapper<Role>(Role.class));
        } catch (Exception e) {
            e.printStackTrace();
        }
        return roleList;
    }
}

JSP前台显示列表代码:

<c:forEach items="${roleList}" var="role">
                <tr>
                   <td><input name="ids" type="checkbox"></td>
                   <td>${role.id}</td>
                   <td>${role.roleName}</td>
                   <td>${role.roleDesc}</td>
                   <td class="text-center">
                         <a href="#" class="btn bg-olive btn-xs">删除</a>
                   </td>
                 </tr>
</c:forEach>

实现第二个功能——角色添加

Controller层:

@RequestMapping(value = "save")
    public String save(Role role) {
    roleService.save(role);
    //重定向到list
        return "redirect:/role/list";
    }

RoteService Interface:

void save(Role role);

RoteServiceImpl:

public void save(Role role) {
        roleDao.save(role);
    }

RoteDao Interface:

void save(Role role);

RoteDaoImpl:

public void save(Role role) {
        String sql = "insert into sys_role values(?,?,?)";
        try {
            template.update(sql, null, role.getRoleName(), role.getRoleDesc());
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

JSP前台代码:

<form action="${pageContext.request.contextPath}/role/save"
              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">角色名称</div>
                        <div class="col-md-4 data">
                            <input type="text" class="form-control" name="roleName"
                                   placeholder="角色名称" value="">
                        </div>
                        <div class="col-md-2 title">角色描述</div>
                        <div class="col-md-4 data">
                            <input type="text" class="form-control" name="roleDesc"
                                   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>
    </div>

实现第二个功能——用户列表

Controller:

@RequestMapping("user")
@Controller
public class UserController {
    @Autowired
    private UserService userService;
    @Autowired
    private RoleService roleService;
    @RequestMapping(value = "/list")
    public ModelAndView list() {
        List<User> userList = userService.list();
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.addObject("userList", userList);
        modelAndView.setViewName("user-list");
        return modelAndView;
    }
}

UserService Interface:

public interface UserService {
    /**
     * 查询所有用户
     * @return 所有用户的domain
     */
    List<User> list();
}

UserServiceImpl:

public class UserServiceImpl implements UserService {
    private UserDao userDao;
    private RoleDao roleDao;
    public void setRoleDao(RoleDao roleDao) {
        this.roleDao = roleDao;
    }

    public void setUserDao(UserDao userDao) {
        this.userDao = userDao;
    }
    public List<User> list() {
        List<User> userList = userDao.findAll();
//        封装userList中User的每一个数据
        for (User user : userList) {
            Long id = user.getId();
            List<Role> userRoles=roleDao.findRoleById(id);
            user.setRoles(userRoles);
        }
        return userList;
    }
}

UserDao Interface:

public interface UserDao {
    List<User> findAll();
}

UserDaoImpl:

public class UserDaoImpl implements UserDao {

    private JdbcTemplate template;

    public void setTemplate(JdbcTemplate template) {
        this.template = template;
    }
public List<User> findAll() {
        String sql = "select * from sys_user";
        List<User> userList = null;
        try {
            userList = template.query(sql, new BeanPropertyRowMapper<User>(User.class));
        } catch (Exception e) {
            e.printStackTrace();
        }
        return userList;
    }
}

JSP前台代码:

<!--数据列表-->
                        <table id="dataList"
                               class="table table-bordered table-striped table-hover dataTable">
                            <thead>
                            <tr>
                                <th class="" style="padding-right: 0px"><input
                                        id="selall" type="checkbox" class="icheckbox_square-blue">
                                </th>
                                <th class="sorting_asc">ID</th>
                                <th class="sorting_desc">用户名</th>
                                <th class="sorting_asc sorting_asc_disabled">邮箱</th>
                                <th class="sorting_desc sorting_desc_disabled">联系电话</th>
                                <th class="sorting">具有角色</th>
                                <th class="sorting">操作</th>
                            </tr>
                            </thead>
                            <tbody>
                            <c:forEach items="${userList}" var="user">
                                <tr>
                                    <td><input name="ids" type="checkbox"></td>
                                    <td>${user.id}</td>
                                    <td>${user.username}</td>
                                    <td>${user.email}</td>
                                    <td>${user.phoneNum}</td>
                                    <td class="text-center">
                                        <c:forEach items="${user.roles}" var="userRoles">
                                            ${userRoles.roleName}&nbsp;
                                        </c:forEach>
                                    </td>
                                    <td class="text-center">
                                        <a href="javascript:void(0);" onclick="delUser('${user.id}')" class="btn bg-olive btn-xs">删除</a>
                                    </td>
                                </tr>
                            </c:forEach>
                            </tbody>

                        </table>
                        <!--数据列表/-->

实现第三个功能——添加用户

先需要在查询所有的用户角色逐个显示到复选框中

复选框逻辑:

UserController:

/**
     * 查询所有的角色数据作为显示框选项
     * @return 视图跳转到user-list
     */
    @RequestMapping(value = "/saveUI")
    public ModelAndView saveUI() {
        ModelAndView modelAndView = new ModelAndView();
        List<Role> roleList=roleService.list();
        modelAndView.addObject("roleList",roleList);
        modelAndView.setViewName("user-add");
        return modelAndView;
    }

RoleService Interface:

List<Role> findAllRoles();

RoleServiceImpl:

public List<Role> findAllRoles() {
        List<Role> allRotes = roleDao.findAll();
        return allRotes;
    }

RoleDao Interface:

List<Role> findAll();

RoleDaoImpl:

public class RoleDaoImpl implements RoleDao {
    private JdbcTemplate template;
    public void setTemplate(JdbcTemplate template) {
        this.template = template;
    }
public List<Role> findAll() {
        String sql = "select * from sys_role";
        //创建集合存储查询到的数据
        List<Role> roleList = null;
        try {
            roleList = template.query(sql, new BeanPropertyRowMapper<Role>(Role.class));
        } catch (Exception e) {
            e.printStackTrace();
        }
        return roleList;
    }
}

JSP：这样就显示出来了

<c:forEach items="${roleList}" var="role">
                                <input type="checkbox" name="roleIds" value="${role.id}">${role.roleName}&nbsp;
                            </c:forEach>

再进行用户创建功能实现:

UserController:用数组接收前台发送过来的角色表单数据

/**
     * 创建用户
     * @return 视图跳转到user-list
     */
    @RequestMapping(value = "/save")
    public String save(User user,long[] roleIds) {
        userService.save(user,roleIds);
        return "redirect:/user/list";
    }

UserService Interface:

void save(User user,long[] roleIds);

UserServiceImpl:既要新建用户信息，也要建立用户与角色关系信息,也就是要对两张表操作

public void save(User user,long[] roleIds) {
        Long userId = userDao.save(user);
        userDao.saveUserAndRole(userId,roleIds);
    }

UserDao Interface:

Long save(User user);
void saveUserAndRole(long userId,long[] roleIds);

UserDaoImpl:

存储用户信息第一种方法:存完用户表后再查询自动生成的ID编号，然后再根据ID编号存用户——角色表

第二种方法(不常用):手动配置Connection

public Long save(final User user) {
        final String saveUserSql = "insert into sys_user values(?,?,?,?,?)";
//        创建PreparedStatementCreator
        PreparedStatementCreator preparedStatementCreator = new PreparedStatementCreator() {
            //            使用原始的jdbc完成PreparedStatement的组建
            public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
//                PreparedStatement.RETURN_GENERATED_KEYS代表自动生成主键
                PreparedStatement preparedStatement = connection.prepareStatement(saveUserSql, PreparedStatement.RETURN_GENERATED_KEYS);
                preparedStatement.setObject(1, null);
                preparedStatement.setObject(2, user.getUsername());
                preparedStatement.setObject(3, user.getEmail());
                preparedStatement.setObject(4, user.getPassword());
                preparedStatement.setObject(5, user.getPhoneNum());
                return preparedStatement;
            }
        };
//        通过该对象获得生成的主键
        GeneratedKeyHolder generatedKeyHolder = new GeneratedKeyHolder();
        Long userId = null;
        try {
            //将用户信息存储到表中
            template.update(preparedStatementCreator, generatedKeyHolder);

            userId = generatedKeyHolder.getKey().longValue();
        } catch (Exception e) {
            e.printStackTrace();
        }
    return userId;
    }

将存完后自动生成的ID直接返回给Service，再执行 用户——角色表进行存储

public void saveUserAndRole(long userId, long[] roleIds) {
        String saveUserAndRoleSql = "insert into sys_user_role values(?,?)";
        try {
            //将用户与中间表信息存储到中间表中
            for (long role : roleIds) {
                template.update(saveUserAndRoleSql, userId, role);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

//再放一遍UserServiceImpl:
public void save(User user,long[] roleIds) {
            Long userId = userDao.save(user);
            userDao.saveUserAndRole(userId,roleIds);
        }

JSP前台:

<form action="${pageContext.request.contextPath}/user/save"
              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">用户名称</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 class="col-md-2 title">邮箱</div>
                        <div class="col-md-4 data">
                            <input type="text" class="form-control" name="email"
                                   placeholder="邮箱" value="">
                        </div>
                        <div class="col-md-2 title">联系电话</div>
                        <div class="col-md-4 data">
                            <input type="text" class="form-control" name="phoneNum"
                                   placeholder="联系电话" value="">
                        </div>
                        <div class="col-md-2 title">用户角色</div>
                        <div class="col-md-10 data">
                            <%--						选择角色页面展示--%>
                            <c:forEach items="${roleList}" var="role">
                                <input type="checkbox" name="roleIds" value="${role.id}">${role.roleName}&nbsp;
                            </c:forEach>
                        </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>

实现第四个功能——删除用户

既要删除用户记录，又要删除用户和角色对应关系记录,也是对两张表操作

UserController:

/**
     * 删除用户
     * @return 视图跳转到user-list
     */
    @RequestMapping(value = "/delete/{userId}")
    public String delete(@PathVariable("userId") long userId) {
        userService.delete(userId);
        return "redirect:/user/list";
    }

UserService Interface:

void delete(long userId);

UserServiceImpl:

public void delete(long userId) {
//        1.删除关系表数据
        userDao.deleteUserAndRole(userId);
//        2.删除用户表数据
        userDao.deleteUser(userId);
    }

UserDao:

    //删除关系表中的记录
void deleteUserAndRole(long userId);
   //删除用户表记录
 void deleteUser(long userId);

UserDaoImpl:

public void deleteUserAndRole(long userId) {
        String deleteUserAndRoleSql = "delete from sys_user_role where userId=?";
        try {
            template.update(deleteUserAndRoleSql, userId);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public void deleteUser(long userId) {
        String deleteUserSql = "delete from sys_user where Id=?";
        try {
            template.update(deleteUserSql, userId);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

JSP前台代码:

<td class="text-center">
   <a href="javascript:void(0);" onclick="delUser('${user.id}')" class="btn bg-olive btn-xs">删除</a>
   </td>