flightdaoimpl.java

机票查询系统.主要针对于机票的销售,便于顾客查询.

package com.dao.impl;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.dao.BaseDao;
import com.dao.FlightDao;
import com.dao.bean.FlightBean;

public class FlightDaoImpl extends BaseDao implements FlightDao{

	@Override
	public FlightBean findFlight(String flightid) {
		// TODO Auto-generated method stub
	FlightBean bean=null;
		sql="select * from tbl_flightinfo where flightid=?";
		initConn();
		try {
			pstmt=conn.prepareStatement(sql);
			pstmt.setString(1, flightid);
			rs=pstmt.executeQuery();
			if(rs.next()){
				bean=new FlightBean();
				bean.setFlightid(rs.getString("Flightid"));
				bean.setArriTime(rs.getString("ArriTime"));
				bean.setCompany(rs.getString("Company"));
				bean.setLeaveaTime(rs.getString("LeaveaTime"));
				bean.setLeaveairport(rs.getString("Leaveairport"));
				bean.setArriveairport(rs.getString("Arriveairport"));
				bean.setAirplane(rs.getString("Airplane"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally{
			closeConn();
		}
		return bean;
	}

}