18.spring后台管理系统

最新推荐文章于 2024-05-09 11:33:00 发布

苏七qaq

最新推荐文章于 2024-05-09 11:33:00 发布

阅读量275

点赞数

分类专栏： spring 文章标签： spring java

本文链接：https://blog.csdn.net/weixin_45974277/article/details/120814042

版权

spring 专栏收录该内容

38 篇文章 0 订阅

订阅专栏

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<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_4_0.xsd"
         version="4.0">

    <!--解决乱码的过滤器-->
    <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>

    <!--全局的初始化参数-->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>
    <!--Spring的监听器-->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>



    <!--SpringMVC的前端控制器-->
    <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>2</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>DispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

</web-app>

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

    <!--1、mvc注解驱动-->
    <mvc:annotation-driven/>

    <!--2、配置视图解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/pages/"/>
        <property name="suffix" value=".jsp"/>
    </bean>

    <!--3、静态资源权限开放-->
    <mvc:default-servlet-handler/>

    <!--4、组件扫描  扫描Controller-->
    <context:component-scan base-package="com.itheima.controller"/>

</beans>

applicaitonContext.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、配置JdbcTemplate对象-->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <!--配置RoleService-->
    <bean id="roleService" class="com.itheima.service.impl.RoleServiceImpl">
        <property name="roleDao" ref="roleDao"/>
    </bean>

    <!--配置RoleDao-->
    <bean id="roleDao" class="com.itheima.dao.impl.RoleDaoImpl">
        <property name="jdbcTemplate" ref="jdbcTemplate"/>
    </bean>

    <!--配置UserService-->
    <bean id="userService" class="com.itheima.service.impl.UserServiceImpl">
        <property name="userDao" ref="userDao"/>
        <property name="roleDao" ref="roleDao"/>
    </bean>

    <!--配置UserDao-->
    <bean id="userDao" class="com.itheima.dao.impl.UserDaoImpl">
        <property name="jdbcTemplate" ref="jdbcTemplate"/>
    </bean>
</beans>

Role类

package com.itheima.domain;

public class Role {

    private Long id;
    private String roleName;
    private String roleDesc;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getRoleName() {
        return roleName;
    }

    public void setRoleName(String roleName) {
        this.roleName = roleName;
    }

    public String getRoleDesc() {
        return roleDesc;
    }

    public void setRoleDesc(String roleDesc) {
        this.roleDesc = roleDesc;
    }

    @Override
    public String toString() {
        return "Role{" +
                "id=" + id +
                ", roleName='" + roleName + '\'' +
                ", roleDesc='" + roleDesc + '\'' +
                '}';
    }
}

User:

package com.itheima.domain;

import java.util.List;

public class User {

    private Long id;
    private String username;
    private String email;
    private String password;
    private String phoneNum;

    //当前用户具备哪些角色
    private List<Role> roles;

    public List<Role> getRoles() {
        return roles;
    }

    public void setRoles(List<Role> roles)
    {
        this.roles = roles;
    }

    public Long getId()
    {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getPhoneNum() {
        return phoneNum;
    }

    public void setPhoneNum(String phoneNum) {
        this.phoneNum = phoneNum;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", email='" + email + '\'' +
                ", password='" + password + '\'' +
                ", phoneNum='" + phoneNum + '\'' +
                '}';
    }
}

1.用户列表的展示：

1.在用户列表栏，点击跳转controller层的user/list，controller调用数据库的数据，再通过modelAndView.setViewName返回到view层。

userController：

public class UserController {

    @Autowired
    private UserService userService;

    @Autowired
    private RoleService roleService;

    @RequestMapping("/list")
    public ModelAndView list()
    {
        List<User> userList = userService.list();
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.addObject("userList",userList);
        modelAndView.setViewName("user-list");
        return modelAndView;
    }
}

service层：需要Role数据库表的数据

1.获取user表中的每一个user，存在userList<User>中

2.对userList进行循环，获得每个user，根据每个user中的id，进行联结查询，获得每个user对应的职位，将职位通过User类的setRole方法写到每个user对象中

public class UserServiceImpl implements UserService {

    private UserDao userDao;
    public void setUserDao(UserDao userDao) {
        this.userDao = userDao;
    }

    private RoleDao roleDao;
    public void setRoleDao(RoleDao roleDao) {
        this.roleDao = roleDao;
    }

    public List<User> list()
    {
        List<User> userList = userDao.findAll();
        //封装userList中的每一个User的roles数据
        for (User user : userList)
        {
            //获得user的id
            Long id = user.getId();
            //将id作为参数 查询当前userId对应的Role集合数据
            List<Role> roles = roleDao.findRoleByUserId(id);
            user.setRoles(roles);
        }
        return userList;
    }

UserDao:

public class UserDaoImpl implements UserDao {

