public class TestDao extends HibernateDaoSupport
{
public void save(Test obj)
{
Session sess = this.getSessionFactory().openSession();
Transaction tran = sess.beginTransaction();
try
{
sess.saveOrUpdate(obj);
tran.commit();
}
catch (HibernateException e)
{
tran.rollback();
}
finally
{
sess.close();
}
}
public void delete(Test obj)
{
Session sess = this.getSessionFactory().openSession();
Transaction tran = sess.beginTransaction();
try
{
sess.delete(obj);
tran.commit();
}
catch (HibernateException e)
{
tran.rollback();
}
finally
{
sess.close();
}
}
public Test get(int id)
{
Session sess = this.getSessionFactory().openSession();
try
{
return (Test) sess.get(Test.class, id);
}
finally
{
sess.close();
}
}
private List<Test> findAll_lh(String where)
{
Session sess = this.getSessionFactory().openSession();
Collection result = new ArrayList();
try
{
Query query = sess.createQuery(" From Test a,Test3 b where a.id=b.testId " + where + " order by a.id ");
result = query.list();
}
finally
{
sess.close();
}
List<Test> list = new ArrayList<Test>();
ArrayList sList = (ArrayList) result;
Iterator iterator1 = sList.iterator();
while (iterator1.hasNext())
{
Object[] o = (Object[]) iterator1.next();
Test test = (Test) o[0];
Test3 test3 = (Test3) o[1];
test.setTest3(test3);
list.add(test);
System.out.println("0000000000000=" + test.getTest3().getMingCheng());
}
return list;
}
private List<Test> findAll(String where, Pager pager)
{
String hSql = " From Test a where 1=1 " + where + " order by id ";
pager.setRowCount(getAllRowCount(hSql));
Session sess = this.getSessionFactory().openSession();
try
{
Query query = sess.createQuery(hSql);
query.setFirstResult(pager.getFirstResult());
query.setMaxResults(pager.getPageSize());
return query.list();
}
finally
{
sess.close();
}
}
//��������
public int getAllRowCount(String hql)
{
return getHibernateTemplate().find(hql).size();
}
public List<Test> getList(String startTime, String endTime, String mc, Pager pager)
{
String where = " ";
where = where + " and " + TypeChange.DateBetweenSql("a.riQi", startTime, endTime);
if (!TypeChange.toNotNullDao(mc).equals(""))
{
where = where + " and a.mingCheng like '%" + TypeChange.toNotNullDao(mc) + "%'";
}
return this.findAll(where, pager);
}
}