Spring+mybatis整合

之前都在做平台类的项目，因为最近有个海外项目要急着上线，但是微服务改造计划还没完完成，只能由我来先写一个过渡性的东西，供海外使用，计划使用springboot去做，但是因为要先做一个实验性的改造，先用spring+mybatis实现原有的功能以测试和hibernate的差别是否有很大的区别，重新构建sm框架时，遇到了很多坑，研究了一下午终于搞定。

首先是spring-mybatis的配置文件：

<?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:aop="http://www.springframework.org/schema/aop" 
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/aop 
http://www.springframework.org/schema/aop/spring-aop.xsd"> 
<!-- 开启自动扫描 --> 
<context:component-scan base-package="com.travelsky.cupps.db.other"></context:component-scan> 
<!-- --> 
<aop:aspectj-autoproxy /> 
<!-- 引入外部数据库的配置文件，location位置填写的是相对位置 --> 
<context:property-placeholder location="jdbc.properties" 
ignore-resource-not-found="false" local-override="false" /> 
<!-- 配置数据库连接池 --> 
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<!-- 初始化连接大小 -->
<property name="initialSize" value="${jdbc.initialSize}"></property>
<!-- 连接池最大数量 -->
<property name="maxActive" value="${jdbc.maxActive}"></property>
<!-- 连接池最大空闲 -->
<property name="maxIdle" value="${jdbc.maxIdle}"></property>
<!-- 连接池最小空闲 -->
<property name="minIdle" value="${jdbc.minIdle}"></property>
<!-- 获取连接最大等待时间 -->
<property name="maxWait" value="${jdbc.maxWait}"></property>
</bean>
 
 
<!-- ========================================针对myBatis的配置项============================== --> 
<!-- 配置SessionFactory --> 
<bean name="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> 
<!-- 实例化sqlSessionFactory时需要使用上述配置好的数据源以及SQL映射文件 --> 
<property name="dataSource" ref="dataSource" /> 
<property name="typeAliasesPackage" value="classpath:com/travelsky/cupps/db/other/entity"></property> 
<property name="mapperLocations" value="classpath:com/travelsky/cupps/db/other/mapper/*.xml" /> 
</bean> 
<!-- 扫描mapper配置文件的地址 --> 
<!-- <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> 
<property name="basePackage" value="com.travelsky.cupps.db.other.mapper.*xml" /> 
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /> 
</bean> -->
<!-- DAO接口所在包名，Spring会自动查找其下的类 Mybatis MapperScannerConfigurer 自动扫描 将Mapper接口生成代理注入到Spring -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.travelsky.cupps.db.other.mapper" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>
<!-- 配置Spring的事务管理器 --> 
<bean id="transactionManager" 
class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 
<property name="dataSource" ref="dataSource" /> 
</bean> 
</beans>

其次是jdbc.properties:

jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:ORCL
jdbc.username=root
jdbc.password=root
jdbc.initialSize=0
jdbc.maxActive=20
jdbc.maxIdle=20
jdbc.minIdle=1
jdbc.maxWait=60000

最后是pom.xml:

  1 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  2   <modelVersion>4.0.0</modelVersion>
  3   <groupId>com.travelsky</groupId>
  4   <artifactId>data</artifactId>
  5   <version>1.0</version>
  6    <properties>
  7         <!-- spring版本号 -->
  8         <spring.version>4.1.5.RELEASE</spring.version>
  9         <!-- mybatis版本号 -->
 10         <mybatis.version>3.2.6</mybatis.version>
 11         <!-- log4j日志文件管理包版本 -->
 12         <slf4j.version>1.7.7</slf4j.version>
 13         <log4j.version>1.2.17</log4j.version>
 14     </properties>
 15   <dependencies>
 16     <dependency>
 17       <groupId>junit</groupId>
 18       <artifactId>junit</artifactId>
 19       <version>3.8.1</version>
 20       <scope>test</scope>
 21     </dependency>
 22     <!-- springmvcjar包 -->
 23         <!-- jacksonjar包 -->
 24         <dependency>
 25             <groupId>com.fasterxml.jackson.core</groupId>
 26             <artifactId>jackson-databind</artifactId>
 27             <version>2.5.0</version>
 28         </dependency>
 29         <dependency>
 30             <groupId>com.fasterxml.jackson.core</groupId>
 31             <artifactId>jackson-core</artifactId>
 32             <version>2.5.0</version>
 33         </dependency>
 34         
 35         <!-- json -->
 36         <dependency>
 37             <groupId>net.sf.json-lib</groupId>
 38             <artifactId>json-lib</artifactId>
 39             <version>2.2.3</version>
 40             <classifier>jdk15</classifier>
 41         </dependency>
 42         
 43         <dependency>
 44             <groupId>com.fasterxml.jackson.core</groupId>
 45             <artifactId>jackson-annotations</artifactId>
 46             <version>2.5.0</version>
 47         </dependency>
 48         <dependency>
 49             <groupId>org.springframework</groupId>
 50             <artifactId>spring-core</artifactId>
 51             <version>${spring.version}</version>
 52         </dependency>
 53 
 54         <dependency>
 55             <groupId>org.springframework</groupId>
 56             <artifactId>spring-web</artifactId>
 57             <version>${spring.version}</version>
 58         </dependency>
 59         <dependency>
 60             <groupId>org.springframework</groupId>
 61             <artifactId>spring-orm</artifactId>
 62             <version>${spring.version}</version>
 63         </dependency>
 64         <dependency>
 65             <groupId>org.springframework</groupId>
 66             <artifactId>spring-oxm</artifactId>
 67             <version>${spring.version}</version>
 68         </dependency>
 69         <dependency>
 70             <groupId>org.springframework</groupId>
 71             <artifactId>spring-tx</artifactId>
 72             <version>${spring.version}</version>
 73         </dependency>
 74 
 75         <dependency>
 76             <groupId>org.springframework</groupId>
 77             <artifactId>spring-jdbc</artifactId>
 78             <version>${spring.version}</version>
 79         </dependency>
 80 
 81         <dependency>
 82             <groupId>org.springframework</groupId>
 83             <artifactId>spring-webmvc</artifactId>
 84             <version>${spring.version}</version>
 85         </dependency>
 86         <dependency>
 87             <groupId>org.springframework</groupId>
 88             <artifactId>spring-aop</artifactId>
 89             <version>${spring.version}</version>
 90         </dependency>
 91         
 92         <dependency>
 93             <groupId>org.springframework</groupId>
 94             <artifactId>spring-context</artifactId>
 95             <version>${spring.version}</version>
 96         </dependency>
 97 
 98         <dependency>
 99             <groupId>org.springframework</groupId>
