SqlMapConfig.xml
<?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="true" enhancementEnabled="true" maxRequests="32" maxSessions="10" maxTransactions="5" useStatementNamespaces="false" /> <transactionManager type="JDBC"> <dataSource type="SIMPLE"> <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/> <property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost:3306/test"/> <property name="JDBC.Username" value="root"/> <property name="JDBC.Password" value="root"/> </dataSource> </transactionManager>
<sqlMap resource="com/test/data/Person.xml"/> </sqlMapConfig>
SqlMap.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="person"> <select id="getPerson" resultClass="com.test.domain.Person"> select username as username,password as password,name as name,email as email,birthday as birthday,address as address,age as age,sex as sex where username=#value# </select> <insert id="addPerson" parameterClass="com.test.domain.Person"> insert into person(username ,password, name, email, birthday, address, age, sex) values(#username#, #password#, #name#, #email#, #birthday#, #address#, #age#, #sex#) </insert> </sqlMap>