a0ebde109efc001d1745a9bad977883d

java做的机票查询系统、 仅供初学者参考！

package Flight;

import Flight.Bean;
import Flight.DBUtil;
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=new Bean();
		ArrayList al=new ArrayList();
		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.setFlightno(rs.getString("flightno"));
				al.add(bean);
			}
			return al;
			
		}
		catch(java.sql.SQLException sqle) {
		sqle.printStackTrace();
			
		}
		finally {
			db.close(rs, ps, con);
			
		}
		
		
	}
}