struts2+spring+hibernate的简单实例

需求： 查询用户列表

技术： struts2+spring+hibernate, oracle, myeclipse

一、工程结构

　　　　　　

jar包： 【有些包没用到】　

　　　　antlr-2.7.7.jar
　　　　aspectjrt.jar
　　　　aspectjweaver.jar
　　　　cglib-nodep-2.1_3.jar
　　　　common-annotations.jar
　　　　commons-beanutils-1.7.0.jar
　　　　commons-collections-3.1.jar
　　　　commons-dbcp.jar
　　　　commons-fileupload-1.2.1.jar
　　　　commons-io-1.3.2.jar
　　　　commons-logging-1.0.4.jar
　　　　commons-pool.jar
　　　　commons-validator-1.3.1.jar
　　　　dom4j-1.6.1.jar
　　　　ehcache-1.2.3.jar
　　　　ejb3-persistence.jar
　　　　freemarker-2.3.15.jar
　　　　hibernate-annotations.jar
　　　　hibernate-cglib-repack-2.1_3.jar
　　　　hibernate-commons-annotations-4.0.2.Final.jar
　　　　hibernate-entitymanager.jar
　　　　hibernate3.jar
　　　　javassist-3.9.0.GA.jar
　　　　jstl-1.0.2.jar
　　　　jta-1.1.jar
　　　　log4j-api-2.7.jar
　　　　log4j.jar
　　　　ognl-2.7.3.jar
　　　　ojdbc14.jar
　　　　slf4j-api-1.5.8.jar
　　　　slf4j-log4j12-1.6.1.jar
　　　　spring-webmvc-struts.jar
　　　　spring.jar
　　　　struts2-core-2.1.8.1.jar
　　　　struts2-spring-plugin-2.1.8.1.jar
　　　　xwork-core-2.1.6.jar

 二、正式开发

　　（1）配置文件

　　** web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns="http://xmlns.jcp.org/xml/ns/javaee"
    xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
    id="WebApp_ID" version="3.1">
    <display-name>ssh</display-name>
    <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
        <welcome-file>index.html</welcome-file>
        <welcome-file>index.htm</welcome-file>
        <welcome-file>default.html</welcome-file>
        <welcome-file>default.htm</welcome-file>
        <welcome-file>default.jsp</welcome-file>
    </welcome-file-list>

    <!-- Spring配置和监听start -->    
    <context-param>    
        <param-name>contextConfigLocation</param-name>    
        <param-value>classpath:applicationContext.xml</param-value>    
    </context-param>    
    <listener>    
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>    
    </listener> 
    
    <!-- 拦截请求 -->
    <filter>    
        <filter-name>struts2</filter-name>    
        <filter-class>
              org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter    
        </filter-class>    
    </filter>    
    <filter-mapping>    
        <filter-name>struts2</filter-name>    
          <url-pattern>*.action</url-pattern>    
     </filter-mapping>
</web-app>

　　** struts.xml

<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.1//EN" "http://struts.apache.org/dtds/struts-2.1.dtd">

<struts>
    <constant name="struts.objectFactory" value="spring" /> 
    
    <package name="ssh" extends="struts-default">
        <global-results>
            <result name="error">/WEB-INF/jsp/error.jsp</result>
            <result name="success">/WEB-INF/jsp/success.jsp</result>
        </global-results>
        
        <action name="query" class="com.jg.ssh.action.UserAction" method="queryUsers" />
    </package>
</struts>

　　** applicationContext.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:p="http://www.springframework.org/schema/p"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
    
    <!-- 数据库配置 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver">
        </property>
        <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl">
        </property>
        <property name="username" value="Peter"></property>
        <property name="password" value="123"></property>
    </bean>

    <!-- 配置会话工厂SessionFactory -->
    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource">
            <ref bean="dataSource" />
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">
                     org.hibernate.dialect.Oracle10gDialect
                </prop>
                <prop key="hibernate.hbm2ddl.auto">update</prop>
            </props>
        </property>
        <!-- 配置实体描述文件 -->
        <property name="mappingResources">
            <list>
                 <value>com/jg/ssh/pojo/User.hbm.xml</value>
            </list>
        </property>
    </bean>

    <bean id="userAction" class="com.jg.ssh.action.UserAction" scope="prototype">
        <property name="userService" ref="userService"></property>
    </bean>

    <bean id="userService" class="com.jg.ssh.service.UserService">
        <property name="baseDao" ref="baseDao"></property>
    </bean>

    <bean id="baseDao" class="com.jg.ssh.dao.BaseDao">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>
</beans>  

　　** log4j.properties

log4j.rootLogger = DEBUG, stdout
log4j.appender.stdout = org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout = org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern =%d{ISO8601} %-5p [%F\:%L] \: %m%n

　　（2）各层

　　** com.jg.ssh.pojo

　　User.java

　　 private Integer id;
    private String username;
    private String sex;
    private String password;
    private String telephone;
    private String address;

　　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.jg.ssh.pojo.User" table="TB_USER">
        <id name="id" type="java.lang.Integer">
            <column name="ID" />
            <generator class="native" />
        </id>
        <property name="username" type="java.lang.String">
            <column name="USERNAME" />
        </property>
        <property name="sex" type="java.lang.String">
            <column name="SEX" />
        </property>
        <property name="password" type="java.lang.String">
            <column name="PASSWORD" />
        </property>
        <property name="telephone" type="java.lang.String">
            <column name="TELEPHONE" />
        </property>
        <property name="address" type="java.lang.String">
            <column name="ADDRESS" />
        </property>
    </class>
