配置文件如下:
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