30ecb6cea9fc001d1745a9bad977883d

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

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,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 ticketinfo where lcavccity=? and destination=? and econum=?";
			ps=con.prepareStatement(sql);
			
			ps.setString(1, lcavccity);
			ps.setString(2, destination);
			ps.setInt(3, econum)
			
			
			rs=ps.executeQuery();
			bean=new Bean();
			while(rs.next()) {
				count++;
				
				bean.setNum(count);
				bean.setFlightno(rs.getString("flightno"));
				
				
			}
			
			
		}
		catch(java.sql.SQLException sqle) {
		sqle.printStackTrace();
			
		}
		finally {
			db.close(rs, ps, con);
			
		}
		return bean;
	}

}