package com.easyjf.web.tools;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;
import com.easyjf.dbo.EasyJDB;
/**
*
* <p>Title: IDAO的EasyDBO實現</p>
* <p>Description:通過ORM系統中間件EasyDBO實現添刪改查等數據庫操作 </p>
* <p>Copyright: Copyright (c) 2006</p>
* <p>Company: EasyJF開源團隊</p>
* @author 大峽
* @version 0.1
*/
public class EasyDBODAO implements IDAO {
	private static final EasyDBODAO singleton = new EasyDBODAO();

	private EasyJDB db = EasyJDB.getInstance();

	public static EasyDBODAO getInstance() {
		return singleton;
	}

	public boolean save(Object obj){
		// TODO Auto-generated method stub
		return db.add(obj);
	}

	public boolean update(Object obj) {
		// TODO Auto-generated method stub
		return db.update(obj);
	}

	public boolean del(Object obj) {
		// TODO Auto-generated method stub
		return db.del(obj);
	}

	public Object get(Class clz, Serializable id) {
		// TODO Auto-generated method stub
		return db.get(clz, (Object) id);
	}

	public Object getBy(Class clz, String fieldName, Serializable value) {
		// TODO Auto-generated method stub
		Collection paras = new ArrayList();
		paras.add(value);
		return db.read(clz, fieldName + "=?", paras);
	}

	public List query(Class clz, String scope) {
		// TODO Auto-generated method stub
		return db.query(clz, scope);
	}

	public List query(Class clz, String scope, Collection paras) {
		// TODO Auto-generated method stub
		return db.query(clz, scope, paras);
	}

	public List query(Class clz, String scope, Collection paras, int begin,
			int max) {
		// TODO Auto-generated method stub
		return db.query(clz, scope, paras, begin, max);
	}

	public int execute(String sql, Collection paras) {
		// TODO Auto-generated method stub
		int ret=-1;
		try{
		 ret=db.execute(sql,paras);
		}
		catch(Exception e)
		{
			//這里添加錯誤處理代碼
			e.printStackTrace();
		}
		return ret;
	}
	
	public int execute(String sql) {
		return execute(sql,null);
	}

	public Object uniqueResult(String sql, Collection paras) {
		// TODO Auto-generated method stub
		return db.uniqueResult(sql,paras);
	}

	public Object uniqueResult(String sql) {
		// TODO Auto-generated method stub
		return db.uniqueResult(sql);
	}

}