67,512
社区成员
发帖
与我相关
我的任务
分享
lstResult = this.getHibernateTemplate().find(strHql);
private static final Logger logger = Logger.getLogger(ShowDaoImpl.class);
@SuppressWarnings("unused")
private SessionFactory sessionFactory = null;
public void setSessionFactory(SessionFactory sessionFactory) {
if (logger.isDebugEnabled()) {
logger.debug("setSessionFactory(SessionFactory) - start");
}
this.sessionFactory = sessionFactory;
if (logger.isDebugEnabled()) {
logger.debug("setSessionFactory(SessionFactory) - end");
}
}
@SuppressWarnings("unchecked")
public List getDatas(String strHql) {
if (logger.isDebugEnabled()) {
logger.debug("getDatas(String) - start");
}
System.out.println( "strHql ====== " + strHql );
List lstResult = new ArrayList();
try{
lstResult = this.getHibernateTemplate().find(strHql);
System.out.println("HQL语句执行完毕 DaoImpl");
if (logger.isDebugEnabled()) {
logger.debug("getDatas(String) - end");
}
//lstResult = sessionFactory.getCurrentSession().createQuery(strHql).list();
return lstResult;
}
catch(Exception e){
logger.error("getDatas(String)", e);
System.out.println(e.toString());
if (logger.isDebugEnabled()) {
logger.debug("getDatas(String) - end");
}
return null;
}
private ShowDao showDao = null;
public ShowDao getShowDao() {
return showDao;
}
public void setShowDao(ShowDao showDao) {
this.showDao = showDao;
}
public ShowBo(){
}
@SuppressWarnings("unchecked")
public void setDatasToForm(ShowActionForm actionForm){
String strHql = "FROM com.leonguo.entity.Emp";
List lstResult = showDao.getDatas(strHql);
System.out.println("strHql 执行完成!Bo");
List<ResultData> lstDatas = new ArrayList<ResultData>();
for (int i = 0; i < lstResult.size(); i++) {
Emp empData = new Emp();
empData = (Emp) lstResult.get(i);
Department departData = new Department();
departData = empData.getDepartment();
ResultData resultData = new ResultData();
resultData.setEmpId(empData.getEmpId());
resultData.setEmpName(empData.getEmpName());
resultData.setDepartmentName(departData.getDepartmentName());
lstDatas.add(resultData);
}
actionForm.setLstDatas(lstDatas);
}
<?xml version="1.0" encoding="GB2312"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">
<bean name="/showAction" class="com.leonguo.struts.action.ShowAction">
<property name="showBo" ref="showBo">
</property>
</bean>
<bean id="showBo" class="com.leonguo.bo.ShowBo">
<property name="showDao">
<ref bean="showDaoProxy"/>
</property>
</bean>
<bean id="showDao" class="com.leonguo.dao.ShowDaoImpl">
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>
<bean id="dataSourse"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver">
</property>
<property name="url"
value="jdbc:microsoft:sqlserver://localhost:1433">
</property>
<property name="username" value="sa"></property>
<property name="password" value="sa"></property>
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean" >
<property name="dataSource">
<ref bean="dataSourse" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/leonguo/entity/Department.hbm.xml</value>
<value>com/leonguo/entity/Emp.hbm.xml</value>
<value>com/leonguo/entity/Mession.hbm.xml</value></list>
</property>
</bean>
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean>
<bean id="showDaoProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager" />
</property>
<property name="target">
<ref local="showDao" />
</property>
<property name="transactionAttributes">
<props>
<prop key="save*">PROPAGATION_REQUIRED,-OrderException,-OrderMinimumAmountException</prop>
<prop key="add*">PROPAGATION_REQUIRED,-OrderException,-OrderMinimumAmountException</prop>
<prop key="modify*">PROPAGATION_REQUIRED,-OrderException,-OrderMinimumAmountException</prop>
</props>
</property>
</bean>
</beans>
private ShowBo showBo = null;
public ShowBo getShowBo() {
return showBo;
}
public void setShowBo(ShowBo showBo) {
this.showBo = showBo;
}
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
ShowActionForm actionForm = (ShowActionForm) form;
try {
showBo.setDatasToForm(actionForm);
return mapping.findForward("success");
} catch (Exception e) {
System.out.println(e.toString());
return mapping.findForward("default");
}
}
<?xml version="1.0" encoding="GB2312"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">
<bean name="/showAction" class="com.leonguo.struts.action.ShowAction">
<property name="showBo" ref="showBo">
</property>
</bean>
<bean id="showBo" class="com.leonguo.bo.ShowBo">
<property name="showDao">
<ref bean="showDaoProxy"/>
</property>
</bean>
<bean id="showDao" class="com.leonguo.dao.ShowDaoImpl">
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>
<bean id="dataSourse"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver">
</property>
<property name="url"
value="jdbc:microsoft:sqlserver://localhost:1433">
</property>
<property name="username" value="sa"></property>
<property name="password" value="sa"></property>
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean" >
<property name="dataSource">
<ref bean="dataSourse" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/leonguo/entity/Department.hbm.xml</value>
<value>com/leonguo/entity/Emp.hbm.xml</value>
<value>com/leonguo/entity/Mession.hbm.xml</value></list>
</property>
</bean>
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean>
<bean id="showDaoProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager" />
</property>
<property name="target">
<ref local="showDao" />
</property>
<property name="transactionAttributes">
<props>
<prop key="save*">PROPAGATION_REQUIRED,-OrderException,-OrderMinimumAmountException</prop>
<prop key="add*">PROPAGATION_REQUIRED,-OrderException,-OrderMinimumAmountException</prop>
<prop key="modify*">PROPAGATION_REQUIRED,-OrderException,-OrderMinimumAmountException</prop>
</props>
</property>
</bean>
</beans>
private ShowBo showBo = null;
public ShowBo getShowBo() {
return showBo;
}
public void setShowBo(ShowBo showBo) {
this.showBo = showBo;
}
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
ShowActionForm actionForm = (ShowActionForm) form;
try {
showBo.setDatasToForm(actionForm);
return mapping.findForward("success");
} catch (Exception e) {
System.out.println(e.toString());
return mapping.findForward("default");
}
}