for(NewMapTabe:list1){//查询上游监测点的经纬度Stringsql2="selectLON,LATfromjnc_baiduwhereID='"+e.getID()+"'";pstmt2=conn.prepareStatement(sql2);rs2=pstmt2.executeQuery();...
for(NewMapTab e:list1){
//查询上游监测点的经纬度
String sql2 = "select LON,LAT from jnc_baidu where ID = '"+e.getID()+"'";
pstmt2 = conn.prepareStatement(sql2);
rs2 = pstmt2.executeQuery();
while(rs2.next()){
NewMapTab p = new NewMapTab();
p.setLAT(rs2.getFloat(1));
p.setLON(rs2.getFloat(2));
pointlist1.add(p);
}
}
for(NewMapTab e:list2){ //查询下游监测点的经纬度
String sql3 = "select LON,LAT from jnc_baidu where ID = '"+e.getID()+"'";
pstmt3 = conn.prepareStatement(sql3);
rs3 = pstmt3.executeQuery();
while(rs3.next()){
NewMapTab po = new NewMapTab();
po.setXlAT(rs3.getFloat(1));
po.setXLON(rs3.getFloat(2));
pointlist2.add(po);}
}
我需要返回pointlist1和pointlist2,该怎么办
展开