一,新建maven项目,并进行设置
(1)properties -->project Facets -->Dynamic Web Module 2.5
(2)properties -->Deployment Assembly -->Add -->Java Build Path Entries -->...
二.配置pom.xml
<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/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>MavenSSH</groupId>
<artifactId>MavenSSH</artifactId>
<version>0.0.1-SNAPSHOT</version>
<properties>
<spring.version>4.3.14.RELEASE</spring.version>
<struts.version>2.5.16</struts.version>
</properties>
<dependencies>
<!-- https://mvnrepository.com/artifact/javax.servlet/servlet-api -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/org.eclipse.persistence/javax.persistence -->
<dependency>
<groupId>org.eclipse.persistence</groupId>
<artifactId>javax.persistence</artifactId>
<version>2.2.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-core -->
<!-- spring -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-beans -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-web -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-orm -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->
<!-- Hibernate -->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>5.2.16.Final</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.struts/struts2-core -->
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-core</artifactId>
<version>${struts.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.struts/struts2-spring-plugin -->
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-spring-plugin</artifactId>
<version>${struts.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.struts/struts2-convention-plugin -->
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-convention-plugin</artifactId>
<version>${struts.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>
</dependencies>
</project>
三.配置web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
<display-name>MavenSSH</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
<!-- 配置Struts2过滤器 -->
<filter>
<filter-name>struts2</filter-name>
<filter-class>org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- 配置Spring的监听器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 指定Spring配置文件所在路径 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring.xml</param-value>
</context-param>
</web-app>
注意:将指定spring配置文件路径中<param-values>中的路径换成你的spring配置文件所在路径:spring配置文件名。
四.在项目的src/main/resource包下新建.properties文件
#mysql config
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=true
jdbc.user=/**数据库连接名**/
jdbc.password=/**连接密码**/
#hibernate config
hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
hibernate.show_sql=true
hibernate.format_sql=false
hibernate.hbm2ddl.auto=update
注意:
将.properties中数据库的连接名,连接密码换成你的连接名和连接密码。
同时mysql数据库驱动5版本以下(包括5)driver为*:com.mysql.jdbc.Driver;
6为com.mysql.Cj.jdbc.Driver 。
五.配置spring.xml文件
(1)在src/main/resource包下新建spring.xml文件
(2)写入代码
<?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:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.3.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
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd">
<!-- 引入properties -->
<context:property-placeholder location="classpath:database.properties"/>
<!-- 开启包扫描,并注册注解,扫描@Service,@Controller,@Repository,.... -->
<!-- 在base-package后定义的包中扫描(这里是action,和lib包,两个包都在src/main/java包下) -->
<context:component-scan base-package="action,lib"/>
<!-- 配置数据源 -->
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${jdbc.driver}">
</property>
<property name="url" value="${jdbc.url}">
</property>
<property name="username" value="${jdbc.user}"></property>
<property name="password" value="${jdbc.password}"></property>
</bean>
<!-- 配置hibernate sessionfactory -->
<bean id="sessionFactory"
class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
<prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
</props>
</property>
<property name="mappingResources">
<list>
<!-- <value>lib/Account.hbm.xml</value> -->
</list>
</property>
<!-- Scan entities automatically 自动扫描实体类Entity,在value后的包中扫描(这里是lib包) -->
<property name="packagesToScan" value="lib"/>
</bean>
</beans>
六.在src/main/java/下新建一个包lib,里面存放:
- 代表数据库中一张表的实体类Entity
- 实现数据库操作的Dao接口(Dao层)
- 实现了Dao接口的Dao类(Dao层)
- Service层:包含Dao类对象,通过调用Dao类对象方法对数据库进行操作。
(1)表的实体类:
表定义如下:
新建一个类Account.java作为这张表的实体类
写入以下代码:
注释请搜索:
hibernate用注解配置实体类的映射
package lib;
import java.sql.Date;
import javax.persistence.*;
@Entity //注意要加Entity注释
@Table(name="account", catalog="test") //schema="dbo",name指定表名映射
public class Account {
@Id //主键值(至少一个)
@Column(name="accountName") //其中成员变量名与表中对应列名不同要建立映射关系
private String accountId;
@Column(name="createDate")
private Date createDate;
//@Column(name="balance"),成员变量名和表中列名相同可以省略注释
private int balance;
public String getAccountId() {
return accountId;
}
public void setAccountId(String accountId) {
this.accountId = accountId;
}
public Date getCreateDate() {
return createDate;
}
public void setCreateDate(Date createDate) {
this.createDate = createDate;
}
public int getBalance() {
return balance;
}
public void setBalance(int balance) {
this.balance = balance;
}
}
(2)Dao层
接口(本例中为AccountDao.java)
package lib;
public interface AccountDao {
void save(Account account);
Account findById(String accountId);
}
接口的实现类(本例中为AccountDaoImpl.java
package lib;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate5.HibernateTemplate;
import org.springframework.stereotype.Repository;
/*
* Account表-Dao实现
*
*
*/
@Repository
public class AccountDaoImpl implements AccountDao{
private HibernateTemplate template;
@Autowired
public AccountDaoImpl(SessionFactory sessionFactory) {
this.template = new HibernateTemplate(sessionFactory);
}
public void save(Account account) {
template.save(account);
//手动管理事务
//Session s = sessionFactory.openSession();
//Transaction tx = s.beginTransaction();
//s.save(account);
//tx.commit();
//s.close();
}
@Override
public Account findById(String accountId) {
// TODO Auto-generated method stub
return template.get(Account.class, accountId);
//手动管理事务
//return sessionFactory().openSession().find(Account.class,accountId);
}
}
(3)Service层
接口(本例中为AccountService)
package lib;
public interface AccountService {
void save(Account account);
Account findById(String accountId);
}
Service接口的实现类(本例中为AccountServiceImpl,类中包含了Dao的实现类对象)
package lib;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class AccountServiceImpl implements AccountService {
//Dao接口的上转型对象
@Autowired
private AccountDao accountDao;
@Override
public void save(Account account) {
// TODO Auto-generated method stub
accountDao.save(account);
}
@Override
public Account findById(String accountId) {
// TODO Auto-generated method stub
return accountDao.findById(accountId);
}
}
七.Action
1.在src/main/java/包下新建一个action包
2.在包中新建一个action类(继承ActionSupport类)
3.写入代码
(1)类中包含:
表的实体类对象,Service接口的上转型对象,并提供get/set方法。
(2)注意:若表单中的元素是表中的属性(表的一列),那么不用在action中为表单元素创建同name的成员变量,只要在
表单中将
元素的name改成:
表的实体类对象名.属性名就可以。(这样在提交表单后,实体类对象的对应变量会自动被赋值,实体类对象表示的是表中的一行,也就是一条记录)
package action;
import java.sql.*;
import org.springframework.beans.factory.annotation.Autowired;
import com.opensymphony.xwork2.ActionSupport;
import lib.*;
public class AccountAction extends ActionSupport {
Account account;
@Autowired
AccountService accountService;
public String execute() throws Exception {
account.setCreateDate(new Date(new java.util.Date().getTime()));
accountService.save(account);
return SUCCESS;
}
public String findById(String accountId) {
Account acc = accountService.findById(accountId);
System.out.println(acc);
return SUCCESS;
}
public Account getAccount() {
return account;
}
public void setAccount(Account account) {
this.account = account;
}
public AccountService getAccountService() {
return accountService;
}
public void setAccountService(AccountService accountService) {
this.accountService = accountService;
}
}
八.配置struts.xml
1.在src/main/resources包下新建struts.xml文件
2.进行配置
<?xml version="1.0" encoding="UTF-8"?>
<!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.i18n.encoding" value="utf-8"></constant>
<constant name="struts.convention.action.packages" value="action"></constant>
<constant name="struts.enable.DynamicMethodInvocation" value="true" />
<package name="abc" namespace="/" extends="struts-default">
<!-- 使表单通过(action的name属性).方法名.action访问 指定action中的方法-->
<global-allowed-methods>regex:.*</global-allowed-methods>
<action name="Account*" class="action.AccountAction">
<interceptor-ref name="defaultStack"></interceptor-ref>
<result name="success">/succ.jsp</result>
<result name="fail" type="redirect">/fail.jsp</result>
<result name="input">/index.jsp</result>
</action>
</package>
</struts>
九.view层
1.在WebContent包下新建文件夹view
2.在view文件夹中新建jsp页面
3.写入代码
/*******************index.jsp***********************/
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Please Login</title>
</head>
<body>
<form action="Account!findById.action" method="post">
<!-- 表单中元素的name用(表实体类对象名.成员变量名) -->
accountId:<input type="text" name="account.accountId"/><br/>
<input type="submit" value="Search"/>
</form>
Struts Form:<br/>
<s:form action="Account.action" method="post">
<s:textfield name="account.accountId" label="accountId"></s:textfield>
<s:textfield name="account.balance" label="balance"></s:textfield>
<s:submit value="Create"></s:submit>
</s:form>
</body>
</html>
/************succ.jsp*************/
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Succ</title>
</head>
<body>
Success.<br/>
Welcome, <%=session.getAttribute("user")%><br/>
Welcome Tags, <s:property value="#session.user"></s:property><br/>
<!-- 注意:Action中的Object Stack仅在服务器内跳转有效 -->
Welcome Action, <s:property value="user"></s:property>,<s:property value="pass"></s:property><br/>
</body>
</html>
/**********fail.jsp**********/
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Fail</title>
</head>
<body>
fail
</body>
</html>