|
|
ToDo:
|
|
ɥozɐʞıɥ
2004-01-05 障篌
_ 御篋
蚊若
蚊峨檎Boot/strong>с 蘂ｃ
蚊紊羶c鎛⒢襲帥Boot 腟綣桁Boot蕋篆
<MUZA 綏
Open若
ャ⒢ｃ ｃ綺⒢οfficeBuilding㏍
_ ＜ｃ 薈500YEN560YEN茵1骸ャ障筝羝⒤㍽吟
㏍ DVD若取卸ｃ
本日のツッコミ(全2件) [ツッコミを入れる]
2008-01-05 萎えから抜けられないまま冬休みが終わるヨー
_ [ORM] Hibernate Annotation(ManyToMany)
昨日、とりあえずTableだけは作ったので実装。関連テーブルについてはなんかウマい事やってくれるみたい。従業員
package org.hikazoh;
import java.io.Serializable;
import javax.persistence.*;
import java.util.*;
@Entity
@Table(name="Employee")
@NamedQuery(name="org.hikazoh.Employee",query="from org.hikazoh.Employee where lastName =:lastname")
public class Employee implements Serializable {
@Id
@Column(name="ID")
@GeneratedValue(strategy=GenerationType.IDENTITY)
private Integer iD;
@Column(name="FirstName")
private String firstName;
@Column(name="LastName")
private String lastName;
@ManyToOne(targetEntity=Department.class)
@JoinColumn(name="departmentID",referencedColumnName="ID")
private Department department;
@ManyToMany(targetEntity=Skill.class)
@JoinTable(name="Emp_Skill",
joinColumns={@JoinColumn(name="EmpID")},
inverseJoinColumns={@JoinColumn(name="SkillID")})
private Set<skill> skills;
public Integer getID() {
return iD;
}
public void setID(Integer id) {
iD = id;
}
public String getFirstName() {
return firstName;
}
public void setFirstName(String firstName) {
this.firstName = firstName;
}
public String getLastName() {
return lastName;
}
public void setLastName(String lastName) {
this.lastName = lastName;
}
public Department getDepartment() {
return department;
}
public void setDepartment(Department department) {
this.department = department;
}
public Set<skill> getSkills() {
return skills;
}
public void setSkills(Set<skill> skills) {
this.skills = skills;
}
}
</skill></skill></skill>
スキル
package org.hikazoh;
import java.io.Serializable;
import javax.persistence.*;
import java.util.*;
@Entity
@Table(name="Skill")
public class Skill implements Serializable {
@Id
@Column(name="ID")
@GeneratedValue(strategy=GenerationType.IDENTITY)
private Integer Id;
@Column(name="NAME")
private String Name;
@ManyToMany(targetEntity=Employee.class)
@JoinTable(name="Emp_Skill",
joinColumns={@JoinColumn(name="SkillID")},
inverseJoinColumns={@JoinColumn(name="EmpID")})
private Set<employee> employees;
public String getName() {
return Name;
}
public void setName(String name) {
Name = name;
}
public Set<employee> getEmployees() {
return employees;
}
public void setEmployees(Set<employee> employees) {
this.employees = employees;
}
public Integer getId() {
return Id;
}
}
</employee></employee></employee>
エントリーサンプル(関連テーブルに関しては、双方向だからかな？どっちかのSetに入れておけばちゃんとINSERTしてくれました)
package org.hikazoh;
import java.util.*;
import org.hibernate.*;
import org.hibernate.cfg.AnnotationConfiguration;
public class ManyToManyTest {
public static void main(String[] args) {
SessionFactory sessionFactory =
new AnnotationConfiguration()
.addPackage("org.hikazoh")
.addAnnotatedClass(Skill.class)
.addAnnotatedClass(Employee.class)
.addAnnotatedClass(Department.class)
.buildSessionFactory();
Transaction tx = null;
Session session = sessionFactory.openSession();
try{
tx = session.beginTransaction();
Department dept = new Department();
dept.setName("Sales");
session.save(dept);
Employee emp = new Employee();
emp.setFirstName("Hika");
emp.setLastName("Zou");
emp.setDepartment(dept);
Skill skill = new Skill();
skill.setName("ServerManagement");
session.save(emp);
Set<employee> emps = new HashSet<employee>();
emps.add(emp);
skill.setEmployees(emps);
session.save(skill);
tx.commit();
}catch(Exception e){
e.printStackTrace();
System.out.println("[" + e.getLocalizedMessage() + "]" );
if ( tx != null ){
tx.rollback();
}
}finally{
session.close();
}
sessionFactory.close();
}
}
</employee></employee>
_ [本] 誰がために鐘は鳴る (下巻) (新潮文庫)
上下巻を本日読了。タブンいま訳しなおすと４日間の濃密な日々はカナーリ官能な表現になりそう。内容的には好きな作品です。村上春樹の源流を辿ったような気がします。
[ツッコミを入れる]
2010-01-05 絶賛営業中
_ 本日
閉店は23時過ぎ。帰ってきたら日付変更線を超えていた。
_ [生活] 第22回 保険に入らない選択ってどうなの？［前編］ | web R25
これもアリかも。
[ツッコミを入れる]
Before...
_ anonimous [Those average every day people also used that exact same h..]
_ anonimous [Average every day people also used that exact same http://..]
_ anonimous [Every day people also used that exact same http://hawley.2..]
_ anonimous [Used that exact same http://roadshow.250Free.com/shopping-..]
_ anonimous [apple also used that exact same http://emilio.250Free.com/..]