一个使用ibatis对数据库增删改查的例子

一个使用ibatis对数据库增删改查的例子:
这里用的开发环境是:Eclipse3.2+mysql5.0.20,ibatis包是ibatis-common-2.jar,
ibatis-dao-2.jar,ibatis-sqlmap-2.jar,mysql包是mysql-connector-java-5.0.3-bin.jar.
步骤:
1.创建数据库:
create database itcast;
use itcast;
创建表：
create table student
(
   id int primary key auto_increment,
   firstname varchar(20) not null,
   lastname varchar(20) not null
)

2.创建POJO类,Student.java，此程序中用到的所有类都放在cn.itcast包下面，
其他的配置文件都放在txd.configfile包下面。
package cn.itcast;

public class Student {
   private Integer id;

   private String firstname;

   private String lastname;

   public String getFirstname() {
    return firstname;
   }

   public void setFirstname(String firstname) {
    this.firstname = firstname;
   }

   public Integer getId() {
    return id;
   }

   public void setId(Integer id) {
    this.id = id;
   }

   public String getLastname() {
    return lastname;
   }

   public void setLastname(String lastname) {
    this.lastname = lastname;
   }
}

3.跟Student类对应的xml配置文件Student.xml,



  
  
    insert into student(firstname,lastname) values
    (#firstname#,#lastname#)
  

  
    select id, firstname, lastname from student
  

  
    delete from student where id=#value#
  

  
    update student set firstname=#firstname#,lastname=#lastname#
    where id=#id#
  

4.jdbc.properties文件,存储数据库连接的driver,url,username,password等信息,
driver=com.mysql.jdbc.Driver
url=jdbc:mysql:///itcast
username=root
password=

5. SqlMap的配置文件SqlMapConfigExample.xml,

PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">


  
  
  
       lazyLoadingEnabled="true" maxRequests="32" maxSessions="10"
    maxTransactions="5" useStatementNamespaces="false" />

  
  
   
   
    
    
    
    
   
  
  
  

6.MySqlMapClient.java类,用于产生一个SqlMapClient
package cn.itcast;

import java.io.IOException;
import java.io.Reader;

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

public class MySqlMapClient {

   private static SqlMapClient sqlMapClient;

   static {
    String resource = "txd/configfile/SqlMapConfigExample.xml";
    Reader reader = null;
    try {
     reader = Resources.getResourceAsReader(resource);
     sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
    } catch (IOException e) {
     e.printStackTrace();
    }
   }

   public static SqlMapClient getSqlMapInstance() {
    return sqlMapClient;
   }

}

7.StudentManager 类测试一下上面的代码,
package cn.itcast;

import java.sql.SQLException;
import java.util.List;

import com.ibatis.sqlmap.client.SqlMapClient;

public class StudentManager {

   public static void main(String[] args) {
    SqlMapClient sqlMap = MySqlMapClient.getSqlMapInstance();

    // insert一条记录

    // Student student = new Student();
    // student.setFirstname("zhang");
    // student.setLastname("san");
    // try {
    // sqlMap.insert("insert_student", student);
    // System.out.println("插入成功!");
    // } catch (SQLException e) {
    // e.printStackTrace();
    // }

    // delete一条记录

    // try {
    // int result = sqlMap.delete("delStudent", 5);
    // System.out.println(result);
    // } catch (SQLException e) {
    // e.printStackTrace();
    // }

    // update一条已存在的记录

    Student student = new Student();
    student.setId(1);
    student.setFirstname("jiang");
    student.setLastname("zemin");
    try {
     int result = sqlMap.update("updateStudent", student);
     System.out.println(result);
    } catch (SQLException e) {
     e.printStackTrace();
    }

    // query获得多条记录

    // try {
    // List list = sqlMap.queryForList("getStudent", null);
    // for (Student student : list) {
    // System.out
    // .println(student.getId() + "\t"
    // + student.getFirstname() + "\t"
    // + student.getLastname());
    // }
    // } catch (SQLException e) {
    // e.printStackTrace();
    // }

    // query单条记录

    // try {
    // Student student = (Student) sqlMap.queryForObject("getStudent", 1);
    // System.out.println(student.getId());
    // System.out.println(student.getFirstname());
    // System.out.println(student.getLastname());
    // } catch (SQLException e) {
    // e.printStackTrace();
    // }
   }

}