数据库课程设计【简单的人事管理系统】/ MySQL / Java 实现对员工信息的增删改查

package System; import System.Model.Staff; import com.mysql.jdbc.jdbc2.optional.MysqlDataSource; import javax.sql.DataSource; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Scanner; public class Connection { // 先定义一个数据源对象 private static DataSource dataSource = null; // 数据库的用户名 private static final String USER = "root"; // 数据库的密码 private static final String PASSWORD = "123456"; // 数据库连接字符串 //private static final String URL = "jdbc:mysql://127.0.0.1:3306/management_system?characterEncoding=utf8&useSSL=true&serverTimezone=Asia/Shanghai"; private static final String URL = "jdbc:mysql://127.0.0.1:3306/management_system?characterEncoding=utf-8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai"; public static void main(String[] args) throws SQLException { // 1. 初化始数据源 MysqlDataSource myDataSource = new MysqlDataSource(); // 2. 设置连接的参数 myDataSource.setURL(URL); myDataSource.setUser(USER); myDataSource.setPassword(PASSWORD); // 3. 把构建好的Mysql数据源赋值给JDBC中的datasource dataSource = myDataSource; java.sql.Connection connection = null; // Statement statement = null; // 预处理对象 PreparedStatement statement = null; ResultSet resultSet = null; try { // 1. 通过数据源获取一个数据库连接 connection = dataSource.getConnection(); // 接收用户输入的值getConnection System.out.println("请输入工号->"); Scanner scanner = new Scanner(System.in); String work_num = scanner.next(); // 2. 定义SQL语句 String sql = "select * from staff where work_num = ?"; System.out.println("sql-->" + sql); // 3. 获取statement对象 // statement = connection.createStatement(); // 获取一个预处理对象 statement = connection.prepareStatement(sql); // 处理占位符的值 statement.setString(1, work_num); // 4. 执行SQL resultSet = statement.executeQuery(); // 5. 解析结果集,resultSet.next()表示结果集中是否有记录 if (resultSet.next()) { // 创建表示结果的JAVA对象 Staff staff = new Staff(); // 依次读取结果集中的数据并赋值给JAVA对象 //id,name,sex,id_num,birthday,work_num,department,salary,post,address,phone_num staff.setId(resultSet.getInt(1)); staff.setName(resultSet.getString(2)); staff.setSex(resultSet.getString(3)); staff.setId_num(resultSet.getString(4)); staff.setBirthday(resultSet.getDate(5)); staff.setWork_num(resultSet.getInt(6)); staff.setDepartment(resultSet.getString(7)); staff.setSalary(resultSet.getBigDecimal(8)); staff.setPost(resultSet.getString(9)); staff.setAddress(resultSet.getString(10)); staff.setPhone_num(resultSet.getString(7)); // 打印结果 System.out.println(staff); } } catch (SQLException e) { e.printStackTrace(); } finally { // 依次关闭资源 if (resultSet != null) { try { resultSet.close(); } catch (SQLException e) { e.printStackTrace(); } } if (statement != null) { try { statement.close(); } catch (SQLException e) { e.printStackTrace(); } } if (connection != null) { connection.close(); } } } }