• 日期: 2027-08-24
  • 标签: 常规

import javax.swing.; import javax.swing.border.EmptyBorder; import java.awt.; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; 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';

private static JFrame frame;
private static JPanel panel;
private static JTextArea textArea;

public static void main(String[] args) {
    try {
        UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
    } catch (Exception e) {
        e.printStackTrace();
    }

    frame = new JFrame('个人简历管理系统');
    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    frame.setSize(800, 600);

    panel = new JPanel(new BorderLayout());
    panel.setBorder(new EmptyBorder(20, 20, 20, 20));

    textArea = new JTextArea();
    textArea.setEditable(false);
    textArea.setFont(new Font('宋体', Font.PLAIN, 16));
    JScrollPane scrollPane = new JScrollPane(textArea);
    panel.add(scrollPane, BorderLayout.CENTER);

    JMenuBar menuBar = new JMenuBar();
    frame.setJMenuBar(menuBar);

    JMenu menuFile = new JMenu('文件');
    menuBar.add(menuFile);

    JMenuItem menuItemExit = new JMenuItem('退出');
    menuItemExit.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent e) {
            System.exit(0);
        }
    });
    menuFile.add(menuItemExit);

    JMenu menuResume = new JMenu('个人简历');
    menuBar.add(menuResume);

    JMenuItem menuItemInsert = new JMenuItem('录入');
    menuItemInsert.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent e) {
            try {
                insertResume(getConnection(), new Scanner(System.in));
                viewResume(getConnection());
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
    });
    menuResume.add(menuItemInsert);

    JMenuItem menuItemView = new JMenuItem('浏览');
    menuItemView.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent e) {
            try {
                viewResume(getConnection());
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
    });
    menuResume.add(menuItemView);

    JMenuItem menuItemQuery = new JMenuItem('查询');
    menuItemQuery.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent e) {
            try {
                queryResume(getConnection(), new Scanner(System.in));
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
    });
    menuResume.add(menuItemQuery);

    JMenuItem menuItemDelete = new JMenuItem('删除');
    menuItemDelete.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent e) {
            try {
                deleteResume(getConnection(), new Scanner(System.in));
                viewResume(getConnection());
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
    });
    menuResume.add(menuItemDelete);

    JMenuItem menuItemUpdate = new JMenuItem('修改');
    menuItemUpdate.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent e) {
            try {
                updateResume(getConnection(), new Scanner(System.in));
                viewResume(getConnection());
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
    });
    menuResume.add(menuItemUpdate);

    JMenuItem menuItemAdd = new JMenuItem('增加');
    menuItemAdd.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent e) {
            try {
                addResume(getConnection(), new Scanner(System.in));
                viewResume(getConnection());
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
    });
    
    menuResume.add(menuItemAdd);

    frame.setContentPane(panel);
    frame.setVisible(true);
}
private static Connection getConnection() throws SQLException {
    return DriverManager.getConnection(DB_URL, USER, PASSWORD);
}

// 创建表
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();
    }
    textArea.setText("个人简历信息录入成功。\n");
}

// 个人简历信息浏览
private static void viewResume(Connection conn) throws SQLException {
    try (Statement stmt = conn.createStatement()) {
        String sql = "SELECT * FROM resume";
        ResultSet rs = stmt.executeQuery(sql);
        StringBuilder sb = new StringBuilder();
        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');
            sb.append('ID：').append(id).append('\n');
            sb.append('姓名：').append(name).append('\n');
            sb.append('性别：').append(gender).append('\n');
            sb.append('出生日期：').append(birthdate).append('\n');
            sb.append('身份证号：').append(idNumber).append('\n');
            sb.append('电话号码：').append(phone).append('\n');
            sb.append('电子邮件地址：').append(email).append('\n\n');
        }
        textArea.setText(sb.toString());
    }
}

