Plane对象:
在Plane对象里定义了飞机的编号id、航班号、目的地、起飞日期。生成了构造方法和toString()方法;以及getting()和setting()方法,但在程序里没用到。
package com.hangkong;
public class Plane {
private int id;//编号
private String planeNum;//航班号
private String address;//目的地
private String date;//日期
public Plane(int id, String planeNum, String address, String date) {
super();
this.id = id;
this.planeNum = planeNum;
this.address = address;
this.date = date;
}
public Plane(){
super();
}
//Alt+Shift+s
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getPlaneNum() {
return planeNum;
}
public void setPlaneNum(String planeNum) {
this.planeNum = planeNum;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getDate() {
return date;
}
public void setDate(String date) {
this.date = date;
}
@Override
public String toString() {
return "Plane" + id + "\t\t" + planeNum + "\t\t" + address + "\t\t" + date;
//return "Plane ID:" + id + "\t航班编号:" + planeNum + "\t目的地:" + address + "\t起飞时间:" + date;
}
}
MySQL数据库:
数据库名字是Fly,数据表是plane;在getcon()函数中注册驱动、获取连接
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `plane`
-- ----------------------------
DROP TABLE IF EXISTS `plane`;
CREATE TABLE `plane` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`planeNum` varchar(20) DEFAULT NULL,
`address` varchar(20) DEFAULT NULL,
`date` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of plane
-- ----------------------------
INSERT INTO `plane` VALUES ('1', 'DZ001', '东京', '2019-9-1');
INSERT INTO `plane` VALUES ('2', 'DZ002', '上海', '2019-8-28');
INSERT INTO `plane` VALUES ('3', 'DZ003', '广州', '2019-8-29');
INSERT INTO `plane` VALUES ('4', 'DZ004', '深圳', '2019-8-29');
INSERT INTO `plane` VALUES ('5', 'DZ005', '厦门', '2019-8-30');
INSERT I