ibatis的简单应用

 

ExampleMain.java

package com.si_tech;
    
import java.sql.SQLException;   
import java.util.List;   
  
import com.ibatis.sqlmap.client.SqlMapClientBuilder;   
   
public class ExampleMain {   
  
    public static void update() {   
        //首先初始化iBatis获得一个SqlMapClient对象   
        String resource = "com/si_tech/SqlMapConfig.xml";   
        com.ibatis.sqlmap.client.SqlMapClient sqlMap = null;   
        try {   
            java.io.Reader reader = com.ibatis.common.resources.Resources   
                    .getResourceAsReader(resource);   
            sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);   
        } catch (Exception e) {   
            e.printStackTrace();   
        }   
        // sqlMap系统初始化完毕，开始执行update操作   
        try {   
            sqlMap.startTransaction();   
            User user = new User();   
            user.setId(new Integer(1));   
            user.setName("zhupan");   
            user.setSex(new Integer(1));   
            sqlMap.update("updateUser", user);   
            sqlMap.commitTransaction();   
        } catch (SQLException e) {   
            System.out.println(e.getMessage());   
        } finally {   
            try {   
                sqlMap.endTransaction();   
            } catch (SQLException e) {   
                e.printStackTrace();   
            }   
        }   
    }   
    public static List getUser() {   
//      首先初始化iBatis获得一个SqlMapClient对象   
        String resource = "com/si_tech/SqlMapConfig.xml";   
        com.ibatis.sqlmap.client.SqlMapClient sqlMap = null;   
        List user=null;   
        try {   
            java.io.Reader reader = com.ibatis.common.resources.Resources   
                    .getResourceAsReader(resource);   
            sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);   
        } catch (Exception e) {   
            e.printStackTrace();   
        }   
        // sqlMap系统初始化完毕，开始执行getAllUser操作   
        try {   
            sqlMap.startTransaction();                 
            user=sqlMap.queryForList("getAllUser", "zhupan");   
            sqlMap.commitTransaction();   
        } catch (SQLException e) {   
            System.out.println(e.getMessage());   
        } finally {   
            try {   
                sqlMap.endTransaction();   
            } catch (SQLException e) {   
                e.printStackTrace();   
            }   
        }   
        return user;  
    }  
    public static List getUsers(){
     String resource = "com/si_tech/SqlMapConfig.xml";   
        com.ibatis.sqlmap.client.SqlMapClient sqlMap = null;   
        List list=null;
        try {   
            java.io.Reader reader = com.ibatis.common.resources.Resources   
                    .getResourceAsReader(resource);   
            sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);   
        } catch (Exception e) {   
            e.printStackTrace();   
        }   
        try {   
            sqlMap.startTransaction();                 
            list=sqlMap.queryForList("getAllUsers", null);   
            sqlMap.commitTransaction();   
        } catch (SQLException e) {   
            System.out.println(e.getMessage());   
        } finally {   
            try {   
                sqlMap.endTransaction();   
            } catch (SQLException e) {   
                e.printStackTrace();   
            }   
        }   
        return list;
    }
    public static void main(String[] args) {   
        update();   
        List user=getUsers();
        for(int i=0;i<user.size();i++)
        {   
            System.out.println(((User)user.get(i)).getName());   
        }   
  
    }   
}  

User.java

package com.si_tech;
import java.io.Serializable;

public class User implements Serializable {
 private static final long serialVersionUID = 1L;

 private Integer id;

 private String name;

 private Integer sex;

 public User() {

 }

 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 getSex() {
  return sex;
 }

 public void setSex(Integer sex) {
  this.sex = sex;
 }

}

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>

 <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="com.mysql.jdbc.Driver" />
   <property name="JDBC.ConnectionURL"
    value="jdbc:mysql://localhost/sample" />
   <property name="JDBC.Username" value="root" />
   <property name="JDBC.Password" value="root" />
   <property name="Pool.MaximumActiveConnections" value="10" />
   <property name="Pool.MaximumIdleConnections" value="5" />
   <property name="Pool.MaximumCheckoutTime" value="120000" />
   <property name="Pool.TimeToWait" value="500" />
   <property name="Pool.PingQuery"
    value="select 1 from sample" />
   <property name="Pool.PingEnabled" value="false" />
   <property name="Pool.PingConnectionsOlderThan" value="1" />
   <property name="Pool.PingConnectionsNotUsedFor" value="1" />
  </dataSource>
 </transactionManager>

 <sqlMap resource="com/si_tech/User.xml" />
</sqlMapConfig>

 

User.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap     
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"     
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="User">

 <typeAlias alias="user" type="com.si_tech.User" />
 <select id="getUser" parameterClass="java.lang.String"
  resultClass="com.si_tech.User">

  select name, sex from t_user where name = #name#
 </select>

 <select id="getAllUser" resultClass="user">

  select name, sex from t_user where name = #name#
 </select>
 
 <select id="getAllUsers" resultClass="user">

  select * from t_user
 </select>
 <update id="updateUser" parameterClass="user">

  UPDATE t_user SET name=#name#, sex=#sex# WHERE id = #id#
 </update>

 <insert id="insertUser" parameterClass="user">
  INSERT INTO t_user ( name, sex) VALUES ( #name#, #sex# )
 </insert>

 <delete id="deleteUser" parameterClass="java.lang.String">
  delete from t_user where id=#value#
 </delete>

</sqlMap>