iBATIS配置文件——sqIMapConfig.xml

<?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"><sqlMapConfig><properties><property name="dialect" value="mysql" /><property name="Driver" value="JDBC.Driver" /><property name="ConnectionURL" value="JDBC.ConnectionURL" /><property name="Username" value="JDBC.Username" /><property name="Password" value="JDBC.Password" /><property name="MaximumActiveConnections" value="Pool.MaximumActiveConnections" /><property name="MaximumIdleConnections" value="Pool.MaximumIdleConnections" /><property name="MaximumCheckoutTime" value="Pool.MaximumCheckoutTime" /><property name="TimeToWait" value="Pool.TimeToWait" /><property name="PingQuery" value="Pool.PingQuery" /><property name="PingEnabled" value="Pool.PingEnabled" /><property name="MaximumCheckoutTime" value="Pool.PingConnectionsOlderThan" /><property name="PingConnectionsNotUsedFor" value="Pool.PingConnectionsNotUsedFor" /></properties><typeAliases><typeAlias alias="user" type="com.demo.core.bean.UserInfo" /></typeAliases><plugins><plugin interceptor="com.demo.core.dao.mybatis.sqlpage.PaginationInterceptor" /></plugins><settings maxRequests="512"maxSessions="128"maxTransactions="32"cacheModelsEnabled="true" lazyLoadingEnabled="true"enhancementEnabled="true" useStatementNamespaces="true"  /><!-- 数据源 --><!-- 1.SimpleDataSourceFactory数据源 ,适用于没有Java EE提供DataSource的情况下。--><transactionManager type="JDBC"> <dataSource type="SIMPLE"><property name="${Driver}" value="com.mysql.jdbc.Driver" /><property name="${ConnectionURL}" value="jdbc:mysql://localhost:3306/demo" /><property name="${Username}" value="root" /><property name="${Password}" value="123" /><!-- 可选 --><property name="${MaximumActiveConnections}" value="10" /><property name="${MaximumIdleConnections}" value="5" /><property name="${MaximumCheckoutTime}" value="120000" /><property name="${TimeToWait}" value="500" /><property name="${PingQuery}" value="select 1 from user" /><property name="${PingEnabled}" value="false" /><property name="${PingConnectionsOlderThan}" value="1" /><property name="${PingConnectionsNotUsedFor}" value="1" /></dataSource></transactionManager><!-- 2.DbcpDataSourceFactory数据源使用Jakarta DBCP(Database Connection Pool)的DataSourceAPI提供连接池服务。适用于应用服务器和Web容器不提供DataSource服务的情况,或执行一个单独的应用。 --><transactionManager type="JDBC"> <dataSource type="DBCP"><property name="JDBC.Driver" value="com.mysql.jdbc.Driver" /><property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost:3306/demo" /><property name="JDBC.Username" value="root" /><property name="JDBC.Password" value="" /><!-- 可选 --><property name="Pool.MaximumActiveConnections" value="10" /><property name="Pool.MaximumIdleConnections" value="5" /><property name="Pool.MaximumWait" value="60000" /> <property name="Pool.ValidationQuery" value="select 1 from user" /><property name="Pool.LogAbandoned" value="false" /><property name="Pool.RemoveAbandoned" value="false" /><property name="Pool.RemoveAbandonedTimeout" value="50000" /></dataSource></transactionManager><!-- 3.JndiDataSourceFactory在应用容器内部从JNDI Context中查找DataSource实现。在使用应用服务器,并且服务器提供了容器管理的连接池和相关DataSource实现的情况下。需要在Server.xml中配置JNDI实例。<Context ...><Resource name="jdbc/mydatasource" auth="Container" type="javax.sql.DataSource"/><ResourceParams name="jdbc/mydatasource"><parameter><name>username</name><value>dbusername</value></parameter><parameter><name>password</name><value>dbpassword</value></parameter><parameter><name>driverClassName</name><value>org.hsql.jdbcDriver</value></parameter><parameter><name>url</name><value>jdbc:HypersonicSQL:database</value></parameter><parameter><name>maxActive</name><value>8</value></parameter><parameter><name>maxIdle</name><value>4</value></parameter></ResourceParams>...........</Context> --><transactionManager type="JDBC"> <dataSource type="JNDI"><property name="DataSource" value="java:comp/env/jdbc/mydatasource" /></dataSource></transactionManager> <!-- 从类路径 --><sqlMap resource="com/demo/ibatis/beans/address_SqlMap.xml" /><!-- 从URL加载 --> <sqlMap URL="file://C:/config/address_SqlMap.xml" /></sqlMapConfig>