package com.parddu.crm.pers;

import java.io.Serializable;
import java.util.List;

import com.parddu.crm.util.Page;

public interface IcommonDAO {

	/**
	 * 添加一行紀(jì)錄
	 * @param obj
	 * @return
	 * @throws Exception
	 */
	public boolean insert(Object obj) throws Exception; 
	
	/**
	 * 修改一行紀(jì)錄 根據(jù)主鍵
	 * @param obj
	 * @return
	 * @throws Exception
	 */
	public boolean update(Object obj) throws Exception;
	
	/**
	 * 刪除指定紀(jì)錄
	 * @param obj
	 * @return
	 * @throws Exception
	 */
	public boolean delete(Object obj) throws Exception;
	
	/**
	 * 根據(jù)主鍵查詢(xún)指定類(lèi)型的對(duì)象
	 * @param cla
	 * @param id
	 * @return
	 * @throws Exception
	 */
	public boolean deleteById(Class cla,Serializable id) throws Exception;
	
	/**
	 * 根據(jù)主鍵查詢(xún)指定類(lèi)型的對(duì)象
	 * @param cla
	 * @param id
	 * @return
	 * @throws Exception
	 */
	public Object queryById(Class cla,Serializable id) throws Exception;

	public List queryHQL(String hql,List param) throws Exception;
	
	public List querySQL(String sql,List param) throws Exception;

	public int updateHQL(String ql,List param) throws Exception;
	
	public int updateSQL(String ql,List param) throws Exception;

	public List queryPageHQL(String hql,List param,Page p) throws Exception;
	
	public List queryPageSQL(String sql,List param,Page p) throws Exception;
	
	/**
	 * 根據(jù)屬性查詢(xún)數(shù)據(jù)
	 * @param cla
	 * @param property
	 * @param value
	 * @return
	 * @throws Exception
	 */
	public List queryByProperty(Class cla,String property,Object value) throws Exception;
	
	
}