SSM6.3【Spring：练习-用户列表展示、用户添加和删除操作】

用户列表展示

 

 用户添加

 

 用户删除

 

 代码实现

package com.haifei.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;
    }

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

    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;
    }
}

pom.xml

+

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

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

 

package com.haifei.controller;

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

import java.util.List;

@RequestMapping("/user")
@Controller
public class UserController {

    @Autowired
    private UserService userService;

    @Autowired
    private RoleService roleService;

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

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

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

    @RequestMapping("/del/{userId}") //restful风格传参，参数占位
    public String del(@PathVariable("userId") Long userId){
        userService.del(userId);
        return "redirect:/user/list";
    }

}

package com.haifei.service;

import com.haifei.domain.User;

import java.util.List;

public interface UserService {

    List<User> list();

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

    void del(Long userId);
}

package com.haifei.service.impl;

import com.haifei.dao.RoleDao;
import com.haifei.dao.UserDao;
import com.haifei.domain.Role;
import com.haifei.domain.User;
import com.haifei.service.UserService;

import java.util.List;

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;
    }

    @Override
    public List<User> list() {
//        return userDao.findAll();

        List<User> userList = userDao.findAll();
        //封装userList中每一个User对象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;
    }

    @Override
    public void save(User user, Long[] roleIds) {
        /*//1 向sys_user表中存储数据
        userDao.save(user);
        //2 向sys_user_role关系表中存储多条数据
        userDao.saveUserRoleRelation(user.getId(), roleIds); //user.getId()为空，报错空指针异常*/

        //1 向sys_user表中存储数据
        Long userId = userDao.save(user);
        //2 向sys_user_role关系表中存储多条数据
        userDao.saveUserRoleRelation(userId, roleIds);

        //后面待学习的声明性事务锁可应用于此处
    }

    @Override
    public void del(Long userId) { //先删除user会报错，因为user的id是外键，即关系表的主键之一
        //1 删除sys_user_role关系表中userId对应的数据
        userDao.delUserRoleRelation(userId);
        //2 删除sys_user表中user信息
        userDao.del(userId);

        //后面待学习的声明性事务锁可应用于此处
    }
}

package com.haifei.dao;

import com.haifei.domain.User;

import java.util.List;

public interface UserDao {

    List<User> findAll();

    Long save(User user);

    void saveUserRoleRelation(Long id, Long[] roleIds);

    void delUserRoleRelation(Long userId);

    void del(Long userId);
}

package com.haifei.dao.impl;

import com.haifei.dao.UserDao;
import com.haifei.domain.User;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.support.GeneratedKeyHolder;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;

public class UserDaoImpl implements UserDao {

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

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

    /*@Override
    public void save(User user) {
        String sql = "insert into sys_user values (?,?,?,?,?)";
        template.update(sql, null,user.getUsername(), user.getEmail(), user.getPassword(), user.getPhoneNum());
    }*/
    @Override
    public Long save(User user) {
        //1 创建PreparedStatementCreator
        PreparedStatementCreator creator = new PreparedStatementCreator() { //匿名内部类  实现PreparedStatementCreator接口
            @Override
            public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
                //使用原始jdbc完成有个PreparedStatement的组建
                String sql = "insert into sys_user values (?,?,?,?,?)";
                PreparedStatement preparedStatement = connection.prepareStatement(sql, 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;
            }
        };

        //2 创建keyHolder
        GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();

        template.update(creator, keyHolder); //int update(PreparedStatementCreator var1, KeyHolder var2)

        //3 获得生成的主键
        long userId = keyHolder.getKey().longValue();

        return userId; //返回当前保存用户的id 该id是数据库自动生成的
    }

    @Override
    public void saveUserRoleRelation(Long userId, Long[] roleIds) {
        String sql = "insert into sys_user_role values (?,?)";
        for (Long roleId : roleIds) {
            template.update(sql, userId, roleId);
        }
    }

    @Override
    public void delUserRoleRelation(Long userId) {
        String sql = "delete from sys_user_role where userId=?";
        template.update(sql, userId);
    }

    @Override
    public void del(Long userId) {
        String sql = "delete from sys_user where id=?";
        template.update(sql, userId);
    }

}

RoleDao

+

List<Role> findRoleByUserId(Long id);

RoleDaoImpl

+

@Override
    public List<Role> findRoleByUserId(Long id) {
        String sql = "select * from sys_user_role ur,sys_role r where ur.roleId=r.id and ur.userId=?";
        List<Role> roles = template.query(sql, new BeanPropertyRowMapper<Role>(Role.class), id);
        return roles;
    }