- 一。代码分析。
- package org.hxwl.tm.DAOImpl;
import java.util.List;
import org.hibernate.Query;
import org.hxwl.tm.IDAO.ITeacherDAO;
import org.hxwl.tm.vo.Teacher;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
public class TeacherDAOImpl extends HibernateDaoSupport implements ITeacherDAO {
@Override
public void delete(String name) throws Exception {
String hsql = "delete from Teacher as t where t.name = ?";
Query q = super.getSession().createQuery(hsql);
q.setString(0, name);
q.executeUpdate();
}
@Override
public List findAll() throws Exception {
String hsql = "from Teacher";
Query q = super.getSession().createQuery(hsql);
List list = q.list();
return list;
}
@Override
public Teacher findByName(String name) throws Exception {
String hsql = "from Teacher as t where t.name = ?";
Query q = super.getSession().createQuery(hsql);
q.setString(0, name);
Teacher teacher = (Teacher)q.list().get(0);
return teacher;
}
@Override
public void save(Teacher teacher) throws Exception {
System.out.println("测试insert DAOImpl");
System.out.println(teacher.getName());
System.out.println(teacher.getBirth());
super.getSessionFactory().openSession().save(teacher);
// super.getSession().save(teacher);
}
@Override
public boolean isExists(String name) throws Exception {
String hsql = "from Teacher as t where t.name = ?";
Query q = super.getSession().createQuery(hsql);
q.setString(0, name);
List list = q.list();
if(list.size()>0)
return true;
else
return false;
}
@Override
public boolean login(Teacher teacher) throws Exception {
boolean flag = false;
String hsql = "from Teacher as t where t.name=? and t.password=?";
Query q = super.getSession().createQuery(hsql);
q.setString(0, teacher.getName());
q.setString(1, teacher.getPassword());
List all = q.list();
if (all.size() > 0) {
flag = true;
}
return flag;
}
@Override
public void update(Teacher teacher) throws Exception {
super.getSession().update(teacher);
}
}
@Override
public void save(Teacher teacher) throws Exception {
System.out.println("测试insert DAOImpl");
System.out.println(teacher.getName());
System.out.println(teacher.getBirth());
[color=#FF0000]super.getSessionFactory().openSession().save(teacher);[/color]
// super.getSession().save(teacher);
}
super.getSessionFactory().openSession().save(teacher);
这一句是我在后来做的时候改的,原来是:
super.getSession().save(teacher); - 二、Spring的applicationContext.xml配置:
- Java code
- <? xml version = " 1.0 " encoding = " UTF-8 " ?> <! DOCTYPE beans PUBLIC " -//SPRING//DTD BEAN//EN " " http://www.springframework.org/dtd/spring-beans.dtd " > < beans > < bean id = " dataSourse " class = " org.springframework.jndi.JndiObjectFactoryBean " destroy - method = " close " > < property name = " jndiName " value = " java:comp/env/jdbc/tm " ></ 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.connection.autocommit " > true </ prop > <!-- 显示sql语句 --> < prop key = " hibernate.show_sql " > false </ prop > </ props > </ property > < property name = " mappingResources " > < list > < value > org / hxwl / tm / vo / Admin.hbm.xml </ value > < value > org / hxwl / tm / vo / Ad.hbm.xml </ value > < value > org / hxwl / tm / vo / Teacher.hbm.xml </ value > < value > org / hxwl / tm / vo / Stipend.hbm.xml </ value > < value > org / hxwl / tm / vo / ResearchCase.hbm.xml </ value > < value > org / hxwl / tm / vo / TeachResearchCase.hbm.xml </ value > < value > org / hxwl / tm / vo / AuditionCase.hbm.xml </ value > < value > org / hxwl / tm / vo / CheckWork.hbm.xml </ value > < value > org / hxwl / tm / vo / EduCase.hbm.xml </ value > < value > org / hxwl / tm / vo / Evection.hbm.xml </ value > < value > org / hxwl / tm / vo / OperationCase.hbm.xml </ value > < value > org / hxwl / tm / vo / RewardsAndPunishment.hbm.xml </ value > < value > org / hxwl / tm / vo / TeacherValueByStudent.hbm.xml </ value > < value > org / hxwl / tm / vo / TrainCase.hbm.xml </ value ></ list > </ property > </ bean > < bean id = " hibernateTemplate " class = " org.springframework.orm.hibernate3.HibernateTemplate " abstract = " false " lazy - init = " default " autowire = " default " dependency - check = " default " > < property name = " sessionFactory " > < ref bean = " sessionFactory " /> </ property > </ bean > <!-- interface --> < bean id = " iAdminDAO " class = " org.hxwl.tm.IDAO.IAdminDAO " abstract = " true " ></ bean > < bean id = " iAdDAO " class = " org.hxwl.tm.IDAO.IAdDAO " abstract = " true " ></ bean > < bean id = " iTeacherDAO " class = " org.hxwl.tm.IDAO.ITeacherDAO " abstract = " true " ></ bean > <!-- daoImpl --> < bean id = " iAdminDAOImpl " class = " org.hxwl.tm.DAOImpl.AdminDAOImpl " parent = " iAdminDAO " > < property name = " hibernateTemplate " > < ref bean = " hibernateTemplate " /> </ property > </ bean > < bean id = " iAdDAOImpl " class = " org.hxwl.tm.DAOImpl.AdDAOImpl " parent = " iAdDAO " > < property name = " hibernateTemplate " > < ref bean = " hibernateTemplate " /> </ property > </ bean > < bean id = " iTeacherDAOImpl " class = " org.hxwl.tm.DAOImpl.TeacherDAOImpl " parent = " iTeacherDAO " > < property name = " hibernateTemplate " > < ref bean = " hibernateTemplate " /> </ property > </ bean > <!-- struts action --> <!-- others --> < bean name = " /index " class = " org.hxwl.tm.struts.action.IndexAction " > < property name = " adDAOImpl " > < ref bean = " iAdDAOImpl " /> </ property > </ bean > <!-- admin --> < bean name = " /adminLogin " class = " org.hxwl.tm.struts.action.AdminAction " > < property name = " admindao " > < ref bean = " iAdminDAOImpl " /> </ property > </ bean > < bean name = " /jsp/admin/admin " class = " org.hxwl.tm.struts.action.AdminAction " > < property name = " admindao " > < ref bean = " iAdminDAOImpl " /> </ property > </ bean > <!-- showAd --> < bean name = " /showAd " class = " org.hxwl.tm.struts.action.ShowAdAction " > < property name = " adDAOImpl " > < ref bean = " iAdDAOImpl " /> </ property > </ bean > <!-- ad --> < bean name = " /jsp/admin/ad " class = " org.hxwl.tm.struts.action.AdAction " > < property name = " adDAOImpl " > < ref bean = " iAdDAOImpl " /> </ property > </ bean > < bean name = " /jsp/admin/listAd_manage " class = " org.hxwl.tm.struts.action.ListAd_manageAction " > < property name = " adDAOImpl " > < ref bean = " iAdDAOImpl " /> </ property > </ bean > < bean name = " /jsp/admin/updateAd " class = " org.hxwl.tm.struts.action.UpdateAdAction " > < property name = " adDAOImpl " > < ref bean = " iAdDAOImpl " /> </ property > </ bean > <!-- teacher --> < bean name = " /jsp/admin/teacher " class = " org.hxwl.tm.struts.action.TeacherAction " > < property name = " teacherDAOImpl " > < ref bean = " iTeacherDAOImpl " /> </ property > </ bean > </ beans >
- 三、HibernateDaoSupport来整合ssh,getHibernateTemplate()就相当于hibernate中的session,如果你一定要取到session,应该使用spring提供的HibernateCallback来获得session;
例如:
一个简单的分页查询:
- Java code
- public List findByPage( final String hql, final int offset, final int pageSize){ List list = getHibernateTemplate().executeFind( new HibernateCallback(){ public Object doInHibernate(Session arg0) // 得到回调中的session throws HibernateException, SQLException { // TODO Auto-generated method stub List result = session.createQuery(hql) .setFirstResult(offset) .setMaxResults(pageSize) .list(); return result; } }); return list; } 需要复杂的查询时,使用SqlQuery类时,有时需要当前的session: 这是一个查年统计的查询: public XXXX findByNameAndMonth(String name, Date date) throws DataException { XXXX year = null ; String sql = " select * from t_uday_ " + (date.getMonth() + 1 ) + " where login_name=? and logout_date=? " ; SQLQuery query = null ; try { query = this .getHibernateTemplate() .getSessionFactory() .getCurrentSession() // 取到当前Session .createSQLQuery(sql); query.addEntity(XXXX. class ); query.setString( 0 , name); query.setDate( 1 , date); year = (XXXX) query.uniqueResult(); } catch (HibernateException e) { e.printStackTrace(); throw new DataException(e.getMessage()); } return year; }
<bean id="dataSourse"
class="org.springframework.jndi.JndiObjectFactoryBean"
destroy-method="close">
<property name="jndiName" value="java:comp/env/jdbc/tm"> </property>
</bean>
appication中这么写取不到数据源的楼主,如果你是weblogic的话也得需要一个对象模版才行啊
建议你junit的时候
这么写
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver </value>
</property>
<property name="url">
<value>jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=bugtrack </value>
</property>
<property name="username">
<value>sa </value>
</property>
<property name="password">
<value>sa </value>
</property>
</bean>
class="org.springframework.jndi.JndiObjectFactoryBean"
destroy-method="close">
<property name="jndiName" value="java:comp/env/jdbc/tm"> </property>
</bean>
appication中这么写取不到数据源的楼主,如果你是weblogic的话也得需要一个对象模版才行啊
建议你junit的时候
这么写
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver </value>
</property>
<property name="url">
<value>jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=bugtrack </value>
</property>
<property name="username">
<value>sa </value>
</property>
<property name="password">
<value>sa </value>
</property>
</bean>
四、环境:weblogic8 ,oracle9i
框架:struts1.2.4 + Spring1.2 + Hibernate2.1,使用weblogic的连接池的DataSourse管理数据库链接。
struts与spring的结合方式采用在struts-config.xml中添加 (有错的)
框架:struts1.2.4 + Spring1.2 + Hibernate2.1,使用weblogic的连接池的DataSourse管理数据库链接。
struts与spring的结合方式采用在struts-config.xml中添加 (有错的)
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean" destroy-method="close">
- <property name="jndiName">
- <value>DS</value>
- </property>
- </bean>
- <bean id="sessionFactory" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
- <property name="dataSource">
- <ref local="dataSource"/>
- </property>
- <property name="mappingResources">
- <list>
- <value>....</value>
- ......
- </list>
- </property>
- <property name="hibernateProperties">
- <props>
- <prop key="hibernate.dialect">net.sf.hibernate.dialect.Oracle9Dialect</prop>
- <prop key="hibernate.show_sql">true</prop>
- <prop key="hibernate.jdbc.fetch_size">50</prop>
- <prop key="hibernate.jdbc.batch_size">25</prop>
- <prop key="hibernate.connection.pool_size">2</prop>
- </props>
- </property>
- </bean>
- <!--设定Hibernate事务管理类-->
- <bean id="transactionManager" class="org.springframework.orm.hibernate.HibernateTransactionManager">
- <property name="sessionFactory">
- <ref local="sessionFactory"/>
- </property>
- </bean>
- ..........................
- <bean id="pingFenDAO" class="businessservice.PingFenDAOImp">
- <property name="sessionFactory">
- <ref local="sessionFactory"/>
- </property>
- </bean>
- <!--设定业务代理类,将业务处理与事务管理结合-->
- <bean id="pingFenDAOProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
- <property name="transactionManager">
- <ref bean="transactionManager"/>
- </property>
- <property name="target">
- <ref local="pingFenDAO"/>
- </property>
- <property name="transactionAttributes">
- <props>
- <prop key="insert*">PROPAGATION_REQUIRED</prop>
- <prop key="update*">PROPAGATION_REQUIRED</prop>
- <prop key="select*">PROPAGATION_REQUIRED,readOnly</prop>
- <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
- </props>
- </property>
- </bean>
- <!--评分Action的Controller-->
- <bean name="/PingFenAction" class="action.PingFenAction" singleton="true">
- <property name="pingFenDAO">
- <ref bean="pingFenDAOProxy"/>
- </property>
- </bean