简单入门案例

Ibatis 入门
1.创建数据库脚本
 drop database sample;
 create database sample;
 use sample;
 drop table t_user;
 create table t_user(
  id int not null auto_increment,
  name varchar(50) default null,
  sex int(11) default null,
  primary key (id)
 );
 insert into t_user values (1,'1',1),(2,'2',2),(3,'3',3),(4,'4',4),(5,'5',5);
2.编写Ibaits必须的配置文件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="mysqladmin" />
    <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/ctgusec/zhupan/maps/User.xml" />
 </sqlMapConfig>
3.编写实体类
 package com.ctgusec.zhupan.model;
 import java.io.Serializable;
 public class User implements Serializable {
  private static final long serialVersionUID = 1L;
  private Integer id;
  private String name;
  private Integer sex;
  .
  .
  .
4.在编写数据库表到实体类的映射
 <?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="User">
  <typeAlias alias="user" type="com.ctgusec.zhupan.model.User" />
  <select id="getUser" parameterClass="java.lang.String" resultClass="user">
   <![CDATA[ select name,sex from t_user where name=#name# ]]>
  </select>
  <select id="getAllUser" resultClass="user">
   <![CDATA[ select name sex from t_user ]]>
  </select>
  <update id="updateUser" parameterClass="user">
   <![CDATA[ update t_user set name=#name#,sex=#sex# where id=#id#]]>
  </update>
  <insert id="insertUser" parameterClass="user">
   <![CDATA[INSERT INTO t_user ( name, sex) VALUES ( #name#, #sex# )]]>
  </insert>
  <delete id="deleteUser" parameterClass="java.lang.Integer">
   <![CDATA[delete from t_user where id=#value#]]>
  </delete>
 </sqlMap>
5.测试
 package com.ctgusec.zhupan;
 import java.io.Reader;
 import java.sql.SQLException;
 import java.util.List;
 import com.ctgusec.zhupan.model.User;
 import com.ibatis.common.resources.Resources;
 import com.ibatis.sqlmap.client.SqlMapClient;
 import com.ibatis.sqlmap.client.SqlMapClientBuilder;
 public class ExampleMain {
  //删除的操作
  public static boolean delete() {
   boolean flag = true;
   String resource = "com/ctgusec/zhupan/maps/SqlMapConfig.xml";
   SqlMapClient sqlMap = null;
   try {
    Reader reader = Resources.getResourceAsReader(resource);
    sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
   } catch (Exception e) {
    flag = false;
    e.printStackTrace();
   }
   try {
    sqlMap.startTransaction();
    sqlMap.delete("deleteUser",new Integer(7));
    sqlMap.commitTransaction();
   } catch (Exception e) {
    flag = false;
    e.printStackTrace();
   } finally {
    try {
     sqlMap.endTransaction();
    } catch (SQLException e) {
     flag = false;
     e.printStackTrace();
    }
   }
   return flag;
  }
  //增加的操作
  public static boolean add() {
   boolean flag = true;
   String resource = "com/ctgusec/zhupan/maps/SqlMapConfig.xml";
   SqlMapClient sqlMap = null;
   try {
    Reader reader = Resources.getResourceAsReader(resource);
    sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
   } catch (Exception e) {
    flag = false;
    e.printStackTrace();
   }
   try {
    sqlMap.startTransaction();
    User user = new User();
    user.setName("xc");
    user.setSex(new Integer(1));
    sqlMap.insert("insertUser", user);
    sqlMap.commitTransaction();
   } catch (Exception e) {
    flag = false;
    e.printStackTrace();
   } finally {
    try {
     sqlMap.endTransaction();
    } catch (SQLException e) {
     flag = false;
     e.printStackTrace();
    }
   }
   return flag;
  }
  //修改的操作
  public static void update() {
   // 首先初始化iBatis获得一个SqlMapClient对象
   String resource = "com/ctgusec/zhupan/maps/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("zhangsan");
    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/ctgusec/zhupan/maps/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", null);
    sqlMap.commitTransaction();
   } catch (SQLException e) {
    System.out.println(e.getMessage());
   } finally {
    try {
     sqlMap.endTransaction();
    } catch (SQLException e) {
     e.printStackTrace();
    }
   }
   return user;
  }
  public static void main(String[] args) {
 //  System.out.println(delete());
   // System.out.println(add());
   // System.out.println("testtest");
   // update();
   // List user=getUser();
   // for(int i=0;i<user.size();i++)
   // {
   // System.out.print(((User)user.get(i)).getName()+"、");
   // }
  }
 }
6.其中所使用的包
 commons-dbcp.jar
 commons-logging.jar
 commons-loggin-api.jar
 commons-pool.jar
 hsqldb.jar
 ibatis-common-2.jar
 ibatis-dao-2.jar
 ibatis-sqlmap-2.jar
 mysql-connector-java-3.1.12-bin.jar