super map where clause 中用in语句大量查询
QueryParam qp = new QueryParam();
String sql="UNIKEY in (";
sql=sql+“‘1’,‘2’,’3‘ ” ;
sql=sql+")";
qp.queryLayerParams = new QueryLayerParam[1];
qp.queryLayerParams[0] = new QueryLayerParam();
qp.queryLayerParams[0].name = objTolayer.get(name).toString();// 相应的图层
qp.queryLayerParams[0].sqlParam = new SqlParam();
qp.queryLayerParams[0].sqlParam.whereClause = sql;
try {
ResultSet rs = mapService.query(qp, tmi.getMapName()); // 传入查询语句和地图图层名称
if (rs.totalCount == 0) {
log.error("getNodeInfo时发生错误,没有相应实体");
} else {
return rs;
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
String sql="UNIKEY in (";
sql=sql+“‘1’,‘2’,’3‘ ” ;
sql=sql+")";
qp.queryLayerParams = new QueryLayerParam[1];
qp.queryLayerParams[0] = new QueryLayerParam();
qp.queryLayerParams[0].name = objTolayer.get(name).toString();// 相应的图层
qp.queryLayerParams[0].sqlParam = new SqlParam();
qp.queryLayerParams[0].sqlParam.whereClause = sql;
try {
ResultSet rs = mapService.query(qp, tmi.getMapName()); // 传入查询语句和地图图层名称
if (rs.totalCount == 0) {
log.error("getNodeInfo时发生错误,没有相应实体");
} else {
return rs;
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}