ibatis 开始

参考了官方的 iBATIS-SqlMaps-2-Tutorial_cn.pdf 

注意 6中一定要加上try catch 否则会报Unhandled exception type SQLException错误

1.Person.java

根据自己的数据库表制作Person.java，他也可能是User.java，Company.java等等

 

2.Person.java

 1<?xml version="1.0" encoding="UTF-8"?>
 2
 3<!DOCTYPE sqlMap
 4    PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
 5     "http://www.ibatis.com/dtd/sql-map-2.dtd">
 6     
 7<sqlMap namespace="Person">
 8
 9 <select id="getPerson" parameterClass="int" resultClass="com.xc.ibatis.Person">
  <![CDATA[  
      select 
          *
      from Person 
      WHERE id = #value#
      ]]>
 </select>
 
</sqlMap>

 

3.SqlMapConfig.xml

 1<?xml version="1.0" encoding="UTF-8" standalone="no"?>
 2<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd">
 3
 4<sqlMapConfig>
 5
 6 <properties resource="SqlMapConfig.properties" />
 7 <settings 
 8     cacheModelsEnabled="true" 
 9     lazyLoadingEnabled="true"
      enhancementEnabled="true" 
     maxSessions="64" 
      maxTransactions="8"
     maxRequests="128" />

 <transactionManager type="JDBC">
  <dataSource type="SIMPLE">
   <property value="${driver}" name="JDBC.Driver" />
   <property value="${url}" name="JDBC.ConnectionURL" />
   <property value="${username}" name="JDBC.Username" />
   <property value="${password}" name="JDBC.Password" />
   <property value="15" name="Pool.MaximumActiveConnections" />
   <property value="15" name="Pool.MaximumIdleConnections" />
   <property value="1000" name="Pool.MaximumWait" />
  </dataSource>
 </transactionManager>

 <sqlMap resource="com/xc/ibatis/Person.xml" />

</sqlMapConfig>

 

4.SqlMapConfig.properties

username=user

password=pass
url=jdbc:oracle:thin:@192.168.0.78:1521:ora9i
driver=oracle.jdbc.driver.OracleDriver

 

 

 

5.MyAppSqlConfig.java

 1package com.xc.ibatis;
 2
 3import java.io.Reader;
 4
 5import com.ibatis.common.resources.Resources;
 6import com.ibatis.sqlmap.client.SqlMapClient;
 7import com.ibatis.sqlmap.client.SqlMapClientBuilder;
 8
 9public class MyAppSqlConfig {
    private static final SqlMapClient sqlMap;
    
    static{
        try{
            String resource = "SqlMapConfig.xml";
            Reader reader = Resources.getResourceAsReader(resource);
            sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
            reader.close();
        }catch(Exception e){
            e.printStackTrace();
            throw new RuntimeException("Error initializing MyAppSqlConfig class. Cause:"+ e);
        }
    }
    
    public static SqlMapClient getSqlMapInstance(){
        return sqlMap;
    }
}

 

6.testibatis.java

 1package Test;
 2
 3import com.ibatis.sqlmap.client.SqlMapClient;
 4import com.xc.ibatis.*;
 5
 6public class testibatis {
 7
 8    /** *//**
 9     * @param args
     */
    public static void main(String[] args) {
        // TODO Auto-generated method stub
        SqlMapClient sqlMap = MyAppSqlConfig.getSqlMapInstance();
        try{
            
        Integer Orgid = new Integer(3);
        Person person = (Person)sqlMap.queryForObject("getPerson", id);
        System.out.println(person.getName()+ " " + person.getAge());
        }catch(Exception e){
            e.printStackTrace();
            throw new RuntimeException("Error testibatis Cause:"+ e);
        }
    }

}