搭建SSM框架，实现对User表的CRUD

最新推荐文章于 2022-08-31 21:44:01 发布

无穷尽

最新推荐文章于 2022-08-31 21:44:01 发布

阅读量322

点赞数

本文链接：https://blog.csdn.net/qq_37630321/article/details/85160033

版权

搭建SSM框架

1、配置maven依赖

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>cn.zyyx</groupId>
    <artifactId>ssmintegration</artifactId>
    <version>1.0-SNAPSHOT</version>

    <dependencies>
        <!-- 引入数据源和数据库连接依赖 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.27</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.0.19</version>
        </dependency>
        <!-- 引入mybatis的依赖 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.2.2</version>
        </dependency>
        <!-- 引入spring的依赖 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>4.3.3.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>4.3.3.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aop</artifactId>
            <version>4.3.14.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.3.3.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.8.10</version>
        </dependency>
        <!-- mybatisi整合spring -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.1.1</version>
        </dependency>
        <!-- 引入springmvc的依赖 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>4.3.3.RELEASE</version>
        </dependency>
        <!-- 引入jstl与servlet的依赖 -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>servlet-api</artifactId>
            <version>2.5</version>
        </dependency>
    </dependencies>
</project>
**2、** 配置Spring的核心配置文件beans.xml
```xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       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-4.3.xsd
                          http://www.springframework.org/schema/tx
                          http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
                          http://www.springframework.org/schema/aop
                          http://www.springframework.org/schema/aop/spring-aop-4.3.xsd">
       <!-- 配置注解扫描器 -->
       <context:component-scan base-package="cn.zyyx.service.impl,cn.zyyx.dao.impl"/>

        <!-- 配置事务的通知 -->
        <tx:advice id="txAdvice" transaction-manager="txManager">
            <tx:attributes>
                <tx:method name="*" isolation="DEFAULT" propagation="REQUIRED"/>
            </tx:attributes>
        </tx:advice>

        <!-- 配置面向aop -->
        <aop:config>
            <aop:advisor advice-ref="txAdvice" pointcut="execution(* *..*Service.*(..))" />
        </aop:config>

        <!-- 整合数据源Druid -->
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
            <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
            <property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
            <property name="username" value="root"/>
            <property name="password" value="wangliuyi520YL"/>
            <property name="maxActive" value="10"/>
            <property name="minIdle" value="2"/>
            <property name="initialSize" value="3"/>
        </bean>

        <!-- 整合Mybatis -->
       <bean id="sf" class="org.mybatis.spring.SqlSessionFactoryBean">
           <property name="dataSource" ref="dataSource"/>
           <property name="configLocation" value="classpath:mybatis-config.xml"/>
       </bean>

       <!-- 配置事务管理器 -->
        <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource"/>
        </bean>
</beans>

3、配置Mybatis的核心配置文件mybatis-config.xml和User的映射配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
        <typeAliases>
            <typeAlias type="cn.zyyx.domain.User" alias="User"/>
        </typeAliases>
        <mappers>
            <mapper resource="UserMapper.xml"/>
        </mappers>
</configuration>

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="users">
        <insert id="insertOne" parameterType="User">
            insert into users(name,age) values (#{name},#{age})
        </insert>
        <delete id="deleteOne" parameterType="int">
            delete from users where id=#{id}
        </delete>
        <update id="updateOne" parameterType="User">
            update users set name=#{name} , age=#{age} where id=#{id}
        </update>
        <select id="selectOne" parameterType="int" resultType="User">
            select * from users where id=#{id}
        </select>
        <select id="selectAll" resultType="User">
            select * from users
        </select>
</mapper>

4、创建dao层、service层以及domain
在这里插入图片描述
5、配置SpringMVC
一、web.xml文件中配置请求转发器以及监听(让Spring容器随着Web容器的启动而初始化)

<?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">
        <!-- 指定spring的配置文件beans.xml -->
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath*:beans.xml</param-value>
        </context-param>
        <!-- 确保web服务器启动时，完成spring的容器初始化 -->
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
        <!-- 配置，统一编码过滤器 -->
        <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>
            <init-param>
                <param-name>forceEncoding</param-name>
                <param-value>true</param-value>
            </init-param>
        </filter>
        <filter-mapping>
            <filter-name>characterEncodingFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
        <!-- 配置springMVC的请求处理器 -->
        <servlet>
            <servlet-name>dispatcher</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        </servlet>
        <servlet-mapping>
            <servlet-name>dispatcher</servlet-name>
            <url-pattern>/</url-pattern>
        </servlet-mapping>
</web-app>

二、配置SpringMVC的映射处理器、视图解析器

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       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-4.3.xsd
                          http://www.springframework.org/schema/context
                          http://www.springframework.org/schema/context/spring-context-4.3.xsd">
       <!-- 配置扫描器 -->
        <context:component-scan base-package="cn.zyyx.controller"/>
       <!-- 配置SpringMVC的注解驱动 -->
       <mvc:annotation-driven/>
       <!-- 配置视图解析器 -->
       <bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
           <property name="prefix" value="/"/>
           <property name="suffix" value=".jsp"/>
       </bean>
</beans>

三、创建controller层，配置控制器
在这里插入图片描述

package cn.zyyx.controller;

import cn.zyyx.domain.User;
import cn.zyyx.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

import javax.annotation.Resource;
import java.util.List;

/**
 * @author 紫炎易霄
 */
@Controller
public class UserController {

    @Resource(name = "userService")
    private UserService<User> userService;

    /**
     * 查询所有用户
     * @return
     */
    @RequestMapping("/selectAll")
    public String selectAll(Model model){
        List<User> userList = userService.selectAll();
        model.addAttribute("users",userList);
        return "index";
    }
    /**
     * 删除用户
     */
    @RequestMapping("/deleteOne")
    public String deleteOne(@RequestParam("id") Integer id){
        userService.delete(id);
        return "redirect:/selectAll";
    }
    /**
     * 查询单个用户
     */
    @RequestMapping("/selectOne")
    public String selectOne(@RequestParam("id") Integer id,Model model){
        User user = userService.selectOne(id);
        model.addAttribute("user",user);
        return "WEB-INF/updateUser";
    }
    /**
     * 修改用户
     */
    @RequestMapping("/updateOne")
    public String updateOne(User user){
        userService.update(user);
        return "redirect:/selectAll";
    }
    /**
     * 跳转到新增方法体
     */
    @RequestMapping("/insertOne")
    public String insertUser(){
        return "WEB-INF/addUser";
    }
    /**
     * 新增用户
     */
    @RequestMapping("/saveOne")
    public String saveUser(User user){
        userService.insert(user);
        return "redirect:/selectAll";
    }
}

6、运行测试
在这里插入图片描述
7、总结：本人在对SSM进行整合的时候，自以为很简单就配置完成了，没想到还是忘了一些重要的配置，弄了两个小时才发现自己在web.xml文件中的监听没有配置，导致启动web容器的时候，我的Spring容器还没有进行初始化，导致我的service层对象不能注入到controller中。。。希望大家引以为戒。。。大家不懂得可以在下方留言，我们一起进步！
8、代码
链接：https://pan.baidu.com/s/1nQc9UUWwSmQlN5cn0y7p-w
提取码：wedq