骏骏骏的博客

主题

骏骏骏2025-10-16
2271
11.6m
Get...

ssm整合 ​

一、ssm整合文档 ​

1、整合思路 ​

整合思路
- [ ] 	1.首先搭建整合的环境
- [ ] 	2.spring的配置搭建
- [ ] 	3.使用spring整合springmvc框架
	4.使用spring整合mybatis

2、搭建整合的环境 ​

2.1、创建数据库和表 ​
-- 创建数据库
create database db_user;
use db_user;
-- 创建表
create table tb_user(
	id int primary key auto_increment,
	username varchar(20) not null,
	birthday Date,
	sex varchar(4),
	address varchar(100)
);
-- 添加测试数据
INSERT INTO `user` VALUES (41, '张三', '2000-02-27 17:47:08', '男', '北京');
INSERT INTO `user` VALUES (42, '李四', '2000-03-02 15:09:37', '女', '湖南');
INSERT INTO `user` VALUES (43, '王五', '2000-03-04 11:34:34', '女', '河北');
INSERT INTO `user` VALUES (45, '赵六', '2000-03-04 12:04:06', '男', '深圳');
INSERT INTO `user` VALUES (46, '老七', '2000-03-07 17:37:26', '男', '上海');
INSERT INTO `user` VALUES (47, '小李子', '2000-03-08 11:44:00', '女', '长安');
2.2、创建maven工程 ​

使用idea创建maven工程，选择webapp的模板。在pom.xml文件中添加依赖

<dependencies>
    <!--单元测试-->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
    <!--spring相关依赖-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>5.3.4</version>
    </dependency>
    <!--spring上下文依赖-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>5.3.4</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>5.3.4</version>
    </dependency>
    <!--spring事务支持-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>5.3.4</version>
    </dependency>
    <!--spring jdbc的支持-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.3.4</version>
    </dependency>

    <!--springmvc-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>5.3.4</version>
    </dependency>
    <!--springs mvc模块-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>5.3.4</version>
    </dependency>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>4.0.1</version>
    </dependency>
    <dependency>
      <groupId>javax.servlet.jsp</groupId>
      <artifactId>jsp-api</artifactId>
      <version>2.2</version>
    </dependency>
	<!--jstl标签库-->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>
    <!--mybatis-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.6</version>
    </dependency>
    <!--mybatis整合spring的依赖-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>2.0.5</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.27</version>
    </dependency>
    <!--druid数据库连接池-->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.2.6</version>
    </dependency>
  </dependencies>
2.3、编写实体类 ​
package com.kdf.entity;
import java.util.Date;
@Component
public class User implements Serializable {
    private int id;
    private String username;
    private Date birthday;
    private String sex;
    private String address;
    //生成get和set方法
2.4、编写dao层的接口UserDao ​
package com.kdf.dao;

import com.kdf.entity.User;
import java.util.List;

public interface UserDao {
	//查询所有的方法
    public List<User> queryAll();
}
2.5、编写UserService，用于调用dao的接口方法，实现业务 ​
package com.kdf.service;

import com.kdf.dao.UserDao;
import com.kdf.entity.User;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.List;
//添加service的注解
@Service
public class UserService {

    private UserDao userDao;
    public List<User> findAll(){
        System.out.println("业务层：查询所有用户信息。。。");
        return null;
    }
}

3、spring框架搭建 ​

3.1、编写applicationContext.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
        https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        https://www.springframework.org/schema/context/spring-context.xsd">
        
        <!-- 开启注解扫描，要扫描的是service和dao层的注解，但是要忽略web层注解，因为web层让SpringMVC框架去管理 -->
    <context:component-scan base-package="com.kdf">
    <!-- 配置要忽略的注解 -->
    <context:exclude-filter type="annotation"
    expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
</beans>
3.2、编写测试类UserTest，测试spring框架是否搭建成功 ​
public class UserTest {
	@Test
    public void test1(){
        //读取配置文件
        ApplicationContext app = new 			ClassPathXmlApplicationContext("applicationContext.xml");
        //获取bean对象
        User user = (User) app.getBean("user");
        System.out.println(user);
    }
}

4、使用spring整合springMvc ​

4.1、搭建springmvc的开发环境，在web.xml中配置DispatcherServlet前端控制器 ​
  <servlet>
    <servlet-name>dispatcherServlet</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <!--初始化加载springmvc配置文件-->
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:springmvc.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet>
  <!--配置路径映射-->
  <servlet-mapping>
    <servlet-name>dispatcherServlet</servlet-name>
   <!--*.do表示匹配所有带有.do的请求-->   
    <url-pattern>*.do</url-pattern>
  </servlet-mapping>
4.2、在web.xml中配置过滤器解决中文乱码问题 ​
<!-- 配置解决中文乱码的过滤器 -->
<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>*.do</url-pattern>
</filter-mapping>
4.3、创建springmvc.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"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        https://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/mvc
        https://www.springframework.org/schema/mvc/spring-mvc.xsd">
    <!--扫描controller-->
    <context:component-scan base-package="com.kdf.controller"/>
    <!--配置视图解析器-->
    <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/pages/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
    <!--开启注解驱动的支持-->
    <mvc:annotation-driven/>
</beans>
4.4、编写页面，测试springmvc是否搭建成功 ​
在index.jsp文件中编写超链接跳转到Controller

<a href="${pageContext.request.contextPath}/findAll.do">查询所有</a>
4.5、创建UserController，编写方法，进行测试 ​
@Controller
public class UserController {
    @RequestMapping("/findAll.do")
    public String findAll(){
        System.out.println("controller层：测试springmvc请求成功");
        //返回页面
        return "success";
    }
}
4.6、整合 ​

​ 目的：在controller中能成功调用service对象中的方法

在项目启动的时候，就加载applicationContext.xml的配置文件，在web.xml中配置 ContextLoaderListener监听器（该监听器只能加载WEB-INF目录下的applicationContext.xml的配置文 件）

<!-- 配置Spring的监听器，用于启动服务时加载容器 -->
<listener>
	<listener-class>org.springframework.web.context.ContextLoaderListener</listenerclass>
</listener>
<!-- 配置加载类路径的配置文件 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>

在controller中注入service对象，调用service对象的方法进行测试

@Controller
public class UserController {
    @Autowired
    UserService userService; //Controller中注入service对象
    @RequestMapping("/findAll.do")
    public String findAll(Model model){
        List<User> all = userService.findAll(); //调用service中的方法
        System.out.println("查询所有执行成功"+all);
        model.addAttribute("list",all);
        return "success";
    }
}

5、spring整合mybatis ​

5.1、搭建mybatis的运行环境 ​

​ 编写mybatis的核心配置文件----sqlMapConfig.xml

<?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>
<!--    加载配置文件-->
    <properties resource="jdbc.properties"/>
<!--    配置别名-->
    <typeAliases>
        <package name="com.kdf.entity"/>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--加载mybatis的映射文件-->
        <mapper resource="com/kdf/mapper/userMapper.xml"/>
    </mappers>
</configuration>
5.2、编写mybatis的映射文件（userMapper.xml) ​

