• 日期: 2028-04-02
  • 标签: 教育

以下是Java个人简历系统的示例代码：

import java.sql.*; import java.util.Scanner;

public class ResumeSystem { private static final String DB_URL = "jdbc:sqlserver://localhost:1433;databaseName=resume_db"; private static final String USER = "sa"; private static final String PASSWORD = "password";

public static void main(String[] args) {
    Scanner scanner = new Scanner(System.in);
    try (Connection conn = DriverManager.getConnection(DB_URL, USER, PASSWORD)) {
        // 创建表
        createTable(conn);

        while (true) {
            System.out.println("请选择要执行的操作：");
            System.out.println("1. 个人简历信息录入");
            System.out.println("2. 增加个人简历信息");
            System.out.println("3. 个人简历信息浏览");
            System.out.println("4. 按身份证号查询信息");
            System.out.println("5. 个人简历信息删除");
            System.out.println("6. 个人简历信息修改");
            System.out.println("7. 退出程序");
            int choice = scanner.nextInt();
            scanner.nextLine(); // 读取剩余的换行符

            switch (choice) {
                case 1:
                    insertResume(conn, scanner);
                    break;
                case 2:
                    addResume(conn, scanner);
                    break;
                case 3:
                    viewResume(conn);
                    break;
                case 4:
                    queryResume(conn, scanner);
                    break;
                case 5:
                    deleteResume(conn, scanner);
                    break;
                case 6:
                    updateResume(conn, scanner);
                    break;
                case 7:
                    System.exit(0);
                    break;
                default:
                    System.out.println("无效的选项，请重新选择。");
                    break;
            }
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

// 创建表
private static void createTable(Connection conn) throws SQLException {
    try (Statement stmt = conn.createStatement()) {
        String sql = "CREATE TABLE resume (" +
                "id INT IDENTITY(1,1) PRIMARY KEY," +
                "name VARCHAR(50) NOT NULL," +
                "gender VARCHAR(10) NOT NULL," +
                "birthdate DATE NOT NULL," +
                "id_number VARCHAR(20) NOT NULL UNIQUE," +
                "phone VARCHAR(20) NOT NULL," +
                "email VARCHAR(50) NOT NULL)";
        stmt.executeUpdate(sql);
    }
}

// 个人简历信息录入
private static void insertResume(Connection conn, Scanner scanner) throws SQLException {
    System.out.print("请输入姓名：");
    String name = scanner.nextLine();
    System.out.print("请输入性别（男/女）：");
    String gender = scanner.nextLine();
    System.out.print("请输入出生日期（格式为yyyy-MM-dd）：");
    String birthdate = scanner.nextLine();
    System.out.print("请输入身份证号：");
    String idNumber = scanner.nextLine();
    System.out.print("请输入电话号码：");
    String phone = scanner.nextLine();
    System.out.print("请输入电子邮件地址：");
    String email = scanner.nextLine();

    String sql = "INSERT INTO resume (name, gender, birthdate, id_number, phone, email) VALUES (?, ?, ?, ?, ?, ?)";
    try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
        pstmt.setString(1, name);
        pstmt.setString(2, gender);
        pstmt.setDate(3, Date.valueOf(birthdate));
        pstmt.setString(4, idNumber);
        pstmt.setString(5, phone);
        pstmt.setString(6, email);
        pstmt.executeUpdate();
    }
    System.out.println("个人简历信息录入成功。");
}

// 增加个人简历信息
private static void addResume(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("身份证号对应的个人简历信息不存在。");
        }
    }
}

// 个人简历信息浏览
private static void viewResume(Connection conn) throws SQLException {
    String sql = "SELECT * FROM resume";
    try (Statement stmt = conn.createStatement()) {
        ResultSet rs = stmt.executeQuery(sql);
        while (rs.next()) {
            System.out.println("id: " + rs.getInt("id"));
            System.out.println("姓名: " + rs.getString("name"));
            System.out.println("性别: " + rs.getString("gender"));
            System.out.println("出生日期: " + rs.getDate("birthdate"));
            System.out.println("身份证号: " + rs.getString("id_number"));
            System.out.println("电话号码: " + rs.getString("phone"));
            System.out.println("电子邮件地址: " + rs.getString("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()) {
            System.out.println("id: " + rs.getInt("id"));
            System.out.println("姓名: " + rs.getString("name"));
            System.out.println("性别: " + rs.getString("gender"));
            System.out.println("出生日期: " + rs.getDate("birthdate"));
            System.out.println("身份证号: " + rs.getString("id_number"));
            System.out.println("电话号码: " + rs.getString("phone"));
            System.out.println("电子邮件地址: " + rs.getString("email"));
            System.out.println();
        } else {
            System.out.println("身份证号对应的个人简历信息不存在。");
        }
    }
}

// 个人简历信息删除
private static void deleteResume(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()) {
            String deleteSql = "DELETE FROM resume WHERE id_number = ?";
            try (PreparedStatement deleteStmt = conn.prepareStatement(deleteSql)) {
                deleteStmt.setString(1, idNumber);
                deleteStmt.executeUpdate();
            }
            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("身份证号对应的个人简历信息不存在。");
        }
    }
}

}

说明：

  1. 该程序使用了SQL Server数据库，需要先在本地安装SQL Server，并创建名为“resume_db”的数据库。

  2. 程序中使用了JDBC API连接数据库，需要在项目中添加对应的JDBC驱动程序，例如sqljdbc4.jar。

  3. 程序中实现了个人简历信息的录入、增加、浏览、查询、删除和修改功能。个人简历信息包括姓名、性别、出生日期、身份证号、电话号码和电子邮件地址，存储在名为“resume”的表中。

  4. 程序中使用了PreparedStatement对象来避免SQL注入攻击。

  5. 程序中使用了try-with-resources语句来确保资源（例如Statement和PreparedStatement对象）在使用后能够自动关闭，从而避免资源泄漏。

  6. 程序中使用了java.util.Scanner类来读取用户输入

用Java做个人简历系统并能使数据连接sql server 做成一个完成的程序 以下是要求1个人简历信息录入功能--输入；2增加个人简历信息；3个人简历信息浏览--输出；4按身份证号查询信息；5个人简历信息删除；6个人简历信息修改；7数据保存8数据读取

原文地址: https://www.cveoy.top/t/topic/ggbp 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录