100             <artifactId>spring-context-support</artifactId>
101             <version>${spring.version}</version>
102         </dependency>
103 
104         <dependency>
105             <groupId>org.springframework</groupId>
106             <artifactId>spring-test</artifactId>
107             <version>${spring.version}</version>
108         </dependency>
109         
110         <dependency>
111                <groupId>org.springframework</groupId>
112                <artifactId>spring-aspects</artifactId>
113            <version>${spring.version}</version>
114 </dependency>
115     <!-- mybatis jar包 -->
116     <dependency>
117             <groupId>org.mybatis</groupId>
118             <artifactId>mybatis</artifactId>
119             <version>${mybatis.version}</version>
120         </dependency>
121         <!-- mybatis/spring包 -->
122         <dependency>
123             <groupId>org.mybatis</groupId>
124             <artifactId>mybatis-spring</artifactId>
125             <version>1.2.2</version>
126         </dependency>
127     <!-- 其他jar -->
128     <!-- 导入oracle数据库链接jar包 -->
129         <dependency>
130             <groupId>com.travelsky.cupps</groupId>
131             <artifactId>oracle</artifactId>
132             <version>10.2.0.1.0</version>
133         </dependency>
134         <!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 -->
135         <dependency>
136             <groupId>commons-dbcp</groupId>
137             <artifactId>commons-dbcp</artifactId>
138             <version>1.2.2</version>
139         </dependency>
140         <!-- JSTL标签类 -->
141         <dependency>
142             <groupId>jstl</groupId>
143             <artifactId>jstl</artifactId>
144             <version>1.2</version>
145         </dependency>
146         <!-- 日志文件管理包 -->
147         <!-- log start -->
148         <dependency>
149             <groupId>log4j</groupId>
150             <artifactId>log4j</artifactId>
151             <version>${log4j.version}</version>
152         </dependency>
153         
154         <dependency>
155             <groupId>org.slf4j</groupId>
156             <artifactId>slf4j-api</artifactId>
157             <version>${slf4j.version}</version>
158         </dependency>
159 
160         <dependency>
161             <groupId>org.slf4j</groupId>
162             <artifactId>slf4j-log4j12</artifactId>
163             <version>${slf4j.version}</version>
164         </dependency>
165         <!-- 上传组件包 -->
166         <dependency>
167             <groupId>commons-fileupload</groupId>
168             <artifactId>commons-fileupload</artifactId>
169             <version>1.3.1</version>
170         </dependency>
171         <dependency>
172             <groupId>commons-io</groupId>
173             <artifactId>commons-io</artifactId>
174             <version>2.4</version>
175         </dependency>
176         <dependency>
177             <groupId>commons-codec</groupId>
178             <artifactId>commons-codec</artifactId>
179             <version>1.9</version>
180         </dependency>
181         <dependency>
182             <groupId>commons-codec</groupId>
183             <artifactId>commons-codec</artifactId>
184             <version>1.9</version>
185         </dependency>
186         <dependency>
187             <groupId>javax.servlet</groupId>
188             <artifactId>javax.servlet-api</artifactId>
189             <version>3.0.1</version>
190             <scope>provided</scope>
191         </dependency>
192         <dependency>
193             <groupId>javax.servlet.jsp</groupId>
194             <artifactId>jsp-api</artifactId>
195             <version>2.1</version>
196             <scope>provided</scope>
197         </dependency>
198         
199   </dependencies>
200 </project>

由着三个文件就能将sm框架给搭建起来，当然，一些实体还得自己写啦

本文链接：https://www.cnblogs.com/daimazhang/p/9179201.html

Spring+mybatis整合

Spring+mybatis整合的更多相关文章

随机推荐

热门专题

目录导航