-------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.