# Spring_test

**Repository Path**: wangkaij/spring_test

## Basic Information

- **Project Name**: Spring_test
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-09-27
- **Last Updated**: 2021-09-27

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 一、Spring练习环境搭建

## 1. Spring环境搭建步骤

- 创建工程
- 导入静态页面
- 导入需要坐标
- 创建包结构（controller、service、dao、domain、urils）
- 导入数据库脚本（test.sql）
- 创建POJO类（User.java和Role.java）
- 创建配置文件（applicationContext.xml、spring-mvc.xml、jdbc.properties、log4j.properties）

**applicationContext.xml基础配置：** 

```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.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>

    <!-- 配置JdbcTemplate对象 -->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>
</beans>
```

**spring-mvc.xml基础配置：** 

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

    <!-- 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. 组件扫描 -->
    <context:component-scan base-package="com.wangkai.controller"/>
</beans>
```

**web.xml基础配置：** 

```xml
<!DOCTYPE web-app PUBLIC
 "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
 "http://java.sun.com/dtd/web-app_2_3.dtd" >

<web-app>

  <!-- 全局的初始化参数 -->
  <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>1</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>dispatcherServlet</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>
</web-app>
```



# 二、角色列表的展示和添加操作

## 2.1 角色列表的展示步骤分析

- 点击角色管理菜单发送请求到服务器端（修改角色管理菜单的url地址）
- 创建RoleController和showList()方法
- 创建RoleService和showList()方法
- 创建RoleDao和findAll()方法
- 使用JdbcTemplate完成查询操作
- 将查询数据存到Mode中
- 转发到role-list.jsp页面进行展示

**RoleController.java**

```java
@RequestMapping("/role")
@Controller
public class RoleController {
	//注入service层
    @Autowired
    private RoleService roleService;

    @RequestMapping("/list")
    public ModelAndView list(){
        ModelAndView modelAndView = new ModelAndView();
        List<Role> roleList = roleService.list();
        //设置模型对象
        modelAndView.addObject("roleList",roleList);
        //设置视图
        modelAndView.setViewName("role-list");
        return modelAndView;
    }
}
```

**Service层**

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

```java
public class RoleServiceImpl implements RoleService {
	//注入Dao层
    private RoleDao roleDao;
    public void setRoleDao(RoleDao roleDao){
        this.roleDao = roleDao;
    }

    @Override
    public List<Role> list() {
        List<Role> roleList = roleDao.findAll();
        System.out.println("执行service--list");
        return roleList;
    }
}
```

**Dao层**

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

```java
public class RoleDaoImpl implements RoleDao {
	//注入JdbcTemplate
    private JdbcTemplate template;
    public void setTemplate(JdbcTemplate template){
        this.template = template;
    }

    @Override
    public List<Role> findAll() {
        System.out.println("执行dao--findAll");
        String sql = "select * from sys_role";
        List<Role> roleList = template.query(sql, new BeanPropertyRowMapper<Role>(Role.class));
        System.out.println("执行dao ---> "+roleList);
        return roleList;
    }
}
```



## 2.2 角色添加的步骤分析

- 点击列表页面新建按钮跳转到角色添加页面
- 输入角色信息，点击保存按钮，表单数据提交服务器
- 编写RoleController的save()方法
- 编写RoleService的save()方法
- 编写RoleDao的save()方法
- 使用JdbcTemplate保存Role数据到sys_role
- 跳转回角色列表页面

**RoleController.java**

```java
@RequestMapping("/save")
public String save(Role role){
    roleService.save(role);
    return "redirect:/role/list";
}
```

**Service层**

```java
void save(Role role);
```

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

**Dao层**

```java
void save(Role role);
```

```java
@Override
public void save(Role role) {
    String sql = "insert into sys_role values(?,?,?)";
    template.update(sql,null,role.getRoleName(),role.getRoleDesc());
}
```



# 三、用户列表的展示

**UserController.java**

```java
@Controller
@RequestMapping("/user")
public class UserController {
    @Autowired
    private UserService userService;

    @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层**

```java
public interface UserService {
    List<User> list();
}
```

```java
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() {
        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;
    }
}
```

**Dao层--UserDao**

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

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

**Dao层--RoleDao**

```java
List<Role> findRoleByUserId(Long id);
```

```java
@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;
}
```



# 四、删除用户操作