由于项目需要刚刚研究了一下ibatis和json-lib的配置和应用。
调试成功,写下笔记以供大家分享和自己日后查阅
用到ibatis-2.3.4.726.jar这个包是独立的
还有json-lib-2.3-jdk15.jar这个包需要一下几个包也在才能使用
commons-beanutils-1.7.jar
commons-lang-2.0.jar
commons-logging-1.0.2.jar
ezmorph-1.0.6.jar
xom-1.1.jar
commons-collections-3.2.jar
还有连接oracle的包ojdbc14.jar
可以到http://www.docjar.com去下载包
现在讲讲ibatis的配置:
文件结构如下图:
sqlMapConfig.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>
<properties resource="CCH/Map/SqlMapConfig11.properties" />
<settings cacheModelsEnabled="true"
enhancementEnabled="true"
lazyLoadingEnabled="true"
errorTracingEnabled="true"
maxRequests="32"
maxSessions="10"
maxTransactions="5"
useStatementNamespaces="false" />
<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}" />
</dataSource>
</transactionManager>
<sqlMap resource="CCH/Map/User.xml" />
</sqlMapConfig>
SqlMapConfig11.properties的内容:
driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@IP:1521:orcl
username=username
password=password
user.xml的内容为:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="User">
<!--
Use primitive wrapper type (e.g. Integer) as parameter and allow
results to be auto-mapped results to Person object (Java Bean)
properties
-->
<resultMap id="userResult" class="CCH.Model.UserInfo">
<result property="userId" column="userName"/>
<result property="userName" column="userName1"/>
</resultMap>
<insert id="insertUser" parameterClass="CCH.Model.UserInfo">
insert into cch_test(UserName,UserName1) values(#userId#,#userName#)
</insert>
<select id="selectUser" resultMap="userResult" >
select * from cch_test
</select>
</sqlMap>
myAppConf.java的内容为:
package CCH.App;
import java.io.IOException;
import java.io.Reader;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
public class MyAppConfig {
private static SqlMapClient client = null;
static {
try {
Reader reader = Resources.getResourceAsReader("CCH/Map/SqlMapConfig.xml");
client = SqlMapClientBuilder.buildSqlMapClient(reader);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static SqlMapClient getSqlMapClient(){
return client;
}
}