配置文件如下:
base-context.xml文件如下:
1
2
3
4
5
6
7
8
9
10
11
12
|
<? 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"
xsi:schemaLocation = "http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd" >
<!--用于激活容器中注册的bean-->
<!--<context:annotation-config/>-->
< context:property-placeholder location = "classpath*:/props/*.properties" ignore-unresolvable = "true" />
< context:component-scan base-package = "com.ufind.server.*" >
< context:exclude-filter type = "annotation" expression = "org.springframework.stereotype.Controller" />
</ context:component-scan >
</ beans >
|
db-mybatis.xml如下:
1
2
3
4
5
6
7
8
9
10
11
12
|
<? xml version = "1.0" encoding = "UTF-8" ?>
< beans 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" >
< bean id = "sessionFactory" class = "org.mybatis.spring.SqlSessionFactoryBean" >
< property name = "dataSource" ref = "dataSource" />
< property name = "mapperLocations" value = "classpath:mybatis/mappers/*.xml" />
</ bean >
< bean id = "mapperScannerConfigurer" class = "org.mybatis.spring.mapper.MapperScannerConfigurer" >
< property name = "basePackage" value = "com.ufind.server.infra.repository.sql" />
< property name = "sqlSessionFactoryBeanName" value = "sessionFactory" />
</ bean >
</ beans >
|
persistence-context.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
|
<? xml version = "1.0" encoding = "UTF-8" ?>
< beans 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" >
< bean id = "dataSourceTransactionManager" class = "org.springframework.jdbc.datasource.DataSourceTransactionManager" >
< property name = "dataSource" ref = "dataSource" />
</ bean >
< bean id = "dataSource" class = "com.alibaba.druid.pool.DruidDataSource"
init-method = "init" destroy-method = "close" >
<!-- 数据库基本信息配置 -->
< property name = "driverClassName" value = "${db.jdbc.driver}" />
< property name = "url" value = "${db.jdbc.connection.url}" />
< property name = "username" value = "${db.jdbc.username}" />
< property name = "password" value = "${db.jdbc.password}" />
<!-- 初始化连接数量 -->
< property name = "initialSize" value = "10" />
<!-- 最大并发连接数 -->
< property name = "maxActive" value = "100" />
<!-- 最小空闲连接数 -->
< property name = "minIdle" value = "20" />
<!-- 配置获取连接等待超时的时间 -->
< property name = "maxWait" value = "5000" />
<!-- 超过时间限制是否回收 -->
< property name = "removeAbandoned" value = "true" />
<!-- 超过时间限制多长; -->
< property name = "removeAbandonedTimeout" value = "120000" />
<!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 -->
< property name = "timeBetweenEvictionRunsMillis" value = "60000" />
<!-- 配置一个连接在池中最小生存的时间,单位是毫秒 -->
< property name = "minEvictableIdleTimeMillis" value = "40000" />
<!-- 用来检测连接是否有效的sql,要求是一个查询语句-->
< property name = "validationQuery" value = "select 1" />
<!-- 申请连接的时候检测 -->
< property name = "testWhileIdle" value = "true" />
<!-- 申请连接时执行validationQuery检测连接是否有效,配置为true会降低性能 -->
< property name = "testOnBorrow" value = "false" />
<!-- 归还连接时执行validationQuery检测连接是否有效,配置为true会降低性能 -->
< property name = "testOnReturn" value = "false" />
<!-- 打开PSCache,并且指定每个连接上PSCache的大小 -->
< property name = "poolPreparedStatements" value = "true" />
< property name = "maxPoolPreparedStatementPerConnectionSize"
value = "50" />
<!--属性类型是字符串,通过别名的方式配置扩展插件,常用的插件有:
监控统计用的filter:stat
日志用的filter:log4j
防御SQL注入的filter:wall -->
< property name = "filters" value = "stat" />
</ bean >
</ beans >
|
在mappers下边是mybatis的xml文件,启动的时候出现错误:
DEBUG o.m.spring.SqlSessionFactoryBean - Property 'configLocation' not specified, using default MyBatis Configuration
解决方式如下:
1
2
3
4
5
|
< bean id = "sessionFactory" class = "org.mybatis.spring.SqlSessionFactoryBean" >
< property name = "dataSource" ref = "dataSource" />
< property name = "mapperLocations" value = "classpath:mybatis/mappers/*.xml" />
< property name = "configLocation" value = "classpath:spring/persistence-context.xml" />
</ bean >
|
在sessionFactory下加入:
1
|
< property name = "configLocation" value = "classpath:spring/persistence-context.xml" />
|
添加persistence-context.xml
的位置即可,或者所有的文件都在一个文件即可
总结
以上就是这篇文章的全部内容了,希望本文的内容对大家的学习或者工作具有一定的参考学习价值,谢谢大家对服务器之家的支持。如果你想了解更多相关内容请查看下面相关链接
原文链接:https://blog.csdn.net/xlgen157387/article/details/50885635