ibatis

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:@127.0.0.1:1521:orcl" />
  <property name="JDBC.Username" value="vtyi" />
  <property name="JDBC.Password" value="vtyi" />
  </dataSource>
 </transactionManager>
 <sqlMap resource="Account.xml" />
 <sqlMap resource="Product.xml" />
</sqlMapConfig>
 

 

Account.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="Account">
<select id="getAccount" parameterClass="java.lang.Integer" resultClass="test.Account">
 select * from account where id= #id#
</select>

<insert id="insertAccount" parameterClass="test.Account">
 
 <selectKey resultClass="int" keyProperty="id">
  select accountSequence.nextval as id from dual
 </selectKey>
 
 insert into Account values(#id#,#name#,#subid#,#address#)
</insert>

<!-- 
<parameterMap id="insert_param" class="test.Account">
 <parameter property="id" jdbcType="NUMBER" javaType="java.lang.Integer" nullValue="0" />
 <parameter property="name" jdbcType="VARCHAR" javaType="java.lang.String" nullValue="aa" />
</parameterMap>
<statement id="insert_statement" parameterMap="insert_param">
 insert into Account(id,name) values(?,?);
</statement>
<parameterMap id="parameterMap" class="map">
 <parameter property="name" jdbcType="VARCHAR" javaType="java.lang.String" mode="INOUT" nullValue="aa">
 </parameter>
</parameterMap>
<procedure id="procedureMap" parameterMap="parameterMap">
 {call swap(?)}
</procedure>
-->
<resultMap id="one_many" class="test.Account">
 <result property="id" column="id" />
 <result property="name" column="name" />
 <result property="subid" column="subid" />
 <result property="address" column="address" />
 <!-- n+1
 <result property="address" column="address" />
 <result property="subid" column="subid" select="getProduct" />
  -->
 <result property="product.id" column="id" />
 <result property="product.name" column="name" />
</resultMap>
<!-- n+1
<resultMap id="product_result" class="test.Product" >
 <result property="id" column="id" />
 <result property="name" column="name" />
</resultMap>
-->
<select id="getAccountAndProduct" parameterClass="java.lang.Integer" resultMap="one_many">
 select * from Account ,Product  where Account.id= Product.id and Account.id=#id#
</select>
<!-- 
<select id="getProduct" parameterClass="java.lang.Integer" resultMap="product_result">
 select * from Product where id= #id#
</select>
-->

<cacheModel id="cache_one" type="MEMORY"><!-- FIFO  OSCACHE-->
 <flushInterval hours="24" />
 <flushOnExecute statement="insertAccount" />
 
 <property name="reference-type" value="WEAK" /><!-- STRONG,SOFT -->
</cacheModel>
<cacheModel id="cache_two" type="LRU" readOnly="true" serialize="true">
 <flushInterval hours="24" />
 <flushOnExecute statement="insertAccount" />

 <property name="cache-size" value="1000" />
</cacheModel>

<!-- dynamic -->
<select id="dynamic_sql" cacheModel="cache_two" resultMap="one_many">
 select * from Account
 <isGreaterThan prepend="and" property="id" compareValue="0" >
  where id=#id#
 </isGreaterThan>
 order by id
</select>
<statement id="dynamicGetAccountList" resultMap="one_many" >
 select * from ACCOUNT
 <dynamic prepend="WHERE">
 <isNotNull prepend="AND" property="firstName">
  ( ACC_FIRST_NAME = #firstName#
 <isNotNull prepend="OR" property="lastName">
  ACC_LAST_NAME = #lastName#
 </isNotNull>
  )
 </isNotNull>
 <isNotNull prepend="AND" property="emailAddress">
  ACC_EMAIL like #emailAddress#
 </isNotNull>
 <isGreaterThan prepend="AND" property="id" compareValue="0">
  ACC_ID = #id#
 </isGreaterThan>
 </dynamic>
 order by ACC_LAST_NAME
</statement>

<statement id="someName" resultMap="one_many" >
 select * from ACCOUNT
 <dynamic prepend="where">
 <isGreaterThan prepend="and" property="id" compareValue="0">
 ACC_ID = #id#
 </isGreaterThan>
 <isNotNull prepend="and" property="lastName">
 ACC_LAST_NAME = #lastName#
 </isNotNull>
 </dynamic>
 order by ACC_LAST_NAME
</statement>

<!-- xml -->
<select id="getByIdValueXml" resultClass="xml" xmlResultName="account" >
 select * from Account where id= #id#
</select>
</sqlMap>

 

Account.java

 

package test;

public class Account {

 private Integer id;
 private String name;
 private Integer subid;
 private String address;
 private Product product;
 public Integer getId() {
  return id;
 }
 public void setId(Integer id) {
  this.id = id;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public Integer getSubid() {
  return subid;
 }
 public void setSubid(Integer subid) {
  this.subid = subid;
 }
 public String getAddress() {
  return address;
 }
 public void setAddress(String address) {
  this.address = address;
 }
 
 public Product getProduct() {
  return product;
 }
 public void setProduct(Product product) {
  this.product = product;
 }
 @Override
 public String toString(){
  return "id= "+id+" name= "+name+" subid= "+subid+" address= "+address+
  " product={ "+product+" }";
 }
 
}

Product.java

 

package test;

public class Product {

 private Integer id;
 private String name;
 public Integer getId() {
  return id;
 }
 public void setId(Integer id) {
  this.id = id;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 @Override
 public String toString(){
  return "id= "+id+" name= "+name;
 }
}

 

Ibatis.java

 

package test;

import java.beans.Introspector;
import java.beans.PropertyDescriptor;
import java.io.Reader;
import java.util.List;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class Ibatis {

 /**
  * @param args
  */
 public static void main(String[] args) throws Exception {
  
  String resource="sql-map-config.xml";
  System.out.println(Ibatis.class.getClassLoader().getResource("E:\\workspace\\test\\src\\sql-map-config.xml"));
  Reader reader=Resources.getResourceAsReader(resource);
  SqlMapClient sqlMap=SqlMapClientBuilder.buildSqlMapClient(reader);
//  List list=sqlMap.queryForList("getAccount",1);
  List list=sqlMap.queryForList("getAccountAndProduct",1);
  if(list!=null && !list.isEmpty()){
   for(int i=0;i<list.size();i++){
    Account acc=(Account)list.get(i);
    System.out.println(acc);
   }
  }
  Account acc=new Account();
  acc.setAddress("深圳3");
//  acc.setId(new Integer(2));
  acc.setSubid(new Integer(3));
  acc.setName("cccca");
  sqlMap.insert("insertAccount", acc);
  
  String xml=(String)sqlMap.queryForObject("getByIdValueXml", new Integer(1));
  System.out.println(xml);
 }

 public String convertToXml(Object o,Class c,String name) throws Exception{
  StringBuffer sb=new StringBuffer("");
  if(o.getClass().isAssignableFrom(c)){
   PropertyDescriptor[] pd=Introspector.getBeanInfo(c).getPropertyDescriptors();
   if(pd.length>0){
     sb.append("<"+name+">");
     for(int i=0;i<pd.length;i++){
     
     }
   }
  }
  return null;
 }
}