首先pom. 中需要导入的包

    <!--mybatis-spring-->
      <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis-spring</artifactId>
          <version>1.3.2</version>
      </dependency>
      <!--mybatis-->
      <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis</artifactId>
          <version>3.4.4</version>
      </dependency>
      <!--mysql-->
      <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>8.0.11</version>
      </dependency>
        <!--spring-->
      <dependency>
          <groupId>org.spring work</groupId>
          <artifactId>spring-context</artifactId>
          <version>5.0.2.RELEASE</version>
      </dependency>
      <dependency>
          <groupId>org.spring work</groupId>
          <artifactId>spring-tx</artifactId>
          <version>5.0.2.RELEASE</version>
      </dependency>
      <dependency>
          <groupId>org.spring work</groupId>
          <artifactId>spring-jdbc</artifactId>
          <version>5.0.2.RELEASE</version>
      </dependency>
      <dependency>
          <groupId>org.aspectj</groupId>
          <artifactId>aspectjweaver</artifactId>
          <version>1.8.11</version>
      </dependency>
      <!--log4j-->

      <dependency>
          <groupId>org.slf4j</groupId>
          <artifactId>slf4j-log4j12</artifactId>
          <version>1.7.25</version>
          <scope>test</scope>
      </dependency>


      <!--c3p0-->
      <dependency>
          <groupId>c3p0</groupId>
          <artifactId>c3p0</artifactId>
          <version>0.9.1.2</version>
      </dependency>
      <dependency>
          <groupId>com.mchange</groupId>
          <artifactId>mchange-commons-java</artifactId>
          <version>0.2.11</version>
      </dependency>

Mybatis总配置文件

<?  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>
    <typeAliases>
		<!--<typeAlias type=\"cn.gsm.mybatis.pojo.Book\" alias=\"Book\"></typeAlias>-->
        <!-- 批量别名定义,扫描整个包下的类,别名为类名(首字母大写或小写都可以) -->
        <package name=\"cn.gsm.mkm.pojo\"/>
	</typeAliases>
    <mappers>
		<!--resource是使用/-->
        <!--指定扫描某个配置文件-->
		<!--<mapper resource=\"cn/gsm/mybatis/mapper/BookMapper. \"></mapper>-->
        <!--扫描指定包下的所有文件-->
        <package name=\"cn.gsm.mkm.mapper\"></package>
	</mappers>
</configuration>

spring配置文件

<?  version=\"1.0\" encoding=\"UTF-8\"?>
<beans  ns=\"http://www.spring work.org/schema/beans\"
	    ns:xsi=\"http://www.w3.org/2001/ Schema-instance\"
	    ns:context=\"http://www.spring work.org/schema/context\"
	   xsi:schemaLocation=\"http://www.spring work.org/schema/beans
    	 http://www.spring work.org/schema/beans/spring-beans.xsd
     	 http://www.spring work.org/schema/context
         http://www.spring work.org/schema/context/spring-context.xsd \">
	<!--数据库连接配置文件-->
	<context:property-placeholder location=\"classpath:jdbc.properties\"/>
    <!-- 1) 连接池实例 -->
	<bean id=\"dataSource\" class=\"com.mchange.v2.c3p0.ComboPooledDataSource\">
		<property name=\"driverClass\" value=\"${mysql8Driver}\"></property>
		<property name=\"jdbcUrl\"
				  value=\"${mysql8url}\"></property>
		<property name=\"user\" value=\"${mySQLUsername}\"></property>
		<property name=\"password\" value=\"${mySQLPwd}\"></property>
		<property name=\"initialPoolSize\" value=\"3\"></property>
		<property name=\"maxPoolSize\" value=\"6\"></property>
	</bean>
    <bean id=\"sessionFactory\" class=\"org.mybatis.spring.SqlSessionFactoryBean\">
		<!-- a. 连接池 -->
		<property name=\"dataSource\" ref=\"dataSource\"></property>
		<!--读取myBatis主配置文件-->
		<property name=\"configLocation\" value=\"classpath:SqlMapConfig. \"></property>
        <!--if mapper接口的配置文件与接口不在同一目录下,需要手动配置 配置文件的路径-->
        <!--<property name=\"mapperLocations\" value=\"classpath:cn/gsm/mkm/mapper/*. \">        </property>-->
	</bean>
    <bean class=\"org.mybatis.spring.mapper.MapperScannerConfigurer\">
         <!--配置mapper接口的 路径-->
         <property name=\" Package\"  value=\"cn.gsm.mkm.mapper\"></property>
     </bean>
    <!--指定扫描某包下的所有东西-->
	<context:component-scan  -package=\"cn.gsm.mkm.service.*\"></context:component-scan>

</beans>    

 

收藏 打印