package com.accp.dao;
import java.util.List;
import javax.jms.Session;
import org.hibernate.Criteria;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Projection;
import org.hibernate.criterion.Projections;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.accp.entity.Users;
import com.accp.entity.Utype;
import com.opensymphony.xwork2.ActionContext;
public class UtypeDao extends HibernateDaoSupport {
public List<Utype> find() {
DetachedCriteria criteria = DetachedCriteria.forClass(Utype.class);
return getHibernateTemplate().findByCriteria(criteria);
}
public static void main(String[] args) {
ApplicationContext ac = new ClassPathXmlApplicationContext(
"applicationContext.xml");
UtypeDao dao = ac.getBean(UtypeDao.class);
dao.test();
}
/**
* criteria集合查询
*/
// public void test(){
// org.hibernate.Session session=super.getSession();
// Criteria c=session.createCriteria(Utype.class);
// List<Utype> list=c.list();
// for (Utype utypeDao : list) {
// System.out.println(utypeDao.getName());
// }
// super.releaseSession(session);
//
//
// }
/**
* criteria条件查询
*/
public void test() {
org.hibernate.Session session = super.getSession();
Criteria criteria = session.createCriteria(Utype.class);
criteria.setProjection(Projections.projectionList().add(
Projections.property("id")).add(Projections.property("name")));
List<Object[]> list = criteria.list();
for (Object[] objects : list) {
System.out.println(objects[0]);
System.out.println(objects[1]);
}
super.releaseSession(session);
}
}