iBATIS入门（实例代码）

<?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="sqlmap/map/SqlMapConfigExample.properties" />

   <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="${driver}"/>
     <property name="JDBC.ConnectionURL" value="${url}"/>
     <property name="JDBC.Username" value="${username}"/>
     <property name="JDBC.Password" value="${password}"/>
    </dataSource>
   </transactionManager>

     
   <sqlMap resource="sqlmap/map/User.xml" />
  </sqlMapConfig>

package com.ibatis.my.domain;
public class User {
    public int uid;
    public String name;
    public int sex;
    public int age;
    public String addr;
    public String zipcode;   

    public String getAddr() {
        return addr;
    }
    public void setAddr(String addr) {
        this.addr = addr;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public int getSex() {
        return sex;
    }
    public void setSex(int sex) {
        this.sex = sex;
    }
    public int getUid() {
        return uid;
    }
    public void setUid(int uid) {
        this.uid = uid;
    }
    public String getZipcode() {
        return zipcode;
    }
    public void setZipcode(String zipcode) {
        this.zipcode = zipcode;
    }
}

import java.io.Reader;

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

public class Myapp {
    private static final SqlMapClient sqlMap;
    static {
        try {
            String resource = "sqlmap/map/sql-map-config.xml";
            Reader reader = Resources.getResourceAsReader (resource);
            sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
        }
        catch (Exception e) {
         e.printStackTrace();    
        throw new RuntimeException ("Error initializing MyApp class. Cause:"+e);
        }
    }
    public static SqlMapClient getSqlMapInstance () {
        return sqlMap;
    }
}

package com.ibatis.my.action;

import com.ibatis.my.domain.User;
import com.ibatis.sqlmap.client.SqlMapClient;

public class Opperates {

    public static void main(String[] args) {
        User newUser= new User();
        newUser.setUid(5);
        newUser.setName("oring");
        newUser.setSex(2);
        newUser.setAge(2);
       
        newUser.setAddr("dfghg");
        newUser.setZipcode("301");
        SqlMapClient sqlMap = Myapp.getSqlMapInstance();
        try{
           
           Integer uid= new Integer(1);
        //   User user = (User) sqlMap.queryForObject ("getUser", uid);           
           sqlMap.insert ("insertUser", newUser);
        }
        catch(Exception e){
               e.printStackTrace();
        }
       
    }
}