    private JdbcTemplate jdbcTemplate;
    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    public List<User> findAll() 
    {
        List<User> userList = jdbcTemplate.query("select * from sys_user", new BeanPropertyRowMapper<User>(User.class));
        return userList;
    }
}

RoleDao:

public class RoleDaoImpl implements RoleDao
{

    private JdbcTemplate jdbcTemplate;
    public List<Role> findRoleByUserId(Long id)
    {
        List<Role> roleList = jdbcTemplate.query("select roleName,roleDesc from sys_role,sys_user_role where sys_user_role.userId=? And sys_user_role.roleId=sys_role.id", new BeanPropertyRowMapper<Role>(Role.class), id);
        return roleList;
    }
}

最后通过modelAndView返回给user-list.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="role">
							&nbsp;&nbsp;${role.roleName}:${role.roleDesc}
						</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>

2.用户的删除：

通过用户的id，先删除sys_user_role的信息(先删除外键信息)，再删除sys_user的信息

		<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="role">
							&nbsp;&nbsp;${role.roleName}:${role.roleDesc}
						</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>

	<script>
		function delUser(userId){
		    if(confirm("您确认要删除吗")){
		        location.href="${pageContext.request.contextPath}/user/del/"+userId;
			}
		}
	</script>

controller层:

    @RequestMapping("/del/{userId}")
    public String del(@PathVariable("userId") Long userId){
        userService.del(userId);
        return "redirect:/user/list";
    }

service层：

    public void del(Long userId) {
        //1、删除sys_user_role关系表
        userDao.delUserRoleRel(userId);
        //2、删除sys_user表
        userDao.del(userId);
    }

UserDao层：

    public void delUserRoleRel(Long userId)
    {
        jdbcTemplate.update("delete from sys_user_role where userId=?",userId);
    }

    public void del(Long userId) {
        jdbcTemplate.update("delete from sys_user where id=?",userId);
    }

3.用户的新建：

		<button type="button" class="btn btn-default" title="新建" onclick="location.href='${pageContext.request.contextPath}/user/saveUI.jsp'">
			<i class="fa fa-file-o"></i> 新建
		</button>

用户职位（角色）的展示需要通过查询数据库的职位表，获取职位表的全部职位，再动态渲染上去

userController:

    @RequestMapping("/saveUI")
    public ModelAndView saveUI(){
        ModelAndView modelAndView = new ModelAndView();
        List<Role> roleList = roleService.list();
        modelAndView.addObject("roleList",roleList);
        modelAndView.setViewName("user-add");
        return modelAndView;
    }

roleService:

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

roleDao:

    public List<Role> findAll(){
        List<Role> roleList = jdbcTemplate.query("select * from sys_role", new BeanPropertyRowMapper<Role>(Role.class));
        return roleList;
    }

渲染并跳转该界面：

<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 class="" type="checkbox" name="roleIds" value="${role.id}">${role.roleName}
			</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>

然后点击保存，让controller层映射user/save中的方法执行

    @RequestMapping("/save")
    public String save(User user,Long[] roleIds){
        userService.save(user,roleIds);
        return "redirect:/user/list";
    }

userService:需要存user和user_role两张表

    public void save(User user, Long[] roleIds) {
        //第一步 向sys_user表中存储数据,该user被创建之后，返回它的userId
        Long userId = userDao.save(user);
        //第二步 向sys_user_role 关系表中存储多条数据
        userDao.saveUserRoleRel(userId,roleIds);
    }

userDao:

    public Long save(final User user) {
        //创建PreparedStatementCreator
        PreparedStatementCreator creator = new PreparedStatementCreator() {
            public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
                //使用原始jdbc完成有个PreparedStatement的组建
                PreparedStatement preparedStatement = connection.prepareStatement("insert into sys_user values(?,?,?,?,?)", PreparedStatement.RETURN_GENERATED_KEYS);
                preparedStatement.setObject(1,null);
                preparedStatement.setString(2,user.getUsername());
                preparedStatement.setString(3,user.getEmail());
                preparedStatement.setString(4,user.getPassword());
                preparedStatement.setString(5,user.getPhoneNum());
                return preparedStatement;
            }
        };
        //创建keyHolder
        GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
        jdbcTemplate.update(creator,keyHolder);
        //获得生成的主键
        long userId = keyHolder.getKey().longValue();
        return userId; //返回当前保存用户的id 该id是数据库自动生成的
    }

    public void saveUserRoleRel(Long userId, Long[] roleIds) {
        for (Long roleId : roleIds) {
            jdbcTemplate.update("insert into sys_user_role values(?,?)",userId,roleId);
        }
    }

注意：需要设置jdbc.properties的url为xxx?useSSL=false&useUnicode=true&characterEncoding=UTF-8

3.角色列表的展示：

苏七qaq

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
18.spring后台管理系统

web.xml<?xml version="1.0" encoding="UTF-8"?><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...
复制链接

扫一扫

专栏目录