e07f3fdba8fc001d1745a9bad977883d

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

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 Bean select(String lcavccity,String destination) {
		DBUtil db=new DBUtil();
		Bean bean=null;
		//ArrayList al=new ArrayList();
		int count=0;
		try{
			con=db.getConnection();
			String sql="select flightno from ticketinfo where lcavccity=? and destination=?";
			ps=con.prepareStatement(sql);
			
			ps.setString(1, lcavccity);
			ps.setString(2, destination);
			
			
			rs=ps.executeQuery();
			
			while(rs.next()) {
				count++;
				bean=new Bean();
				bean.setNum(count);
				bean.setFlightno(rs.getString("flightno"));
				
				
			}
			
			
		}
		catch(java.sql.SQLException sqle) {
		sqle.printStackTrace();
			
		}
		finally {
			db.close(rs, ps, con);
			
		}
		return bean;
	}

}