使用配置文件整合ssm

提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档

---

前言

使用配置文件整合ssm，需要创建的配置文件包括：
spring的配置文件：applicationContext.xml，
mybatis的配置文件：mybatis.xml，配置mybatis的一些属性，
springmvc的配置文件：springmvc.xml，配置视图引擎，添加页面的映射，
web配置文件：web.xml

---

一、创建表

二、创建实体类、xxxMapper接口、xxxService接口、xxxServiceImpl实现类、xxxController逻辑类

1.User实体类

/*  使用了lombok插件  */
@Data	
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private Integer id;
    private String name;
    private String gender;
    private String password;
}

2、UserMapper接口

@Mapper
public interface UserMapper {
    @Select("select * from tbl_user")
    List<User> findAll();
}

3、UserService接口

public interface UserService {
    List<User> findAll();
}

4、UserServiceImpl实现类

@Service("userService")
public class UserServiceImpl implements UserService {
    @Autowired
    private UserMapper mapper;

    @Override
    public List<User> findAll() {
        List<User> userList = mapper.findAll();
        System.out.println("查找成功");
        return userList;
    }
}

5、UserController逻辑类

@Controller
public class UserController {
    @Autowired
    private UserService userService;

    @RequestMapping("/list")
    public String getAll(Model model){
        List<User> userList = userService.findAll();
        model.addAttribute("msg" , "查询所有用户\n" + userList);
        return "success";
    }
}

三、applicaitonContext.xml配置文件

1、设定扫描的范围，contrller层属于springmvc的扫描范围，这里使用context:exclude-filter标签排除
2、配置数据源，这里用的是Druid数据库连接池导入jdbc.properties配置文件，以下是创建的 jdbc.properties文件
注意：必须使用在location中加入classpath，否则会报错

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test?useSSL=false
jdbc.username=root
jdbc.password=root

3、配置session工厂 把数据源注入给Session工厂 SqlSessionFactory是创建访问数据库服务所必须的持久层configLocation Mybatis主配置文件路径，支持classpath语法mapperLocations 指定mybatis的mapper配置文件，支持classpath语法dataSource 数据源。
4、配置mapper的扫描包。

<?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 https://www.springframework.org/schema/context/spring-context.xsd">

    <context:component-scan base-package="com.zch">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

    <!--    配置数据源   -->
    <context:property-placeholder location="classpath:jdbc.properties"/>
    <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>

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

    <!--    扫描包  -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.zch.mapper"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>
</beans>

四、mybatis配置文件

<?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>

    <mappers>
        <package name="com.zch.mapper"/>
    </mappers>
</configuration>

此处完成后可以利用SpringTest进行测试，主要测试数据库连接无异常

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = {"classpath:applicationContext.xml"})
public class UserServiceImplTest {
    @Test
    public void findAll() {
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        UserService userService = (UserService) context.getBean("userService");

        List<User> userList = userService.findAll();
        userList.forEach(System.out::println);
    }
}

五、配置springmvc.xml文件

本项目使用的是thymeleaf引擎模板
需在WEB-INF目录下创建templates文件夹j

<?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 http://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">

    <context:component-scan base-package="com.zch">
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

    <bean id="viewResolve" class="org.thymeleaf.spring5.view.ThymeleafViewResolver">
        <property name="order" value="1"/>
        <property name="characterEncoding" value="UTF-8"/>
        <property name="templateEngine">
            <bean class="org.thymeleaf.spring5.SpringTemplateEngine">

                <property name="templateResolver">
                    <bean class="org.thymeleaf.spring5.templateresolver.SpringResourceTemplateResolver">
                        <property name="prefix" value="/WEB-INF/templates/"/>

                        <property name="suffix" value=".html"/>
                        <property name="templateMode" value="HTML5"/>
                        <property name="characterEncoding" value="UTF-8"/>

                    </bean>
                </property>

            </bean>
        </property>
    </bean>

    <mvc:view-controller path="/" view-name="index"></mvc:view-controller>
    <!--开启MVC的注解驱动，不然之前所有的请求映射都无法正常访问 404-->
    <mvc:annotation-driven/>

</beans>

六、配置web.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>
  <display-name>Archetype Created Web Application</display-name>
  <!--监听器，一定要配置！否则会出现HTTP状态500 - 内部服务器错误-->
<listener>
  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

<!--  spring启动容器-->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:applicationContext.xml</param-value>
  </context-param>

  <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>forceRequestEncoding</param-name>
      <param-value>true</param-value>
    </init-param>
  </filter>
  <filter-mapping>
    <filter-name>CharacterEncodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
  
  <servlet>
    <servlet-name>test</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

    <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>test</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>
</web-app>

七、创建html文件

1、index.html

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>首页</title>
</head>
<body>
    <h2>首页</h2>
<a th:href="@{/list}">所有用户</a>
</body>
</html>

2、success.html

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>成功</title>
</head>
<body>
    <p th:text="${msg}"></p>
</body>
</html>

八、最后配置tomcat服务器

如下图：

九、运行

最终运行结果