作为一个学习中的码农,一直学习才是我们的常态,所以最近学习了SSH(Spring,Struts2,Hibernate)整合,数据库用的MySQL。

写了一个简单的例子,用的工具是IntelliJ Idea,写的Maven项目。

1.首先创建项目

我们看一下项目架构

2.创建好项目我们开始项目的第一步,一如jar包,我们首先考虑一个问题需要什么jar包,会有什么问题,jar包冲突问题怎么解决。

笔者遇到的问题比较少,但是遇到了一个log4j与hibernate带的jbossjar包版本冲突。最后注释掉log4j就可以了

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    <parent>
        <artifactId>Spring</artifactId>
        <groupId>cn.curry</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>
    <artifactId>SSH02</artifactId>
    <packaging>war</packaging>
    <name>SSH02 Maven Webapp</name>
    <url>http://maven.apache.org</url>
    <dependencies>
        <!--单测-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.3</version>
        </dependency>
        <!--javaee-->
        <dependency>
            <groupId>javax.javaee</groupId>
            <artifactId>javaee</artifactId>
            <version>6.0-alpha-1</version>
            <classifier>sources</classifier>
        </dependency>
        <!--slf4j日志-->
        <!-- <dependency>
             <groupId>org.slf4j</groupId>
             <artifactId>slf4j-api</artifactId>
             <version>1.7.12</version>
         </dependency>-->
        <!--log4j日志-->
        <!-- <dependency>
             <groupId>log4j</groupId>
             <artifactId>log4j</artifactId>
             <version>1.2.9</version>
         </dependency>-->
        <!--spring核心包-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>4.3.6.RELEASE</version>
        </dependency>
        <!--aspectJ包-->
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.8.7</version>
        </dependency>
        <!--spring-jdbcjar 包-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.3.3.RELEASE</version>
        </dependency>
        <!--dbcp包-->
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-dbcp2</artifactId>
            <version>2.1.1</version>
        </dependency>

        <!--c3p0jar 包-->
        <dependency>
            <groupId>c3p0</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.1.2</version>
        </dependency>
        <!--mysql数据库驱动-->
        <dependency>
            <groupId>org.wisdom-framework</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.34_1</version>
        </dependency>
        <!--hibernate核心包-->
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-ehcache</artifactId>
            <version>5.0.6.Final</version>
        </dependency>
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-core</artifactId>
            <version>5.0.6.Final</version>
        </dependency>
        <!--oracle数据库-->
        <!--<dependency>
         <groupId>com.oracle</groupId>
         <artifactId>ojdbc6</artifactId>
         <version>11.2.0.1.0</version>
       </dependency>-->
        <!--jta的jar包-->
        <dependency>
            <groupId>javax.transaction</groupId>
            <artifactId>jta</artifactId>
            <version>1.1</version>
        </dependency>
        <!--支持缓存的核心包-->
        <!-- <dependency>
             <groupId>net.sf.ehcache</groupId>
             <artifactId>ehcache</artifactId>
             <version>2.4.3 </version>
         </dependency>-->
        <!--支持缓存的依赖包-->
        <!--<dependency>
            <groupId>backport-util-concurrent</groupId>
            <artifactId>backport-util-concurrent</artifactId>
            <version>3.1</version>
        </dependency>-->
       <!-- jstl jar包-->
         <dependency>
             <groupId>org.apache.taglibs</groupId>
             <artifactId>taglibs-standard-spec</artifactId>
             <version>1.2.1</version>
         </dependency>

         <dependency>
             <groupId>org.apache.taglibs</groupId>
             <artifactId>taglibs-standard-impl</artifactId>
             <version>1.2.1</version>
         </dependency>
       <!-- mybatis jar包-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.2</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</artifactId>
            <version>4.3.3.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>4.3.6.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.apache.struts</groupId>
            <artifactId>struts2-spring-plugin</artifactId>
            <version>2.5.10.1</version>
        </dependency>
        <dependency>
            <groupId>org.apache.struts</groupId>
            <artifactId>struts2-core</artifactId>
            <version>2.5.8</version>
        </dependency>

        <dependency>
            <groupId>org.apache.struts.xwork</groupId>
            <artifactId>xwork-core</artifactId>
            <version>2.3.8</version>
        </dependency>
        <!--<dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring</artifactId>
            <version>2.5.2</version>
        </dependency>
        <dependency>
            <groupId>com.alexkasko.springjdbc</groupId>
            <artifactId>springjdbc-iterable</artifactId>
            <version>1.0.3</version>
        </dependency>-->


    </dependencies>
    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.*</include>
                </includes>
            </resource>
        </resources>
    </build>
