IBaseDao的设计

去网上查了下，发现泛型Dao的设计比较热门，比较起来也相对通用。

只是因为还没有用上hibernate，所以做了些修改，不提供BaseDao的默认实现(如果是hibnerate下，很多实现可以在一个抽象类里面实现)。

2009-09-09 更新 : 修改了几个方法的返回类型， 添加了一个查询方法。开始感到这个框架的问题， 用了好几个Object 类型的参数了。思考下后面应该怎么改。

package shopping.ibm.dao;

import java.sql.Connection;
import java.util.ArrayList;
import java.util.List;

/**
 * Provide basic dao operations.
 * 
 * @author yaoh
 *
 * @param <T, I>
 */
public interface IBaseDao<T, I> {

	/**
	 * Get database connection.
	 * 
	 * @return available database cnnection.
	 */
	public Connection getConnection(); 

	/**
	 * Release database connection.
	 * 
	 */
	public void releaseConnection(Connection conn);

	/**
	 * Get data count based on sql.
	 * 
	 * @param sql
	 * @return total count.
	 */
    public int getTotalCount();

    /**
     * Create an object.
     * @param t
     * @return positive id if create successfully.
     */
	public long create(T t);

	/**
	 * Update an object.
	 * @param t
	 * @return positive id if create successfully.
	 */
	public int update(T t);

	/**
	 * Delete an object.
	 * @param t
	 * @return delete successfully.
	 */
	public boolean delete(T t);

	/**
	 * Delete by id.
	 * @param id
	 * @return delete successfully.
	 */
	public boolean deleteById(I id);

	/**
	 * batch delete by id.
	 * @param id
	 * @return result of each delete.
	 */
	public void batchDeleteById(I[] ids); 

	/**
	 * batch delete by object.
	 * @param ts
	 * @return result of each delete.
	 */
	public void batchDelete(T[] ts);


	/**
	 * find T by id.
	 * @param id
	 * @return query result.
	 */
	public T findById(I id);

	/**
	 * find by primary key.(name....)
	 * @param keyName
	 * @param keyValue
	 * @return
	 */
	public T findByPk(String keyName, Object keyValue); 

	/**
	 * find by key.
	 * @param keyNames
	 * @param keyValues
	 * @return
	 */
	public List<T> findByKey(String[] keyNames, Object[] keyValues);

	/**
	 * find by sql.
	 * @param strsql
	 * @return
	 */
	public List<T> findBySql(String sql);

	/**
	 * Excute sql directly.
	 * @param strsql
	 * @return is sql successfully.
	 */
	public boolean excuteSql(String sql);

	/**
	 * Update user with id set keyNames = keyValues
	 * @param id
	 * @param keyNames
	 * @param keyValues
	 * @return if update successfully.
	 */
	public int update(long id, ArrayList<String> keyNames, ArrayList<Object> keyValues);
}