写点什么

做个小项目那不是简简单单!Java 实现航空航班管理系统。

用户头像
极客good
关注
发布于: 刚刚

import com.mysql.jdbc.ExceptionInterceptor;


import com.sun.javafx.runtime.VersionInfo;


import com.sun.xml.internal.ws.api.pipe.NextAction;


public class TestFly {


static Connection con = null;//连接


static PreparedStatement ps = null;//模板


static ResultSet rs = null;//结果集


public static void main(String[] args) throws Exception {


System.out.println("大壮航空航班信息管理系统**\n");


//show();


boolean bool = Dome();


while(bool){


bool = Dome();


}


if(!bool){


System.out.println("已成功退出大壮航空航班信息管理系统\n");


System.exit(0);


}


}


//流程


public static boolean Dome() throws Exception{


Scanner scan = new Scanner(System.in);


show();


int key = scan.nextInt();


switch (key) {


case 1:


showMessage(listMessage());


break;


case 2:{


System.out.println("输入起飞时间:");


String date = scan.next();


showMessage(selectDate(date));


}break;


case 3:{


System.out.println("输入目的地:");


String Address = scan.next();


showMessage(selectAddress(Address));


}break;


case 4:{


System.out.println("输入航班编号:");


String planeNum = scan.next();


deleteFly(planeNum);


}break;


case 5:{


System.out.println("输入航班编号和更改后目的地和时间:");


String planeNum = scan.next();


String Address = scan.next();


String date = scan.next();


updateFly(Address,date,planeNum);


}break;


case 6:{


System.out.println("输入航班编号、目的地、起飞时间:");


String planeNum = scan.next();


String Address = scan.next();


String date = scan.next();


creatPlane(planeNum,Address,date);


}break;


default:


//scan.close();


return false;


}


//scan.close();


return true;


}


//注册驱动,获取连接


public static Connection getCon() throws Exception{


Class.forName("com.mysql.jdbc.Driver");


con = DriverManager.getConnection("jdbc:mysql://localhost:3306/fly", "root", "");


return con;


}


//创建初始信息,插入信息


public static void creatPlane(String planeNum,String address, String date) throws Exception{


getCon();


String sql = "insert into plane values (null,?,?,?)";


ps = con.prepareStatement(sql);


ps.setString(1, planeNum);


ps.setString(2, address);


ps.setString(3, date);


ps.executeUpdate();


ps.close();


con.close();


selectPlaneNum(planeNum);


}


//系统主菜单


public static void show(){


System.out.println("请选择操作:(1.列出所有航班,2.按起飞时间查询,3.按目的地查询,4.删除航班,5.更新航班,6.增加航班,7.退出系统)");


}


//获取结果集合输出


public static void showMessage(Set<Plane> set){


System.out.println("\n 大壮航空***\n");


if(set.size() == 0){


System.out.println("未匹配到任何数据!");


System.out.println("\n 大壮航空***\n");


return;


}


System.out.println("Plane\t\t 航班编号\t 目的地\t\t 起飞时间");


for( Plane value : set){


System.out.println(value);


}


System.out.println("\n 大壮航空***\n");


}


//列出所有航班信息


public static Set<Plane> listMessage() throws Exception{


getCon();


String sql = "select * from plane";


ps = con.prepareStatement(sql);


rs = ps.executeQuery();


Set<Plane> set = new HashSet<>();


while(rs.next()){


int id = rs.getInt("id");


String planeNum = rs.getString("planeNum");


String address = rs.getString("address");


String dateTime = rs.getString("date");


Plane plane = new Plane(id, planeNum, address, dateTime);


set.add(plane);


}


ps.close


【一线大厂Java面试题解析+核心总结学习笔记+最新架构讲解视频+实战项目源码讲义】
浏览器打开:qq.cn.hn/FTf 免费领取
复制代码


();


con.close();


return set;


}


//按起飞时间查询


public static Set<Plane> selectDate(String date) throws Exception{


getCon();


String sql = "select * from plane where date = ? ";


ps = con.prepareStatement(sql);


ps.setString(1, date);


rs = ps.executeQuery();


Set<Plane> set = new HashSet<>();


//String planes = "";


while(rs.next()){


int id = rs.getInt("id");


String planeNum = rs.getString("planeNum");


String address = rs.getString("address");


String dateTime = rs.getString("date");


Plane plane = new Plane(id, planeNum, address, dateTime);


set.add(plane);


//planes += plane.toString() + "\n";


}


ps.close();


con.close();


return set;


}


//按目的地查询


public static Set<Plane> selectAddress(String Address) throws Exception{


getCon();


String sql = "select * from plane where address = ? ";


ps = con.prepareStatement(sql);


ps.setString(1, Address);


rs = ps.executeQuery();


Set<Plane> set = new HashSet<>();


//String planes = "";


while(rs.next()){


int id = rs.getInt("id");


String planeNum = rs.getString("planeNum");


String address = rs.getString("address");


String dateTime = rs.getString("date");


Plane plane = new Plane(id, planeNum, address, dateTime);


set.add(plane);


//planes += plane.toString() + "\n";


}


ps.close();


con.close();


return set;


}


//按航班编号


public static void selectPlaneNum(String planeNum) throws Exception{


getCon();


String sql = "select * from plane where planeNum = ? ";


ps = con.prepareStatement(sql);


ps.setString(1, planeNum);


rs = ps.executeQuery();


boolean x = true;


while(rs.next()){


if(x){


System.out.println("\n 大壮航空***\n");


System.out.println("Plane\t\t 航班编号\t 目的地\t\t 起飞时间");


}


int id = rs.getInt("id");


String planenum = rs.getString("planeNum");


String address = rs.getString("address");


String date = rs.getString("date");


System.out.println("Plane" + id + "\t\t" + planenum + "\t\t" + address + "\t\t" + date);


x = false;


}


System.out.println("\n 大壮航空***\n");


}


//按航班编号删除航班


public static void deleteFly(String planeNum) throws Exception{


getCon();


String sql = "delete from plane where planeNum = ? ";


ps = con.prepareStatement(sql);


ps.setString(1, planeNum);


ps.executeUpdate();


ps.close();


con.close();


System.out.println("\n 大壮航空***\n");


System.out.println("已删除!");


System.out.println("\n 大壮航空***\n");


}

用户头像

极客good

关注

还未添加个人签名 2021.03.18 加入

还未添加个人简介

评论

发布
暂无评论
做个小项目那不是简简单单!Java实现航空航班管理系统。