真不好意识，前不久写了篇iBATIS入门，由于那时候快过年了，一直没有心情写，现在上班了，也没什么事情做，就在这里继续写写吧，O(∩_∩)O哈哈~，希望各位能够喜欢。

首先我们需要下载一些iBATIS的jar包，这个我就不在这里说了，网上有，我是用的ibatis-2.3.0.677.jar

数据库是用的Oracle9i，开发工具是MyEclipse；

数据库脚本

create table student(
sid integer not null primary key,
sname nvarchar2 (50),
major nvarchar2 (50),
score float ,
birth date
);

首先我们需要在src目录下创建个SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMapConfig     
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"     
    "">

<sqlMapConfig>

<!--
假如我们需要引入额外的文件就是这样引用的
<providers embedded="resources.providers.config, IBatisNet.Test"/>
-->
<!-- Configure a built-in transaction manager. If you're using an
       app server, you probably want to use its transaction manager
       and a managed datasource -->
       <!-- 配置事物，以及数据库的链接属性 -->
       <settings
    cacheModelsEnabled="true"
    enhancementEnabled="true"
    lazyLoadingEnabled="true"
    maxRequests="32"
    maxSessions="10"
    maxTransactions="5"
    useStatementNamespaces="false"
    />
<transactionManager type="JDBC" commitRequired="false">
    <dataSource type="SIMPLE">
    <!-- sql2000的配置 -->
     <!-- <property name="JDBC.Driver" value="net.sourceforge.jtds.jdbc.Driver"/>
      <property name="JDBC.ConnectionURL" value="jdbc:jtds:sqlserver://localhost:1433;DataBaseName=MyTest"/>
      <property name="JDBC.Username" value="sa"/>
      <property name="JDBC.Password" value=""/> -->
     
      <property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
      <property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@localhost:1521:oracle9i"/>
      <property name="JDBC.Username" value="scott"/>
      <property name="JDBC.Password" value="tiger"/>
    </dataSource>
</transactionManager>

<!-- List the SQL Map XML files. They can be loaded from the
       classpath, as they are here (com.domain.data...) -->
       <!-- 此处是用来配置相对应的bean对应的配置文件，以及sql语句 -->
<sqlMap resource="com/ibats/bean/Student.xml"/>

</sqlMapConfig>

bean我就不在这里写了，各位自己写下

然后我在这里关键是讲解下Student.xml 下面怎样整合sql语句

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMap     
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"     
    "">
<sqlMap namespace="Student">
<!-- 为这个类起个别名 -->
<typeAlias alias="Student" type="com.ibats.bean.Student" />
<!-- 查询所有 -->
<select id="selectAllStudent" resultClass="Student">
   select * from student order by sid
</select>
<!--指定条件查询 -->
<select id="selectStudentById" parameterClass="int"
   resultClass="Student">
   select * from student where sid = #sid#
</select>
<select id="selectStudentCount" resultClass="Integer">
   select count(1) from student
</select>
<!-- 模糊查询-->
<select id="selectStudentByName" parameterClass="String"
   resultClass="Student">
   select sid,sname,major,score,birth from Student where sname like
   '%$sname$%'
</select>
<!-- 动态查询 -->
<select id="selectByDynamic" resultClass="Student">
   select * from student
   <dynamic prepend="where">
    <isNotEmpty property="major">major = #major#</isNotEmpty>
   </dynamic>
</select>

<select id="selectByGreate" resultClass="Student">
   select * from student
   <!-- 当sid>1013时执行下面操作 -->
   <isGreaterThan property="sid" compareValue="1013">
    where sid > #sid#
   </isGreaterThan>
   order by sid
</select>
<!-- 判断sname属性是否为null，score属性是否为null，并且sid 大于1119 -->
<select id="DynamicStudent" resultClass="Student">
   select * from student
   <dynamic prepend="where">
    <isNotNull prepend="and" property="sname">
     (sname = #sname#
     <isNotNull prepend="or" property="score">
      score = #score#
     </isNotNull>
     )
    </isNotNull>
    <isNotNull prepend = "and" property = "major">
     major = #major#
    </isNotNull>
    <isGreaterThan prepend ="and" property = "sid" compareValue = "1119">
     sid > 1119
    </isGreaterThan>
   </dynamic>
