关于DAO简单理解实现

-------DAO接口--------------------

import java.sql.Connection;

import java.sql.SQLException;
import java.util.List;


public interface DAO<T> { //Database Access Object


/**
* 获取总数
* @param conn
* @param sql
* @param args
* @return
*/
public Object getCount(Connection conn, String sql, Object ...args) throws SQLException;

/**
* 查询多个对象
* @param conn
* @param sql
* @param clazz
* @param args
* @return
*/
public List<T> getList(Connection conn, String sql, Object ...args) throws SQLException;

/**
* 查询单个对象
* @param conn
* @param sql
* @param clazz
* @param args
* @return
*/
public T get(Connection conn, String sql, Object ... args) throws SQLException; 

/**
* 通用的增删改
* @param conn
* @param sql
* @param args
* @return
*/
public int update(Connection conn, String sql, Object ... args) throws SQLException;

}

------------------------实现DAO接口,利用DButils类------------------------------------------------

import java.lang.reflect.ParameterizedType;
import java.lang.reflect.Type;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;


import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.commons.dbutils.handlers.ScalarHandler;


public class JdbcDAOImpl<T> implements DAO<T> {


private QueryRunner qr = new QueryRunner();


Class clazz = null;


public JdbcDAOImpl() {
/**// 1. 获取带泛型的父类类型
Type type = this.getClass().getGenericSuperclass();


// 2. 参数化类型
ParameterizedType pt = (ParameterizedType) type;


// 3. 获取真实的参数
Type[] types = pt.getActualTypeArguments();


clazz = (Class) types[0];


System.out.println(clazz);*/

clazz = ReflectionUtils.getSuperGenericType(getClass());
}


@Override
public Object getCount(Connection conn, String sql, Object... args)
throws SQLException {
return (long) qr.query(conn, sql, new ScalarHandler(), args);
}


@Override
public List<T> getList(Connection conn, String sql, Object... args)
throws SQLException {
return qr.query(conn, sql, new BeanListHandler<T>(clazz), args);
}


@Override
public T get(Connection conn, String sql, Object... args)
throws SQLException {
return qr.query(conn, sql, new BeanHandler<T>(clazz), args);
}


@Override
public int update(Connection conn, String sql, Object... args)
throws SQLException {
return qr.update(conn, sql, args);
}


}

----------------创建表对应的实例类继承 JdbcDAOImpl<T>-------------------

public class OrderDAO extends JdbcDAOImpl<Order>{


}

这样就很简单的实现DAO.