配置文件 sql-map-config.xml <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd"> <sqlMapConfig> <settings cacheModelsEnabled="true" enhancementEnabled="true" lazyLoadingEnabled="true" errorTracingEnabled="true" maxRequests="32" maxSessions="10" maxTransactions="5" useStatementNamespaces="false" /> <transactionManager type="JDBC"> <dataSource type="SIMPLE"> <!-- com.microsoft.sqlserver.jdbc.SQLServerDriver --> <property name="JDBC.Driver" value="com.mysql.jdbc.Driver" /> <!--jdbc:sqlserver://localhost:1433;databaseName=ibatisorm --> <property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost:3306/ibatisorm" /> <property name="JDBC.Username" value="root" /> <property name="JDBC.Password" value="root" /> <property name="Pool.MaximumActiveConnections" value="10" /> <property name="Pool.MaximumIdleConnections" value="5" /> <property name="Pool.MaximumCheckoutTime" value="120000" /> <property name="Pool.TimeToWait" value="500" /> <property name="Pool.PingQuery" value="select 1 from TestDB" /> <property name="Pool.PingEnabled" value="false" /> <property name="Pool.PingConnectionsOlderThan" value="1" /> <property name="Pool.PingConnectionsNotUsedFor" value="1" /> </dataSource> </transactionManager> <sqlMap resource="sqlMap/User.xml" /> <sqlMap resource="sqlMap/Person.xml" /> <sqlMap resource="sqlMap/Address.xml" /> </sqlMapConfig>