iBatis笔记部分分析和总结.docxVIP

sqlMapConfig.xml 样例 ?xml version=1.0 encoding=UTF-8? !DOCTYPE sqlMapConfig PUBLIC -////DTD SQL Map Config 2.0//EN /dtd/sql-map-config-2.dtd sqlMapConfig !-- 设置属性 -- settings enhancementEnabled=true useStatementNamespaces=true cacheModelsEnabled=true lazyLoadingEnabled=true / !-- 设置数据库参数 -- transactionManager type=JDBC dataSource type=SIMPLE 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=123 / property name=Pool.MaximumActiveConnection 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 user / property name=Pool.PingEnabled value=false / property name=Pool.PingConnectionsOlderThan value=1 / property name=Pool.PingConnectionsNotUsedFor value=1 / /dataSource /transactionManager !-- 设置映射文件 -- sqlMap resource=com/demo/ibatis/beans/user_SqlMap.xml / /sqlMapConfig 可以在属性文件中配置键值对，例如 sqlMapCperties driver= driver=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/demo username=root password=123 在 sqlMapConfig.xml 中引用配置文件的时候需要加入第一行： sqlMapConfig !-- 加载配置文件 -- properties resource=SqlMapCperties / !-- 设置属性 -- settings enhancementEnabled=true useStatementNamespaces=true cacheModelsEnabled =true lazyLoadingEnabled=true / !-- 设置数据库参数 -- transactionManager type=JDBC dataSource type=SIMPLE property name=JDBC.Driver value=${driver} / property name=JDBC.ConnectionURL value=${url} / property name=JDBC.Username value=${username} / property name=JDBC.Password value=${password} / property name=Pool.MaximumActiveConnection 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 user / property name=Pool.PingEnabled value=false