网上机票查询系统（jsp+servlet+strut)

package cn.edu.manage; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.LinkedList; import java.util.List; import cn.edu.bean.City; import cn.edu.bean.Flight; import cn.edu.bean.Sell; import cn.edu.bean.Sseat; import cn.edu.dbcon.DBconn; /** * *关于航班的业务处理类 * */ public class Flight_manage { public Flight_manage() {} boolean issuc=false; DBconn dbc=new DBconn(); public LinkedList<Sseat>getSeat() { Connection conn=dbc.getcon(); LinkedList<Sseat>list=new LinkedList<Sseat>(); Statement stmt=null; ResultSet rs=null; String sql="select * from sseat"; try { stmt=conn.createStatement(); rs=stmt.executeQuery(sql); while(rs.next()) { Sseat ss=new Sseat(rs.getInt("sid"),rs.getInt("scount")); list.add(ss); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { close(rs,stmt,conn); } return list; } public LinkedList<City> getcity() { Connection conn=dbc.getcon(); LinkedList<City>city=new LinkedList<City>(); Statement stmt=null; ResultSet rs=null; String sql="select * from city"; try { stmt=conn.createStatement(); rs=stmt.executeQuery(sql); while(rs.next()) { City ci=new City(rs.getInt(1),rs.getString(2)); city.add(ci); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { close(rs,stmt,conn); } return city; } //获得所有航班信息 public List<Flight>getAll() { List<Flight>list=new ArrayList<Flight>(); Connection conn=dbc.getcon(); Statement stmt=null; Statement stmt1=null; ResultSet rs=null; ResultSet rs1=null; String sql="select * from flight"; try { stmt=conn.createStatement(); rs=stmt.executeQuery(sql); stmt1=conn.createStatement(); while(rs.next()) { Flight flight=new Flight(); flight.setFlid(rs.getString("flid")); flight.setEndtime(rs.getString("endtime")); flight.setStartime(rs.getString("startime")); flight.setPrice(rs.getFloat("price")); int startc=rs.getInt("startc"); int endc=rs.getInt("endc"); int count=rs.getInt("seat"); rs1=stmt1.executeQuery("select cname from city where cid="+startc); if(rs1.next()) { flight.setStartc(rs1.getString(1)); } rs1=stmt1.executeQuery("select cname from city where cid="+endc); if(rs1.next()) { flight.setEndc(rs1.getString(1)); } rs1=stmt1.executeQuery("select scount from sseat where sid="+count); if(rs1.next()) { flight.setSeat(rs1.getInt(1)); } list.add(flight); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { if(rs1!=null) try { rs1.close(); stmt1.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } close(rs,stmt,conn); } System.out.println(); return list; } //按编号查找航班 public Flight get(String flid) { Connection conn=dbc.getcon(); Flight flight =new Flight(); Statement stmt=null; ResultSet rs=null; Statement stmt1=null; ResultSet rs1=null; String sql="select * from flight where flid='"+flid+"'"; try { stmt=conn.createStatement(); rs=stmt.executeQuery(sql); stmt1=conn.createStatement(); if(rs.next()) { flight.setFlid(rs.getString("flid")); flight.setEndtime(rs.getString("endtime")); flight.setStartime(rs.getString("startime")); flight.setPrice(rs.getFloat("price")); int startc=rs.getInt("startc"); int endc=rs.getInt("endc"); int count=rs.getInt("seat"); rs1=stmt1.executeQuery("select cname from city where cid="+startc); if(rs1.next()) { flight.setStartc(rs1.getString(1)); } rs1=stmt1.executeQuery("select cname from city where cid="+endc); if(rs1.next()) { flight.setEndc(rs1.getString(1)); } rs1=stmt1.executeQuery("select scount from sseat where sid="+count); if(rs1.next()) { flight.setSeat(rs1.getInt(1)); } } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { close(rs,stmt,conn); try { rs1.close(); stmt1.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return flight; } //取消航班 public boolean delete(String flid) { Connection conn=dbc.getcon(); Statement stmt=null; try { stmt=conn.createStatement(); int count=stmt.executeUpdate("delete from flight where flid='"+flid+"'"); if(count>0) issuc=true; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { close(stmt,conn); } return issuc; } public void close(ResultSet rs,Statement stmt,Connection conn) { try { rs.close(); stmt.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public void close(Statement stmt,Connection conn) { try { stmt.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } //增加航班 public boolean add(String flid,int startc,int endc,String startime,String endtime,int seat,float price) { Connection conn=dbc.getcon(); Statement stmt=null; try { stmt=conn.createStatement(); String sql="insert into flight(flid,startc,endc,startime,endtime,seat,price) values('"+flid+"',"+startc+","+endc+",'"+startime+"','"+endtime+"',"+seat+","+price+")"; int count=stmt.executeUpdate(sql); if(count>0) issuc=true; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { close(stmt,conn); } return issuc; } //取得售票情况列表 public LinkedList<Sell>getSell() { LinkedList<Sell>list=new LinkedList<Sell>(); Connection conn=dbc.getcon(); Statement stmt=null; ResultSet rs=null; String sql="select * from sell order by bout"; try { stmt=conn.createStatement(); rs=stmt.executeQuery(sql); while(rs.next()) { Sell se=new Sell(); se.setFlid(rs.getString("flid")); Flight fl=get(se.getFlid()); se.setFlight(fl); se.setBount(rs.getInt("bout")); se.setCount(rs.getInt("count")); se.setTime(rs.getString("time")); list.add(se); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { close(rs,stmt,conn); } return list; } //测试方法是否正确执行 public static void main(String[]args) { Flight_manage mm=new Flight_manage(); System.out.println("*****************************************************"); /*Flight fff=mm.get("MU2305"); System.out.println("flid="+fff.getFlid()+",startc="+fff.getStartc()+",seat="+fff.getSeat());*/ System.out.println("*****************************************************"); //mm.delete("MU2305"); List<Flight>mylist=mm.getAll(); System.out.println(mylist.size()); for(int i=0;i<mylist.size();i++) { Flight ff=mylist.get(i); System.out.println("flid="+ff.getFlid()+",startc="+ff.getStartc()+",seat="+ff.getSeat()); } } }