//JUNIT测试类@Testpublicvoidtesticmaxnum(){IcMaxNumDAOnumdao=newIcMaxNumImpl();IcMaxNumnum=newIcMaxNum();num.setFTableName("'poorder'");//出错的在这里,返回值为NULLSystem...
//JUNIT测试类
@Test
public void testicmaxnum(){
IcMaxNumDAO numdao = new IcMaxNumImpl();
IcMaxNum num = new IcMaxNum();
num.setFTableName("'poorder'");
//出错的在这里,返回值为NULL
System.out.println(numdao.geticmaxnum(num.getFTableName()));
}
//实现类
public class IcMaxNumImpl extends DAO implements IcMaxNumDAO{
@Override
public IcMaxNum geticmaxnum(String fTableName) {
String sql="select fmaxnum from icmaxnum "
+ "where ftablename = ?";
return get(sql, fTableName);
}
}
//业务DAO
public interface IcMaxNumDAO {
public IcMaxNum geticmaxnum(String fTableName);
}
//实体类
public class IcMaxNum {
//无参构造方法
public IcMaxNum() {
}
public void setFTableName(String fTableName) {
this.fTableName = fTableName;
}
public String getFTableName() {
return fTableName;
}
public void setFMaxNum(int fMaxNum) {
this.fMaxNum = fMaxNum;
}
public int getFMaxNum() {
return fMaxNum;
}
private String fTableName;
private int fMaxNum;
public IcMaxNum(String fTableName, int fMaxNum) {
super();
this.fTableName = fTableName;
this.fMaxNum = fMaxNum;
}
@Override
public String toString() {
return "IcMaxNum [fTableName=" + fTableName + ", fMaxNum=" + fMaxNum
+ "]";
}
}
//DAO
public class DAO {
private QueryRunner queryRunner=new QueryRunner(true);
private Class clazz;
public DAO() {
Type supperClass= getClass().getGenericSuperclass();
if(supperClass instanceof ParameterizedType){
ParameterizedType parameterizedType=(ParameterizedType)supperClass;
Type [] typeArgs= parameterizedType.getActualTypeArguments();
if(typeArgs!=null && typeArgs.length>0){
if(typeArgs[0] instanceof Class){
clazz=(Class) typeArgs[0];
}
}
}
}
@param sql
* @param args
* @return
*/
public T get(String sql,Object...args){
Connection connection=null;
try {
connection=JdbcUtils.getConnection();
return queryRunner.query(connection, sql, new BeanHandler<>(clazz), args);
} catch (Exception e) {
e.printStackTrace();
}finally{
JdbcUtils.releaseConnection(connection);
}
return null;
}
}
展开