小型飞机票预定系统，源代码+数据库文件

package com; import java.sql.*; public class TicketchaxunData { Connection conn = null; //取得数据库连接的方法 public void setupConn(){ try{ if(conn == null){ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //定义SQLServer数据库的连接地址，如果是默认端口，不用定义端口 String url ="jdbc:odbc:uer"; //使用DriverManager类的getConnection()方法建立连接 conn = DriverManager.getConnection(url, "", ""); } }catch(Exception e){ e.printStackTrace(); } } public String[][] chaxun(String tape,String value,String s2,String s3){//查询记录 String[][] detail = new String[0][11]; setupConn(); if(tape.equals("航班号")){ try{ Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); String sqlCount = "select count(*) from ticket where planeID='"+value+"'"; String sql= "select * from ticket where PlaneID='"+value+"'"; //取得飞机票数据表的记录总数 ResultSet rs=stmt.executeQuery(sqlCount); System.out.println("hello"); int count = 0; if(rs.next()){ count = rs.getInt(1); } //重新创建数组 detail = new String[count][11]; //取得用户数据表的全部记录 rs=stmt.executeQuery(sql); int i = 0; //将记录加入数组 while (rs.next()) { for(int j = 0; j < 11; j++){ detail[i][j] = rs.getString(j + 1); System.out.println(detail[i][j]); } //删除微妙 detail[i][3]=detail[i][3].substring(0,detail[i][3].indexOf(".")); detail[i][4]=detail[i][4].substring(0,detail[i][4].indexOf(".")); i++; } }catch(Exception ex){ ex.printStackTrace(); } return detail; } if(tape.equals("航班公司")){ try{ Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); String sqlCount = "select count(*) from ticket where planeCompany='"+value+"'"; String sql= "select * from ticket where planeCompany='"+value+"'"; //取得飞机票数据表的记录总数 ResultSet rs=stmt.executeQuery(sqlCount); //System.out.println("hello"); int count = 0; if(rs.next()){ count = rs.getInt(1); } //重新创建数组 detail = new String[count][11]; //取得用户数据表的全部记录 rs=stmt.executeQuery(sql); int i = 0; //将记录加入数组 while (rs.next()) { for(int j = 0; j < 11; j++){ detail[i][j] = rs.getString(j + 1); System.out.println(detail[i][j]); } //删除微妙 detail[i][3]=detail[i][3].substring(0,detail[i][3].indexOf(".")); detail[i][4]=detail[i][4].substring(0,detail[i][4].indexOf(".")); i++; } }catch(Exception ex){ ex.printStackTrace(); } return detail; } if(tape.equals("起飞地点")){ try{ Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); String sqlCount = "select count(*) from ticket where planeqifeiPlace='"+value+"'"; String sql= "select * from ticket where planeqifeiPlace='"+value+"'"; //取得飞机票数据表的记录总数 ResultSet rs=stmt.executeQuery(sqlCount); //System.out.println("hello"); int count = 0; if(rs.next()){ count = rs.getInt(1); } //重新创建数组 detail = new String[count][11]; //取得用户数据表的全部记录 rs=stmt.executeQuery(sql); int i = 0; //将记录加入数组 while (rs.next()) { for(int j = 0; j < 11; j++){ detail[i][j] = rs.getString(j + 1); System.out.println(detail[i][j]); } //删除微妙 detail[i][3]=detail[i][3].substring(0,detail[i][3].indexOf(".")); detail[i][4]=detail[i][4].substring(0,detail[i][4].indexOf(".")); i++; } }catch(Exception ex){ ex.printStackTrace(); } return detail; } if(tape.equals("到达地点")){ try{ Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); String sqlCount = "select count(*) from ticket where planeArrPlace='"+value+"'"; String sql= "select * from ticket where planeArrPlace='"+value+"'"; //取得飞机票数据表的记录总数 ResultSet rs=stmt.executeQuery(sqlCount); //System.out.println("hello"); int count = 0; if(rs.next()){ count = rs.getInt(1); } //重新创建数组 detail = new String[count][11]; //取得用户数据表的全部记录 rs=stmt.executeQuery(sql); int i = 0; //将记录加入数组 while (rs.next()) { for(int j = 0; j < 11; j++){ detail[i][j] = rs.getString(j + 1); System.out.println(detail[i][j]); } //删除微妙 detail[i][3]=detail[i][3].substring(0,detail[i][3].indexOf(".")); detail[i][4]=detail[i][4].substring(0,detail[i][4].indexOf(".")); i++; } }catch(Exception ex){ ex.printStackTrace(); } return detail; } if(tape.equals("起飞时间")){ try{ Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); String sqlCount = "select count(*) from ticket where planeqifeiTime='"+value+"'"; String sql= "select * from ticket where planeqifeiTime='"+value+"'"; //取得飞机票数据表的记录总数 ResultSet rs=stmt.executeQuery(sqlCount); //System.out.println("hello"); int count = 0; if(rs.next()){ count = rs.getInt(1); } //重新创建数组 detail = new String[count][11]; //取得用户数据表的全部记录 rs=stmt.executeQuery(sql); int i = 0; //将记录加入数组 while (rs.next()) { for(int j = 0; j < 11; j++){ detail[i][j] = rs.getString(j + 1); System.out.println(detail[i][j]); } //删除微妙 detail[i][3]=detail[i][3].substring(0,detail[i][3].indexOf(".")); detail[i][4]=detail[i][4].substring(0,detail[i][4].indexOf(".")); i++; } }catch(Exception ex){ ex.printStackTrace(); } return detail; } if(tape.equals("到达时间")){ try{ Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); String sqlCount = "select count(*) from