SSH框架代码(struts1.2+spring2.0+hibernate3.2)第二部分_航班信息查询使用 ssh(struts 2 + spring + hibernate)实现航班查询-优快云博客

本文介绍了一个使用Spring框架整合Hibernate进行数据库操作的示例应用，包括配置文件、业务逻辑层实现、数据访问层实现及Struts2控制器的实现。

续上一篇

业务逻辑段结构：

业务逻辑结构

applicationContext-common.xml

<?xml version="1.0" encoding="UTF-8"?>  <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd"> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="configLocation"> <value>classpath:hibernate.cfg.xml</value> </property> </bean> <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <property name="sessionFactory"> <ref bean="sessionFactory"/> </property> </bean> <tx:advice id="txAdvice" transaction-manager="transactionManager"> <tx:attributes> <tx:method name="add*" propagation="REQUIRED"/> <tx:method name="del*" propagation="REQUIRED"/> <tx:method name="modify*" propagation="REQUIRED"/> <tx:method name="register" propagation="REQUIRED"/> <tx:method name="*" read-only="true"/> </tx:attributes> </tx:advice> <aop:config> <aop:pointcut id="allManagerMethod" expression="execution(* com.pn.manager.*.*.*(..))"/> <aop:advisor advice-ref="txAdvice" pointcut-ref="allManagerMethod"/> </aop:config> </beans>

applicationContext-actions.xml

applicationContext-beans.xml

hibernate.cfg.xml

<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="hibernate.connection.url">jdbc:mysql://127.0.0.1/ssh</property> <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.username">root</property> <property name="hibernate.connection.password">root</property> <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> <property name="hibernate.show_sql">true</property> <property name="hibernate.hbm2ddl.auto">update</property> <mapping resource="com/pn/model/User.hbm.xml"/> </session-factory> </hibernate-configuration>

log4j.properties

### direct log messages to stdout ### log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.Target=System.out log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n ### direct messages to file hibernate.log ### #log4j.appender.file=org.apache.log4j.FileAppender #log4j.appender.file.File=hibernate.log #log4j.appender.file.layout=org.apache.log4j.PatternLayout #log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n ### set log levels - for more verbose logging change 'info' to 'debug' ### log4j.rootLogger=warn, stdout #log4j.logger.org.hibernate=info #log4j.logger.org.hibernate=debug ### log HQL query parser activity #log4j.logger.org.hibernate.hql.ast.AST=debug ### log just the SQL #log4j.logger.org.hibernate.SQL=debug ### log JDBC bind parameters ### #log4j.logger.org.hibernate.type=info #log4j.logger.org.hibernate.type=debug ### log schema export/update ### #log4j.logger.org.hibernate.tool.hbm2ddl=debug ### log HQL parse trees #log4j.logger.org.hibernate.hql=debug ### log cache activity ### #log4j.logger.org.hibernate.cache=debug ### log transaction activity #log4j.logger.org.hibernate.transaction=debug ### log JDBC resource acquisition #log4j.logger.org.hibernate.jdbc=debug ### enable the following line if you want to track down connection ### ### leakages when using DriverManagerConnectionProvider ### #log4j.logger.org.hibernate.connection.DriverManagerConnectionProvider=trace

com.pn.DaoImpl.UserDao4MysqlImpl

package com.pn.DaoImpl; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.pn.DaoItfc.UserDao; import com.pn.model.User; public class UserDao4MysqlImpl extends HibernateDaoSupport implements UserDao { public void addUser(User user) { // TODO Auto-generated method stub try { this.getHibernateTemplate().save(user); } catch (Exception e) { e.printStackTrace(); } } public boolean findUser(User user) { // TODO Auto-generated method stub User tempUser = (User) getSession().createQuery( "select u from User as u where u.userName=? and u.password=?") .setParameter(0, user.getUserName()).setParameter(1, user.getPassword()).uniqueResult(); if (tempUser != null) return true; return false; } }

com.pn.DaoItfc.UserDao

package com.pn.DaoItfc; import com.pn.model.User; public interface UserDao { public void addUser(User user); public boolean findUser(User user); }

com.pn.manager.itfc.UserManager

package com.pn.manager.itfc; import com.pn.model.User; public interface UserManager { public boolean login(User user); public void register(User user); }

com.pn.manager.impl.UserManagerImpl

package com.pn.manager.impl; import com.pn.DaoItfc.UserDao; import com.pn.manager.itfc.UserManager; import com.pn.model.User; public class UserManagerImpl implements UserManager { private UserDao userDao; public void setUserDao(UserDao userDao) { this.userDao = userDao; } public boolean login(User user) { return userDao.findUser(user); } public void register(User user) { userDao.addUser(user); } }

com.pn.model.User

package com.pn.model; public class User { private int id; private String userName; private String password; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } }

com.pn.model.User.hbm.xml

<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="com.pn.model.User" table="t_user"> <id name="id"> <generator class="native"/> </id> <property name="userName" /> <property name="password"/> </class> </hibernate-mapping>

com.pn.web.actions.LoginAction

package com.pn.web.actions; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.Action; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import com.pn.manager.itfc.UserManager; import com.pn.model.User; import com.pn.web.forms.UserActionForm; public class LoginAction extends Action { private UserManager userManager; public void setUserManager(UserManager userManager) { this.userManager = userManager; } public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { UserActionForm laf = (UserActionForm) form; User user = new User(); user.setUserName(laf.getUserName()); user.setPassword(laf.getPassword()); try { if(!userManager.login(user)) return mapping.findForward("error"); } catch (Exception e) { e.printStackTrace(); return mapping.findForward("error"); } return mapping.findForward("success"); } }

com.pn.web.actions.RegisterAction

package com.pn.web.actions; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.Action; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import com.pn.manager.itfc.UserManager; import com.pn.model.User; import com.pn.web.forms.UserActionForm; public class RegisterAction extends Action { private UserManager userManager; public void setUserManager(UserManager userManager) { this.userManager = userManager; } public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { UserActionForm laf = (UserActionForm) form; User user = new User(); user.setUserName(laf.getUserName()); user.setPassword(laf.getPassword()); try { userManager.register(user); } catch (Exception e) { e.printStackTrace(); return mapping.findForward("error"); } return mapping.findForward("success"); } }

com.pn.web.forms.UserActionForm

package com.pn.web.forms; import org.apache.struts.action.ActionForm; public class UserActionForm extends ActionForm { private String userName; private String password; public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } }

that's all.