membersqlmapdao.java

>项目名称:电脑电子商务平台 >1.运行环境JDK1.6+Oracle10g+Tomcat5.5 >2.开发工具: MyEclipse Enterprise Workbench

package omega.persistence.sqlmapdao;

import java.util.List;

import com.ibatis.sqlmap.client.SqlMapClient;

import omega.domain.Member;
import omega.domain.Orders;
import omega.persistence.iface.MemberDao;

public class MemberSqlMapDao implements MemberDao {

	private static SqlMapClient sqlMapper = DaoConfig.getsqlMapper();

	public List selectAllMember() throws Exception {

		return sqlMapper.queryForList("selectAllMember");
	}

	public void deleteMemberByName(String name) throws Exception {
		sqlMapper.delete("deleteMemberByName", name);
	}

	public void deleteMemberById(int id) throws Exception {
		sqlMapper.delete("deleteMemberById", id);
	}

	public List selectMaxId() throws Exception {
		return (List) sqlMapper.queryForList("selectUserMaxId");
	}

	public void insert(Member member) throws Exception {
		sqlMapper.insert("insertAll", member);
	}

	public List selectMemberByName(String name) throws Exception {
		return (List) sqlMapper.queryForList("selectMemberByName", name);
	}

	public void updateById(Member member) throws Exception {
		sqlMapper.update("updateMember", member);
	}

	public Member getMaxId() throws Exception {
		return (Member) sqlMapper.queryForObject("getMemberMaxId");
	}

	public int getCount() throws Exception {
		return (Integer) sqlMapper.queryForObject("getMemberCount");
	}
}