创作不易 给个赞或者关注吧
属性
private String name;
private int age;
private int price;
private int date;
private String phone;
@Override
public String toString() {
return "订单信息:姓名:" + name + ", 年龄:" + age + ", 价格:" + price + ", 日期" + date + ", 电话:" + phone;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public int getPrice() {
return price;
}
public void setPrice(int price) {
this.price = price;
}
public int getDate() {
return date;
}
public void setDate(int date) {
this.date = date;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public PerSion(String name, int age, int price, int date, String phone) {
super();
this.name = name;
this.age = age;
this.price = price;
this.date = date;
this.phone = phone;
}
public PerSion() {
super();
}
JDBC
static Connection connection = null;
static {
try {
Class.forName("com.mysql.jdbc.Driver");
connection = (Connection) DriverManager.getConnection(
"jdbc:mysql://127.0.0.1:3306/suntourgroup?useUnicode=true&characterEncoding=utf-8", "用户名",
"密码");
} catch (Exception e) {
e.printStackTrace();
}
}
//1.添加出行订单
public static void add(PerSion persion) throws SQLException {
String sql = "insert into suntourgroup values(null,?,?,?,?,?)";
PreparedStatement statement = (PreparedStatement) connection.prepareStatement(sql);
statement.setInt(1, persion.getDate());
statement.setString(2, persion.getPhone());
statement.setString(3, persion.getName());
statement.setInt(4, persion.getAge());
statement.setInt(5, persion.getPrice());
statement.executeUpdate();
}
//2.查看我的出行订单
public static List<PerSion> selectAll() throws SQLException {
String sql = "select * from suntourgroup";
PreparedStatement statement = (PreparedStatement) connection.prepareStatement(sql);
ResultSet set = statement.executeQuery();
List<PerSion>list = new ArrayList<>();
PerSion persion = null;
while (set.next()) {
persion = new PerSion();
persion.setDate(set.getInt("persion_date"));
persion.setPhone(set.getString("persion_phone"));
persion.setName(set.getString("persion_name"));
persion.setAge(set.getInt("persion_age"));
persion.setPrice(set.getInt("persion_price"));
list.add(persion);
}
return list;
}
//3.修改订单信息
public static int update(int date,String phone) throws SQLException {
String sql = "update suntourgroup set persion_date=? where persion_phone=?";
PreparedStatement statement = (PreparedStatement) connection.prepareStatement(sql);
statement.setInt(1, date);
statement.setString(2, phone);
return statement.executeUpdate();
}
//4.删除出行人
public static int delete(String name) throws SQLException{
String sql = "delete from suntourgroup where persion_name=? ";
PreparedStatement statement = (PreparedStatement) connection.prepareStatement(sql);
statement.setString(1, name);
return statement.executeUpdate();
}
方法类
//1.添加出行订单
public static void add() throws SQLException {
System.out.println("请输入出行日期");
int date = scanner.nextInt();
System.out.println("请输入联系方式");
String phone = scanner.next();
if(phone.length()==11) {
while (true) {
System.out.println("请输入选项1.成人2.儿童3.老人");
int cc = scanner.nextInt();
switch (cc) {
case 1:
int q = 0;
System.out.println("请输入姓名");
String name = scanner.next();
System.out.println("请输入年龄");
int age = scanner.nextInt();
q += 2000;
price += q;
System.out.println("是否继续y/n");
String a = scanner.next();
if (a.equalsIgnoreCase("y")) {
PerSion persion = new PerSion(name, age, q, date, phone);
System.out.println("出行日期" + date);
System.out.println("联系方式" + phone);
System.out.println("金额" + price);
JDBC.add(persion);
break;
} else {
System.out.println("出行日期" + date);
System.out.println("联系方式" + phone);
System.out.println("金额" + price);
PerSion persion = new PerSion(name, age, q, date, phone);
JDBC.add(persion);
return;
}
case 2:
int p = 0;
System.out.println("请输入姓名");
String name1 = scanner.next();
System.out.println("请输入年龄");
int age1 = scanner.nextInt();
// 儿童设置占床
System.out.println("1.占床2.不占");
int z = scanner.nextInt();
if (z == 1) {
p += 30;
} else {
p = 0;
}
price += p;
System.out.println("是否继续y/n");
String a1 = scanner.next();
if (a1.equalsIgnoreCase("y")) {
PerSion persion = new PerSion(name1, age1, p, date, phone);
JDBC.add(persion);
System.out.println("出行日期" + date);
System.out.println("联系方式" + phone);
System.out.println("金额" + price);
break;
} else {
System.out.println("出行日期" + date);
System.out.println("联系方式" + phone);
System.out.println("金额" + price);
PerSion persion = new PerSion(name1, age1, p, date, phone);
JDBC.add(persion);
return;
}
case 3:
int k = 0;
System.out.println("请输入姓名");
String name2 = scanner.next();
System.out.println("请输入年龄");
int age2 = scanner.nextInt();
// 老人设置年龄
if (age2 >= 65) {
k += 1000;
} else {
System.out.println("年龄不符");
break;
}
price += k;
System.out.println("是否继续y/n");
String a2 = scanner.next();
if (a2.equalsIgnoreCase("y")) {
PerSion persion = new PerSion(name2, age2, k, date, phone);
JDBC.add(persion);
System.out.println("出行日期" + date);
System.out.println("联系方式" + phone);
System.out.println("金额" + price);
break;
} else {
System.out.println("出行日期" + date);
System.out.println("联系方式" + phone);
System.out.println("金额" + price);
PerSion persion = new PerSion(name2, age2, k, date, phone);
JDBC.add(persion);
return;
}
default:
System.out.println("眼睛不要咱就捐了吧");
break;
}
}
}else {
System.out.println("手机号码格式有误");
}
}
//2.查看我的出行订单
public static void selectAll() throws SQLException {
List<PerSion>list = JDBC.selectAll();
for (PerSion perSion1 : list) {
System.out.println(perSion1);
}
}
//3.修改订单信息
public static void update() throws SQLException {
System.out.println("请输入你要的手机号");
String phone = scanner.next();
System.out.println("请输入你要修改的日期");
int date = scanner.nextInt();
System.out.println(JDBC.update(date, phone));
}
//4.删除出行人
public static void delete() throws SQLException {
System.out.println("请输入姓名");
String name = scanner.next();
System.out.println(JDBC.delete(name));
}
// 5.查看行程
public static void CheckIti() {
System.out.println("1、游船全线一日游︰");
System.out.println("①下关码头——小普陀——南诏风情岛——蝴蝶泉——大理古城");
System.out.println("②大理古城龙龛码头——小普陀——南诏风情岛——蝴蝶泉——大理古城");
System.out.println("2、游船半线游︰大理古城龙龛码头——金梭岛景区、罗荃半岛景区——大理古城");
System.out.println("3、自驾游1(租车)∶大理古城——崇圣寺三塔——蝴蝶泉");
System.out.println("4、自驾游2(租车)∶远观三塔——蝴蝶泉——双廊古镇");
System.out.println("休闲度假游");
System.out.println("1、逛大理古城——游天龙八部影视城——苍山大索道洗马塘");
System.out.println("2、自驾环洱海(租车)∶大理古城——喜洲——双廊——挖色——小普陀——观音阁——下");
System.out.println("3、大理古城——洱源地热国");
System.out.println("4、逛大理古城——桃溪谷");
}
实现类
Scanner scanner = new Scanner(System.in);
while (true) {
System.out.println("欢迎来到阳光旅行团");
System.out.println("1.添加出行订单2.查看我的出行订单3.修改订单信息4.删除出行人5.查看行程6.退出系统");
int cc = scanner.nextInt();
switch (cc) {
case 1:
Way.add();
break;
case 2:
Way.selectAll();
break;
case 3:
Way.update();
break;
case 4:
Way.delete();
break;
case 5:
Way.CheckIti();
break;
case 6:
System.out.println("感谢使用,下次再见");
return;
default:
System.out.println("眼睛不要咱就捐了吧");
break;
}
}