package com.flight.dao;import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import com.flight.bean.flight;public class searchflightDao {
public ArrayList<flight>  findById(String start_city,String arrival_city){
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
ArrayList<flight> fb= new ArrayList<flight>();


try {
conn = DBManager.getConnection();
String sql = "select * from flights where start_city = ? and arrival_city = ?";
stmt =conn.prepareStatement(sql);
stmt.setString(1, start_city);
stmt.setString(2, arrival_city);
rs = stmt.executeQuery();//此处一定不要传入sql
if(rs.next()){
flight fa=new flight();
fa = new flight();//创建对象
fa.setId(rs.getInt("id"));
fa.setFlight_id(rs.getString("flight_id"));
fa.setStart_city(rs.getString("start_city"));
fa.setArrival_city(rs.getString("arrival_city"));
fa.setStart_time(rs.getString("start_time"));
fa.setArrival_time(rs.getString("arrival_time"));
fa.setKtype(rs.getString("ktype"));
fa.setAlltime(rs.getString("alltime"));
fa.setEconomy_price(rs.getString("economy_price"));
fa.setBusiness_price(rs.getString("business_price"));
fa.setFirstclass_price(rs.getString("firstclass_price"));
fa.setEconomy_seataccount(rs.getString("economy_seataccount"));
fa.setBusiness_seataccount(rs.getString("business_seataccount"));
fa.setFirstclass_seataccount(rs.getString("firstclass_seataccount"));
fa.setDatetime(rs.getString("datetime"));
fb.add(fa);

}
}

catch (SQLException e) {
e.printStackTrace();
} finally{
DBManager.close(rs, stmt, conn);//7. 关闭数据库连接
}
//System.out.println(fb);
return fb;//返回
}

}
我在底部用输出语句做了下测试,就能查到一条结果!!