AI 助理
备案控制台
开发者社区 开发与运维 文章 正文

Spring3.2.8+Mybatis3.2.6+Maven 整合配置

2017-11-21 1410
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
本文涉及的产品
RDS MySQL Serverless 基础系列，0.5-2RCU 50GB
推荐场景：
学生管理系统数据库设计 搭建个人博客
云数据库 RDS MySQL，高可用系列 2核4GB
云数据库 RDS PostgreSQL，高可用系列 2核4GB
简介：


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
<?xml version= "1.0"  encoding= "UTF-8" ?>
<beans  default -autowire= "byName"
        xmlns= "http://www.springframework.org/schema/beans"
        xmlns:xsi= "http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http: //www.springframework.org/schema/beans
             http: //www.springframework.org/schema/beans/spring-beans.xsd
             http: //www.springframework.org/schema/tx
             http: //www.springframework.org/schema/tx/spring-tx.xsd
             http: //www.springframework.org/schema/aop
             http: //www.springframework.org/schema/aop/spring-aop.xsd
             http: //www.springframework.org/schema/context
             http: //www.springframework.org/schema/context/spring-context.xsd"
        xmlns:tx= "http://www.springframework.org/schema/tx"
        xmlns:aop= "http://www.springframework.org/schema/aop"
        xmlns:context= "http://www.springframework.org/schema/context" >
     <context:annotation-config/>
     <context:property-placeholder location= "classpath*:jdbc.properties" />
     <!-- 配置系统的数据源 -->
     <bean id= "dataSource"  class = "com.alibaba.druid.pool.DruidDataSource"  init-method= "init"  destroy-method= "close" >
         <property name= "driverClassName"  value= "${driver}" />
         <property name= "url"  value= "${url}" />
         <property name= "username"  value= "root" />
         <property name= "password"  value= "leizm" />
         <property name= "filters"  value= "stat" />
         <property name= "maxActive"  value= "10" />
         <property name= "initialSize"  value= "1" />
         <property name= "maxWait"  value= "60000" />
         <property name= "minIdle"  value= "1" />
         <property name= "timeBetweenEvictionRunsMillis"  value= "60000" />
         <property name= "minEvictableIdleTimeMillis"  value= "300000" />
         <property name= "validationQuery"  value= "SELECT 'x'" />
         <property name= "testWhileIdle"  value= "true" />
         <property name= "testOnBorrow"  value= "false" />
         <property name= "testOnReturn"  value= "false" />
         <property name= "poolPreparedStatements"  value= "true" />
         <property name= "maxPoolPreparedStatementPerConnectionSize"  value= "50" />
         <property name= "maxOpenPreparedStatements"  value= "100" />
     </bean>
     <bean id= "sqlSessionFactory"  class = "org.mybatis.spring.SqlSessionFactoryBean" >
         <property name= "configLocation"  value= "classpath:mybatis-config.xml" />
         <property name= "mapperLocations"  value= "classpath:/com/lavasoft/demo/entity/*.xml" />
         <property name= "dataSource"  ref= "dataSource" />
     </bean>
     <!-- 事务管理器配置,单数据源事务 -->
     <bean id= "transactionManager"  class = "org.springframework.jdbc.datasource.DataSourceTransactionManager" >
         <property name= "dataSource"  ref= "dataSource" />
     </bean>
     <!-- 配置那些类的方法进行事务管理 -->
     <aop:config>
         <aop:pointcut id= "executeService"  expression= "execution(* com.lavasoft.*.service..*(..))" />
         <aop:advisor pointcut-ref= "executeService"  advice-ref= "txAdvice" />
     </aop:config>
     <tx:advice id= "txAdvice"  transaction-manager= "transactionManager" >
         <tx:attributes>
             <tx:method name= "select*"  read-only= "true" />
             <tx:method name= "get*"  read-only= "true" />
             <tx:method name= "load*"  read-only= "true" />
             <tx:method name= "find*"  read-only= "true" />
             <tx:method name= "query*"  read-only= "true" />
             <tx:method name= "read*"  read-only= "true" />
             <tx:method name= "sync*" />
             <tx:method name= "*"  propagation= "REQUIRED"  rollback- for = "java.lang.Exception" />
         </tx:attributes>
     </tx:advice>
     <context:component-scan base- package = "com.lavasoft.demo.dao"  resource-pattern= "*DAO.class" />
     <context:component-scan base- package = "com.lavasoft.demo.service" />
