ɥozɐʞıɥ

2008-01-14 自分デフレスパイラル [長年日記]

_ 本日

体調戻らず。引き篭もり状態。

_ ひかぞー

5cmほど髪を切りました。1000YEN Cutです。美容室なんて勿体無い。

_ [Web] Mahalo

流行りそうなものなので、いちをーアカウントを確保しておいた。

_ [ORM] Hibernate Annotation ManyToMany(Joinしたものだけを取り出す)

ManyToManyはLAZY FETCH(遅延)もしくはEAGER FETCH(外部)になっちゃうのは避けられないようです。 HQLでManyToManyの場合に、必ず対象テーブルにあるレコードだけを引っ張ってくる方法が見つかりませんでした。（ヲレの知識、能力不足でしょう) Criteriaなら以下の方法で出来ました（っつーか、外部結合で結合条件にnot nullを入れただけ) 従業員の中でスキルを持っているレコードだけを抜き出す

package org.hikazoh;
 
import java.io.Serializable;
import javax.persistence.*;
import java.util.*;
 
import org.hibernate.annotations.Cascade;
import org.hibernate.annotations.Fetch;
import org.hibernate.annotations.FetchMode;
import org.hibernate.annotations.FilterJoinTable;
import org.hibernate.annotations.LazyCollection;
import org.hibernate.annotations.LazyCollectionOption;
import org.hibernate.annotations.NotFoundAction;
import org.hibernate.annotations.Where;
import org.hibernate.annotations.WhereJoinTable;
 
@Entity
@Table(name="Employee")
@NamedQuery(name="org.hikazoh.Employee",query="from org.hikazoh.Employee emp where emp.lastName like :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)
	@org.hibernate.annotations.Fetch(org.hibernate.annotations.FetchMode.JOIN)
	@JoinTable(name="Emp_Skill",
			joinColumns={@JoinColumn(name="EmpID")},
			inverseJoinColumns={@JoinColumn(name="SkillID")})
	private Set 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 getSkills() {
		return skills;
	}
	public void setSkills(Set skills) {
		this.skills = skills;
	}
}

@Fetchを入れておいて、Joinさせることがミソ？だけど外部結合になっちゃいますけど。

Criteriaで条件を無理矢理指定。

package org.hikazoh;
 
import org.hibernate.*;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.criterion.Expression;
import java.util.*;
 
public class SimpleCriteria {
 
	public static void main(String[] args) {
		SessionFactory sessionFactory =
			new AnnotationConfiguration()
			.addPackage("org.hikazoh")
			.addAnnotatedClass(Department.class)
			.addAnnotatedClass(Employee.class)
			.addAnnotatedClass(Skill.class)
			.buildSessionFactory();
		Transaction tx = null;
		Session session = sessionFactory.openSession();
		try{
			tx = session.beginTransaction();
			
			List emps = (List)session.createCriteria(Employee.class)
			.add(Expression.sql("skillid is not null")).list();
			for(Employee emp : emps){
				System.out.println("[first name]=" + emp.getFirstName());
				for(Skill skill : emp.getSkills()){
					System.out.println("[Skill Name]=" + skill.getName());
				}
			}
		}catch(Exception e){
			e.printStackTrace();
			System.out.println("[" + e.getLocalizedMessage() + "]");
		}finally{
			session.close();
		}
		sessionFactory.close();
	}
}

本日のツッコミ(全2件) [ツッコミを入れる]

_ zpoowin (2009-08-18 04:58)

