private SessionFactory sessionFactory;

private HibernateTransactionManager transactionManager; public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
} public void setTransactionManager(HibernateTransactionManager transactionManager) {
this.transactionManager = transactionManager;
}
String sql = "from com.yourcompany.struts.model.User as us";
try
{
HibernateTemplate ht = new HibernateTemplate(sessionFactory);
List ls = ht.find(sql);
return ls;
}
catch(Exception e)
{
e.printStackTrace();
transactionManager.rollback(dts);
return null;
}
finally
{
transactionManager.commit(dts);
}