JSP:航班信息查询模块加强版（附工…

说明:
1.基于三层架构，oracle 10g，JSP
2.增加了分页和部分异常处理
3.通过sql拼接实现信息筛选而非setObject()
4.数据库访问通过数据池做的
项目结构图：

说明：biz业务逻辑层     entity实体类     dao：数据访问对象       dao.imple实现类

代码：
实体类：AirInfo.java

public class AirInfo {

private int aid;

private String takeOff;

private String destination;

public int getAid() {

return aid;

}

public void setAid(int aid) {

this.aid = aid;

}

public String getTakeOff() {

return takeOff;

}

public void setTakeOff(String takeOff) {

this.takeOff = takeOff;

}

public String getDestination() {

return destination;

}

public void setDestination(String destination) {

this.destination = destination;

}

}
=============================================================================
数据访问类：

package dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.naming.NamingException;

import javax.sql.DataSource;

public class BaseDao {

Connection conn   = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

public Connection getConnection(){

try {

Context ctx = new InitialContext();

DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/scott");

conn = ds.getConnection();

} catch (NamingException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return conn;

}

public void closeAll(Connection conn,PreparedStatement pstmt,ResultSet rs){

try {

if(null!=rs)

rs.close();

if(null!=pstmt)

pstmt.close();

if(null!=conn)

conn.close();

} catch (SQLException e) {