///////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // 根据区段获得属于区段内的所有车站信息 并排序 public void getAllStationInfoByDistrict(String districtName) { StationDistrictRelation tableName = new StationDistrictRelation(); // 设置要进行操作的数据库表名 String sqlStr = "select * from stationdistrictrelation where District_name = '" + districtName + "'"; // 获取区段内所有车站信息 List<StationDistrictRelation> list = databaseAccessHandler.sqlQuery(tableName, "StationDistrictRelation", sqlStr); List<StationDistrictRelation> sortedStationDistrictRelationList = new ArrayList<StationDistrictRelation>(); // 对区段内所有车站信息进行排序 : 首站->终点站 sortedStationDistrictRelationList = this.sortStations(list); baseParam.setSortedStationDistrictRelationList(sortedStationDistrictRelationList); if (sortedStationDistrictRelationList == null || sortedStationDistrictRelationList.size() == 0) return; int len = sortedStationDistrictRelationList.size(); List<String> stationNameList = new ArrayList<String>(); // 计算区段内站的总距离 和提取车站名 int sumStationDistance = 0; for (int i = 0; i < len; i++) { StationDistrictRelation sdr = sortedStationDistrictRelationList.get(i); sumStationDistance = sumStationDistance + sdr.getPredistance(); stationNameList.add(sdr.getStation_name()); // 提取车站名 } BaseParam.setSortedStationNameList(stationNameList); baseParam.setSumStationDistance(sumStationDistance); }