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

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

import java.io.Serializable;
import java.util.Date;

public class User implements Serializable{
    
	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

    
    
    
    
        INSERT INTO user(ID,Name) VALUES(#id#,#name#,)
	

    
    
		DELETE FROM user WHERe ID=#id#
	

    
    
		UPDATE user  SET Name=#name# WHERe ID=#id#
	

    
    
		SELECT ID AS id, Name AS name,create_Time AS createTime FROM user
		
			
				= #startTime# ]]>
			
			
				
			
		
		ORDER BY ID ASC LIMIT #start#,#onePageNum#
	

    
    
		SELECT COUNT(ID) FROM USER
	

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 params = new HashMap();
		params.put("id", id);
		params.put("name", name);
		return this.getSqlMapClientTemplate().update("User.update", params);
	}

    
    public List getUserBypage(Date startTime, Date endTime, Integer start, Integer onePageNum){
		Map params = new HashMap();
		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 getUserBypage(Date startTime, Date endTime, Integer start, Integer onePageNum);

    
    public Integer getcount();
} 

最后，别忘记配置

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 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 getUserBypage(Date startTime, Date endTime, Integer start, Integer onePageNum);
}