ssm整合笔记（配置文件

• 创建数据库

• 基本环境搭建

  • 连接数据库

    bd.properties

    jdbc.driver=com.mysql.jdbc.Driver
    # mysql8.0+s需要加入一个时区配置：  ?serverTimezone=UTC
    jdbc.url=jdbc:mysql://localhost:3306/ssmbuild
    jdbc.username=root
    jdbc.password=Wjy12300.
    

  • 包目录结构

    • mapper
    • service
    • controller
    • pojo

  • resources

    • mybatis-config.xml （mybatis核心配置

      <!--
      	1. 配置typeAliea 面向pojo
      	2. 配置映射到哪个mapper.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>
      <!--    日志打印 -->
        <settings>  
             <setting name="logImpl" value="STDOUT_LOGGING" />  
        </settings>
      <!--    引用别名 -->
          <typeAliases>
              <package name="com.qqhru.pojo"/>
          </typeAliases>
      
      <!--    映射配置 -->
          <mappers>
              <package name="com.qqhru.mapper.BookMapper"/>
        </mappers>
      </configuration>
      

    - Spring-dao.xml
    
      ```xml
      <!--spring整合mybatis
              1. 获取数据源配置文件 <context:property-placeholder
              2. 赋值数据源 <bean class="DriverManagerDataSource" （JdBC连接池
              3. 根据数据源和sqlSessionFactoryBean 获取sqlSession对象
              4. 根据sqlSession对象创建sqlSessionTemplate对象
              5. 为mapperImpl中的对象注入值
              6. 设置自动扫描 ma p层包中的类 注册到spring中
      -->
      <?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">
      <!--    首先获取数据源 -->
          <context:property-placeholder location="classpath:db.properties"/>
      
      <!--    加载数据源 引用配置文件中的配置-->
          <bean id="datasource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
              <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>
      <!--    在 MyBatis-Spring 中，可使用 SqlSessionFactoryBean来创建 SqlSessionFactory。
      要配置这个工厂 bean，只需要把下面代码放在 Spring 的 XML 配置文件中： -->
          <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
      <!--        通过数据源获取sqlSessionFactory对象 -->
              <property name="dataSource" ref="datasource" />
      <!--        配置全局配置文件 -->
              <property name="configLocation" value="classpath:mybatis-config.xml"/>
              <property name="mapperLocations" value="classpath:com/qqhru/mapper/*.xml"/>
          </bean>
      
              <!--注册sqlSessionTemplate , 关联sqlSessionFactory-->
              <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
                  <!--利用构造器注入-->
                  <constructor-arg index="0" ref="sqlSessionFactory"/>
              </bean>
      
      <!--    为dao中sqlSessionTemplate赋值-->
          <bean class="com.qqhru.mapper.impl.BookDaoImpl">
              <property name="sqlSessionTemplate" ref="sqlSession"/>
          </bean>
          <!--
                 自动扫描包中的类 并注册到Spring中
          解释 ：https://www.cnblogs.com/jpfss/p/7799806.html-->
          <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
              <!-- 注入sqlSessionFactory -->
              <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
              <!-- 给出需要扫描Dao接口包 -->
              <property name="basePackage" value="com.qqhru.mapper"/>
          </bean>
      
    </beans>
      
    

    • spring-service.xml

      <!--
      	1. 设置自动扫描 service层包中的类 注册到spring中
      	2. 注册<bean class="XxxServiceImpl"> 为service中的的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
              https://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.qqhru.service"/>
          <bean id="bookService" class="com.qqhru.service.Impl.BookServiceImpl">
              <property name="bookMapper" ref="bookMapper"/>
        </bean>
      </beans>
      

    
    
    - springmvc-config.xml (后面还涉及到静态资源的过滤配置 )
    
      ```xml
      <!--
      	1. 配置视图解析器
      	2. 开启注解支持
      	3. 设置自动扫描 controller层包中的类 注册到spring中
      	4. 静态资源过滤设置
      -->
      <?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
             https://www.springframework.org/schema/mvc/spring-mvc.xsd">
              <mvc:annotation-driven/>
      <!--    静态资源过滤 -->
              <mvc:default-servlet-handler/>
      <!--    视图解析器-->
              <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
                  <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />
                  <property name="prefix" value="/WEB-INF/pages/" />
                  <property name="suffix" value=".jsp" />
              </bean>
      <!--    其实mvc扫描的应该是视图层 -->
              <context:component-scan base-package="com.qqhru.controller"/>
    
      </beans>
    

    • web.xml

      <!--
      	1. 配置前端控制器
      	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">
      
          <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:applactionContext.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>
      
          <!--  过滤器-->
          <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>
      
          <servlet-mapping>
              <servlet-name>dispatcherServlet</servlet-name>
              <url-pattern>*.action</url-pattern>
        </servlet-mapping>
      </web-app>
      

    
    
    - applactionContext.xml （spring核心配置
    
      ```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"
             xsi:schemaLocation="http://www.springframework.org/schema/beans
             http://www.springframework.org/schema/beans/spring-beans.xsd">
      
          <import resource="springmvc-config.xml"/>
          <import resource="spring-dao.xml"/>
        <import resource="spring-service.xml"/>
      </beans>