SSM整合

SSM整合

1 添加依赖

junit, spring-context, spring-web, spring-webmvc,mybatis, mybatis-spring,
jstl, javax.servlet-api, jsp-api, mysql-connector-java,
druid, 日志slf4j-log4j12, spring-jdbc, spring-tx, spring-test
网站上面查找最新版的依赖：
https://mvnrepository.com/

2 连接数据库，生成实体类

3 配置文件

3.1 Dao层配置：spring-dao.xml

dao：data，access，object
1.数据库连接池
2.SqlSessionFactory对象，需要spring 和 mybatis 整合包下的
3.交给mapper管理，配置mapper文件扫描器
4.事务管理

<!--    自动扫描-->
    <context:component-scan base-package="com.java201.pojo"/>
<!--    引入数据库的db.properties文件-->
    <context:property-placeholder location="classpath:config/db.properties"/>
<!--    配置数据源-->
    <bean name="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${db.driver}"/>
        <property name="url" value="${db.url}"/>
        <property name="username" value="${db.userName}"/>
        <property name="password" value="${db.password}"/>
    </bean>
<!--    配置mybatis的工厂sqlSessionFactory-->
    <bean name="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--        引用数据源-->
        <property name="dataSource" ref="dataSource"/>
<!--        别名-->
        <property name="typeAliasesPackage" value="com.java201.pojo"/>
<!--        指定mybatis核心配置文件的位置-->
        <property name="configLocation" value="classpath:sqlMapConfig.xml"/>
<!--        自动扫描 mapping.xml文件-->
        <property name="mapperLocations" value="classpath:mapper/*.xml"/>
    </bean>
<!--    配置mapperScan，自哦懂扫描mybatis中的pojo接口包，并且自动注入到上面的工厂，
        初始化所有的mapper接口对象 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.java201.dao"/>
    </bean>
<!--    开启事务管理器-->
    <bean name="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
<!--    开启事务注解-->
    <tx:annotation-driven transaction-manager="transactionManager"/>

mybatis核心配置文件：sqlMapConfig.xml

<configuration>
    <settings>
        <!--当返回行的所有列都是空时， MyBatis 默认返回 null-->
        <setting name="returnInstanceForEmptyRow" value="true"/>
        <!--显示 sql 语句-->
        <setting name="logImpl" value="STDOUT_LOGGING"/>
        <!--数据库的字段名的下划线 => pojo 属性中的 驼峰命名法-->
       <!-- <setting name="mapUnderscoreToCamelCase" value="true"/>-->
        <!--开启二级缓存-->
        <setting name="cacheEnabled" value="true"/>
    </settings>
</configuration>

3.2 Controller层配置：spring-web.xml

1.包扫描器，扫描Controller注解的类
2.配置注解驱动
3.配置视图层解析器

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

    <!--    开启注解扫描，扫描controller包，有多个用逗号隔开-->
    <context:component-scan base-package="com.java201.controller"/>
    <!--    自动加载推荐的处理器映射器、适配器-->
    <mvc:annotation-driven/>
    <!--    配置视图解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <!-- 指定视图前缀-->
        <property name="prefix" value="/WEB-INF/pages/"/>
        <!-- 指定视图后缀-->
        <property name="suffix" value=".jsp"/>
    </bean>
<!--    对静态资源进行放行，对其他资源放行也是同理-->
    <mvc:resources mapping="/img/**" location="/img/"/>
</beans>

3.3 web.xml

1.配置spring监听器，指定读取的文件
2.配置前端控制器

<?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_3_1.xsd"
         version="3.1"
         metadata-complete="true">
  <display-name>Archetype Created Web Application</display-name>
<!--  spring监听器，监听容器启动，加载配置文件-->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:spring-*.xml</param-value>
  </context-param>
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  
<!--  解决post乱码过滤器-->
  <filter>
    <filter-name>EncodingFilter</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>EncodingFilter</filter-name>
    <url-pattern>/ *</url-pattern>
  </filter-mapping>

  <!--配置前端控制器-->
  <servlet>
    <servlet-name>SpringMVC</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <!--加载配置文件-->
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:spring-web.xml</param-value>
    </init-param>
    <!--随容器启动而加载-->
    <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>SpringMVC</servlet-name>
<!--    匹配所有请求，包括img,js.css，所以在spring-web.xml中放行-->
    <url-pattern>/</url-pattern>
  </servlet-mapping>
</web-app>

测试：
添加接口UserMapper以及他的配置UserMapper.xml


@RunWith 运行；
@ContextConfiguration(“calsspath:spring-dao.xml”)加载配置文件；
@Autowired 自动注入对象

3.4 Service层配置：spring-service.xml

1.service包的注解扫描@Service
2.事务管理

<context:component-scan base-package="com.java201.service"/>

接口类 XxxService.java

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

接口实现类

@Service
@Transactional(rollbackFor = Throwable.class)
public class UserServiceImpl implements UserService {

    @Autowired
    private UserMapper mapper;

    @Override
    public List<User> findAllUsers() {
        return mapper.findAll();
    }
}

测试：

@Controller
public class UserController {

    @Autowired
    private UserService userService;

    @RequestMapping("/find")
    public String findAll(Model model) {
        List<User> users = userService.findAllUsers();
        model.addAttribute("list",users);
        return "findusers";
    }
}

findusers.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>
</head>
<body>
<table align="center" style="background-color: antiquewhite">
    <tr>
        <th>ID</th>
        <th>姓名</th>
        <th>年龄</th>
    </tr>
    <c:forEach items="${list}" var="list">
        <tr>
            <td>${list.id}</td>
            <td>${list.userName}</td>
            <td>${list.userAge}</td>
        </tr>
    </c:forEach>
</table>
</body>
</html>

解决用tomcat插件控制台输出乱码

解决post表单提交乱码

web.xml中添加过滤器

<!--  解决post乱码过滤器-->
  <filter>
    <filter-name>EncodingFilter</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>EncodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>