​ 在resources资源目录下创建directory （com/kdf/mapper),在mapper文件夹下创建userMapper.xml

<?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="com.kdf.dao.UserDao">
    <select id="queryAll" resultType="user">
        select * from tb_user
    </select>
</mapper>
5.3、编写测试代码 ​

​ 测试mybatis的框架是否正确运行

    @Test
    public void test2() throws IOException {
        //加载配置文件
        InputStream in = Resources.getResourceAsStream("sqlMapConfig.xml");
        //创建SQLSessionFactory的构建者
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        SqlSessionFactory factory = builder.build(in);
        SqlSession sqlSession = factory.openSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        List<User> users = mapper.queryAll();
        System.out.println(users);
    }
5.4、整合mybatis ​

​ 整合思路：把 mybatis 配置文件（SqlMapConfig.xml）中内容配置到 spring 配置文件中， 同时，把 mybatis配置文件的内容清掉。

注意： 由于我们使用的是代理 Dao 的模式，Dao 具体实现类由 MyBatis 使用代理方式创建，所以此时 mybatis 配置文件不能删。

5.4.1、配置数据源 ​
  <!--引入jdbc.properties-->
    <context:property-placeholder location="classpath:jdbc.properties"/>
    <!--配置数据源-->
    <bean class="com.alibaba.druid.pool.DruidDataSource" id="dataSource">
        <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>
5.4.2、配置mybatis的sqlSession工厂 ​
<!--配置sqlSession工程-->
    <bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sessionFactory">
        <!--加载数据源-->
        <property name="dataSource" ref="dataSource"/>
        <!--加载mybatis的配置文件-->
        <property name="configLocation" value="classpath:sqlMapConfig.xml"/>
        <!--加载mapper文件-->
        <property name="mapperLocations" value="classpath:com/kdf/mapper/*.xml"/>
    </bean>
5.4.3、配置自动扫描所有接口和文件 ​
<!--配置扫描dao的包-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
	<property name="basePackage" value="com.kdf.dao"/>
</bean>
5.4.4、在userDao中添加@Repostory注解 ​
@Repository
public interface UserDao {
    public List<User> queryAll();
}
5.4.5、在service中注入dao的对象 ​
@Service
public class UserService {
    @Autowired
    private UserDao userDao; //注入dao的对象
    public List<User> findAll(){
        List<User> users = userDao.queryAll();
        System.out.println("查询成功");
        return users;
    }
}

6、测试整合结果 ​

6.1、编写测试类测试 ​
@Test
public void test3(){
    //读取配置文件
    ApplicationContext app = new 	ClassPathXmlApplicationContext("applicationContext.xml");
//获取bean对象
	UserService service = app.getBean(UserService.class);
	List<User> all = service.findAll();
	System.out.println(all);
}
6.2、在服务器中测试 ​

​ 编写index.jsp页面访问controller

<%@page pageEncoding="UTF-8" contentType="text/html; charset=utf-8" language="java" %>
<html>
<body>
<h2>ssm整合好了，测试一下吧~</h2>
<a href="${pageContext.request.contextPath}/findAll.do">查询所有</a>
</body>
</html>

​ 编写success.jsp页面测试

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
    <h1>spring整合springmvc成功。。。。</h1>
<table>
    <tr>
        <th>编号</th>
        <th>姓名</th>
        <th>生日</th>
        <th>性别</th>
        <th>地址</th>
    </tr>
    <c:forEach items="${list}" var="user">
        <tr>
            <td>${user.id}</td>
            <td>${user.username}</td>
            <td>${user.birthday}</td>
            <td>${user.sex}</td>
            <td>${user.address}</td>
        </tr>
    </c:forEach>
</table>
<p>${list.size()}</p>
</body>
</html>
最近更新