List<Record> list = Db.find("SELECT\n" +
" a.equipment_name,\n" +
" b.ename,\n" +
" a.enclosure\n" +
"FROM\n" +
" pub_db2.equipment_unseal a,\n" +
" pub_db1.she_bei_info b\n" +
//"WHERE CONVERT(a.equipment_name USING utf8) =CONVERT( b.ename USING utf8)");
" limit " + start + ", " + end);
public void listData() {
/*Object[] queryParams = getQueryParams();
System.out.println("SQL查询queryParams"+queryParams);
String[] properties = (String[]) queryParams[0];
System.out.println("SQL查询properties"+properties);
String[] symbols = (String[]) queryParams[1];
System.out.println("SQL查询symbols"+symbols);
Object[] values = (Object[]) queryParams[2];
System.out.println("SQL查询values"+values);
String orderBy = getOrderBy();
if(StringUtil.isEmpty(orderBy)) {
orderBy = "id desc";
}
List<Record> list = DBTool.findByMultPropertiesDbSource(TspaceConst.dbsource2, "equipment_unseal", properties, symbols, values, orderBy, getPager());
*/
//方法一 有效
int start = getPager().getStartRow();
int end = getPager().getRows();
System.out.println("查询后的结果分页start"+start);
System.out.println("查询后的结果分页end"+start);
List<Record> list = Db.find("SELECT\n" +
" a.*,\n" +
" b.*\n" +
"FROM\n" +
" pub_db2.equipment_unseal a,\n" +
" pub_db1.she_bei_info b \n" +
" where 1= 1 LIMIT "+start+","+end);
//方法二 测试中
//List<Record> list2 = Db.use(configname).find("select A.a,B.b from A left join (select a,b from B) B on A.a = B.a")
System.out.println("查询后的结果"+list);
renderDatagrid(
list,
//DBTool.countByMultPropertiesDbSource(TspaceConst.dbsource2, "equipment_unseal", properties, symbols, values)
Db.queryLong("SELECT\n" +
" COUNT(*)\n" +
"FROM\n" +
" pub_db2.equipment_unseal a,\n" +
" pub_db1.she_bei_info b where 1=1").intValue()
);
}