ibatis 对数据进行增删改查处理

假设数据库表为user，数据有id，name ,createTime

/**User.java*/
import java.io.Serializable;
import java.util.Date;

public class User implements Serializable{
    /**id*/
	private Integer id;
    
    /**昵称*/
	private String name;
    
    /**开始时间*/
	private Date ceateTime;
    
     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 Date getCreateTime() {
		return createTime;
	}
	public void setCreateTime(Date createTime) {
		this.createTime = createTime;
	}
}

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="PlayerGameData" type="com.linyun.base.domain.User" />
    
    <!-- 增 -->
    <insert id="insert" parameterClass="PlayerGameData">
        INSERT INTO user(ID,Name) VALUES(#id#,#name#,)
	</insert>

    <!-- 删除 -->
    <delete id="delete" parameterClass="String">
		DELETE FROM user WHERE ID=#id#
	</delete>

    <!-- 修改-->
    <update id="update" parameterClass="java.util.Map">
		UPDATE user  SET Name=#name# WHERE ID=#id#
	</update>

    <!-- 查询 分页-->
    <select id="getUserBypage" resultClass="User">
		SELECT ID AS id, Name AS name,create_Time AS createTime FROM user
		<dynamic prepend="WHERE">
			<isNotNull property="startTime" prepend="AND">
				<![CDATA[ create_Time >= #startTime# ]]>
			</isNotNull>
			<isNotNull property="endTime"  prepend="AND">
				<![CDATA[ create_Time <= #endTime# ]]>
			</isNotNull>
		</dynamic>
		ORDER BY ID ASC LIMIT #start#,#onePageNum#
	</select>

    /**查数量*/
    <select id="getcount" resultClass="Integer"  parameterClass="java.util.Map">
		SELECT COUNT(ID) FROM USER
	</select>

</sqlMap>

UserDao.java

import java.util.Date;
import java.util.List;

import User;
import IUserDAO;

public class UserDAO extends SqlMapClientDaoSupport implements IUserDAO {
    /**增*/
    public Integer create(User user) {
		Object obj = this.getSqlMapClientTemplate().insert("User.insert", user);
		if(obj==null)
			return Integer.valueOf(0);
		return (Integer)obj;
	}

    /**删除*/
    public Integer delete(String id) {
		return this.getSqlMapClientTemplate().delete("User.delete", id);
	}

    /**修改*/
    public Integer update(String id,Integer name){
		Map<String,Object> params = new HashMap<String,Object>();
		params.put("id", id);
		params.put("name", name);
		return this.getSqlMapClientTemplate().update("User.update", params);
	}

    /**查询*/
    public List<User> getUserBypage(Date startTime, Date endTime, Integer start, Integer onePageNum){
		Map<String, Object> params = new HashMap<String, Object>();
		params.put("startTime", startTime);
		params.put("endTime", endTime);
		params.put("start", start);
		params.put("onePageNum", onePageNum);
		return this.getSqlMapClientTemplate().queryForList("User.getUserBypage",params);
	}

    /**查数量 */
    public Integer getcount(){
        return  (Integer)this.getSqlMapClientTemplate().queryForObject("User.getcount");
    }
}

IUserDAO.java ,new的时候选择interface

import java.util.Date;
import java.util.List;

import User;

public interface IUserDAO{
    /**增*/
    public Integer create(User user);

    /**删除*/
    public Integer delete(String id);

    /**修改*/
    public Integer update(String id,Integer name);

    /**查询*/
    public List<User> getUserBypage(Date startTime, Date endTime, Integer start, Integer onePageNum);

    /**查数量 */
    public Integer getcount();
} 

最后，别忘记配置

/**xml配置---sqlMapConfig.xml*/

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


/**dao配置---在dao.xml里添加*/

<bean id="userDAO" class="com.impl.UserDAO"
    scope="prototype">
	<property name="sqlMapClient" ref="sqlMapClient" />
</bean>

/**若要在UserService中调用则还需在 service.xml配置*/
<bean id="userService" class="com.service.impl.UserService">
	<property name="userDAO" ref="userDAO" />
</bean>

UserService.java

import java.util.Date;
import java.util.List;

public class UserService implements IUserService {
    private IUserDAO userDAO;
    
    /**增*/
    public synchronized Integer create(long id,String name)
	{
		try {
			//增加记录
			User user = new User();
			user.setId(id);
			user.setName(name);
			user.setCreateTime(new Date());
			userDAO.create(user);
			return 0;
		} catch (Exception e) {
			e.printStackTrace();
			return -5;
		}
	}

     /**查询*/
    public List<User> getUserBypage(Date startTime, Date endTime, Integer start, Integer onePageNum){
        return userDAO.getUserBypage(startTime,endTime,start,onePageNum);
    }
    
    public IUserDAO getUserDAO() {
		return userDAO;
	}

	public void setUserDAO(IUserDAO userDAO) {
		this.userDAO = userDAO;
	}   

}

IUserService.java

import java.util.Date;
import java.util.List;

public interface IUserService {
    /**创建数据*/
	public void create(User user);
    
    /**查询*/
    public List<User> getUserBypage(Date startTime, Date endTime, Integer start, Integer onePageNum);
}