ॻ͔ͳ͚ΕͳΒͳ͍ ▸ ίωΫγϣϯऔಘɺ
εςʔτϝϯτऔಘɺ
ύϥϝʔλࢦఆɺ
݁Ռηοτͷऔಘɺ
݅ذͯ͠ɺ
֤ྻ͔ΒऔΓग़͠ɺ
ΤϯςΟςΟʹೖɺɾɾɾ 46 public Employee findById(Integer id) { Employee employee = null; // Γ String sql = "SELECT name, department_id," + " joined_date FROM employee WHERE id = ?"; try (Connection con = DriverManager .getConnection(URL, USER, PASSWORD); PreparedStatement ps = con.prepareStatement(sql)) { ps.setInt(1, id); ResultSet rs = ps.executeQuery(); if (rs.next()) { String name = rs.getString("name"); int departmentId = rs.getInt("department_id"); Date joinedDate = rs.getDate("joined_date"); employee = new Employee(); employee.setId(id); employee.setName(name); employee.setDepartmentId(departmentId); employee.setJoinedDate(joinedDate); } } catch (SQLException e) { // ຊདྷϩάग़ྗྫ֎ͷ࠶εϩʔΛߦ͏ e.printStackTrace(); } return employee; } ※ ※ʮϘΠϥʔϓϨʔτίʔυʯͱݺΕΔ