2016-09-22 14:45

@Override
public Page BaseDrugInfo_ch(int page, int size, String key) {
String select_sql = "select * ",from_sql = "";
if(StrKit.isBlank(key)){
from_sql = "from sys_drug_list_ch order by create_time desc";
}else{
from_sql = "from sys_drug_list_ch where (DRUG_NAME like '%"+key+"%' or DRUG_COMMON_NAME like '%"+key+"%') order by create_time desc";
}
Page list = find(page, size, select_sql, from_sql);
return list;
}

2016-09-22 14:43

我刚刚发现一个问题,我的数据大概有10000条,每页十条数据；在分页的时候使用了order by create_time desc ;然后取出的数据前两页还是正常的,后面的数据就和前面的数据是一样的;;;不知道这是不是一个bug?