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