a0fac503a6fc001d1745a9bad977883d

来自「java做的机票查询系统、 仅供初学者参考！」· 代码 · 共 45 行

package Flight;
import java.util.*;

public class DAO {
	private java.sql.ResultSet rs = null;
	private java.sql.PreparedStatement ps = null;
	private java.sql.Connection con = null;

	public ArrayList select(String lcavccity,String destination,int econum) {
		DBUtil db=new DBUtil();
		Bean bean=null;
		ArrayList al=new ArrayList();
		int count=0;
		try{
			con=db.getConnection();
			String sql="select flightno from where lcavccity=? and destination=? and econum>0";
			ps=con.prepareStatement(sql);
			
			ps.setString(1, lcavccity);
			ps.setString(2, destination);
			ps.setInt(3, econum);
			
			rs=ps.executeQuery();
			while(rs.next()) {
				bean=new Bean();
				bean.setFlightno(rs.getString("flightno"));
				al.add(bean);
				count++;
			}
			
			
		}
		catch(java.sql.SQLException sqle) {
		sqle.printStackTrace();
			
		}
		finally {
			db.close(rs, ps, con);
			
		}
		return al;
	}

}