<?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: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://www.springframework.org/schema/context
https://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 缩小扫描范围到 com.itheima.SpringMVC -->
<context:component-scan base-package="com.itheima.SpringMVC"/>
<bean id="User" class="com.itheima.SpringMVC.pojo.User">
<property name="username"
value="涂大钧"></property>
<property name="password"
value="123"></property>
</bean>
<!--数据源-->
<context:property-placeholder location="classpath*:jdbc.properties"/>
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="driverClassName"
value="${jdbc.driver}"/>
<property name="url"
value="${jdbc.url}"></property>
<property name="username"
value="${jdbc.username}"/>
<property name="password"
value="${jdbc.password}"/>
</bean>
<!--配置sql-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource"
ref="dataSource"></property>
<!--别名扫包-->
<property name="typeAliasesPackage"
value="com.itheima.SpringMVC.pojo"></property>
<!--指定XML文件位置-->
<!--mybatis-config.xml-->
<property name="configLocation"
value="classpath:/mybatis-mvc-config.xml" />
</bean>
<!--指定Mapper XML文件位置-->
<!--扫描Mapper-->
<bean class="org.mybatis.spring.mapper.
MapperScannerConfigurer">
<property name="
sqlSessionFactoryBeanName"
value="sqlSessionFactory"></property>
<property name="basePackage"
value="com.itheima.SpringMVC.Mapper"></property>
</bean>
<!-- 事务管理器-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource"
ref="dataSource"></property>
</bean>
<!--开启注解驱动的事务管理-->
<tx:annotation-driven transaction-manager="transactionManager"></tx:annotation-driven>
</beans><?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>
<!-- 引入外部配置文件 -->
<properties resource="jdbc.properties">
<!-- 可以在这里添加默认属性值 -->
</properties>
<!-- 设置 MyBatis 核心配置 -->
<settings>
<!-- 开启驼峰命名自动映射，如将数据库字段 user_name 映射到 Java 属性 userName -->
<setting name="mapUnderscoreToCamelCase"
value="true"/>
<!-- 开启二级缓存 -->
<setting name="cacheEnabled"
value="true"/>
<!-- 开启延迟加载 -->
<setting name="lazyLoadingEnabled"
value="true"/>
<!-- 开启 aggressiveLazyLoading 会导致所有关联对象在被访问时立即加载 -->
<setting name="aggressiveLazyLoading"
value="true"/>
<!-- 配置日志实现 -->
<setting name="logImpl"
value="STDOUT_LOGGING"/>
</settings>
<!-- 配置类型别名，简化映射 -->
<typeAliases>
<package name="com.itheima.SpringMVC.pojo"/>
</typeAliases>
<!-- 配置插件 -->
<plugins>
<!-- PageHelper 分页插件 -->
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<!-- 可选配置 -->
<property name="reasonable"
value="true"/>
<property name="supportMethodsArguments"
value="true"/>
<property name="params"
value="count=countSql"/>
</plugin>
</plugins>
<!-- 配置数据库环境 -->
<environments default="development">
<environment id="development">
<!-- 使用 JDBC 事务管理器 -->
<transactionManager type="JDBC"/>
<!-- 配置数据源，使用 POOLED 连接池 -->
<dataSource type="POOLED">
<property name="driver"
value="${jdbc.driver}"/>
<property name="url"
value="${jdbc.url}"/>
<property name="username"
value="${jdbc.username}"/>
<property name="password"
value="${jdbc.password}"/>
<!-- 可选配置：连接池参数 -->
<property name="poolMaximumActiveConnections"
value="10"/>
<property name="poolMaximumIdleConnections"
value="5"/>
</dataSource>
</environment>
</environments>
<!-- 注册映射器 -->
<mappers>
<package name="com.itheima.SpringMVC.Mapper" />
<!-- <mapper resource="SpringMVC/Mapper/UsersMapper.xml"/>-->
<!-- <mapper resource="SpringMVC/Mapper/UserMapper.xml"/>-->
<!-- <mapper resource="SpringMVC/Mapper/IdCardMapper.xml"/>-->
<!-- <mapper resource="SpringMVC/Mapper/GoodsMapper.xml"/>-->
<!-- <mapper resource="SpringMVC/Mapper/GoodsTypeMapper.xml"/>-->
<!-- <mapper resource="SpringMVC/Mapper/OrdersMapper.xml"/>-->
<!-- <mapper resource="SpringMVC/Mapper/OrderItemsMapper.xml"/>-->
</mappers>
</configuration>有问题吗
在mybatis-spring早期版本中，SqlSessionFactory初始化可能因jdbc.properties未加载导致属性设置失败。从1.1.0开始，MapperScannerConfigurer引入sqlSessionFactoryBeanName，允许在Spring初始化完成后构建SqlSessionFactory，解决了这个问题。此改变确保了数据源配置的正确性。
扫一扫
2739
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
