在idea下ssm整合的配置文件

1.整个项目的目录结构如下，便于理解

 

2. 如上图，从上到下进行配置

（1）首先的db.properties文件的配置

db.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatis
jdbc.user=root
jdbc.password=root
initialSize=3
maxActive=20
maxIdle=20
minIdle=1
maxWait=6000

（2）generatorConfig.xml文件的配置

该配置是mybatis的逆向工程，可以自动生成实体类文件、Mapper文件和持久层的接口文件

详情请见例外一个博客：https://blog.csdn.net/Intelligent_33/article/details/95363995

 

（3）mybatis-config.xml文件的配置

mybatis-config.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>
    <!-- 全局setting，根据配置添加-->
    <!--配置别名-->
    <typeAliases>
        <!-- 批量扫描的别名-->
        <package name="com.lnsf.entities"/>

    </typeAliases>

    <!--引入分页插件 -->
    <plugins>
        <plugin interceptor="com.github.pagehelper.PageInterceptor">
            <!--分页合理化 -->
            <property name="reasonable" value="true"/>
        </plugin>
    </plugins>

</configuration>

（4）spring.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"
        xmlns:cache="http://www.springframework.org/schema/cache"
        xmlns:aop="http://www.springframework.org/schema/aop"
        xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
        xmlns:context="http://www.springframework.org/schema/context"
        xmlns:tx="http://www.springframework.org/schema/tx"
        xsi:schemaLocation="http://www.springframework.org/schema/cache http://www.springframework.org/schema/cache/spring-cache-4.3.xsd
      http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd
      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-4.3.xsd
      http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
      http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">

    <!-- spring扫描dao 和 server -->
    <context:component-scan base-package="com.lnsf">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

    <!-- 导入外部文件 -->
    <context:property-placeholder location="classpath:db.properties"/>
    <!-- 配置连接池 -->
    <bean id="datasource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"></property>
        <property name="jdbcUrl" value="${jdbc.url}"></property>
        <property name="user" value="${jdbc.user}"></property>
        <property name="password" value="${jdbc.password}"></property>

        <property name="initialPoolSize" value="${initialSize}"></property>
        <property name="maxPoolSize" value="${maxActive}"></property>
        <property name="maxIdleTime" value="${maxIdle}"></property>
        <property name="maxConn