</beans>




1
2
3
4
5
6
7
8
9
10
11
<?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>
     <typeAliases>
         < package  name= "com.lavasoft.demo.entity" />
     </typeAliases>
     <plugins>
         <plugin interceptor= "com.lavasoft.framework.ext.interceptor.PageInterceptor" />
     </plugins>
</configuration>


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
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
<?xml version= "1.0"  encoding= "UTF-8" ?>
<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>jeefw</groupId>
     <artifactId>jeefw</artifactId>
     <version> 1.0 -SNAPSHOT</version>
     <properties>
         <spring.version> 3.2 . 8 .RELEASE</spring.version>
         <struts2.version> 2.3 . 16.1 </struts2.version>
         <hibernate.version> 4.3 . 4 .Final</hibernate.version>
         <mybatis.version> 3.2 . 6 </mybatis.version>
         <mysql.version> 5.1 . 29 </mysql.version>
         <ojdbc14.version> 10.2 . 0.4 . 0 </ojdbc14.version>
         <servlet-api.version> 2.5 </servlet-api.version>
         <jsp-api.version> 2.2 </jsp-api.version>
         <jstl.version> 1.2 </jstl.version>
         <fastjson.version> 1.1 . 39 </fastjson.version>
         <commons-dbcp2.version> 2.0 </commons-dbcp2.version>
         <commons-pool2.version> 2.2 </commons-pool2.version>
         <commons-logging.version> 1.1 . 3 </commons-logging.version>
         <commons-io.version> 1.3 . 2 </commons-io.version>
         <commons-lang3.version> 3.3 . 1 </commons-lang3.version>
         <commons-fileupload.version> 1.2 . 1 </commons-fileupload.version>
         <log4j.version> 1.2 . 17 </log4j.version>
         <slf4j.version> 1.7 . 6 </slf4j.version>
         <dom4j.version> 1.6 . 1 </dom4j.version>
         <jfreechart.version> 1.0 . 17 </jfreechart.version>
         <shiro.version> 1.2 . 3 </shiro.version>
         <aspectjweaver.version> 1.7 . 4 </aspectjweaver.version>
         <bonecp.version> 0.8 . 0 .RELEASE</bonecp.version>
         <druid.version> 1.0 . 4 </druid.version>
         <c3p0.version> 0.9 . 2.1 </c3p0.version>
         <testng.version> 6.8 . 8 </testng.version>
         <junit.version> 4.11 </junit.version>
         <freemarker.version> 2.3 . 20 </freemarker.version>
         <velocity.version> 1.7 </velocity.version>
         <tapestry.version> 5.3 . 7 </tapestry.version>
         <asm.version> 4.2 </asm.version>
         <cglib.version> 3.1 </cglib.version>
         <!-- Plugin的属性定义 -->
         <project.build.sourceEncoding>UTF- 8 </project.build.sourceEncoding>
         <jdk.version> 1.6 </jdk.version>
     </properties>
     <dependencies>
         <!-- mybaits -->
         <dependency>
             <groupId>org.mybatis</groupId>
             <artifactId>mybatis</artifactId>
             <version>${mybatis.version}</version>
         </dependency>
         <dependency>
             <groupId>org.mybatis</groupId>
             <artifactId>mybatis-spring</artifactId>
             <version> 1.2 . 2 </version>
         </dependency>
         <dependency>
             <groupId>org.mybatis.caches</groupId>
             <artifactId>mybatis-ehcache</artifactId>
             <version> 1.0 . 2 </version>
         </dependency>
         <!-- JDBC驱动 -->
         <dependency>
             <groupId>mysql</groupId>
             <artifactId>mysql-connector-java</artifactId>
             <version>${mysql.version}</version>
         </dependency>
         <!-- spring相关 -->
         <dependency>
             <groupId>org.springframework</groupId>
             <artifactId>spring-core</artifactId>
             <version>${spring.version}</version>
         </dependency>
         <dependency>
             <groupId>org.springframework</groupId>
             <artifactId>spring-beans</artifactId>
             <version>${spring.version}</version>
         </dependency>
         <dependency>
             <groupId>org.springframework</groupId>
             <artifactId>spring-context</artifactId>
             <version>${spring.version}</version>
         </dependency>
         <dependency>
             <groupId>org.springframework</groupId>
             <artifactId>spring-jdbc</artifactId>
             <version>${spring.version}</version>
         </dependency>
         <dependency>
             <groupId>org.springframework</groupId>
             <artifactId>spring-web</artifactId>
             <version>${spring.version}</version>
         </dependency>
         <dependency>
             <groupId>org.springframework</groupId>
             <artifactId>spring-webmvc</artifactId>
             <version>${spring.version}</version>
         </dependency>
         <dependency>
             <groupId>org.springframework</groupId>
             <artifactId>spring-aop</artifactId>
             <version>${spring.version}</version>
         </dependency>
         <dependency>
             <groupId>org.springframework</groupId>
             <artifactId>spring-tx</artifactId>
             <version>${spring.version}</version>
         </dependency>
         <dependency>
             <groupId>org.springframework</groupId>
             <artifactId>spring-orm</artifactId>
             <version>${spring.version}</version>
         </dependency>
         <dependency>
             <groupId>org.springframework</groupId>
             <artifactId>spring-context-support</artifactId>
             <version>${spring.version}</version>
         </dependency>
         <dependency>
             <groupId>org.springframework</groupId>
             <artifactId>spring-test</artifactId>
             <version>${spring.version}</version>
         </dependency>
         <dependency>
             <groupId>org.springframework</groupId>
             <artifactId>spring-jms</artifactId>
             <version>${spring.version}</version>
         </dependency>
         <!-- json库 -->
         <!-- 模板库 -->
         <dependency>
             <groupId>org.freemarker</groupId>
             <artifactId>freemarker</artifactId>
             <version>${freemarker.version}</version>
         </dependency>
         <!-- 日志库 -->
         <dependency>
             <groupId>commons-logging</groupId>
             <artifactId>commons-logging</artifactId>
             <version>${commons-logging.version}</version>
         </dependency>
         <dependency>
             <groupId>log4j</groupId>
             <artifactId>log4j</artifactId>
             <version>${log4j.version}</version>
         </dependency>
         <dependency>
             <groupId>org.slf4j</groupId>
             <artifactId>slf4j-log4j12</artifactId>
             <version>${slf4j.version}</version>
         </dependency>
         <dependency>
             <groupId>org.slf4j</groupId>
             <artifactId>slf4j-api</artifactId>
             <version>${slf4j.version}</version>
         </dependency>
         <!-- 依赖的WEB类库-->
         <dependency>
             <groupId>javax.servlet.jsp</groupId>
             <artifactId>jsp-api</artifactId>
             <version>${jsp-api.version}</version>
         </dependency>
         <dependency>
             <groupId>javax.servlet</groupId>
             <artifactId>servlet-api</artifactId>
             <version>${servlet-api.version}</version>
         </dependency>
         <dependency>
             <groupId>javax.servlet</groupId>
             <artifactId>jstl</artifactId>
             <version>${jstl.version}</version>
         </dependency>
         <!-- 依赖的测试类库-->
         <dependency>
             <groupId>org.springframework</groupId>
             <artifactId>spring-test</artifactId>
             <version>${spring.version}</version>
         </dependency>
         <dependency>
             <groupId>junit</groupId>
             <artifactId>junit</artifactId>
             <version>${junit.version}</version>
         </dependency>
         <dependency>
             <groupId>org.testng</groupId>
             <artifactId>testng</artifactId>
             <version>${testng.version}</version>
         </dependency>
         <!-- 连接池 -->
         <dependency>
             <groupId>com.alibaba</groupId>
             <artifactId>druid</artifactId>
             <version>${druid.version}</version>
         </dependency>
         <!-- shiro权限控制 -->
         <dependency>
             <groupId>org.apache.shiro</groupId>
             <artifactId>shiro-core</artifactId>
             <version>${shiro.version}</version>
         </dependency>
         <dependency>
             <groupId>org.apache.shiro</groupId>
             <artifactId>shiro-web</artifactId>
             <version>${shiro.version}</version>
         </dependency>
         <dependency>
             <groupId>org.apache.shiro</groupId>
             <artifactId>shiro-spring</artifactId>
             <version>${shiro.version}</version>
         </dependency>
         <dependency>
             <groupId>org.apache.shiro</groupId>
             <artifactId>shiro-ehcache</artifactId>
             <version>${shiro.version}</version>
         </dependency>
         <dependency>
             <groupId>org.apache.shiro</groupId>
             <artifactId>shiro-aspectj</artifactId>
             <version>${shiro.version}</version>
         </dependency>
         <dependency>
             <groupId>org.apache.shiro</groupId>
             <artifactId>shiro-quartz</artifactId>
             <version>${shiro.version}</version>
         </dependency>
         <!-- 模板技术 -->
         <dependency>
             <groupId>org.freemarker</groupId>
             <artifactId>freemarker</artifactId>
             <version>${freemarker.version}</version>
         </dependency>
         <dependency>
             <groupId>org.apache.velocity</groupId>
             <artifactId>velocity</artifactId>
             <version>${velocity.version}</version>
         </dependency>
         <!-- 依赖的公共类库-->
         <dependency>
             <groupId>org.apache.commons</groupId>
             <artifactId>commons-io</artifactId>
             <version>${commons-io.version}</version>
         </dependency>
         <dependency>
             <groupId>org.apache.commons</groupId>
             <artifactId>commons-lang3</artifactId>
             <version>${commons-lang3.version}</version>
         </dependency>
         <dependency>
             <groupId>org.apache.commons</groupId>
             <artifactId>commons-collections4</artifactId>
             <version> 4.0 </version>
         </dependency>
         <dependency>
             <groupId>org.kuali.commons</groupId>
             <artifactId>commons-beanutils</artifactId>
             <version> 1.8 . 3 -kuali- 4 </version>
         </dependency>
         <!-- 缓存 -->
         <dependency>
             <groupId>net.sf.ehcache</groupId>
             <artifactId>ehcache</artifactId>
             <version> 2.8 . 1 </version>
         </dependency>
         <!-- 其他 -->
         <dependency>
             <groupId>com.alibaba</groupId>
             <artifactId>fastjson</artifactId>
             <version>${fastjson.version}</version>
         </dependency>
         <dependency>
             <groupId>org.aspectj</groupId>
             <artifactId>aspectjweaver</artifactId>
             <version>${aspectjweaver.version}</version>
         </dependency>
         <dependency>
             <groupId>dom4j</groupId>
             <artifactId>dom4j</artifactId>
             <version>${dom4j.version}</version>
         </dependency>
         <dependency>
             <groupId>com.belerweb</groupId>
             <artifactId>pinyin4j</artifactId>
             <version> 2.5 . 0 </version>
         </dependency>
         <dependency>
             <groupId>com.darwinsys</groupId>
             <artifactId>hirondelle-date4j</artifactId>
             <version> 1.5 . 1 </version>
         </dependency>
     </dependencies>
     <build>
         <finalName>chapter1</finalName>
         <plugins>
             <plugin>
                 <artifactId>maven-surefire-plugin</artifactId>
                 <configuration>
                     <skip> true </skip>
                 </configuration>
             </plugin>
             <!-- jetty插件 -->
             <plugin>
                 <groupId>org.mortbay.jetty</groupId>
                 <artifactId>maven-jetty-plugin</artifactId>
                 <version> 6.1 . 5 </version>
                 <configuration>
                     <webAppSourceDirectory>src/main/webapp</webAppSourceDirectory>
                     <scanIntervalSeconds> 3 </scanIntervalSeconds>
                     <contextPath>/chapter1</contextPath>
                     <connectors>
                         <connector implementation= "org.mortbay.jetty.nio.SelectChannelConnector" >
                             <port> 8088 </port>
                         </connector>
                     </connectors>
                 </configuration>
             </plugin>
         </plugins>
     </build>
