SSM6.2【Spring：练习-角色列表展示和角色添加操作】

角色和用户关系分析

 

 

 角色列表展示功能

 

 

 

角色添加功能

 

 

 

 代码实现

 

package com.haifei.domain;

public class Role {

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

    @Override
    public String toString() {
        return "Role{" +
                "id=" + id +
                ", roleName='" + roleName + '\'' +
                ", roleDesc='" + 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;
    }
}

package com.haifei.controller;

import com.haifei.domain.Role;
import com.haifei.service.RoleService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

import java.util.List;

/**
 * RoleController使用注解@Controller产生(实例化)bean；在spring-mvc.xml中配置组件扫描，扫描Controller层
 * RoleService
 *      使用注解@Autowired实现依赖注入，可以省略set，但仍须在applicationContext.xml中配置bean
 * RoleDao & JdbcTemplate
 *     使用set实现bean的依赖注入，需要在applicationContext.xml中配置bean
 */
@RequestMapping("/role")
@Controller
public class RoleController {

    @Autowired
    private RoleService roleService;
    /*public void setRoleService(RoleService roleService) {
        this.roleService = roleService;
    }*/

    @RequestMapping("/list")
    public ModelAndView list(){
        ModelAndView modelAndView = new ModelAndView();
        List<Role> roleList = roleService.list();
//        System.out.println(roleList);
        //设置模型
        modelAndView.addObject("roleList", roleList);
        //设置视图
        modelAndView.setViewName("role-list"); // webapp/pages/role-list.jsp
        return modelAndView;
    }

    @RequestMapping("/save")
    public String save(Role role){
        roleService.save(role);
        return "redirect:/role/list"; //添加完成后，自动跳转到展示页面（重定向至查询方法）
    }

}

package com.haifei.service;

import com.haifei.domain.Role;

import java.util.List;

public interface RoleService {

    List<Role> list();

    void save(Role role);
}

package com.haifei.service.impl;

import com.haifei.dao.RoleDao;
import com.haifei.domain.Role;
import com.haifei.service.RoleService;

import java.util.List;

public class RoleServiceImpl implements RoleService {

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

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

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

package com.haifei.dao;

import com.haifei.domain.Role;

import java.util.List;

public interface RoleDao {

    List<Role> findAll();

    void save(Role role);
}

package com.haifei.dao.impl;

import com.haifei.dao.RoleDao;
import com.haifei.domain.Role;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.List;

public class RoleDaoImpl implements RoleDao {

    private JdbcTemplate template;
    public void setTemplate(JdbcTemplate template) {
        this.template = template;
    }

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

    @Override
    public void save(Role role) {
//        String sql = "insert into sys_role(roleName, roleDesc) values(?,?)";
        String sql = "insert into sys_role values(?,?,?)";
        template.update(sql, null, role.getRoleName(), role.getRoleDesc()); //id自增
    }
}

<!--配置RoleDao-->
    <bean id="roleDao" class="com.haifei.dao.impl.RoleDaoImpl">
        <property name="template" ref="jdbcTemplate"/>
        <!--name值必须与RoleDaoImpl中声明的JdbcTemplate对象名一致；ref值必须与该配置文件中spring jdbcTemplate对应bean的id一致-->
    </bean>

    <!--配置RoleService-->
    <bean id="roleService" class="com.haifei.service.impl.RoleServiceImpl">
        <property name="roleDao" ref="roleDao"/>
        <!--name值必须与RoleServiceImpl中声明的RoleDao对象名一致；ref值必须与该配置文件中-配置RoleDao对应bean的id一致-->
    </bean>