Ibatis

package com.nasoft.bean;
/**
* User 实体类
* @author Administrator
*
*/
public class User {

/**
* 用户编号
*/
private int userid;

/**
* 用户名字
*/
private String userName ;

/**
* 用户年龄
*/
private int age ;

/**
* 用户地址
*/
private String address;

/**
* 用户生日
*/
private String birthday ;

public int getUserid() {
return userid;
}

public void setUserid(int userid) {
this.userid = userid;
}

public String getUserName() {
return userName;
}

public void setUserName(String userName) {
this.userName = userName;
}

public int getAge() {
return age;
}

public void setAge(int age) {
this.age = age;
}

public String getAddress() {
return address;
}

public void setAddress(String address) {
this.address = address;
}

public String getBirthday() {
return birthday;
}

public void setBirthday(String birthday) {
this.birthday = birthday;
}



}

--------------------------------------------------------



package com.nasoft.dao;

import java.util.List;

import com.nasoft.bean.User;
/**
* UserDAO 接口
* @author Administrator
*
*/
public interface UserDAO {

/**
* 增加用户
* @param user
*/
public void addUser(User user);

/**
* 删除用户
* @param user
*/
public void deleteUser(User user);

/**
* 更新用户
* @param user
*/
public void updateUser(User user);

/**
* 根据ID 查找用户
* @param user
*/
public void findUserByID(User user);

/**
* 查询所有的用户
*/
public List<User> findAllUser();

/**
* 根据条件查询用户
* @param user
*/
public List<User> findUserByWhere(User user);
}

--------------------------------------------------------------

package com.nasoft.tools;

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;

/**
* 通过单例模式构造一个SqlMapClient工具
* @author Administrator
*
*/
public class IbatisTool {
private static  SqlMapClient client ;

/**
* 配置文件的路径
*/
private static String sqlMapPath = "sql-map-config.xml";

private IbatisTool(){

}

public synchronized static SqlMapClient getSqlMapClient(){
Reader reader = null;
try {
reader = Resources.getResourceAsReader(sqlMapPath);
} catch (IOException e) {
e.printStackTrace();
}
client = SqlMapClientBuilder.buildSqlMapClient (reader);
return client;
}

    
}

----------------------------------------------------------


package com.nasoft.test;

import static java.lang.System.out;
import java.io.Reader;
import java.util.List;

import org.junit.BeforeClass;
import org.junit.Test;

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

public class TestIbatis {

private final String  NameSpace = "com.nasoft.dao.impl.UserDAO";

private static  SqlMapClient client ;
@BeforeClass
public static void setUpBeforeClass() throws Exception {
Reader reader = Resources.getResourceAsReader("sql-map-config.xml");
client = SqlMapClientBuilder.buildSqlMapClient (reader);
    
}

@SuppressWarnings("unchecked")
@Test
public void testfindUser() throws Exception{
  
List<User>  list= client.queryForList(NameSpace + ".finduserByID");

for (User user : list) {
//静态类导入
out.println(user);
System.err.print(user.getAddress());

}

}

@Test
public void testUpdateUser() throws Exception{
client.startTransaction();
User user = new User();
user.setUserid(2);
user.setUserName("Hello!World2");
user.setAge(22);
user.setBirthday("1988-12-12");
user.setAddress("beijing - haidian");
client.insert(NameSpace + ".updateUser",user);
client.commitTransaction();
client.endTransaction();

}

@Test
public void testInsertUser() throws Exception{
client.startTransaction();
User user = new User();
user.setUserid(1234);
user.setUserName("Hello!World");
user.setAge(12);
user.setBirthday("1988-12-12");
user.setAddress("beijing - haidian");
client.insert(NameSpace + ".adduser",user);
client.commitTransaction();
client.endTransaction();

}

@Test
public void deleteUser() throws Exception{
client.startTransaction();
User user = new User();
user.setUserid(1234);
client.insert(NameSpace + ".deleteUser",user);
client.commitTransaction();
client.endTransaction();

}
}


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

<typeAlias alias="user" type="com.nasoft.bean.User"/>

<resultMap class="user" id="user">
<result property="userid" column="userid"/>
<result property="userName" column="userName"/>
<result property="age" column="age"/>
<result property="address" column="address"/>
<result property="birthday" column="birthday"/>
</resultMap>
 
   
    <update id="updateUser" parameterClass ="user">
     insert into ibatis_test
     values(#userid# ,#userName# ,#age# ,#address# ,#birthday#)
  </update>
 
  <update id="deleteUser" parameterClass ="user">
     delete from  ibatis_test where userid =#userid#
  </update>
 
  <update id="updateUser" parameterClass ="user">
     update  ibatis_test set userName = #userName# where userid =#userid#
  </update>
 
 
  <select id="finduserByID" resultMap="user">
    select userid ,userName ,age ,address ,birthday
    from ibatis_test
    where userid=#userid#
  </select>
 
  <select id="findAllusers" resultMap="user">
    select userid ,userName ,age ,address ,birthday
    from ibatis_test
  </select>
 
  <insert id="adduser" parameterClass ="user">
  insert into ibatis_test
  values(#userid# ,#userName# ,#age# ,#address# ,#birthday#)
  </insert>
 
  <delete id="deleteuser1">
  delete from  ibatis_test where userid =#userid#
  </delete>
 
</sqlMap>