BaseDao抽取
对dao层的通用方法进行抽取。
先介绍一个接口:Type
| -- ParameterizedType 实现的子接口
| -- Class 实现的类
public interface ParameterizedType extends Type
public final class Class<T> extends Objectimplements Serializable, GenericDeclaration, Type, AnnotatedElement
getActualTypeArguments()
:返回表示此类型实际类型参数的 Type 对象的数组。
BaseDao:
public interface BaseDao<T> {
public List<T> findAll();
public T findById(String id);
}
BaseDaoImpl:
public class BaseDaoImpl<T> implements BaseDao<T>{
Class clazz = null;
String tableName = null;
//需要获取T
public BaseDaoImpl(){
Type superclass = this.getClass().getGenericSuperclass();
ParameterizedType type = (ParameterizedType) superclass;
Type[] arguments = type.getActualTypeArguments();
Type t = arguments[0];
clazz = (Class)t;
tableName = clazz.getSimpleName().toLowerCase();
//System.out.println(tableName);
}
public List<T> findAll() {
QueryRunner qr = new QueryRunner(JdbcUtil.getDataSource());
List<T> list = null;
try {
list = (List<T>)qr.query("select * from "+tableName, new BeanListHandler(clazz));
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
public T findById(String id) {
QueryRunner qr = new QueryRunner(JdbcUtil.getDataSource());
T t = null;
try {
t = (T)qr.query("select * from "+tableName+" where id=?", new BeanHandler(clazz), new Object[]{id});
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return t;
}
}