1、添加spring相关jar包
2、配置ehcache jar包。
3、添加ehcache mybatis 适配器jar包(在mybatis官网)
4、添加spring mybatis 适配器jar包(在mybatis)官网
5、pom.xml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
|
< 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" >
< modelVersion >4.0.0</ modelVersion >
< groupId >com.ntjr.mybatisSpring</ groupId >
< artifactId >mybatisSpring</ artifactId >
< version >0.0.1-SNAPSHOT</ version >
< packaging >war</ packaging >
< properties >
< mybatis_version >3.4.2</ mybatis_version >
< mysql_connector_version >5.1.38</ mysql_connector_version >
< org.springframework >4.3.7.RELEASE</ org.springframework >
</ properties >
< dependencies >
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
< dependency >
< groupId >org.mybatis</ groupId >
< artifactId >mybatis</ artifactId >
< version >${mybatis_version}</ version >
</ dependency >
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
< dependency >
< groupId >mysql</ groupId >
< artifactId >mysql-connector-java</ artifactId >
< version >${mysql_connector_version}</ version >
</ dependency >
<!-- https://mvnrepository.com/artifact/log4j/log4j -->
< dependency >
< groupId >log4j</ groupId >
< artifactId >log4j</ artifactId >
< version >1.2.16</ version >
</ dependency >
<!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
< dependency >
< groupId >org.springframework</ groupId >
< artifactId >spring-webmvc</ artifactId >
< version >${org.springframework}</ version >
</ dependency >
<!-- https://mvnrepository.com/artifact/org.springframework/spring-tx -->
< dependency >
< groupId >org.springframework</ groupId >
< artifactId >spring-tx</ artifactId >
< version >${org.springframework}</ version >
</ dependency >
< dependency >
< groupId >org.springframework</ groupId >
< artifactId >spring-jdbc</ artifactId >
< version >${org.springframework}</ version >
</ dependency >
< dependency >
< groupId >org.springframework</ groupId >
< artifactId >spring-orm</ artifactId >
< version >${org.springframework}</ version >
</ dependency >
<!-- https://mvnrepository.com/artifact/org.aopalliance/com.springsource.org.aopalliance -->
< dependency >
< groupId >org.aopalliance</ groupId >
< artifactId >com.springsource.org.aopalliance</ artifactId >
< version >1.0.0</ version >
</ dependency >
<!-- https://mvnrepository.com/artifact/net.sourceforge.cglib/com.springsource.net.sf.cglib -->
< dependency >
< groupId >net.sourceforge.cglib</ groupId >
< artifactId >com.springsource.net.sf.cglib</ artifactId >
< version >2.2.0</ version >
</ dependency >
<!-- https://mvnrepository.com/artifact/org.aspectj/com.springsource.org.aspectj.weaver -->
< dependency >
< groupId >org.aspectj</ groupId >
< artifactId >com.springsource.org.aspectj.weaver</ artifactId >
< version >1.6.10.RELEASE</ version >
</ dependency >
<!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->
< dependency >
< groupId >com.mchange</ groupId >
< artifactId >c3p0</ artifactId >
< version >0.9.5.2</ version >
</ dependency >
< dependency >
< groupId >org.mybatis.caches</ groupId >
< artifactId >mybatis-ehcache</ artifactId >
< version >1.1.0</ version >
</ dependency >
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
< dependency >
< groupId >org.mybatis</ groupId >
< artifactId >mybatis-spring</ artifactId >
< version >1.3.1</ version >
</ dependency >
<!-- https://mvnrepository.com/artifact/commons-logging/commons-logging -->
< dependency >
< groupId >commons-logging</ groupId >
< artifactId >commons-logging</ artifactId >
< version >1.2</ version >
</ dependency >
<!-- https://mvnrepository.com/artifact/org.apache.taglibs/taglibs-standard-impl -->
< dependency >
< groupId >org.apache.taglibs</ groupId >
< artifactId >taglibs-standard-impl</ artifactId >
< version >1.2.5</ version >
</ dependency >
<!-- https://mvnrepository.com/artifact/org.apache.taglibs/taglibs-standard-impl -->
< dependency >
< groupId >org.apache.taglibs</ groupId >
< artifactId >taglibs-standard-spec</ artifactId >
< version >1.2.5</ version >
</ dependency >
</ dependencies >
</ project >
|
6、applicationContext.xml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
<? 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:mybatis-spring = "http://mybatis.org/schema/mybatis-spring"
xmlns:tx = "http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
<!-- Spring希望管理所有的业务逻辑组件,等。。。 -->
< context:component-scan base-package = "com.atguigu.mybatis" >
< context:exclude-filter type = "annotation"
expression = "org.springframework.stereotype.Controller" />
</ context:component-scan >
<!-- 引入数据库的配置文件 -->
< context:property-placeholder location = "classpath:dbconfig.properties" />
<!-- Spring用来控制业务逻辑。数据源、事务控制、aop -->
< bean id = "dataSource" class = "com.mchange.v2.c3p0.ComboPooledDataSource" >
< property name = "jdbcUrl" value = "${jdbc.url}" ></ property >
< property name = "driverClass" value = "${jdbc.driver}" ></ property >
< property name = "user" value = "${jdbc.username}" ></ property >
< property name = "password" value = "${jdbc.password}" ></ property >
</ bean >
<!-- spring事务管理 -->
< bean id = "dataSourceTransactionManager" class = "org.springframework.jdbc.datasource.DataSourceTransactionManager" >
< property name = "dataSource" ref = "dataSource" ></ property >
</ bean >
<!-- 开启基于注解的事务 -->
< tx:annotation-driven transaction-manager = "dataSourceTransactionManager" />
<!--
整合mybatis
目的:1、spring管理所有组件。mapper的实现类。
service==>Dao @Autowired:自动注入mapper;
2、spring用来管理事务,spring声明式事务
-->
<!--创建出SqlSessionFactory对象 -->
< bean id = "sqlSessionFactoryBean" class = "org.mybatis.spring.SqlSessionFactoryBean" >
< property name = "dataSource" ref = "dataSource" ></ property >
<!-- configLocation指定全局配置文件的位置 -->
< property name = "configLocation" value = "classpath:mybatis-config.xml" ></ property >
<!--mapperLocations: 指定mapper文件的位置-->
< property name = "mapperLocations" value = "classpath:mybatis/mapper/*.xml" ></ property >
</ bean >
<!--配置一个可以进行批量执行的sqlSession -->
< bean id = "sqlSession" class = "org.mybatis.spring.SqlSessionTemplate" >
< constructor-arg name = "sqlSessionFactory" ref = "sqlSessionFactoryBean" ></ constructor-arg >
< constructor-arg name = "executorType" value = "BATCH" ></ constructor-arg >
</ bean >
<!-- 扫描所有的mapper接口的实现,让这些mapper能够自动注入;
base-package:指定mapper接口的包名
-->
< mybatis-spring:scan base-package = "com.atguigu.mybatis.dao" />
<!-- <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.atguigu.mybatis.dao"></property>
</bean> -->
</ beans >
|
7、mybatis-config.xml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
<? 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 = "mapUnderscoreToCamelCase" value = "true" />
< setting name = "jdbcTypeForNull" value = "NULL" />
<!--显式的指定每个我们需要更改的配置的值,即使他是默认的。防止版本更新带来的问题 -->
< setting name = "cacheEnabled" value = "true" />
< setting name = "lazyLoadingEnabled" value = "true" />
< setting name = "aggressiveLazyLoading" value = "false" />
</ settings >
< databaseIdProvider type = "DB_VENDOR" >
< property name = "MySQL" value = "mysql" />
< property name = "Oracle" value = "oracle" />
< property name = "SQL Server" value = "sqlserver" />
</ databaseIdProvider >
</ configuration >
|
注意:此处mybatis配置文件中没有配置数据源,数据源由spring负责。
此外还需要ehcache.xml配置文件,Mapper.xml文件。
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持服务器之家。
原文链接:https://www.cnblogs.com/zhaobingqing/p/7110083.html