//查询上海南站973公交的所有站点,可以这样做
public List linestation(int lineid) {
List temp = new ArrayList();
List str = dao
.find((new StringBuilder(
"select s.stationname,d.dsid,d.lineid,d.stationid,d.orderid,d.type,d.priceinc from Station s,Distance d where s.stationid = d.stationid and lineid="))
.append(lineid).append(" order by d.orderid asc")
.toString());
Distance dis;
for (Iterator it = str.iterator(); it.hasNext(); temp.add(dis)) {
Object obj[] = (Object[]) it.next();
dis = new Distance();
dis.setDsid((Integer) obj[1]);
dis.setLineid((Integer) obj[2]);
dis.setOrderid((Integer) obj[4]);
dis.setPriceinc(((Double) obj[6]).doubleValue());
dis.setStationid((Integer) obj[3]);
dis.setStationname((String) obj[0]);
dis.setType((Integer) obj[5]);
}
if (temp == null)
temp = new ArrayList();
return temp;
}
//用到了多表链接,对象封装,集合,很好的设置方法