spring 集成ibatis及mysql配置
数据源配置:
database.properties内容:
UserName=***Password=*****jdbc.DriverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/databaseNamejdbc.username=${UserName}jdbc.password=${Password}jdbc.maxActive=10jdbc.maxIdle=5jdbc.maxWait=10000<context:property-placeholder location="classpath:database.properties" /><bean id="dataSource" value="${jdbc.url}" /><property name="driverClassName" value="${jdbc.DriverClassName}" /><property name="username" value="${jdbc.username}" /><property name="password" value="${jdbc.password}" /><property name="maxActive" value="${jdbc.maxActive}" /><property name="maxIdle" value="${jdbc.maxIdle}" /><property name="maxWait" value="${jdbc.maxWait}" /></bean><!-- 声明iBatis模板类 --><bean id="sqlMapClientTemplate" ref="dataSource" /><property name="configLocation" value="classpath:sqlMapConfig.xml" /></bean></property></bean><?xml version="1.0" encoding="UTF-8"?><!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd"><sqlMapConfig><settings cacheModelsEnabled="false" enhancementEnabled="true"lazyLoadingEnabled="true" useStatementNamespaces="true" /><sqlMap resource="com/UserInfo.xml" /></sqlMapConfig>