一、Maven 依赖
<properties>
<spring.version>4.2.3.RELEASE</spring.version>
<struts.version>2.3.24.1</struts.version>
<hibernate.version>5.0.6.Final</hibernate.version>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.12</version>
</dependency>
<!--struts-->
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-core</artifactId>
<version>${struts.version}</version>
<exclusions>
<exclusion>
<groupId>javassist</groupId>
<artifactId>javassist</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-spring-plugin</artifactId>
<version>${struts.version}</version>
</dependency>
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-convention-plugin</artifactId>
<version>${struts.version}</version>
</dependency>
<!--spring-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>${hibernate.version}</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.16</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.7</version>
</dependency>
<dependency>
<groupId>javax.transaction</groupId>
<artifactId>jta</artifactId>
<version>1.1</version>
</dependency>
</dependencies>
二、目录结构
三、Spring 配置
1. applicationContext.xml 不将配置全集中在这个文件内拆分引用两个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"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
<import resource="spring-component.xml" />
<import resource="spring-hibernate.xml"/>
</beans>
2. spring-component.xml 配置spring扫描目录
<?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"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
<context:component-scan base-package="cn.zqh.action"/>
<context:component-scan base-package="cn.zqh.service"/>
<context:component-scan base-package="cn.zqh.dao"/>
<context:component-scan base-package="cn.zqh.bean"/>
</beans>
四、hibernate配置
1. jdbc.properties
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ggsddu?useUnicode=true&characterEncoding=utf-8
jdbc.username=root
jdbc.password=-------
jdbc.initialSize=3
jdbc.minIdle=3
jdbc.maxActive=20
jdbc.maxWait=60000
jdbc.timeBetweenEvictionRunsMillis=60000
jdbc.minEvictableIdleTimeMillis=300000
jdbc.validationQuery=SELECT\u00201
jdbc.testWhileIdle=true
jdbc.testOnBorrow=false
jdbc.testOnReturn=false
jdbc.filters=stat
<?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:tx="http://www.springframework.org/schema/tx"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
<!--扫描外部配置文件-->
<context:property-placeholder location="classpath:config/jdbc.properties"/>
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<property name="driverClassName" value="${jdbc.driverClassName}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<!-- 配置初始化大小、最小、最大 -->
<property name="initialSize" value="${jdbc.initialSize}" />
<property name="minIdle" value="${jdbc.minIdle}" />
<property name="maxActive" value="${jdbc.maxActive}" />
<!-- 配置获取连接等待超时的时间 -->
<property name="maxWait" value="${jdbc.maxWait}" />
<!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 -->
<property name="timeBetweenEvictionRunsMillis" value="${jdbc.timeBetweenEvictionRunsMillis}" />
<!-- 配置一个连接在池中最小生存的时间,单位是毫秒 -->
<property name="minEvictableIdleTimeMillis" value="${jdbc.minEvictableIdleTimeMillis}" />
<property name="validationQuery" value="${jdbc.validationQuery}" />
<property name="testWhileIdle" value="${jdbc.testWhileIdle}" />
<property name="testOnBorrow" value="${jdbc.testOnBorrow}" />
<property name="testOnReturn" value="${jdbc.testOnReturn}" />
<!-- 配置监控统计拦截的filters -->
<property name="filters" value="${jdbc.filters}" />
</bean>
<bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
<prop key="hibernate.format_sql">true</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>hbm/TUser.hbm.xml</value>
</list>
</property>
<property name="packagesToScan">
<value>cn.zqh.bean</value>
</property>
</bean>
<!-- <bean id="tUserDao" class="cn.zqh.dao.impl.TUserDaoImpl">
<property name="sessionFactory" ref="sessionFactory"/>
</bean>-->
<!--配置事务管理-->
<bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory"/>
</bean>
<!--开启事务注解-->
<tx:annotation-driven transaction-manager="transactionManager"/>
</beans>
五、struts 配置
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
"http://struts.apache.org/dtds/struts-2.3.dtd">
<struts>
<package name="default" extends="struts-default" namespace="/">
<action name="hi_*" class="testAction" method="{1}">
<result name="success" >
/WEB-INF/index.jsp
</result>
<result name="login" >
/WEB-INF/testLogin.jsp
</result>
</action>
<action name="loginAction" class="loginAction" method="login">
<result name="success" >
/WEB-INF/success.jsp
</result>
<result name="login">
/WEB-INF/testLogin.jsp
</result>
</action>
</package>
</struts>
六、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 xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
version="3.0"
metadata-complete="true">
<display-name>Archetype Created Web Application</display-name>
<!-- Spring监听器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<context-param>
<param-name>contextConfigLocation</param-name>
<!-- 该路径以webRoot作为根路径 -->
<param-value>classpath:config/applicationContext.xml</param-value>
</context-param>
<!-- struts2拦截器 -->
<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>/*</url-pattern>
</filter-mapping>
</web-app>
七、 bean
package cn.zqh.bean;
import javax.persistence.Entity;
import javax.persistence.Table;
/**
* Created by admin on 2017/10/30.
*/
@Entity
@Table(name = "t_user")
public class TUser {
int id;
String account;
String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getAccount() {
return account;
}
public void setAccount(String account) {
this.account = account;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
八、 action
1.TestAction
package cn.zqh.action;
import cn.zqh.service.TUserService;
import com.opensymphony.xwork2.ActionSupport;
import org.springframework.stereotype.Controller;
import javax.annotation.Resource;
/**
* Created by admin on 2017/10/27.
*/
@Controller(value="testAction")
public class TestAction extends ActionSupport {
@Resource
private TUserService tUserService;
public String showLogin(){
return LOGIN;
}
}
2.LoginAction
package cn.zqh.action;
import cn.zqh.bean.TUser;
import cn.zqh.service.TUserService;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;
import org.springframework.stereotype.Controller;
import javax.annotation.Resource;
/**
* Created by admin on 2017/10/31.
*/
@Controller(value="loginAction")
public class LoginAction extends ActionSupport implements ModelDriven<TUser> {
@Resource
private TUserService tUserService;
private TUser tUser = new TUser();
public TUser getModel() {
return tUser;
}
public String login(){
TUser loginUser = null;
try {
loginUser = tUserService.findByAccountAndPassword(tUser);
}catch (Exception e){
//..
}
if (loginUser == null){
this.addActionError("用户名或者密码错误");
return LOGIN;
}else {
ActionContext.getContext().getSession().put("loginUser",loginUser);
return SUCCESS;
}
}
}
九、 service
package cn.zqh.service;
import cn.zqh.bean.TUser;
/**
* Created by admin on 2017/10/30.
*/
public interface TUserService {
TUser findByAccountAndPassword(TUser tUser);
String findPasswordByAccount(String account);
}
2. TUserServiceImpl
package cn.zqh.service.impl;
import cn.zqh.bean.TUser;
import cn.zqh.dao.TUserDao;
import cn.zqh.service.TUserService;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
/**
* Created by admin on 2017/10/30.
*/
@Service("tUserService")
public class TUserServiceImpl implements TUserService {
@Resource
private TUserDao tUserDao;
public TUser findByAccountAndPassword(TUser tUser){
return tUserDao.findByAccountAndPassword(tUser);
}
public String findPasswordByAccount(String account) {
return tUserDao.findPasswordByAccount(account);
}
}
十、 dao
1. TUserDao
package cn.zqh.dao;
import cn.zqh.bean.TUser;
/**
* Created by admin on 2017/10/30.
*/
public interface TUserDao {
TUser findByAccountAndPassword(TUser tUser);
String findPasswordByAccount(String account);
}
2.TUserDaoImpl
package cn.zqh.dao.impl;
import cn.zqh.bean.TUser;
import cn.zqh.dao.TUserDao;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate5.support.HibernateDaoSupport;
import org.springframework.stereotype.Repository;
import javax.annotation.Resource;
import java.util.List;
/**
* Created by admin on 2017/10/30.
*/
@Repository("tUserDao")
public class TUserDaoImpl extends HibernateDaoSupport implements TUserDao {
public TUser findByAccountAndPassword(TUser tUser){
String hql = "From TUser WHERE account = ? AND password = ?";
List<?> list = this.getHibernateTemplate().find(hql,tUser.getAccount(),tUser.getPassword());
if (list.size() > 0) {
return (TUser) list.get(0);
} else {
return null;
}
}
public String findPasswordByAccount(String account) {
String hql = "SELECT password FROM TUser WHERE account= ?";
List<?> list = this.getHibernateTemplate().find(hql,account);
if (list.size() > 0) {
return list.get(0).toString();
} else {
return null;
}
}
@Autowired
public void setSessionFactoryOverride(SessionFactory sessionFactory) {
super.setSessionFactory(sessionFactory);
}
}
3. mysql t_user表 建表语句
CREATE TABLE `t_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account` varchar(25) NOT NULL,
`password` varchar(25) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `account` (`account`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
4. TUser.hbm.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="cn.zqh.bean.TUser" table="t_user" lazy="false">
<id name="id" column="id">
<generator class="native"></generator>
</id>
<property name="account" column="account" length="25"></property>
<property name="password" column="password" length="25"></property>
</class>
</hibernate-mapping>
十一、JSP
1. testLogin.jsp
<%--
Created by IntelliJ IDEA.
User: admin
Date: 2017/10/31
Time: 15:10
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>My JSP 'index.jsp' starting page</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">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<form action="./loginAction.action" method="post">
账号:<input type="text" name="account"/><br/><br/>
密码:<input type="password" name="password"/><br/><br/>
<input type="submit" value="提交"/>
</form>
</body>
</html>
2. success.jsp
<html>
<body>
<h2>success</h2>
</body>
</html>
十二、 演示
http://localhost:8080/ssh/hi_showLogin.action
输入正确的账号密码,提交