</project>

 

3.开始代码书写,创建实体类,小配置

package cn.curry.entity;

/**
 * Created by Curry on 2017/4/2.
 */

public class Stock {
    private Integer sid;
    private String sname;
    private Integer scount;

    public Integer getSid() {
        return sid;
    }

    public void setSid(Integer sid) {
        this.sid = sid;
    }

    public String getSname() {
        return sname;
    }

    public void setSname(String sname) {
        this.sname = sname;
    }

    public Integer getScount() {
        return scount;
    }

    public void setScount(Integer scount) {
        this.scount = scount;
    }
}


<?
xml version="1.0" encoding="ISO-8859-1"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="cn.curry.entity"> <class name="Stock" table="stock"> <id name="sid"> <generator class="native"/> </id> <property name="sname"/> <property name="scount"/> </class> </hibernate-mapping>

实体类小配置不多说。

3.然后我们开始写dao及其实现

dao层

package cn.curry.dao;

import cn.curry.entity.Stock;

/**
 * Created by Curry on 2017/4/2.
 */
public interface IStockDao {
    public int addStock(Stock stock);
}

实现层

package cn.curry.dao.impl;

import cn.curry.dao.IStockDao;
import cn.curry.entity.Stock;
import org.hibernate.Session;
import org.hibernate.SessionFactory;

import java.io.Serializable;


/**
 * Created by Curry on 2017/4/2.
 */
public class StockDao implements IStockDao {
    private SessionFactory sessionFactory;
    public int addStock(Stock stock) {
        Session session = sessionFactory.getCurrentSession();
        Serializable save = session.save(stock);
        Integer count=(Integer)save;

        return count.intValue();
    }

    public SessionFactory getSessionFactory() {
        return sessionFactory;
    }

    public void setSessionFactory(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
    }
}

4.然后我们开始写service

package cn.curry.service;

import cn.curry.entity.Stock;

/**
 * Created by Curry on 2017/4/3.
 */
public interface IStockService {
    public int addStock(Stock stock);
}

接下来写实现

package cn.curry.service.impl;

import cn.curry.dao.IStockDao;
import cn.curry.entity.Stock;
import cn.curry.service.IStockService;

/**
 * Created by Curry on 2017/4/3.
 */
public class StockService implements IStockService{
    private IStockDao stockDao;
    public int addStock(Stock stock) {
        return stockDao.addStock(stock);
    }

    public IStockDao getStockDao() {
        return stockDao;
    }

    public void setStockDao(IStockDao stockDao) {
        this.stockDao = stockDao;
    }
}

简单说两句,以上都是一些最基础的东西,可以看出我们是对数据库stock表添加一条数据。

5.继续我们的重点了开始书写Action层

package cn.curry.action;

import cn.curry.entity.Stock;
import cn.curry.service.IStockService;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;

/**
 * Created by Curry on 2017/4/4.
 */
//继承ActionSupport使其成为action类,实现ModelDriven实现属性名自动装配
public class StockAction extends ActionSupport implements ModelDriven<Stock>{
    //植入stock实体类
    private Stock stock;
    //植入iStockService业务层
    private IStockService iStockService;
    
    public StockAction(){
        stock=new Stock();
    }
    @Override//重写execute
    public String execute() throws Exception {
        int count = iStockService.addStock(stock);
        if (count>0){
            return SUCCESS;
        }else{
            return INPUT;
        }

    }

    public Stock getModel() {
        return stock;
    }

    public Stock getStock() {
        return stock;
    }

    public void setStock(Stock stock) {
        this.stock = stock;
    }

    public IStockService getiStockService() {
        return iStockService;
    }

    public void setiStockService(IStockService iStockService) {
        this.iStockService = iStockService;
    }
}

6.我们先写页面最后在写最重点的xml配置

我们准备了两个页面一个index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page isELIgnored="false"%>
<%
    String path = request.getContextPath();
    String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
<head>
    <title>添加</title>
</head>
<body>
<h2>添加股票</h2>
<form action="addStock" method="post">
    <input name="sname"/>
    <input name="scount"/>
    <input type="submit" value="提交"/>
