blaze

IBatis也是一种RO映射的工具，类似于hibernate，它不是基于table来映射，而是基于sql，所以填补了hibernate的空白

1 建立一个配置文件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"
    maxRequests="32"
    maxSessions="10"
    maxTransactions="5"
    useStatementNamespaces="false"
  />
  <transactionManager type="JDBC" >
    <dataSource type="SIMPLE">
      <property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
      <property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@xxx"/>
      <property name="JDBC.Username" value="user"/>
      <property name="JDBC.Password" value="ppp"/>
    </dataSource>
  </transactionManager>
  <sqlMap resource="bean.xml" />
</sqlMapConfig>

2 bean.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="Bean">

  <select id="getBean" parameterClass="java.lang.Integer" resultClass="com.mindo.bean.Bean">
    select (select count(*) from oa_jksqd t where t.jksq_zt=0 or t.jksq_zt=1 or t.jksq_zt=2) as check1, (select count(*) from oa_jksqd t where t.jksq_zt=3) as check2, (select count(*) from oa_jksqd t where t.jksq_zt=#status#) as check3  from dual
  </select>

 
</sqlMap>

3 测试类

public class IBatisTest {

 public static void main(String[] args) {
  new IBatisTest().loadBean();
 }
 public void loadBean() {
  com.ibatis.sqlmap.client.SqlMapClient sqlMap = null;
  try {
   java.io.Reader reader =
    com.ibatis.common.resources.Resources.getResourceAsReader(
     "sql-map-config.xml");
   sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
   //sqlMap.setUserConnection();
   Bean bean =
    (Bean) sqlMap.queryForObject(
     "getBean",
     new Integer(0));
   System.out.println(bean.getCount());
  } catch (Exception e) {
   e.printStackTrace();
  }

 }
}
4 Bean.java

略。。。