http://www.zimbio.com/Loans/articles/0oGquJUjTaQ/EASY+ONLINE+PERSONAL+LOANS easy online personal loans http://www.zimbio.com/Loans/articles/0oGquJUjTaQ/EASY+ONLINE+PERSONAL+LOANS http://www.zimbio.com/Loans/articles/0oGquJUjTaQ/EASY+ONLINE+PERSONAL+LOANS http://www.zimbio.com/Loans/articles/0oGquJUjTaQ/EASY+ONLINE+PERSONAL+LOANS http://www.zimbio.com/Loans/articles/0oGquJUjTaQ/EASY+ONLINE+PERSONAL+LOANS http://www.zimbio.com/Loans/articles/CE7HsYeGD6g/PAYDAY+LOANS+NO+CREDIT+CHECK+NO+FAXING payday loans no credit check and no faxing http://www.zimbio.com/Loans/articles/CE7HsYeGD6g/PAYDAY+LOANS+NO+CREDIT+CHECK+NO+FAXING http://www.zimbio.com/Loans/articles/CE7HsYeGD6g/PAYDAY+LOANS+NO+CREDIT+CHECK+NO+FAXING http://www.zimbio.com/Loans/articles/CE7HsYeGD6g/PAYDAY+LOANS+NO+CREDIT+CHECK+NO+FAXING http://www.zimbio.com/Loans/articles/CE7HsYeGD6g/PAYDAY+LOANS+NO+CREDIT+CHECK+NO+FAXING http://www.zimbio.com/Loans/articles/s1QLTUdDUvl/ALTERNATIVES+PAYDAY+LOANS alternatives payday loans http://www.zimbio.com/Loans/articles/s1QLTUdDUvl/ALTERNATIVES+PAYDAY+LOANS http://www.zimbio.com/Loans/articles/s1QLTUdDUvl/ALTERNATIVES+PAYDAY+LOANS http://www.zimbio.com/Loans/articles/s1QLTUdDUvl/ALTERNATIVES+PAYDAY+LOANS http://www.zimbio.com/Loans/articles/s1QLTUdDUvl/ALTERNATIVES+PAYDAY+LOANS http://www.zimbio.com/Loans/articles/auNR6H25wfm/PAYDAY+LOAN+CASH+ADVANCE payday loan cash advance http://www.zimbio.com/Loans/articles/auNR6H25wfm/PAYDAY+LOAN+CASH+ADVANCE http://www.zimbio.com/Loans/articles/auNR6H25wfm/PAYDAY+LOAN+CASH+ADVANCE http://www.zimbio.com/Loans/articles/auNR6H25wfm/PAYDAY+LOAN+CASH+ADVANCE http://www.zimbio.com/Loans/articles/auNR6H25wfm/PAYDAY+LOAN+CASH+ADVANCE http://www.zimbio.com/Loans/articles/t7XmHgFUbgS/PAYDAY+LOAN+YES+LOANS payday loan yes loans http://www.zimbio.com/Loans/articles/t7XmHgFUbgS/PAYDAY+LOAN+YES+LOANS http://www.zimbio.com/Loans/articles/t7XmHgFUbgS/PAYDAY+LOAN+YES+LOANS http://www.zimbio.com/Loans/articles/t7XmHgFUbgS/PAYDAY+LOAN+YES+LOANS http://www.zimbio.com/Loans/articles/t7XmHgFUbgS/PAYDAY+LOAN+YES+LOANS http://www.zimbio.com/Loans/articles/MAa61RCyE4h/AMERICREDIT+LOCATIONS americredit locations http://www.zimbio.com/Loans/articles/MAa61RCyE4h/AMERICREDIT+LOCATIONS http://www.zimbio.com/Loans/articles/MAa61RCyE4h/AMERICREDIT+LOCATIONS http://www.zimbio.com/Loans/articles/MAa61RCyE4h/AMERICREDIT+LOCATIONS http://www.zimbio.com/Loans/articles/MAa61RCyE4h/AMERICREDIT+LOCATIONS http://www.zimbio.com/Loans/articles/I-tEjp-CN1p/MINNESOTA+PREDATORY+LENDING minnesota predatory lending http://www.zimbio.com/Loans/articles/I-tEjp-CN1p/MINNESOTA+PREDATORY+LENDING http://www.zimbio.com/Loans/articles/I-tEjp-CN1p/MINNESOTA+PREDATORY+LENDING http://www.zimbio.com/Loans/articles/I-tEjp-CN1p/MINNESOTA+PREDATORY+LENDING http://www.zimbio.com/Loans/articles/I-tEjp-CN1p/MINNESOTA+PREDATORY+LENDING http://www.zimbio.com/Loans/articles/P-O2n3KeNDl/PLS+PAYDAY+LOAN+STORE+LOCATIONS pls payday loan store locations http://www.zimbio.com/Loans/articles/P-O2n3KeNDl/PLS+PAYDAY+LOAN+STORE+LOCATIONS http://www.zimbio.com/Loans/articles/P-O2n3KeNDl/PLS+PAYDAY+LOAN+STORE+LOCATIONS http://www.zimbio.com/Loans/articles/P-O2n3KeNDl/PLS+PAYDAY+LOAN+STORE+LOCATIONS http://www.zimbio.com/Loans/articles/P-O2n3KeNDl/PLS+PAYDAY+LOAN+STORE+LOCATIONS http://www.zimbio.com/Loans/articles/p0911aJfXla/LOW+FEE+PAYDAY+LOANS low fee payday loans http://www.zimbio.com/Loans/articles/p0911aJfXla/LOW+FEE+PAYDAY+LOANS http://www.zimbio.com/Loans/articles/p0911aJfXla/LOW+FEE+PAYDAY+LOANS http://www.zimbio.com/Loans/articles/p0911aJfXla/LOW+FEE+PAYDAY+LOANS http://www.zimbio.com/Loans/articles/p0911aJfXla/LOW+FEE+PAYDAY+LOANS http://www.zimbio.com/Loans/articles/BlX3Vmnl0Jy/INSTANT+CASH+LOAN+STILL+PAYDAY instant cash loan still payday http://www.zimbio.com/Loans/articles/BlX3Vmnl0Jy/INSTANT+CASH+LOAN+STILL+PAYDAY http://www.zimbio.com/Loans/articles/BlX3Vmnl0Jy/INSTANT+CASH+LOAN+STILL+PAYDAY http://www.zimbio.com/Loans/articles/BlX3Vmnl0Jy/INSTANT+CASH+LOAN+STILL+PAYDAY http://www.zimbio.com/Loans/articles/BlX3Vmnl0Jy/INSTANT+CASH+LOAN+STILL+PAYDAY http://www.zimbio.com/Loans/articles/9JCmwKEunrF/FAXLESS+ONLINE+PAYDAY+LOANS+CANADA faxless online payday loans in canada http://www.zimbio.com/Loans/articles/9JCmwKEunrF/FAXLESS+ONLINE+PAYDAY+LOANS+CANADA http://www.zimbio.com/Loans/articles/9JCmwKEunrF/FAXLESS+ONLINE+PAYDAY+LOANS+CANADA http://www.zimbio.com/Loans/articles/9JCmwKEunrF/FAXLESS+ONLINE+PAYDAY+LOANS+CANADA http://www.zimbio.com/Loans/articles/9JCmwKEunrF/FAXLESS+ONLINE+PAYDAY+LOANS+CANADA http://www.zimbio.com/Loans/articles/ehOLLwq_a5c/CASH+ADVANCE+PROS+AMERICA cash advance pros america http://www.zimbio.com/Loans/articles/ehOLLwq_a5c/CASH+ADVANCE+PROS+AMERICA http://www.zimbio.com/Loans/articles/ehOLLwq_a5c/CASH+ADVANCE+PROS+AMERICA http://www.zimbio.com/Loans/articles/ehOLLwq_a5c/CASH+ADVANCE+PROS+AMERICA http://www.zimbio.com/Loans/articles/ehOLLwq_a5c/CASH+ADVANCE+PROS+AMERICA http://www.zimbio.com/Loans/articles/T2Bt_xyyRzB/PAYDAY+LOAN+CASH+ADVANCE+ONLINE payday loan cash advance online http://www.zimbio.com/Loans/articles/T2Bt_xyyRzB/PAYDAY+LOAN+CASH+ADVANCE+ONLINE http://www.zimbio.com/Loans/articles/T2Bt_xyyRzB/PAYDAY+LOAN+CASH+ADVANCE+ONLINE http://www.zimbio.com/Loans/articles/T2Bt_xyyRzB/PAYDAY+LOAN+CASH+ADVANCE+ONLINE http://www.zimbio.com/Loans/articles/T2Bt_xyyRzB/PAYDAY+LOAN+CASH+ADVANCE+ONLINE http://www.zimbio.com/Loans/articles/tgE0U6j8MGW/NO+INTEREST+FIRST+PAYDAY+LOAN no interest on first payday loan http://www.zimbio.com/Loans/articles/tgE0U6j8MGW/NO+INTEREST+FIRST+PAYDAY+LOAN http://www.zimbio.com/Loans/articles/tgE0U6j8MGW/NO+INTEREST+FIRST+PAYDAY+LOAN http://www.zimbio.com/Loans/articles/tgE0U6j8MGW/NO+INTEREST+FIRST+PAYDAY+LOAN http://www.zimbio.com/Loans/articles/tgE0U6j8MGW/NO+INTEREST+FIRST+PAYDAY+LOAN http://www.zimbio.com/Loans/articles/RQl-GRIzvr5/CHECK+CASHING+SOFTWARE+REVIEWSPAYDAY check cashing software reviewspayday http://www.zimbio.com/Loans/articles/RQl-GRIzvr5/CHECK+CASHING+SOFTWARE+REVIEWSPAYDAY http://www.zimbio.com/Loans/articles/RQl-GRIzvr5/CHECK+CASHING+SOFTWARE+REVIEWSPAYDAY http://www.zimbio.com/Loans/articles/RQl-GRIzvr5/CHECK+CASHING+SOFTWARE+REVIEWSPAYDAY http://www.zimbio.com/Loans/articles/RQl-GRIzvr5/CHECK+CASHING+SOFTWARE+REVIEWSPAYDAY Please, send your abuse here!!! send.your.abuse.here@gmail.com

_ ojbthpm (2009-08-18 05:33)