</select>
<!-- 对数据进行排序sortvalue我们是已经在student中定义好的属性 -->
<statement id="getOrderStu" resultClass = "Student">
   select * from student
    <dynamic prepend = "order by">
     <isNotEmpty property = "sortvalue">
      sid $sortvalue$
     </isNotEmpty>
    </dynamic>
</statement>
<!-- 模糊查询 -->
<select id="blurStudent" resultClass = "student">
   select * from student
   <dynamic prepend = "where">
    <isNotEmpty property = "major">
     major like '%$major$%'
    </isNotEmpty>
   </dynamic>
</select>
<!-- 插入语句 -->
<insert id="insertStudent" parameterClass="student">
   insert into Student(sid,sname,major,birth,score) values
   (#sid#,#sname#,#major#,#birth#,#score#)
</insert>
<!-- 删除语法 -->
<delete id="deleteStudentById" parameterClass="int">
   delete from Student where sid = #sid#
</delete>
<!-- 修改语句-->
<update id="updateStudent" parameterClass="student">
   update Student set sname =#sname# , major = #major#, score =
   #score#, birth = #birth# where sid = #sid#
</update>
<!-- 我们可以在statement里面进行insert，update，select操作 -->
<statement id="insertStateStu" parameterClass="student">
   insert into Student (sid,sname,major,birth,score) values
   (#sid#,#sname#,#major#,#birth#,#score#)
</statement>
<!-- 插入时自动生成主键 -->
<!-- 针对Oracle我们首先需要创建其序列
   create sequence workRecord_ID minvalue 1000 maxvalue 99999999 start with 1000 increment by 1 nocache;
-->
<insert id="insertStuSeque" parameterClass="student">
   <selectKey resultClass="int" type="pre" keyProperty="sid">
    SELECT scott.workRecord_ID.nextval AS sid FROM dual
   </selectKey>
   insert into student(sid,sname,major,birth,score) values
   (#sid#,#sname#,#major#,#birth#,#score#)
</insert>

</sqlMap>

我想注释已近非常详细了，然后就是我们的接口了

package com.ibats.dao;

import java.util.List;

import com.ibats.bean.Student;

public interface StudentDAO {
public void addStudent(Student student);

public void addStudentBySeuque(Student student);

public void deleteStduent(int sid);

public void updateStudent(Student student);

public List<Student> queryAllStudent();

public Student queryStudentById(int id);

public Student queryStudentByName(String name);

public List<Student> queryDynamic(Student student) ;

public void addStudentBystat(Student student);

public int getAllCount();
}

剩下来就是我们的实现类了

package com.ibats.dao.imp;

import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import com.ibats.bean.Student;
import com.ibats.dao.StudentDAO;

public class IStudentDaoImp implements StudentDAO {
public Student queryStudentByName(String name) {
   List<Student> stuList = null;
   try {
    stuList = sqlMapClient.queryForList("selectStudentByName", name);
   } catch (SQLException e) {
    e.printStackTrace();
   }
   System.out.println(stuList.size());
   return stuList.get(0);
}

private static SqlMapClient sqlMapClient = null;
static {
   try {
    Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");
    sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
    reader.close();
   } catch (IOException e) {
    e.printStackTrace();
   } finally {

   }
}

public void addStudent(Student student) {
   try {
    sqlMapClient.insert("insertStudent", student);
   } catch (SQLException e) {
    e.printStackTrace();
   }
}

public void addStudentBySeuque(Student student) {
   try {
    sqlMapClient.insert("insertStuSeque", student);
   } catch (SQLException e) {
    e.printStackTrace();
   }
}

public void deleteStduent(int sid) {
   try {
    System.out.println(sqlMapClient.delete("deleteStudentById", sid));
   } catch (SQLException e) {
    e.printStackTrace();
   }
}

public List<Student> queryAllStudent() {
   try {
    List<Student> stuData = sqlMapClient
      .queryForList("selectAllStudent");
    System.out.println(stuData.size());
   } catch (SQLException e) {
    e.printStackTrace();
   }
   return null;
}

public Student queryStudentById(int id) {
   try {
    Student stu = (Student) sqlMapClient.queryForObject(
      "selectStudentById", id);
    if (null != stu)
     System.out.println(stu.getMajor());
   } catch (SQLException e) {
    e.printStackTrace();
   }
   return null;
}

public void updateStudent(Student student) {
   try {
    System.out.println(sqlMapClient.update("updateStudent", student));
   } catch (SQLException e) {
    e.printStackTrace();
   }
}

public void queryLikeStu() {
   Student st = new Student();
   st.setMajor("软件开发");
   try {
    sqlMapClient.queryForList("blurStudent", st);
   } catch (SQLException e) {
    e.printStackTrace();
   }
}
//分页查询
public void queryPageStu() {
   try {
    sqlMapClient.queryForList("selectAllStudent", null, 3, 5);
   } catch (Exception e) {
   }
}

public static void main(String args[]) {
   StudentDAO sdao = new IStudentDaoImp();
   IStudentDaoImp sdi = new IStudentDaoImp();
   sdi.queryPageStu();
   //sdi.queryLikeStu();
   // sdi.queryOrder();
   // sdi.queryByDanmic();
   // sdao.queryAllStudent();
   // sdao.queryStudentById(1);

   /*
   * Student st = new Student(); st.setSid(1219); st.setBirth(new Date(new
   * java.util.Date().getTime())); st.setMajor("软件开发ab"); st.setScore(56);
   * st.setSname("tempuslibin"); sdao.addStudent(st);
   */

   // sdao.deleteStduent(10);
   /*
   * Student st = new Student(); st.setSid(1029); st.setBirth(new Date(new
   * java.util.Date().getTime())); st.setMajor("体验生活"); st.setScore(560);
   * st.setSname("libins"); sdao.updateStudent(st);
   */
   // sdao.queryStudentByName("l");
   /*
   * Student stu = new Student(); stu.setSname("软件开发");
   * stu.setMajor("软件开发"); stu.setScore(56); sdao.queryDynamic(stu);
   */

   /*
   * Student st = new Student(); st.setSid(12191); st.setBirth(new
   * Date(new java.util.Date().getTime())); st.setMajor("软件开发ab");
   * st.setScore(56); st.setSname("tempuslibin");
   * sdao.addStudentBystat(st);
   */
   // sdao.getAllCount();
   /*
   * Student st = new Student(); st.setBirth(new Date(new
   * java.util.Date().getTime())); st.setMajor("软件开发ab"); st.setScore(56);
   * st.setSname("tempuslibin"); sdao.addStudentBySeuque(st);
   */

}

public void queryOrder() {
   Student st = new Student();
   st.setSortvalue(" desc");
   try {
    this.sqlMapClient.queryForList("getOrderStu", st);
   } catch (SQLException e) {
    e.printStackTrace();
   }
}

public void queryByDanmic() {
   Student st = new Student();
   st.setMajor("软件开发ab");
   // st.setScore(56);
   st.setSname("tempuslibin");
   st.setSid(1129);

   try {
    this.sqlMapClient.flushDataCache();
    this.sqlMapClient.queryForList("DynamicStudent", st);
   } catch (SQLException e) {
    e.printStackTrace();
   }
}

public void queryByGreat() {
   Student st = new Student();
   st.setSid(1029);
   try {
    sqlMapClient.queryForList("selectByGreate", st);
   } catch (SQLException e) {
    e.printStackTrace();
   }
}

public List<Student> queryDynamic(Student student) {
   try {
    List<Student> data = sqlMapClient.queryForList("selectByDynamic",
      student);
    print(data);
   } catch (SQLException e) {
    e.printStackTrace();
   }
   return null;
}

public void print(List<Student> data) {
   int size = data.size();
   Student stu = null;
   for (int i = 0; i < size; i++) {
    stu = data.get(i);
    System.out.println(stu.getSid() + " " + stu.getSname() + " "
      + stu.getScore() + " " + stu.getBirth());
   }
}

public void print(Object o) {
   // System.out.
}

public void addStudentBystat(Student student) {
   try {
    sqlMapClient.insert("insertStateStu", student);
   } catch (SQLException e) {
    e.printStackTrace();
   }
}

public int getAllCount() {
   try {
    int count = (Integer) sqlMapClient
      .queryForObject("selectStudentCount");
   } catch (SQLException e) {
    e.printStackTrace();
   }
   return 0;
}
}
大家可以进行下学习，确实iBATIS是个不错的关于dao层的操作，值得我们去研究，我想大家通过今天的研究对单个表的操作已近非常熟悉了吧。

如果以后有时间我会写下关于多个表的操作，谢谢大家的关注，如有什么疑问和需要帮助之处，请留言。谢谢