adddaoimpl.java

struts+spring+ibatis實現的簡單CRUE

package com.zhang.dao;

import java.util.List;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import com.zhang.ibatis.User;

public class AddDAOImpl extends SqlMapClientDaoSupport implements AddDAO {

	public void insert(User user) {

		getSqlMapClientTemplate().insert("creatAccount", user);

	}

	public void delete(String id) {
		getSqlMapClientTemplate().delete("deleteAccountById", id);

	}

	public List query(User user) {
		if ("".equals(user.getUsername())) {
			return getSqlMapClientTemplate().queryForList(
					"getAccount", user);
		}
		return getSqlMapClientTemplate().queryForList("getAccountByUsername",
				user);
	}

	public User query(String id) {
		return (User) getSqlMapClientTemplate().queryForObject("getAccountById", id);
	}

	public void update(User user) {
		getSqlMapClientTemplate().update("updateAccount", user);
	}
}