stationdao.java

jsp对列车有查询功能jsp对列车有查询功能

package li.s2.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import li.s2.bean.*;

public class StationDAO extends BaseDAO {
	 /**
	  * 查询一个车次对象是否存在,并返回该对象具体信息
	  * @param stationBean
	  * @return returnStationBean
	  */
	public StationBean selectOneStationBean(StationBean stationBean){
		Connection con = null;
		PreparedStatement pst = null;
		ResultSet rs = null;
		StationBean returnStationBean = null;
		String SQL="select * from station where trainNum=? and station=?";
		try {
			con = this.getConn();
			pst = con.prepareStatement(SQL);
			pst.setString(1, stationBean.getTrainNum());
			pst.setString(2, stationBean.getStation());
			rs = pst.executeQuery();
			while(rs.next()){
				returnStationBean = new StationBean();
				returnStationBean.setStationId(rs.getInt("stationId"));
				returnStationBean.setTrainNum(rs.getString("trainNum"));
				returnStationBean.setStation(rs.getString("station"));
				returnStationBean.setOutTime(rs.getString("outTime"));
				returnStationBean.setDayTime(rs.getInt("dayTime"));
				returnStationBean.setSitePrice(rs.getFloat("sitePrice"));
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				this.CloseAll(rs, pst, con);
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return returnStationBean;
	}
	/**
	 * 测试查询方法是否成功
	 * @param args
	 */
	public static void main(String[] args) {
		StationDAO stationDAO = new StationDAO();
		StationBean stationBean = new StationBean();
		stationBean.setTrainNum("k339");
		stationBean.setStation("沈阳");
		StationBean returnStationBean= stationDAO.selectOneStationBean(stationBean);
		
		System.out.println(returnStationBean.getSitePrice());
	}
}