</project>



测试一把：


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
D:\jdk1.6.0_45\bin\java -Didea.launcher.port=7532 -Didea.launcher.bin.path=C:\IDEA.13.0.1\bin -Dfile.encoding=UTF-8 -classpath D:\jdk1.6.0_45\jre\lib\charsets.jar;D:\jdk1.6.0_45\jre\lib\deploy.jar;D:\jdk1.6.0_45\jre\lib\javaws.jar;D:\jdk1.6.0_45\jre\lib\jce.jar;D:\jdk1.6.0_45\jre\lib\jsse.jar;D:\jdk1.6.0_45\jre\lib\management-agent.jar;D:\jdk1.6.0_45\jre\lib\plugin.jar;D:\jdk1.6.0_45\jre\lib\resources.jar;D:\jdk1.6.0_45\jre\lib\rt.jar;D:\jdk1.6.0_45\jre\lib\ext\dnsns.jar;D:\jdk1.6.0_45\jre\lib\ext\localedata.jar;D:\jdk1.6.0_45\jre\lib\ext\sunjce_provider.jar;D:\jdk1.6.0_45\jre\lib\ext\sunmscapi.jar;D:\jdk1.6.0_45\jre\lib\ext\sunpkcs11.jar;D:\IdeaProjects\basefw\mybatisext\target\classes;D:\IdeaProjects\basefw\mybatisext\src\lib\javacsv.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\sac-1.3.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\junit-4.4.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\freemarker.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\aopalliance.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\jsoup-1.7.2.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\xalan-2.7.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-dbcp.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-pool.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\log4j-1.2.15.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\aspectjweaver.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\htmlunit-2.10.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\mybatis-3.2.6.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-io-2.2.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\httpcore-4.2.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\httpmime-4.2.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-logging.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\cssparser-0.9.7.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\nekohtml-1.9.16.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\xml-apis-1.3.04.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\httpclient-4.2.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\ibatis-2.3.4.726.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\serializer-2.7.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\xercesImpl-2.9.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-beanutils.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-codec-1.6.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-lang3-3.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\jsoup-1.7.2-javadoc.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\jsoup-1.7.2-sources.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\mybatis-spring-1.2.2.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\htmlunit-core-js-2.10.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-collections-3.2.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\javax.servlet.jsp.jstl-1.2.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\mysql-connector-java-5.1.17-bin.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\javax.servlet.jsp.jstl-api-1.2.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\fastjson-1.1.15-20120106.101821-4.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.aop-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.asm-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.jms-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.orm-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.oxm-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.web-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.core-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.jdbc-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.test-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.beans-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.aspects-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.context-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.expression-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.instrument-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.web.struts-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.transaction-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.web.portlet-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.web.servlet-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.context.support-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.instrument.tomcat-3.1.2.RELEASE.jar;C:\IDEA.13.0.1\lib\idea_rt.jar com.intellij.rt.execution.application.AppMain com.lavasoft.demo.service.PersonSVImpl
2014-04-02 16:20:25 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Parsed configuration file:  'class path resource [mybatis-config.xml]'
2014-04-02 16:20:25 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Parsed mapper file:  'file [D:\IdeaProjects\basefw\mybatisext\target\classes\com\lavasoft\demo\entity\Address.xml]'
2014-04-02 16:20:25 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Parsed mapper file:  'file [D:\IdeaProjects\basefw\mybatisext\target\classes\com\lavasoft\demo\entity\Extinfo.xml]'
2014-04-02 16:20:25 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Parsed mapper file:  'file [D:\IdeaProjects\basefw\mybatisext\target\classes\com\lavasoft\demo\entity\Menu.xml]'
2014-04-02 16:20:25 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Parsed mapper file:  'file [D:\IdeaProjects\basefw\mybatisext\target\classes\com\lavasoft\demo\entity\Orders.xml]'
2014-04-02 16:20:25 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Parsed mapper file:  'file [D:\IdeaProjects\basefw\mybatisext\target\classes\com\lavasoft\demo\entity\Person.xml]'
>>>>>>:jdbc:mysql: //localhost:3306/testdb, UserName=root@localhost, MySQL-AB JDBC Driver
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Creating a  new  SqlSession
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Registering transaction synchronization  for  SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c6320]
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  JDBC Connection [jdbc:mysql: //localhost:3306/testdb, UserName=root@localhost, MySQL-AB JDBC Driver] will be managed by Spring
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  ==>  Preparing: insert into person(name,pswd) values(?,?)
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  ==> Parameters: 测试插入asdfasd(String), asdf(String)
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  <==    Updates: 1
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c6320]
Person{id=68, name= '测试插入asdfasd' , pswd= 'asdf' }
>>>>>>:jdbc:mysql: //localhost:3306/testdb, UserName=root@localhost, MySQL-AB JDBC Driver
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c6320] from current transaction
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  ==>  Preparing: insert into extinfo(personid,email,qq) values(?,?,?)
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  ==> Parameters: 68(Long), test@test.com(String), 234232343(Long)
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  <==    Updates: 1
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c6320]
Extinfo{id=29, personid=68, email= 'test@test.com' , qq=234232343}
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c6320]
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c6320]
2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c6320]
Process finished with  exit  code 0