</form>
</body>
</html>

第二个成功页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>成功</title>
</head>
<body>
<h1>添加成功!!!</h1>
</body>
</html>

7.最后的配置文件部分了,我们先写一个数据库连接的配置文件jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///y2163
jdbc.username=root
jdbc.password=1234

然后我们看strust2的配置strus.xml

<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.5//EN"
    "http://struts.apache.org/dtds/struts-2.5.dtd">

<struts>
    <constant name="struts.devMode" value="true" />
    <constant name="struts.custom.i18n.resources" value="messages" />
    <package name="default" namespace="/"  extends="struts-default">
        <!--控制权交给Spring容器所以class配置的是Spring配置的注入id-->
        <action name="addStock" class="stockAction">
            <result name="success">success.jsp</result>
            <result name="input">index.jsp</result>
        </action>
     </package>  

</struts>

接下来是我们至关重要的的applicationContext.xml的配置,里面配置连接数据库,关联hibernate,关联Struts2

<?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:p="http://www.springframework.org/schema/p"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/aop
       http://www.springframework.org/schema/aop/spring-aop.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd
       http://www.springframework.org/schema/tx
       http://www.springframework.org/schema/tx/spring-tx.xsd">
    <!--<context:component-scan base-package="cn.curry"></context:component-scan>-->
    <!--关联jdbc.properties-->
    <context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
    <!--配置数据源-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"></property>
        <property name="jdbcUrl" value="${jdbc.url}"></property>
        <property name="user" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>
    <!--配置注入sessionFactory-->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
        <!--数据源-->
        <property name="dataSource" ref="dataSource"></property>
        <!--hibernate属性配置,代替hibernate的大配置-->
        <property name="hibernateProperties">
            <props>
                <!--sql方言-->
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQL57InnoDBDialect</prop>
                <!--是否输出sql语句-->
                <prop key="hibernate.show_sql">true</prop>
                <!--是否格式化输出sql语句-->
                <prop key="hibernate.format_sql">true</prop>
                <!--是否与当前线程绑定-->
                <prop key="hibernate.current_session_context_class">org.springframework.orm.hibernate5.SpringSessionContext</prop>
            </props>
        </property>
        <!--关联小配置-->
        <property name="mappingDirectoryLocations" value="classpath:cn/curry"></property>
    </bean>
    <!--注入dao-->
    <bean id="stockDao" class="cn.curry.dao.impl.StockDao">
        <property name="sessionFactory" ref="sessionFactory"></property>
    </bean>
    <!--注入service-->
    <bean id="stockService" class="cn.curry.service.impl.StockService">
        <property name="stockDao" ref="stockDao"></property>
    </bean>
    <bean id="stockAction" class="cn.curry.action.StockAction">
        <property name="iStockService" ref="stockService"></property>
    </bean>
    <!--事物管理器-->
    <bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"></property>
    </bean>
    <!--aop配置事物管理-->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="add*" isolation="DEFAULT" propagation="REQUIRED"/>
        </tx:attributes>
    </tx:advice>
    <aop:config>
        <aop:pointcut id="piontCut" expression="execution(* *..service.*.*(..))"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="piontCut"/>
    </aop:config>
</beans>

最后配置一下web.xml,就可以发布项目了

<!DOCTYPE web-app PUBLIC
 "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
 "http://java.sun.com/dtd/web-app_2_3.dtd" >

<web-app>
  <display-name>Archetype Created Web Application</display-name>
  <!--读取配置文件-->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:applicationContext.xml</param-value>
  </context-param>
<!--配置Struts2-->
  <filter>
    <filter-name>struts</filter-name>
    <filter-class>org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter</filter-class>
  </filter>

  <filter-mapping>
    <filter-name>struts</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
<!--配置监听器-->
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <!--欢迎页-->
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
</web-app>

 

然后我们完成了我们项目的全部配置,最后我们启动程序看一下结果

首先看一下数据库的数据

然后启动服务,看页面

然后我们再看一下数据库

我们看到成功的在数据库添加了一条数据。

到此为止,我们的xml整合已经全部完成。

  总结:我们有大量的配置,所以我们要小心不要写错名字,引用错名字,最后在编写类的时候不要引用错包,主要还是多写多练,熟悉每一步的配置。

posted on 2017-04-04 17:04  北漂-少年  阅读(471)  评论(2编辑  收藏  举报