目錄
- 一、搭建資料庫環境
- 二、基本環境搭建
- 1、創建maven專案,添加web支持
- 2、匯入依賴
- 3、建立專案基本結構
- 三、MyBatis層撰寫
- 1、撰寫資料庫組態檔
- 2、IDEA關聯資料庫
- 3、撰寫MyBatis核心組態檔
- 4、撰寫pojo物體類
- 5、撰寫dao層
- 1. 撰寫Mapper介面
- 2. 撰寫Mapper介面對應的Mapper.xml
- 6、撰寫service層
- 1. 撰寫service層的介面
- 2. 撰寫service層介面實作類
- 四、Spring層撰寫
- 1、Spring整合dao層
- 2、Spring整合service層
- 五、SpringMVC層撰寫
- 1、撰寫spring-mvc.xml
- 2、Spring組態檔整合
- 3、配置web.xml
- 4、撰寫Controller
- 5、撰寫視圖層
- 1. 撰寫index.jsp
- 2. 撰寫展示所有書籍頁面allBooks.jsp
- 6、運行測驗
實驗環境為:IDEA2020.1+MySQL8.0.21+Tomcat9.0.36+Maven3.3.9
最終專案結構圖:
![]()
一、搭建資料庫環境
創建一個存放書籍資料的資料庫表
CREATE DATABASE `ssmbuild`;
USE `ssmbuild`;
DROP TABLE IF EXISTS `books`;
CREATE TABLE `books` (
`bookID` INT(10) NOT NULL AUTO_INCREMENT COMMENT '書id',
`bookName` VARCHAR(100) NOT NULL COMMENT '書名',
`bookCounts` INT(11) NOT NULL COMMENT '數量',
`detail` VARCHAR(200) NOT NULL COMMENT '描述',
KEY `bookID` (`bookID`)
) ENGINE=INNODB DEFAULT CHARSET=utf8
INSERT INTO `books`(`bookID`,`bookName`,`bookCounts`,`detail`)VALUES
(1,'Java',1,'從入門到放棄'),
(2,'MySQL',10,'從刪庫到跑路'),
(3,'Linux',5,'從進門到進牢');
生成表格:
二、基本環境搭建
1、創建maven專案,添加web支持
2、匯入依賴
<dependencies>
<!--Junit-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.13</version>
</dependency>
<!--資料庫驅動-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.21</version>
</dependency>
<!-- 資料庫連接池:c3p0 -->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.5</version>
</dependency>
<!--Servlet-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
</dependency>
<!--JSP-->
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.2</version>
</dependency>
<!--jstl-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!--Mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.5</version>
</dependency>
<!--Mybatis-Spring-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.5</version>
</dependency>
<!--Spring-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.2.8.RELEASE</version>
</dependency>
<!--Spring操作資料庫,還需要spring-jdbc-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdb c</artifactId>
<version>5.2.6.RELEASE</version>
</dependency>
<!--lombok-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.12</version>
</dependency>
</dependencies>
最后為了防止maven組態檔無法被匯出或生效,加入以下代碼
<build>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
</resources>
</build>
3、建立專案基本結構
在
src/main/java目錄下新建以下四個包,為后續實驗準備
pojo:用來放物體類dao:資料訪問層,data access objectservice:服務層,呼叫dao層controller:控制層,呼叫service層
三、MyBatis層撰寫
1、撰寫資料庫組態檔
在resource目錄下新建
database.properties![]()
- 注意MySQL8.0以上要設定時區,最后加上
serverTimezone=Asia/Shanghai
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai
jdbc.username=root
jdbc.password=200024
2、IDEA關聯資料庫
時區問題解決方案:https://blog.csdn.net/liuqiker/article/details/102455077
set global time_zone = '+8:00';
打開上述新建的資料表

