icommondao.java

来自「权限组件的java代码写法例子下载」· Java 代码 · 共 76 行

package com.parddu.crm.pers;

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

import com.parddu.crm.util.Page;

public interface IcommonDAO {

	/**
	 * 添加一行纪录
	 * @param obj
	 * @return
	 * @throws Exception
	 */
	public boolean insert(Object obj) throws Exception; 
	
	/**
	 * 修改一行纪录 根据主键
	 * @param obj
	 * @return
	 * @throws Exception
	 */
	public boolean update(Object obj) throws Exception;
	
	/**
	 * 删除指定纪录
	 * @param obj
	 * @return
	 * @throws Exception
	 */
	public boolean delete(Object obj) throws Exception;
	
	/**
	 * 根据主键查询指定类型的对象
	 * @param cla
	 * @param id
	 * @return
	 * @throws Exception
	 */
	public boolean deleteById(Class cla,Serializable id) throws Exception;
	
	/**
	 * 根据主键查询指定类型的对象
	 * @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;
	
	/**
	 * 根据属性查询数据
	 * @param cla
	 * @param property
	 * @param value
	 * @return
	 * @throws Exception
	 */
	public List queryByProperty(Class cla,String property,Object value) throws Exception;
	
	
}