【Spring+Mybatis+SpringMVC整合项目二】天猫商城（配置框架文件）

超、凢脫俗 2022-04-12 14:17 224阅读 0赞

搭建好开发环境后，我们就是开始配置我们的框架

在配置框架前，先加入log4j.properties和jdbc.properties

在resources目录下新建log4j.properties。如图所示这个配置文件的作用是开启日志，当访问页面的时候，查看mybatis运行的情况，执行了什么SQL语句，以及sql语句的返回情况等信息。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70][]

###  log4j.properties代码如下 ###

# Global logging configuration
    log4j.rootLogger=ERROR, stdout
    # MyBatis logging configuration...
    log4j.logger.com.how2java.tmall=TRACE
    # Console output...
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

### 在resources目录下新建jdbc.properties，此配置文件给出了访问数据库需要的必须信息  ###

#数据库配置文件
    jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/tmall_ssm?useUnicode=true&characterEncoding=utf8
    jdbc.username=root
    jdbc.password=admin

### 然后，就开始配置Spring框架，在resources目录下新建applicationContext.xml ###

1.启动对注解的识别

<context:annotation-config />
    <context:component-scan base-package="com.how2java.tmall.service" />

2. 指定对jdbc.properties的引用

<context:property-placeholder location="classpath:jdbc.properties"/>

3. 配置数据源

4. 配置Mybatis的SessionFactory，其中声明了别名，并且使用前面配置的数据源，扫描CategoryMapper.xml配置文件

5.扫描CategoryMapper.xml配置文件

**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/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
         http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
     
        <context:annotation-config />
        <context:component-scan base-package="com.how2java.tmall.service" />
     
        
        <context:property-placeholder location="classpath:jdbc.properties"/>
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
            
            <property name="url" value="${jdbc.url}" />
            <property name="username" value="${jdbc.username}" />
            <property name="password" value="${jdbc.password}" />
     
            
            <property name="initialSize" value="1" />
            <property name="minIdle" value="1" />
            <property name="maxActive" value="20" />
     
            
            <property name="maxWait" value="60000" />
     
            
            <property name="timeBetweenEvictionRunsMillis" value="60000" />
     
            
            <property name="minEvictableIdleTimeMillis" value="300000" />
     
            <property name="validationQuery" value="SELECT 1" />
            <property name="testWhileIdle" value="true" />
            <property name="testOnBorrow" value="false" />
            <property name="testOnReturn" value="false" />
     
            
            <property name="poolPreparedStatements" value="true" />
            <property name="maxPoolPreparedStatementPerConnectionSize"
                      value="20" />
        </bean>
     
        
        <bean id="sqlSession" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="typeAliasesPackage" value="com.how2java.tmall.pojo" />
            <property name="dataSource" ref="dataSource"/>
            <property name="mapperLocations" value="classpath:mapper/*.xml"/>
            
            <property name="plugins">
                <array>
                    <bean class="com.github.pagehelper.PageInterceptor">
                        <property name="properties">
                            <value>
                            </value>
                        </property>
                    </bean>
                </array>
            </property>
        </bean>
     
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com.how2java.tmall.mapper"/>
        </bean>
     
    </beans>

###  在resources目录下新建springMVC.xml，这是对SpringMVC进行配置 ###

### 最后，修改web.xml ###

修改web.xml，主要提供如下功能  
1. 指定spring的配置文件为classpath下的applicationContext.xml  
2. 设置中文过滤器  
3. 指定spring mvc配置文件为classpath下的springMVC.xml

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xmlns="http://java.sun.com/xml/ns/javaee"
             xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
             version="2.5">
     
      
      <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
      </context-param>
      <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>
      </filter>
      <filter-mapping>
        <filter-name>CharacterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
      </filter-mapping>
     
      
      <servlet>
        <servlet-name>mvc-dispatcher</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>mvc-dispatcher</servlet-name>
        <url-pattern>/</url-pattern>
      </servlet-mapping>
     
    </web-app>

本项目会创建的包如下

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70 1][]

## ##

### 完成以上工作后，框架文件就算是配置好了，接下来会利用Mybatis的逆向工程，在数据库结构基础上，一次性将DAO层，Model层和DAO层的映射文件生成出来 ###

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70]: /images/20220412/75ab266b17b041cf9925731520f94418.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70 1]: /images/20220412/19333491be714558b39a22dee66f0c20.png