packagecom.xtdao;importjava.util.Iterator;importjava.util.List;importcom.xthu.HibernateUtil;importorg.hibernate.Query;importorg.hibernate.Session;importcom.xt.product;pub...
package com.xtdao;
import java.util.Iterator;
import java.util.List;
import com.xthu.HibernateUtil;
import org.hibernate.Query;
import org.hibernate.Session;
import com.xt.product;
public class productDaoimpl implements productDao {
public void save(product p) {
Session session = HibernateUtil.getSession();
session.beginTransaction();
session.save(p);
session.getTransaction().commit();
HibernateUtil.closeSession(session);
}
public void delete(String id) {
Session session = HibernateUtil.getSession();
session.beginTransaction();
String hql = "DELETE product WHERE id=?";
Query q = session.createQuery(hql);
q.executeUpdate();
session.beginTransaction().commit();
HibernateUtil.closeSession(session);
}
public void update(product p) {
Session session = HibernateUtil.getSession();
session.beginTransaction();
session.update(p);
session.getTransaction().commit();
HibernateUtil.closeSession(session);
}
public List queryAll() {
Session session = HibernateUtil.getSession();
String hql = "FROM product as pro";
Query q = session.createQuery(hql);
List list = q.list();
HibernateUtil.closeSession(session);
return list;
}
public product queryById(String id) {
Session session = HibernateUtil.getSession();
String hql = "FROM product as pro WHERE poo.id=?";
Query q = session.createQuery(hql);
//String id;
q.setString(0, id);
List list = q.list();
product p = null;
Iterator iter = list.iterator();
if(iter.hasNext()) {
p = (product) iter.next();
}
HibernateUtil.closeSession(session);
return p;
}
}
展开