用了上个博客的DBUtil中的方法,代码如下:
import java.sql.SQLException;
import java.util.Scanner;
import com.jd.util.DBUtil;
public class Manage {
public static void main(String[] args) {
System.out.println("*******************************");
System.out.println("* *");
System.out.println("* 欢迎进入学生信息管理系统 *");
System.out.println("* *");
System.out.println("*******************************");
System.out.println("1.添加学生信息");
System.out.println("2.删除学生信息");
System.out.println("3.修改学生信息");
System.out.println("4.查询学生信息");
System.out.println("请输入操作序号,输入0结束:");
@SuppressWarnings("resource")
Scanner scanner = new Scanner(System.in);
int i = scanner.nextInt();
while (i != 0) {
switch (i) {
case 1: {
System.out.println("请输入学号:");
String id = scanner.next();
if (!DBUtil.exist("select * from student where id = ?", id)) {
System.out.println("请输入姓名、地址");
String name = scanner.next();
String address = scanner.next();
if (DBUtil.update("insert into student (id,name,address) values (?,?,?)", id, name, address)) {
System.out.println("添加成功,请继续选择功能!");
} else {
System.out.println("添加失败,请重新选择功能");
}
} else {
System.out.println("该学号已经存在,请重新选择功能!");
}
}
break;
case 2: {
System.out.println("请输入想要删除信息的学生学号:");
String id = scanner.next();
if (DBUtil.update("delete from student where id=?", id)) {
System.out.println("删除成功,请继续选择功能!");
} else {
System.out.println("找不到该学号,请重新选择功能!");
}
}
break;
case 3: {
System.out.println("请输入想要修改信息的学生学号:");
String id = scanner.next();
if (DBUtil.exist("select id from student where id = ?", id)) {
System.out.println("请输入想要修改信息的学生新姓名、新地址:");
String name = scanner.next();
String address = scanner.next();
if (DBUtil.update("update student set name=?,address=? where id=?", name, address, id)) {
System.out.println("修改成功,请继续选择功能!");
} else {
System.out.println("修改失败,请重新选择功能!");
}
} else {
System.out.println("找不到该学号,请重新选择功能!");
}
}
break;
case 4: {
System.out.println("请输入想要查询信息的学生学号:");
String id = scanner.next();
if (DBUtil.exist("select id from student where id = ?", id)) {
DBUtil.select("select * from student where id = ?", (resultSet) -> {
try {
if (resultSet.next()) {
String name = resultSet.getString("name");
String address = resultSet.getString("address");
System.out.println(id + " " + name + " " + address);
} else {
System.out.println("不存在");
}
} catch (SQLException e) {
e.printStackTrace();
}
}, id);
System.out.println("查询成功!");
} else {
System.out.println("找不到该学号,请重新选择功能!");
}
}
break;
default: {
System.out.println("输入功能编号错误,请重新输入!");
}
break;
}
System.out.println("请重新选择:1——>添加学生信息 2——>删除学生信息 3——>修改学生信息 4——>查询学生信息 0——>结束 请输入:");
i = scanner.nextInt();
}
System.out.println("感谢使用!");
}
}