</hibernate-mapping>

　　** com.jg.ssh.dao

　　BaseDao.java

package com.jg.ssh.dao;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

/**
 * 基础DAO
 */
public class BaseDao extends HibernateDaoSupport {
    /**
     * 根据hql语句查询用户列表
     * @param hql
     * @return 用户列表
     */
    @SuppressWarnings("unchecked")
    public <T>List<T> getObjects(String hql) {
        List<T> userList = this.getHibernateTemplate().find(hql);
        return userList;
    }
    
    @SuppressWarnings({ "unchecked", "rawtypes" })
    public <T>List<T> getAllObjects(Class clazz) {
        return this.getHibernateTemplate().loadAll(clazz);
    }
}

　　** com.jg.ssh.service

　　UserService.java

package com.jg.ssh.service;

import java.util.List;

import com.jg.ssh.dao.BaseDao;
import com.jg.ssh.pojo.User;

/**
 * 用户Service
 */
public class UserService {
    private BaseDao baseDao;
    
    /**
     * 获取用户列表
     * @param username
     * @param clazz
     * @return 用户列表
     */
    @SuppressWarnings("rawtypes")
    public List<User> getUsers(String queryText, Class clazz) {
        if (queryText == null || "".equals(queryText)) {
            return baseDao.getAllObjects(clazz);
        }
        
        String hql = "FROM User WHERE username = '" + queryText + "'";
//        String hql = "FROM User WHERE username = '" + queryText + "'";
        return baseDao.getObjects(hql);
    }
    
    public BaseDao getBaseDao() {
        return baseDao;
    }

    public void setBaseDao(BaseDao baseDao) {
        this.baseDao = baseDao;
    }
}

　　　** com.jg.ssh.action

　　UserAction.java

package com.jg.ssh.action;

import java.util.List;

import com.jg.ssh.pojo.User;
import com.jg.ssh.service.UserService;
import com.jg.ssh.util.ServletContextUtil;
import com.opensymphony.xwork2.ActionSupport;

/**
 * 用户控制器
 */
@SuppressWarnings("serial")
public class UserAction extends ActionSupport {
    private UserService userService;
    
    /**
     * 根据条件查询用户列表
     * @return 用户列表
     */
    public String queryUsers() {
        String param = ServletContextUtil.getRequest().getParameter("queryText");
        List<User> users = userService.getUsers(param, User.class);
        ServletContextUtil.getRequest().setAttribute("users", users);
        return SUCCESS;
    }
    
    public UserService getUserService() {
        return this.userService;
    }

    public void setUserService(UserService userService) {
        this.userService = userService;
    }
}

　　** com.jg.ssh.util

　　ServletContextUtil.java

package com.jg.ssh.util;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts2.ServletActionContext;

import com.opensymphony.xwork2.ActionSupport;

@SuppressWarnings("serial")
public class ServletContextUtil extends ActionSupport {
    public static HttpServletRequest getRequest() {
        return ServletActionContext.getRequest();
    }
}

　　（3） 页面

　　index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://"
            + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>首页</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
</head>

<body>
    <form action="${pageContext.request.contextPath}/query.action" method="post">
        用户名：<input type="text" name="queryText"/>&nbsp;&nbsp;&nbsp;&nbsp;
        <input type="submit" value="查询"/>
    </form> 
</body>
</html>

　　success.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://"
            + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>成功页面</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

</head>

<body>
    <center>
    <c:if test="${empty users}">
        <h3>无任何员工信息！</h3>
    </c:if>
    <c:if test="${not empty users}">
        <table border="1px" cellpadding="5" cellspacing="0" style="width: 40%;margin-top: 50px;">
            <tr>
                <td>用户ID</td>
                <td>用户名</td>
                <td>性别</td>
                <td>密码</td>
                <td>手机</td>
                <td>地址</td>
            </tr>
            <c:forEach items="${users }" var="user">
                <tr>
                    <td><c:out value="${user.id }" /></td>
                    <td><c:out value="${user.username }" /></td>
                    <td><c:out value="${user.sex }" /></td>
                    <td><c:out value="${user.password }" /></td>
                    <td><c:out value="${user.telephone }" /></td>
                    <td><c:out value="${user.address }" /></td>
                </tr>
            </c:forEach>
        </table>
    </c:if>
    </center>
</body>
</html>

　　error.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://"
            + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>错误页面</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

</head>

<body>
    <h1>访问出错！</h1>
</body>
</html>

　　Oracle数据库

-- Create table
create table TB_USER
(
  ID        NUMBER not null,
  USERNAME  VARCHAR2(32) not null,
  SEX       VARCHAR2(5),
  PASSWORD  VARCHAR2(32) not null,
  TELEPHONE VARCHAR2(32),
  ADDRESS   VARCHAR2(255)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 1
    minextents 1
    maxextents unlimited
  );
-- Add comments to the columns 
comment on column TB_USER.ID
  is '用户ID';
comment on column TB_USER.USERNAME
  is '用户名';
comment on column TB_USER.SEX
  is '性别';
comment on column TB_USER.PASSWORD
  is '密码';
comment on column TB_USER.TELEPHONE
  is '电话';
comment on column TB_USER.ADDRESS
  is '地址';
-- Create/Recreate primary, unique and foreign key constraints 
alter table TB_USER
  add constraint ID primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

　　

　　

　　测试结果：