import javasql;import javautilScanner;public class ResumeSystem private static final String DB_URL = jdbcsqlserverlocalhost1433;databaseName=resume_db; private static final String USER = sa;
这些错误提示是因为代码中缺少了相应的方法,需要在代码中添加以下四个方法的定义:
// 个人简历信息浏览 private static void viewResume(Connection conn) throws SQLException { try (Statement stmt = conn.createStatement()) { String sql = "SELECT * FROM resume"; ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { int id = rs.getInt("id"); String name = rs.getString("name"); String gender = rs.getString("gender"); Date birthdate = rs.getDate("birthdate"); String idNumber = rs.getString("id_number"); String phone = rs.getString("phone"); String email = rs.getString("email"); System.out.println("ID:" + id); System.out.println("姓名:" + name); System.out.println("性别:" + gender); System.out.println("出生日期:" + birthdate); System.out.println("身份证号:" + idNumber); System.out.println("电话号码:" + phone); System.out.println("电子邮件地址:" + email); System.out.println(); } } }
// 按身份证号查询信息 private static void queryResume(Connection conn, Scanner scanner) throws SQLException { System.out.print("请输入要查询信息的身份证号:"); String idNumber = scanner.nextLine(); String sql = "SELECT * FROM resume WHERE id_number = ?"; try (PreparedStatement pstmt = conn.prepareStatement(sql)) { pstmt.setString(1, idNumber); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { int id = rs.getInt("id"); String name = rs.getString("name"); String gender = rs.getString("gender"); Date birthdate = rs.getDate("birthdate"); String phone = rs.getString("phone"); String email = rs.getString("email"); System.out.println("ID:" + id); System.out.println("姓名:" + name); System.out.println("性别:" + gender); System.out.println("出生日期:" + birthdate); System.out.println("身份证号:" + idNumber); System.out.println("电话号码:" + phone); System.out.println("电子邮件地址:" + email); } else { System.out.println("身份证号对应的个人简历信息不存在。"); } } }
// 个人简历信息删除 private static void deleteResume(Connection conn, Scanner scanner) throws SQLException { System.out.print("请输入要删除信息的身份证号:"); String idNumber = scanner.nextLine(); String sql = "DELETE FROM resume WHERE id_number = ?"; try (PreparedStatement pstmt = conn.prepareStatement(sql)) { pstmt.setString(1, idNumber); int count = pstmt.executeUpdate(); if (count > 0) { System.out.println("个人简历信息删除成功。"); } else { System.out.println("身份证号对应的个人简历信息不存在。"); } } }
// 个人简历信息修改 private static void updateResume(Connection conn, Scanner scanner) throws SQLException { System.out.print("请输入要修改信息的身份证号:"); String idNumber = scanner.nextLine(); String sql = "SELECT * FROM resume WHERE id_number = ?"; try (PreparedStatement pstmt = conn.prepareStatement(sql)) { pstmt.setString(1, idNumber); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { System.out.print("请输入要修改的项(姓名/性别/出生日期/电话号码/电子邮件地址):"); String field = scanner.nextLine(); System.out.print("请输入要修改的值:"); String value = scanner.nextLine();
String updateSql = "UPDATE resume SET " + field + " = ? WHERE id_number = ?";
try (PreparedStatement updateStmt = conn.prepareStatement(updateSql)) {
updateStmt.setString(1, value);
updateStmt.setString(2, idNumber);
updateStmt.executeUpdate();
}
System.out.println("个人简历信息修改成功。");
} else {
System.out.println("身份证号对应的个人简历信息不存在。");
}
}
原文地址: https://www.cveoy.top/t/topic/ggky 著作权归作者所有。请勿转载和采集!