本文转自 leizhimin 51CTO博客，原文链接：http://blog.51cto.com/lavasoft/1389190，如需转载请自行联系原作者


文章标签：
云数据库 RDS MySQL 版
Java
Apache
Spring
数据格式
XML
关键词：
Spring Mybatis
Maven配置
Spring配置
MyBatis配置
Spring Maven
相关实践学习
如何快速连接云数据库RDS MySQL
本场景介绍如何通过阿里云数据管理服务DMS快速连接云数据库RDS MySQL，然后进行数据表的CRUD操作。
全面了解阿里云能为你做什么
阿里云在全球各地部署高效节能的绿色数据中心，利用清洁计算为万物互联的新世界提供源源不断的能源动力，目前开服的区域包括中国（华北、华东、华南、香港）、新加坡、美国（美东、美西）、欧洲、中东、澳大利亚、日本。目前阿里云的产品涵盖弹性计算、数据库、存储与CDN、分析与搜索、云通信、网络、管理与监控、应用服务、互联网中间件、移动服务、视频服务等。通过本课程，来了解阿里云能够为你的业务带来哪些帮助 &nbsp; &nbsp; 相关的阿里云产品：云服务器ECS 云服务器 ECS（Elastic Compute Service）是一种弹性可伸缩的计算服务，助您降低 IT 成本，提升运维效率，使您更专注于核心业务创新。产品详情: https://www.aliyun.com/product/ecs
技术小阿哥
目录
相关文章
wanderInk
|
2月前
|
安全 Java API
深入解析 Spring Security 配置中的 CSRF 启用与 requestMatchers 报错问题
本文深入解析了Spring Security配置中CSRF启用与`requestMatchers`报错的常见问题。针对CSRF，指出默认已启用，无需调用`enable()`，只需移除`disable()`即可恢复。对于`requestMatchers`多路径匹配报错，分析了Spring Security 6.x中方法签名的变化，并提供了三种解决方案：分次调用、自定义匹配器及降级使用`antMatchers()`。最后提醒开发者关注版本兼容性，确保升级平稳过渡。
wanderInk
241 2
游客kufrkwrbkmpsa
|
3月前
|
Oracle 关系型数据库 Java
【YashanDB知识库】Mybatis-Plus适配崖山配置
【YashanDB知识库】Mybatis-Plus适配崖山配置
游客kufrkwrbkmpsa
74 1
Quan_Chen
|
3月前
|
Java 关系型数据库 数据库
微服务——SpringBoot使用归纳——Spring Boot事务配置管理——Spring Boot 事务配置
本文介绍了 Spring Boot 中的事务配置与使用方法。首先需要导入 MySQL 依赖，Spring Boot 会自动注入 `DataSourceTransactionManager`，无需额外配置即可通过 `@Transactional` 注解实现事务管理。接着通过创建一个用户插入功能的示例，展示了如何在 Service 层手动抛出异常以测试事务回滚机制。测试结果表明，数据库中未新增记录，证明事务已成功回滚。此过程简单高效，适合日常开发需求。
Quan_Chen
170 0
Quan_Chen
|
3月前
|
XML Java 数据库连接
微服务——SpringBoot使用归纳——Spring Boot集成MyBatis——基于 xml 的整合
本教程介绍了基于XML的MyBatis整合方式。首先在`application.yml`中配置XML路径，如`classpath:mapper/*.xml`，然后创建`UserMapper.xml`文件定义SQL映射，包括`resultMap`和查询语句。通过设置`namespace`关联Mapper接口，实现如`getUserByName`的方法。Controller层调用Service完成测试，访问`/getUserByName/{name}`即可返回用户信息。为简化Mapper扫描，推荐在Spring Boot启动类用`@MapperScan`注解指定包路径避免逐个添加`@Mapper`
Quan_Chen
113 0
蓝易云
|
18天前
|
SQL Java 数据库
解决Java Spring Boot应用中MyBatis-Plus查询问题的策略。
保持技能更新是侦探的重要素质。定期回顾最佳实践和新技术。比如，定期查看MyBatis-Plus的更新和社区的最佳做法，这样才能不断提升查询效率和性能。
蓝易云
62 1
蓝易云
|
1月前
|
Java 应用服务中间件 Maven
在IntelliJ IDEA中如何配置使用Maven以创建Tomcat环境
所以，别担心这些工具看起来有些吓人，实际上这些都是为了帮助你更好的完成工作的工具，就像超市里的各种烹饪工具一样，尽管它们看起来可能很复杂，但只要你学会用，它们会为你烹饪出一道道美妙的食物。这就是学习新技能的乐趣，让我们一起享受这个过程，攀登知识的高峰！
蓝易云
168 27
蓝易云
|
1月前
|
Java 应用服务中间件 Apache
在IntelliJ IDEA中使用Maven配置Tomcat环境
此配置方法具有较高的实用性，简单易懂。遵循以上步骤，您将能顺利在IntelliJ IDEA中使用Maven配置Tomcat环境，从而进行Web项目的开发和调试。
蓝易云
155 18
Quan_Chen
|
3月前
|
XML Java 数据库连接
微服务——SpringBoot使用归纳——Spring Boot集成MyBatis——基于注解的整合
本文介绍了Spring Boot集成MyBatis的两种方式：基于XML和注解的形式。重点讲解了注解方式，包括@Select、@Insert、@Update、@Delete等常用注解的使用方法，以及多参数时@Param注解的应用。同时，针对字段映射不一致的问题，提供了@Results和@ResultMap的解决方案。文章还提到实际项目中常结合XML与注解的优点，灵活使用两者以提高开发效率，并附带课程源码供下载学习。
Quan_Chen
80 0
Quan_Chen
|
3月前
|
Java 数据库连接 数据库
微服务——SpringBoot使用归纳——Spring Boot集成MyBatis——MyBatis 介绍和配置
本文介绍了Spring Boot集成MyBatis的方法，重点讲解基于注解的方式。首先简述MyBatis作为持久层框架的特点，接着说明集成时的依赖导入，包括`mybatis-spring-boot-starter`和MySQL连接器。随后详细展示了`properties.yml`配置文件的内容，涵盖数据库连接、驼峰命名规范及Mapper文件路径等关键设置，帮助开发者快速上手Spring Boot与MyBatis的整合开发。
Quan_Chen
188 0
大三的土狗
|
前端开发 druid Java
SpringBoot 整合 MyBatis
文本是基于MVC前后端分离模式的一个SpringBoot整合MyBatis的项目，不过没有用到前端页面，使用了更方便的Apifox请求工具。SpringBoot+MyBatis使用起来更方便，更舒服。掌握SpingBoot整合MyBatis，要比Spring整合简单的多，少了很多繁琐的配置。......
大三的土狗
289 0
SpringBoot 整合 MyBatis

