參考文檔1:https://www.cnblogs.com/yzoro/p/5847015.html
參考文檔2:https://blog.csdn.net/pazezhe314/article/details/79691741?utm_source=blogxgwz7
一纺腊、jar包的下載和選擇
第一步:下載jar包
(1)spring框架的jar包:https://repo.spring.io/
image.png
image.png
(2)hibernate框架的jar包:http://hibernate.org/orm/
image.png
image.png
(3)struts2框架的jar包:https://struts.apache.org/
image.png
image.png
(4)數(shù)據(jù)庫(以mysql為例)連接的jar包:https://dev.mysql.com/downloads/connector/j/
image.png
第二步:選擇三個(gè)框架的基礎(chǔ)jar包文件棺亭,準(zhǔn)備放入搭建的項(xiàng)目里
本項(xiàng)目下載的SSH框架的jar包版本违柏,分別為:hibernate-release-5.4.0.Final(hibernate)、mysql-connector-java-8.0.13(mysql連接)齐婴、spring-framework-5.1.3.RELEASE(spring)、struts-2.5.18(struts2)
(1)struts的基礎(chǔ)jar包:
image.png
(2)spring的jar包(應(yīng)為不多樟澜,所以暫時(shí)全部包括):
image.png
(3)hibernate的基礎(chǔ)jar包:
image.png
(4)mysql連接的jar包:
image.png
二、項(xiàng)目搭建
項(xiàng)目搭建工具:eclipse碉京、navicat premium
項(xiàng)目開發(fā)環(huán)境:①Windows10-64位 ②Tomcat 9.0 ③jdk1.8.0_91 ④MySql 8.0.11
第一步:新建項(xiàng)目,導(dǎo)入jar包螟深,并配置web.xml
(1)新建一個(gè)Dynamic Web Project谐宙,可命名為ssh_01,直接點(diǎn)擊finish按鈕
image.png
(2)將選擇的jar包導(dǎo)入到lib(/WebContent/WEB-INF/lib)中
image.png
(3)將導(dǎo)入的jar包添加到項(xiàng)目Libraries中血崭,項(xiàng)目右鍵==》Properties==》Java Build Path==》Libraries==》選中導(dǎo)入的所有jar包添加到進(jìn)Libraries中
image.png
image.png
(4)在/WebContent/WEB-INF/下新建一個(gè)web.xml,配置過濾器和監(jiān)聽器
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.action</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的監(jiān)聽器配置開始 -->
<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>
</web-app>
第二步 創(chuàng)建用于分層的四個(gè)基礎(chǔ)包厘灼,并分別添加BookCard的操作類
(1)項(xiàng)目切換到Project Explorer窗口夹纫,在/Java Resources/src/目錄下創(chuàng)建四個(gè)包(package)
image.png
(2)根據(jù)數(shù)據(jù)庫表的字段編寫B(tài)ookCard(實(shí)體類)和BookCard.hbm.xml(映射文件)放到ssh_01.entity包里
BookCard.java:
package ssh_01.entity;
import java.math.BigDecimal;
import java.util.Date;
public class BookCard {
private int cid ;
private String name;
private String sex ;
private Date cardDate;
private BigDecimal deposit;
public int getCid() {
return cid;
}
public void setCid(int cid) {
this.cid = cid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public Date getCardDate() {
return cardDate;
}
public void setCardDate(Date cardDate) {
this.cardDate = cardDate;
}
public BigDecimal getDeposit() {
return deposit;
}
public void setDeposit(BigDecimal deposit) {
this.deposit = deposit;
}
}
BookCard.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="ssh_01.entity.BookCard" table="BookCard">
<!-- 卡號(hào) -->
<id name="cid" column="cid">
<generator class="native"></generator>
</id>
<!-- 姓名 -->
<property name="name" column="name"></property>
<!-- 性別 -->
<property name="sex" column="sex"></property>
<!-- 辦卡日期 -->
<property name="cardDate" column="cardDate"></property>
<!-- 押金 -->
<property name="deposit" column="deposit"></property>
</class>
</hibernate-mapping>
(3)在ssh_01.dao包里編寫B(tài)ookCardDao(接口類)和BookCardDaoImpl(實(shí)現(xiàn)類)。
BookCardDao.java:
package ssh_01.dao;
import java.util.List;
import ssh_01.entity.BookCard;
public interface BookCardDao {
public List<BookCard> getAllBookCard();
}
BookCardDaoImpl.java:
package ssh_01.dao;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.query.Query;
import ssh_01.entity.BookCard;
public class BookCardDaoImpl implements BookCardDao {
//在SSH的設(shè)計(jì)理念:要使用某個(gè)實(shí)例设凹,那么就定義聲明一個(gè)對(duì)象舰讹,然后
//給它添加set方法(用于spring注入進(jìn)來)
//實(shí)現(xiàn)不要關(guān)注這個(gè)實(shí)例來自于那里,以及怎么創(chuàng)建闪朱,或者它是誰
private SessionFactory sessionFactory;
public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}
@Override
public List<BookCard> getAllBookCard() {
//sessionFactory這個(gè)實(shí)例可以自己按常規(guī)的hibernate傳統(tǒng)寫法創(chuàng)建
//也可以交給spring去托管
Configuration cfg = new Configuration().configure();
sessionFactory = cfg.buildSessionFactory();
//獲取session
Session session = sessionFactory.openSession();
//后面當(dāng)使用JPA的時(shí)候月匣,EntityManager 類似于 Session
Query<BookCard> query = session.createQuery("from BookCard");
//將所有的數(shù)據(jù)查詢出來并放到List集合里
List<BookCard> list = query.getResultList();
//將集合遍歷循環(huán)
for(BookCard bookCard:list){
//打印輸出到控制臺(tái)
System.out.println(bookCard);
}
//關(guān)閉session
session.close();
//關(guān)閉sessionFactory
sessionFactory.close();
//返回list集合
return list;
}
}
(4)在ssh_01.service包里編寫B(tài)ookCardService(接口類)和BookCardServiceImpl(實(shí)現(xiàn)類)。
BookCardService.java:
package ssh_01.service;
import java.util.List;
import ssh_01.entity.BookCard;
public interface BookCardService {
public List<BookCard> getAllBookCard();
}
BookCardServiceImpl.java:
package ssh_01.service;
import java.util.List;
import ssh_01.dao.BookCardDao;
import ssh_01.entity.BookCard;
public class BookCardServiceImpl implements BookCardService{
//dao實(shí)例使用注入方式
private BookCardDao id;
//用于注入使用
public void setId(BookCardDao id) {
this.id = id;
}
@Override
public List<BookCard> getAllBookCard() {
//本類應(yīng)該編寫業(yè)務(wù)邏輯的代碼奋姿,
//但本例沒有業(yè)務(wù)邏輯锄开,就不用寫。
//訪問數(shù)據(jù)庫的代碼称诗,不會(huì)出現(xiàn)在service這一層
//交給dao來操作數(shù)據(jù)庫
List<BookCard> myBookCardList = id.getAllBookCard();
//進(jìn)行其它的業(yè)務(wù)邏輯操作萍悴,比如增加多一個(gè)選項(xiàng),是否過期
//本例不需要
//....
return myBookCardList;
}
}
(5)在ssh_01.action包里編寫IndexAction(action類)寓免。
IndexAction.java:
package ssh_01.action;
import java.text.DecimalFormat;
import java.util.List;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import ssh_01.entity.BookCard;
import ssh_01.service.BookCardService;
//創(chuàng)建IndexAction(action類)繼承ActionSupport接口
public class IndexAction extends ActionSupport {
private static final long serialVersionUID = 1L;
//聲明service癣诱,但不給它創(chuàng)建具體的實(shí)現(xiàn)類的實(shí)例,
private BookCardService is = null;
//添加set()方法
public void setIs(BookCardService is) {
this.is = is;
}
//編寫execute()方法
public String execute() {
//獲取IndexService實(shí)例袜香,調(diào)用getAllBookCard()方法
//將結(jié)果保存到List集合里
List<BookCard> myBookCardList = is.getAllBookCard();
//將查詢出來的結(jié)構(gòu)集打印到控制臺(tái)
System.out.println("結(jié)果集:"+myBookCardList.size());
//獲取Context上下文對(duì)象
ActionContext ac = ActionContext.getContext();
//將myBookCardList集合添加到上下文對(duì)象里
ac.put("myBookCardList", myBookCardList);
//返回一個(gè)字符串
return "success";
}
//金額格式轉(zhuǎn)換
public String formatDouble(double s){
DecimalFormat fmat=new DecimalFormat("\u00A4##.0");
return fmat.format(s);
}
}
第三步 編寫struts.xml(struts配置文件)撕予、applicationContext.xml(spring配置文件)、hibernate.cfg.xml(hibernate配置文件)
(1)在/src/目錄下新建配置文件struts.xml蜈首、applicationContext.xml实抡、hibernate.cfg.xml
image.png
(2)編寫各配置文件
struts.xml:
<?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">
<!-- 上面的頭,注意版本欢策,從樣例里復(fù)制過來 showcase.war\WEB-INF\src\java\struts.xml -->
<struts>
<!-- 告知Struts2運(yùn)行時(shí)使用Spring來創(chuàng)建對(duì)象 -->
<constant name="struts.objectFactory" value="spring" />
<package name="default" namespace="/" extends="struts-default">
<action name="Index" class="myIndexAction">
<result name="success">/WEB-INF/jsp/index.jsp</result>
</action>
</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"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:jee="http://www.springframework.org/schema/jee"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
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
http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 類似于財(cái)務(wù)部門一樣澜术,類就是錢,所有需要類的實(shí)例都由spring去管理 -->
<bean id="myIndexAction" class="ssh_01.action.IndexAction" scope="prototype">
<!-- setIs(myIndexService) -->
<property name="is" ref="myIndexService"/>
</bean>
<!-- myIndexService = new ssh_01.service.IndexServiceImpl() -->
<bean id="myIndexService" class="ssh_01.service.BookCardServiceImpl" scope="prototype">
<property name="id" ref="myIndexDao"/>
</bean>
<bean id="myIndexDao" class="ssh_01.dao.BookCardDaoImpl" scope="prototype">
<!-- 把sessionFactory 注入給IndexDao -->
<property name="sessionFactory" ref="sessionFactory" />
</bean>
<!-- 添加sessionFactory bane 猬腰,注意鸟废,該類是Spring提供的 -->
<bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean" scope="prototype">
<!-- 注入Hibernate 配置文件路徑,前面要加上 classpath:-->
<property name="configLocation" value="classpath:hibernate.cfg.xml"/>
</bean>
</beans>
hibernate.cfg.xml:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- 數(shù)據(jù)庫連接配置 -->
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost:3306/ssh_01</property>
<property name="connection.username">root</property>
<property name="connection.password">123456</property>
<!-- dialect翻譯為方言 Hibernate根據(jù)你選擇的“方言”,針對(duì)每種數(shù)據(jù)庫姑荷,作調(diào)整盒延,如生成不同的SQL語句等 -->
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<!-- 設(shè)置默認(rèn)的數(shù)據(jù)庫連接池 -->
<property name="connection.pool_size">5</property>
<!-- 顯示SQL -->
<property name="show_sql">true</property>
<!-- 格式化SQL -->
<property name="format_sql">true</property>
<!-- 根據(jù)schema更新數(shù)據(jù)表的工具 -->
<property name="hbm2ddl.auto">update</property>
<!-- 數(shù)據(jù)表映射配置文件 -->
<mapping resource="ssh_01/entity/BookCard.hbm.xml"/>
</session-factory>
</hibernate-configuration>
第四步 顯示結(jié)果
(1)在/WebContent/WEB-INF/目錄下創(chuàng)建文件夾jsp缩擂,再在/jsp/目錄下創(chuàng)建一個(gè)index.jsp頁面
image.png
(2)將所有數(shù)據(jù)取出來顯示到index.jsp頁面上
index.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="/struts-tags" prefix="s" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<table border="1">
<tr>
<td>卡號(hào)</td>
<td>姓名</td>
<td>性別</td>
<td>辦卡日期</td>
<td>押金</td>
</tr>
<!-- 使用struts2標(biāo)簽庫中的iterator將所有數(shù)據(jù)遍歷循環(huán)顯示出來 -->
<s:iterator value="#myBookCardList" status="bcs">
<tr>
<td><s:property value="cid"></s:property></td>
<td><s:property value="name"></s:property></td>
<td><s:property value="sex"></s:property></td>
<td><s:date name="cardDate" format="yyyy年MM月dd日"></s:date></td>
<td><s:property value="%{formatDouble(deposit)}"></s:property></td>
</tr>
</s:iterator>
<!-- 判斷查詢出來等于0,就顯示“沒有查找到數(shù)據(jù)” -->
<s:if test="myBookCardList.size()==0">
<tr>
<td colspan="7">沒有查找到數(shù)據(jù)</td>
</tr>
</s:if>
</table>
</body>
</html>
(3)運(yùn)行項(xiàng)目并顯示結(jié)果
表中無數(shù)據(jù)時(shí):
image.png
表中有數(shù)據(jù)時(shí):
image.png