3、撰寫MyBatis核心組態檔
在resource目錄下新建
mybatis-config.xml![]()
- 資料源的配置,交給后續
Spring去做
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--別名-->
<typeAliases>
<package name="pojo"/>
</typeAliases>
</configuration>
4、撰寫pojo物體類
在
pojo包下創建資料庫表所對應的物體類Books,這里使用了lombok插件![]()
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Books {
private int bookID;
private String bookName;
private int bookCounts;
private String detail;
}
5、撰寫dao層
1. 撰寫Mapper介面
在
dao包下新建BookMapper介面,撰寫增刪改查四種業務對應的方法
public interface BookMapper {
//增加一本書
int addBook(Books books);
//洗掉一本書
//@Param注解指定傳入引數的名稱
int deleteBookByID(@Param("bookID") int id);
//更新一本書
int updateBook(Books books);
//查詢一本書
//@Param注解指定傳入引數的名稱
Books queryByID(@Param("bookID") int id);
//查詢全部的書
List<Books> queryAllBooks();
}
2. 撰寫Mapper介面對應的Mapper.xml
一個
Mapper.xml對應一個Mapper介面,要用namespace系結上述介面
- 實作上述介面里的所有方法
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="dao.BookMapper">
<!--增加一本書-->
<insert id="addBook" parameterType="pojo.Books">
insert into ssmbuild.books(bookName,bookCount,detail)
values (#{bookName},#{bookCount},#{detail})
</insert>
<!--洗掉一本書-->
<delete id="deleteBookByID" parameterType="int">
delete from ssmbuild.books where bookID=#{bookID}
</delete>
<!--更新一本書-->
<update id="updateBook" parameterType="pojo.Books">
update ssmbuild.books set
bookName=#{bookName},bookCounts=#{bookCounts},detail=#{detail}
where bookID=#{bookID} ;
</update>
<!--查詢一本書-->
<select id="queryByID" resultType="pojo.Books">
select * from ssmbuild.books where bookID=#{bookID}
</select>
<!--查詢所有書-->
<select id="queryAllBooks" resultType="pojo.Books">
select * from ssmbuild.books
</select>
</mapper>
然后到mybatis核心組態檔中注冊上述mapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--別名-->
<typeAliases>
<package name="pojo"/>
</typeAliases>
<!--注冊mapper-->
<mappers>
<mapper class="dao.BookMapper"/>
</mappers>
</configuration>
6、撰寫service層
1. 撰寫service層的介面
在
service包下新建BookService介面,同Mapper介面里的方法一致
package service;
import pojo.Books;
import java.util.List;
public interface BookService {
//增加一本書
int addBook(Books books);
//洗掉一本書
int deleteBookByID(int id);
//更新一本書
int updateBook(Books books);
//查詢一本書
Books queryByID(int id);
//查詢全部的書
List<Books> queryAllBooks();
}
2. 撰寫service層介面實作類
然后再
service包下新建上述介面的實作類BookServiceImpl
service層用來呼叫dao層,所以內置私有屬性為dao層的Mapper介面物件
package service;
import dao.BookMapper;
import pojo.Books;
import java.awt.print.Book;
import java.util.List;
//service層呼叫dao層
public class BookServiceImpl implements BookService {
//dao層的Mapper介面物件
private BookMapper bookMapper;
//set方法,為后續Spring注入準備
public void setBookMapper(BookMapper bookMapper) {
this.bookMapper = bookMapper;
}
public int addBook(Books books) {
//呼叫dao層的方法
return bookMapper.addBook(books);
}
public int deleteBookByID(int id) {
//呼叫dao層的方法
return bookMapper.deleteBookByID(id);
}
public int updateBook(Books books) {
//呼叫dao層的方法
return bookMapper.updateBook(books);
}
public Books queryByID(int id) {
//呼叫dao層的方法
return bookMapper.queryByID(id);
}
public List<Books> queryAllBooks() {
//呼叫dao層的方法
return bookMapper.queryAllBooks();
}
}
四、Spring層撰寫
1、Spring整合dao層
在resource目錄下新建
spring-dao.xml![]()
-
關聯資料庫組態檔
database.properties,要引入context約束 -
配置
MyBatis資料源,這里使用第三方的c3p0,還可以附加一些私有屬性 -
創建
sqlSessionFactory,在 MyBatis-Spring 中,則使用SqlSessionFactoryBean來創建,要配置兩個重要屬性configLocation系結MyBatis核心組態檔dataSource指定資料源(必要)
-
配置自動掃描包
dao,動態實作了dao層介面可以注入到Spring容器中(在原來我們是創建
sqlSessionTemplate物件,然后再創建一個Mapper介面實作類,其中內置sqlSessionTemplate私有物件,通過該物件進行操作)
<?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 https://www.springframework.org/schema/context/spring-context.xsd">
<!--1.關聯資料庫組態檔-->
<context:property-placeholder location="classpath:database.properties"/>
<!--2.資料庫連接池
dbcp 半自動化操作 不能自動連接
c3p0 自動化操作(自動的加載組態檔 并且設定到物件里面)
druid、hikari-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<!--配置連接池屬性,使用了EL運算式-->
<property name="driverClass" value="${jdbc.driver}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<!-- c3p0連接池的私有屬性 -->
<property name="maxPoolSize" value="30"/>
<property name="minPoolSize" value="10"/>
<!-- 關閉連接后不自動commit -->
<property name="autoCommitOnClose" value="false"/>
<!-- 獲取連接超時時間 -->
<property name="checkoutTimeout" value="10000"/>
<!-- 當獲取連接失敗重試次數 -->
<property name="acquireRetryAttempts" value="2"/>
</bean>
<!--3.sqlSessionFactory-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--參考上述資料源-->
<property name="dataSource" ref="dataSource"/>
<!--系結MyBatis組態檔-->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
</bean>
<!--4.配置dao介面掃描包,動態實作了Dao介面可以注入到Spring容器中-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--注入sqlSessionFactory-->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
<!--要掃描的dao包-->
<property name="basePackage" value="dao"/>
</bean>
</beans>
2、Spring整合service層
在resource目錄下新建
spring-service.xml![]()
- 配置掃描
service包,使該包下的注解生效 - 將所有業務類注入到
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 https://www.springframework.org/schema/context/spring-context.xsd">
<!--1.掃描service下的包,這個包下的注解就會生效-->
<context:component-scan base-package="service"/>
<!--將所有的業務類注入到Spring,可以通過配置或者注解實作-->
<bean id="BookServiceImpl" class="service.BookServiceImpl">
<!--這里的ref指向spring-dao.xml最后Spring注入的dao介面-->
<property name="bookMapper" ref="bookMapper"/>
</bean>
<!--宣告式事務配置-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<!--注入資料源-->
<property name="dataSource" ref="dataSource"/>
</bean>
</beans>
五、SpringMVC層撰寫
1、撰寫spring-mvc.xml
- 自動掃描包
- 過濾靜態資源
- 支持mvc注解驅動
- 視圖決議器
<?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:mvc="http://www.springframework.org/schema/mvc"
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/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/context
https://www.springframework.org/schema/context/spring-context.xsd">
<!--開啟SpringMVC注解驅動-->
<mvc:annotation-driven/>
<!--靜態資源過濾-->
<mvc:default-servlet-handler/>
<!--掃描包controller-->
<context:component-scan base-package="controller"/>
<!--視圖決議器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/"/>
<property name="suffix" value=".jsp"/>
</bean>
</beans>
2、Spring組態檔整合
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"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd">
<import resource="spring-dao.xml"/>
<import resource="spring-service.xml"/>
<import resource="spring-mvc.xml"/>
</beans>
3、配置web.xml
- 注冊
DispatcherServlet,需要系結SpringMVC組態檔,這里一定要系結整體的組態檔applicationContext.xml,并設定啟動級別 - 增加亂碼過濾
- 設定session過期時間
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
version="4.0">
<!--DispatcherServlet-->
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!--亂碼過濾-->
<filter>
<filter-name>encodingFilter</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>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!--session過期時間-->
<session-config>
<session-timeout>15</session-timeout>
</session-config>
</web-app>
4、撰寫Controller
再
controller包下新建BookController類![]()
@Controller
@RequestMapping("/book")
public class BookController {
//controller層呼叫service層
@Autowired
@Qualifier("BookServiceImpl")
private BookService bookService;
//查詢全部書籍,并且回傳到一個頁面進行顯示
@RequestMapping("/allBooks")
public String list(Model model) {
List<Books> books = bookService.queryAllBooks();
model.addAttribute("list", books);
return "allBooks";
}
}
5、撰寫視圖層
在
web/WEB-INF/目錄下新建jsp包,用來存放我們自定義視圖頁面![]()
1. 撰寫index.jsp
超鏈接跳轉到我們自定的展示所有書籍頁面
allBooks.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>首頁</title>
</head>
<body>
<h5>
<a href="https://blog.csdn.net/qq_45173404/article/details/${pageContext.request.contextPath}/book/allBooks">進入書籍頁面</a>
</h5>
</body>
</html>
2. 撰寫展示所有書籍頁面allBooks.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>全部書籍展示</title>
</head>
<body>
<h1>全部書籍展示</h1>
${list}
</body>
</html>
6、運行測驗
配置Tomcat啟動測驗,記得添加lib目錄,否則Tomcat啟動不來
啟動Tomcat后,默認進入的index.jsp

然后我們點擊超鏈接
成功顯示了我們的所有書籍!
到此位置,SSM整合專案到此結束,后續大家可以自己實作相關業務!!!
轉載請註明出處,本文鏈接:https://www.uj5u.com/qianduan/1429.html
標籤:其他
