1、新建一个web项目
2、打开DB Browser视图,配置数据源MySSH,指向数据库myssh表
3、利用myeclipse自带工具导入struts
struts-config.xml代码如下
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.3//EN" "http://struts.apache.org/dtds/struts-config_1_3.dtd">
<struts-config>
<form-beans />
<global-exceptions />
<global-forwards />
<action-mappings />
<message-resources parameter="com.myssh.struts.ApplicationResources" />
</struts-config>
web.xml则多了以下代码,struts充当控制层,由ActionServlet类负责接收和处理用户发送过来的请求,过滤条件为url=*.do
<servlet>
<servlet-name>action</servlet-name>
<servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
<init-param>
<param-name>config</param-name>
<param-value>/WEB-INF/struts-config.xml</param-value>
</init-param>
<init-param>
<param-name>debug</param-name>
<param-value>3</param-value>
</init-param>
<init-param>
<param-name>detail</param-name>
<param-value>3</param-value>
</init-param>
<load-on-startup>0</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>action</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
4、利用myeclipse工具导入spring
点击完成则导入spring
5、利用myeclipse工具导入hibernate
点击完成,可以发现applicationContext.xml多了两个bean的配置
<span style="white-space:pre"> </span><bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.mysql.jdbc.Driver">
</property>
<property name="url"
value="jdbc:mysql://localhost:3306/myssh">
</property>
<property name="username" value="root"></property>
<property name="password" value="123456"></property>
</bean>
<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.MySQLDialect
</prop>
</props>
</property>
</bean>
hibernate逆向生成实体类和hbm.xml文件
6、构建基础的pojo类,service类,action类,actionForm表单,dao类
项目结构如下
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.5" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<!-- Hibernate启用延迟加载,配置OpenSessionInViewFilter -->
<filter>
<filter-name>OpenSessionInViewFilter</filter-name>
<filter-class>org.springframework.orm.hibernate3.support.OpenSessionInViewFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>OpenSessionInViewFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- 中文乱码处理 -->
<filter>
<filter-name>encoding</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- 初始化参数 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:beans.xml</param-value>
</context-param>
<!-- 监听器启动spring容器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<servlet>
<servlet-name>action</servlet-name>
<servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
<init-param>
<param-name>config</param-name>
<param-value>/WEB-INF/struts-config.xml</param-value>
</init-param>
<init-param>
<param-name>debug</param-name>
<param-value>3</param-value>
</init-param>
<init-param>
<param-name>detail</param-name>
<param-value>3</param-value>
</init-param>
<load-on-startup>0</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>action</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
8、配置struts-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.3//EN" "http://struts.apache.org/dtds/struts-config_1_3.dtd">
<struts-config>
<form-beans >
<form-bean name="userForm" type="com.myssh.web.form" />
</form-beans>
<global-exceptions />
<global-forwards />
<action-mappings>
<action
attribute="userForm"
name="userForm"
parameter="flag"
path="/login"
scope="request"
type="com.myssh.web.action.LoginAction"
validate="false" >
<forward name="goIndexUI" path="/WEB-INF/public/index.jsp" />
</action>
</action-mappings>
<!-- 配置请求处理器,就是把action的创建交给spring容器处理 -->
<controller>
<set-property property="processorClass" value="org.springframework.web.struts.DelegatingRequestProcessor"/>
</controller>
<message-resources parameter="com.myssh.struts.ApplicationResources" />
</struts-config>
9、配置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:context="http://www.springframework.org/schema/context"
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/context
http://www.springframework.org/schema/context/spring-context-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">
<context:annotation-config />
<!-- 下面这句话表示,让spring自动去扫描以com开头的包的组件(action/service),然后自动完成组装 -->
<context:component-scan base-package="com.myssh" />
<!-- 配置databaseSource -->
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url"
value="jdbc:mysql://localhost:3306/myssh?useUnicode=true&characterEncoding=utf-8" />
<property name="username" value="root" />
<property name="password" value="123456" />
<!-- 连接池启动时的初始值 -->
<property name="initialSize" value="3" />
<!-- 连接池的最大值 -->
<property name="maxActive" value="500" />
<!-- 最大空闲值.当经过一个高峰时间后,连接池可以慢慢将已经用不到的连接慢慢释放一部分,一直减少到maxIdle为止 -->
<property name="maxIdle" value="2" />
<!-- 最小空闲值.当空闲的连接数少于阀值时,连接池就会预申请去一些连接,以免洪峰来时来不及申请 -->
<property name="minIdle" value="1" />
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<value>
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.hbm2ddl.auto=update hibernate.show_sql=false
hibernate.format_sql=false
</value>
</property>
<property name="mappingResources">
<list>
<value>com/myssh/pojo/User.hbm.xml</value>
</list>
</property>
</bean>
<!-- 配置 service对象(已启用扫描加注解的方面) -->
<!--
<bean id="userServiceImpl"
class="com.myssh.service.impl.UserServiceImpl">
</bean>
-->
<!-- 配置action(已启用扫描加注解的方面) -->
<!--
<bean name="/login" class="com.myssh.web.action.LoginAction"></bean>
-->
<bean id="UserDAO" class="com.myssh.pojo.UserDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<!-- 配置事务管理器 -->
<bean id="txManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
<tx:annotation-driven transaction-manager="txManager" />
</beans>
10、BaseServiceInter.java
package com.myssh.base.service;
import java.io.Serializable;
import java.util.List;
public interface BaseServiceInter {
//通过一个hql,和传入的参数完成相应的查询任务
public List getResult(String hql,Object [] parameters);
//保存一个对象
public void save(Object obj);
//删除一个对象
public void delete(Object obj);
//更新一个对象
public void update(Object obj);
//根据 id返回一个对象
public Object findById(Class clazz,Serializable id);
//可以执行sql语句
public void createsql(String sql);
//分页查询
public List executeQueryByPage(String hql, Object[] parameters,
int pageNow, int PagesSize);
//返回唯一的查询结果
public Object uniqueQuery(String hql, Object[] parameters);
//返回查询的记录数
public int queryallrows(String hql, Object[] parameters);
//批量删除
public void deletelist(List<Object> list);
}
11、BaseServiceImpl.java
package com.myssh.base.service;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;
import javax.annotation.Resource;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
@Transactional
@Service
public abstract class BaseServiceImpl implements BaseServiceInter {
@Resource SessionFactory sessionFactory;
@Transactional(propagation=Propagation.NOT_SUPPORTED)
public Object findById(Class clazz, Serializable id) {
// TODO Auto-generated method stub
return this.sessionFactory.getCurrentSession().load(clazz, id);
}
public void delete(Object obj) {
// TODO Auto-generated method stub
sessionFactory.getCurrentSession().delete(obj);
}
public void deletelist(List<Object> list)
{
for(int i=0;i<list.size();i++)
{
delete(list.get(i));
}
}
/**
* @author 礼明
* @param hql: 传入的hql语句
* @param parameters:问号对应的参数数组
*/
@Transactional(propagation=Propagation.NOT_SUPPORTED)
public List getResult(String hql, Object[] parameters) {
// TODO Auto-generated method stub
Query query=sessionFactory.getCurrentSession().createQuery(hql);
//注入?
if(parameters!=null&¶meters.length>0){
for(int i=0;i<parameters.length;i++){
query.setParameter(i, parameters[i]);
}
}
return query.list();
}
public void createsql(String sql)
{
SQLQuery query=sessionFactory.getCurrentSession().createSQLQuery(sql);
query.executeUpdate();
}
public void save(Object obj) {
// TODO Auto-generated method stub
sessionFactory.getCurrentSession().save(obj);
}
public void update(Object obj) {
// TODO Auto-generated method stub
sessionFactory.getCurrentSession().update(obj);
}
//分页
@Transactional(propagation=Propagation.NOT_SUPPORTED)
public List executeQueryByPage(String hql, Object[] parameters,
int pageNow, int PagesSize) {
// TODO Auto-generated method stub
Query query=sessionFactory.getCurrentSession().createQuery(hql);
if(parameters!=null && parameters.length>0){
for(int i=0;i<parameters.length;i++){
query.setParameter(i, parameters[i]);
}
}
if(pageNow<1)
{
pageNow=1;
}
//体现分页
return query.setFirstResult((pageNow-1)*PagesSize).setMaxResults(PagesSize).list();
}
//public List executeNextOrBefore(String hql, Object[] parameters){
// Query query=sessionFactory.getCurrentSession().createQuery(hql);
// return query.setFirstResult(0).setMaxResults(1).list();
//}
@Transactional(propagation=Propagation.NOT_SUPPORTED)
public Object uniqueQuery(String hql, Object[] parameters) {
// TODO Auto-generated method stub
Query query=sessionFactory.getCurrentSession().createQuery(hql);
//给?赋值
if(parameters!=null && parameters.length>0){
for(int i=0;i<parameters.length;i++){
query.setParameter(i, parameters[i]);
}
}
return query.uniqueResult();
}
@Transactional(propagation=Propagation.NOT_SUPPORTED)
public int queryallrows(String hql, Object[] parameters) {
// TODO Auto-generated method stub
//获取rowCount
/* List list=this.executeQuery(hql, parameters);
Iterator iteator=list.iterator();
if(iteator.hasNext()){
}*/
int allrows=getResult(hql, parameters).size();
return allrows;
//System.out.println("obj value= "+ obj);//obj如果等于rowConunt
// int rowCount=Integer.parseInt(obj.toString());
// return list.size();
}
}
11、User.java
package com.myssh.pojo;
/**
* User entity.
*
* @author MyEclipse Persistence Tools
*/
public class User implements java.io.Serializable {
// Fields
private Integer id;
private String name;
// Constructors
/** default constructor */
public User() {
}
/** full constructor */
public User(String name) {
this.name = name;
}
// Property accessors
public Integer getId() {
return this.id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return this.name;
}
public void setName(String name) {
this.name = name;
}
}
12、User.hbm.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
<class name="com.myssh.pojo.User" table="user" catalog="myssh">
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="identity" />
</id>
<property name="name" type="java.lang.String">
<column name="name" length="20" />
</property>
</class>
</hibernate-mapping>
13、UserServiceInter.java
package com.myssh.service.inter;
import com.myssh.base.service.BaseServiceInter;
public interface UserServiceInter extends BaseServiceInter {
}
14、UserServiceImpl.java
package com.myssh.service.impl;
import javax.persistence.Entity;
import org.springframework.stereotype.Service;
import com.myssh.base.service.BaseServiceImpl;
import com.myssh.service.inter.UserServiceInter;
@Service
public class UserServiceImpl extends BaseServiceImpl implements
UserServiceInter {
}
15、LoginAction.java
/*
* Generated by MyEclipse Struts
* Template path: templates/java/JavaClass.vtl
*/
package com.myssh.web.action;
import java.io.IOException;
import java.io.PrintWriter;
import java.io.UnsupportedEncodingException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.List;
import java.net.URLEncoder;
import javax.annotation.Resource;
import javax.persistence.Entity;
import javax.persistence.ManyToOne;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;
import org.springframework.stereotype.Controller;
import com.myssh.service.inter.UserServiceInter;
/**
* MyEclipse Struts Creation date: 12-22-2010
*
* XDoclet definition:
*
* @struts.action path="/login" name="userForm" parameter="flag" scope="request"
*/
@Controller
public class LoginAction extends DispatchAction {
@ManyToOne
@Resource UserServiceInter userService;
// 响应返回首页的页面请求
public ActionForward goIndexUI(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
return mapping.findForward("goIndexUI");
}
}
16、UserForm.java
package com.myssh.web.form;
import org.apache.struts.action.ActionForm;
public class UserForm extends ActionForm {
private String id;
private String name;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
17、WebRoot/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>
</head>
<body>
<a href="/MySSH/login.do?flag=goIndexUI">进入网站首页</a>
</body>
</html>
18、WebRoot/WEB-INF/piblic/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>
</head>
<body>
网站首页
</body>
</html>
利用myeclipse工具自带的spring、hibernate、struts整合SSH时会出现一些jar包冲突或版本冲突的问题。
也可以自己先整理ssh整合时需要的jar包,存放在新建的lib2目录下,再构建到项目中,手动去新建和配置spring、hibernate、struts的配置文件。