(C) CASAREAL, Inc. All rights reserved.
#ccc_f1
+%#$ͷ
▸ ࣅͨΑ͏ͳίʔυΛຖճ
ॻ͔ͳ͚ΕͳΒͳ͍
▸ ίωΫγϣϯऔಘɺ
εςʔτϝϯτऔಘɺ
ύϥϝʔλࢦఆɺ
݁Ռηοτͷऔಘɺ
݅ذͯ͠ɺ
֤ྻ͔ΒऔΓग़͠ɺ
ΤϯςΟςΟʹೖɺɾɾɾ
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;
}
※
※ʮϘΠϥʔϓϨʔτίʔυʯͱݺΕΔ
masatoshitada
tarappo
daihiraoka
marikashiotsuki
line_developers
hankehly
optim
tsubakimoto_s
ohmori_yusuke
microcms
oracle4engineer
non97
garrettdimon
rocio
maggiecrowley
bcantrill
eileencodes
lemiorhan
aleyda
mojombo
paigeccino
holman
kneath
sonatard