热门文章

最新文章

  • 1
    【JavaEE】从 0 到 1 掌握 Maven 构建 Java 项目核心技巧 解锁 Java 项目高效管理实用实例
  • 2
    Spring AI Alibaba + Nacos 动态 MCP Server 代理方案
  • 3
    Spring AI Alibaba Graph：多智能体框架实践
  • 4
    Spring AI Alibaba 发布企业级 MCP 分布式部署方案
  • 5
    Spring AI 实战｜Spring AI入门之DeepSeek调用
  • 6
    SpringBoot中@Scheduled和Quartz的区别是什么？分布式定时任务框架选型实战
  • 7
    spring boot 权限管理的几种方式
  • 8
    Spring事务失效场景
  • 9
    Spring Boot 可视化监控
  • 10
    【Spring】【事务】初学者直呼学会了的Spring事务入门
  • 1
    MyBatis-Plus整合SpringBoot及使用
    542
  • 2
    【面试官】Mybatis缓存有什么问题吗？
    124
  • 3
    MyBatis-Plus整合SpringBoot及使用
    218
  • 4
    MyBatis 的延迟加载是如何实现的
    370
  • 5
    mybatis映射关系(1-1 1-n n-n)
    129
  • 6
    Mybatis查询传递单个参数和传递多个参数用法
    169
  • 7
    Mybatis中@Param的用法和作用
    347
  • 8
    mybatis使用statement.getGenreatedKeys()； useGeneratedKeys=”true”；使用自增主键获取主键值策略和Oracle不支持自增，Oracle使用序列
    136
  • 9
    Mybatis框架中SqlSessionFactory
    108
  • 10
    Mybatis之SqlSession简析
    279

    • 相关课程

    更多
  • 全面讲解Spring Cloud Alibaba技术栈（知识精讲+项目实战）第二阶段
  • 精通Spring Cloud Alibaba
  • 微服务框架 Spring Cloud 快速入门
  • Java Web开发系列课程 - Spring框架入门
  • Spring Boot 2.5.x开发实战
  • Spring Cloud微服务架构设计与开发实战

    • 相关电子书

    更多
  • 云栖社区特邀专家徐雷Java Spring Boot开发实战系列课程（第20讲）：经典面试题与阿里等名企内部招聘求职面试技巧
  • 微服务架构模式与原理Spring Cloud开发实战
  • 阿里特邀专家徐雷Java Spring Boot开发实战系列课程（第18讲）：制作Java Docker镜像与推送到DockerHub和阿里云Docker仓库

    • 相关实验场景

    更多
  • 从零搭建Spring Boot的Hello World

    • 推荐镜像

    更多
  • maven
    • 下一篇
    手把手教你白嫖阿里云服务器(免费领服务器)