public String show(Long me, Long friendNum) {
Friend checkedFriend = new Friend();
Session session = HibernateUtil.getSessionFactory().openSession();
Transaction tx = session.beginTransaction();
StringBuffer buf = new StringBuffer();
buf.append("from Friend f ");
buf.append("where f.request =:me ");
buf.append("and f.accept =:friendNum ");
String hql = buf.toString();
checkedFriend =
(Friend)
session
.createQuery(hql)
.setLong("me", me)
.setLong("friendNum", friendNum)
.uniqueResult();
tx.commit();
session.close();
if (checkedFriend == null) {
return "false";
} else {
return "true";
}
}
public String create(Domain domain) {
Session session = HibernateUtil.getSessionFactory().openSession();
Transaction tx = session.beginTransaction();
session.save(domain);
tx.commit();
session.close();
return "true";
}
public List<Domain> index(ID id) {
Session session = HibernateUtil.getSessionFactory().openSession();
Transaction tx = session.beginTransaction();
List<Domain> domainList =
session
.createQuery("from " + domainName + " d where d.id = :id")
.setParameter("id", id)
.list();
tx.commit();
session.close();
return domainList;
}
public Domain show(ID id) {
Session session = HibernateUtil.getSessionFactory().openSession();
Transaction tx = session.beginTransaction();
Domain domain =
(Domain)
session
.createQuery("from " + domainName + " d where d.id = :id")
.setParameter("id", id)
.uniqueResult();
tx.commit();
session.close();
return domain;
}
public List<MemberAdmin> delete(Long id) {
Session session = HibernateUtil.getSessionFactory().openSession();
Transaction tx = session.beginTransaction();
MemberAdmin num = new MemberAdmin();
num = (MemberAdmin) session.load(MemberAdmin.class, id);
session.delete(num);
tx.commit();
session.close();
return null;
}
public Domain find(ID id1, ID id2) {
Session session = HibernateUtil.getSessionFactory().openSession();
Transaction tx = session.beginTransaction();
StringBuffer buf = new StringBuffer();
buf.append("from " + domainName + " f ");
buf.append("where f.request =:me ");
buf.append("and f.accept =:friendNum ");
String hql = buf.toString();
Domain domain =
(Domain)
session
.createQuery("from " + domainName + " d where d.id = :id")
.setParameter("id", id1)
.uniqueResult();
tx.commit();
session.close();
return domain;
}