// 按身份证号查询信息
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();
        StringBuilder sb = new StringBuilder();
        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');
            sb.append('ID：').append(id).append('\n');
            sb.append('姓名：').append(name).append('\n');
            sb.append('性别：').append(gender).append('\n');
            sb.append('出生日期：').append(birthdate).append('\n');
            sb.append('身份证号：').append(idNumber).append('\n');
            sb.append('电话号码：').append(phone).append('\n');
            sb.append('电子邮件地址：').append(email).append('\n\n');
        } else {
            sb.append("身份证号对应的个人简历信息不存在。\n");
        }
        textArea.setText(sb.toString());
    }
}

// 个人简历信息删除
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) {
            textArea.setText("个人简历信息删除成功。\n");
        } else {
            textArea.setText("身份证号对应的个人简历信息不存在。\n");
        }
    }
}

// 个人简历信息修改
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("请输入要修改的项（姓名(name)/性别(gender)/出生日期(birthdate)/电话号码(phone)/电子邮件地址(email)）：");
            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();
            }
            textArea.setText("个人简历信息修改成功。\n");
        } else {
            textArea.setText("身份证号对应的个人简历信息不存在。\n");
        }
    }
}

// 增加个人简历信息
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("请输入要增加的项（姓名(name)/性别(gender)/出生日期(birthdate)/电话号码(phone)/电子邮件地址(email)）：");
            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("身份证号对应的个人简历信息不存在。");
        }
    }
}

} 这是java代码完成以下任务 实训报告撰写内容：系统功能介绍、功能模块划分(模块层次图)、功能模块分析(流程图)、主要功能的核心代码、程序各功能模块运行的截图、系统测试过程、心得体会、程序清单(作为附件部分) 做一个完成的实训报告内容：实训报告：个人简历管理系统

一、系统功能介绍

个人简历管理系统是一款基于Java语言和SQL Server数据库的应用程序，旨在帮助用户轻松管理个人简历信息。该系统具有以下主要功能：

  1. 个人简历信息录入：用户可以输入个人姓名、性别、出生日期、身份证号、电话号码和电子邮件地址等信息，将其保存到数据库中。

  2. 个人简历信息浏览：用户可以查看数据库中所有个人简历信息。

  3. 按身份证号查询信息：用户可以输入身份证号查询对应的个人简历信息。

  4. 个人简历信息删除：用户可以输入身份证号删除对应的个人简历信息。

  5. 个人简历信息修改：用户可以输入身份证号和要修改的项和值，修改对应的个人简历信息。

  6. 增加个人简历信息：用户可以输入身份证号和要增加的项和值，增加对应的个人简历信息。

二、功能模块划分

个人简历管理系统的功能模块如下图所示：

image

三、功能模块分析

  1. 个人简历信息录入

image

  1. 个人简历信息浏览

image

  1. 按身份证号查询信息

image

  1. 个人简历信息删除

image

  1. 个人简历信息修改

image

  1. 增加个人简历信息

image

四、主要功能的核心代码

  1. 个人简历信息录入
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();
        }
        textArea.setText("个人简历信息录入成功。\n");
    }
  1. 个人简历信息浏览
private static void viewResume(Connection conn) throws SQLException {
        try (Statement stmt = conn.createStatement()) {
            String sql = "SELECT * FROM resume";
            ResultSet rs = stmt.executeQuery(sql);
            StringBuilder sb = new StringBuilder();
            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');
                sb.append('ID：').append(id).append('\n');
                sb.append('姓名：').append(name).append('\n');
                sb.append('性别：').append(gender).append('\n');
                sb.append('出生日期：').append(birthdate).append('\n');
                sb.append('身份证号：').append(idNumber).append('\n');
                sb.append('电话号码：').append(phone).append('\n');
                sb.append('电子邮件地址：').append(email).append('\n\n');
            }
            textArea.setText(sb.toString());
        }
    }
  1. 按身份证号查询信息
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();
            StringBuilder sb = new StringBuilder();
            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');
                sb.append('ID：').append(id).append('\n');
                sb.append('姓名：').
Java 个人简历管理系统 - 轻松管理您的个人信息

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

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