文章目錄
- 前言
- 一、整合環境準備
-
- 1、環境注明
- 2、建立資料庫和表結構語句
- 3、配置Maven pom.xml
- 二、SSM架構整合
-
- 1、SSM架構搭建配置
-
- (1)Spring和MyBatis配置
- (2)SpringMVC配置
- 2、日志配置檔案
- 3、整合初始測試
-
- (1)建立jsp頁面,并編寫controller代碼
- (2)整合初始測試結果
- 4、Maven中使用MyBatis自動生成代碼
- 5、SSM架構整體測試
-
- (1)業務邏輯層
- (2)資料通路層
- (3)控制層
- (4)視圖層
- (5)測試結果
- 三、架構整合源碼的下載下傳
前言
以下針對于Spring + SpringMVC + MyBatis(SSM)架構的整合,隻是個人簡單的了解介紹,簡單記錄提供參考
一、整合環境準備
1、環境注明
Eclipse、Maven 3.5.0、MySQL 8.0.18、JDK 1.8、Tomcat 8、Spring4X、MyBatis 3.4.5
2、建立資料庫和表結構語句
在MySQL中運作:
CREATE DATABASE innerssm;
USE innerssm;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for user_t
-- ----------------------------
DROP TABLE IF EXISTS `user_t`;
CREATE TABLE `user_t` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`age` int(4) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user_t
-- ----------------------------
INSERT INTO `user_t` VALUES (1, '測試使用者', '123', 24);
SET FOREIGN_KEY_CHECKS = 1;
3、配置Maven pom.xml
建立Maven工程,具體建立Maven工程可以檢視其他部落客教程
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>com.sslt</groupId>
<artifactId>innersystem</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>war</packaging>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<!-- spring版本号 -->
<spring.version>4.3.10.RELEASE</spring.version>
<!-- mybatis版本号 -->
<mybatis.version>3.4.5</mybatis.version>
<!-- log4j日志檔案管理包版本 -->
<slf4j.version>1.7.7</slf4j.version>
<log4j.version>2.9.0</log4j.version>
<!-- mysql版本号 -->
<mysql.version>8.0.15</mysql.version>
</properties>
<dependencies>
<!-- junit依賴 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<!-- JavaEE依賴 -->
<dependency>
<groupId>javax</groupId>
<artifactId>javaee-api</artifactId>
<version>7.0</version>
<scope>provided</scope>
</dependency>
<!-- 配置servlet -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<!-- jsp依賴 -->
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>javax.servlet.jsp-api</artifactId>
<version>2.3.1</version>
<scope>provided</scope>
</dependency>
<!-- jstl依賴 -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- Spring核心依賴 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<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-aop</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</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-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- mybatis架構依賴包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<!-- spring mybatis依賴 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.1</version>
</dependency>
<!-- mysql資料庫驅動 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.version}</version>
</dependency>
<!-- c3p0連接配接池 -->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
<!-- log4j依賴 -->
<dependency>
<groupId>org.apache.logging.log4j</groupId>
<artifactId>log4j-core</artifactId>
<version>${log4j.version}</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.1.41</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>${slf4j.version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>${slf4j.version}</version>
</dependency>
<!-- 檔案上傳依賴 -->
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>1.4</version>
</dependency>
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.1</version>
</dependency>
</dependencies>
<!-- 配置使用的JDK版本 -->
<profiles>
<profile>
<id>jdk-1.8</id>
<activation>
<activeByDefault>true</activeByDefault>
<jdk>1.8</jdk>
</activation>
<properties>
<maven.compiler.source>1.8</maven.compiler.source>
<maven.compiler.target>1.8</maven.compiler.target>
<maven.compiler.compilerVersion>1.8</maven.compiler.compilerVersion>
</properties>
</profile>
</profiles>
</project>
二、SSM架構整合
1、Spring:Spring架構是一個開放源代碼的J2EE應用程式架構,是針對bean的生命周期進行管理的輕量級容器。提供了功能強大IOC、AOP及Web MVC等功能。Spring架構主要由七部分組成,分别是 Spring Core、 Spring AOP、 Spring ORM、 Spring DAO、Spring Context、 Spring Web和 Spring Web MVC。我們平時開發接觸最多的估計就是IOC容器,可裝載bean,另外Spring的AOP,事務管理等等都是我們經常用到的。Spring架構比較強大,并不能三言兩語來概括,具體深入學習大家可以自己去了解學習—Spring官網
2、SpringMVC:SpringMVC是在Spring架構内置的MVC的實作。應用于web層,相當于Controller,用來處理使用者請求。簡單了解就是使用者通過位址欄輸入如:http://網站域名/login。SpringMVC就會攔截到這個請求,并且調用Controller層中相應的方法,經過一系列的業務邏輯等操作(其中這些都不是SpringMVC的職責),最終把結果傳回給使用者,并且傳回相應的頁面。就是處理前後過程表現,友善前後端資料的傳輸。
3、MyBatis:MyBatis 是支援定制化 SQL、存儲過程以及進階映射的優秀的持久層架構。可以對配置和原生Map使用簡單的 XML 或注解,将接口和 Java 的 POJOs映射成資料庫中的記錄。個人通俗了解就是能自由控制SQL,提升資料庫通路的效率。可以使用 XML 的方式來組織管理我們的SQL,友善管理和後續優化。
1、SSM架構搭建配置
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLiAzNfRHLGZkRGZkRfJ3bs92YsYTMfVmepNHL90EROJTWq1UMNRVT3V1MMBjVtJWd0ckW65UbM5WOHJWa5kHT20ESjBjUIF2X0hXZ0xCMx81dvRWYoNHLrdEZwZ1Rh5WNXp1bwNjW1ZUba9VZwlHdssmch1mclRXY39CXldWYtlWPzNXZj9mcw1ycz9WL49zZuBnLxgDOxADMxYTMwMjNwAjMwIzLc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
(1)Spring和MyBatis配置
在resources的資源檔案目錄管理XML配置檔案
建立applicationContext.xml的配置檔案,其中包括:
(1.1)Spring架構注解掃描配置;
(1.2)資料源c3p0連接配接池配置;
(1.3)Spring和MyBatis整合配置;
(1.4)事務管理配置;
編寫具體的配置資訊:
<?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:aop="http://www.springframework.org/schema/aop"
xmlns:mvc="http://www.springframework.org/schema/mvc"
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/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 開啟spring的注解掃描 -->
<context:component-scan base-package="com.sslt.service"></context:component-scan>
<!-- 引入配置檔案 -->
<context:property-placeholder location="classpath:jdbc.properties"/>
<!-- 配置資料源c3p0連接配接池 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}" />
<property name="jdbcUrl" value="${jdbc.url}" />
<property name="user" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<!-- 連接配接池中保留的最小連接配接數,預設為:3-->
<property name="minPoolSize" value="1" />
<!--連接配接池中保留的最大連接配接數。預設值: 15 -->
<property name="maxPoolSize" value="5" />
<!-- 初始化連接配接池中的連接配接數,取值應在minPoolSize與maxPoolSize之間,預設為3-->
<property name="initialPoolSize" value="1" />
<!--當連接配接池中的連接配接耗盡的時候c3p0一次同時擷取的連接配接數。預設值: 3 -->
<property name="acquireIncrement" value="1" />
</bean>
<!-- spring和MyBatis整合,不需要mybatis的配置映射檔案 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 注入資料源 -->
<property name="dataSource" ref="dataSource" />
<!-- 掃描entity包 使用别名 -->
<property name="typeAliasesPackage" value="com.sslt.entity" />
<!-- 自動掃描mapping.xml檔案 -->
<property name="mapperLocations" value="classpath:com/sslt/mapper/*.xml"></property>
</bean>
<!-- mapper掃描 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.sslt.mapper" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
</bean>
<!-- 配置事務管理器 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 開啟注解事務管理器 -->
<tx:annotation-driven transaction-manager="transactionManager"/>
</beans>
其中jdbc.properties資料源連結具體資訊配置:
#資料庫驅動
jdbc.driver=com.mysql.cj.jdbc.Driver
#資料庫連接配接
jdbc.url=jdbc:mysql://localhost:3306/innerssm?characterEncoding=utf8&&serverTimezone=UTC
#使用者名
jdbc.username=root
#使用者密碼
jdbc.password=123456
(2)SpringMVC配置
在resources的資源檔案目錄建立springMVC.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:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:mvc="http://www.springframework.org/schema/mvc"
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/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 自動掃描該包 @controller注解的類-->
<context:component-scan base-package="com.sslt.controller"/>
<!-- 開啟springMVC的處理器映射器和處理器擴充卡的掃描 -->
<mvc:annotation-driven/>
<!-- 配置視圖解析器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/pages/" />
<property name="suffix" value=".jsp" />
</bean>
<!-- 配置檔案上傳,如果沒有使用檔案上傳可以不用配置,當然如果不配,那麼配置檔案中也不必引入上傳元件包 -->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<!-- 預設編碼 -->
<property name="defaultEncoding" value="UTF-8" />
<!-- 檔案大小最大值 -->
<property name="maxUploadSize" value="10485760000" />
<!-- 記憶體中的最大值 -->
<property name="maxInMemorySize" value="40960" />
</bean>
</beans>
(2.1)在web.xml中配置DispatcherServlet前端控制器
<!--配置前端控制器 -->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 加載SpringMVC的配置檔案 -->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springMVC.xml</param-value>
</init-param>
<!--啟動伺服器,建立該servlet -->
<load-on-startup>1</load-on-startup>
<async-supported>true</async-supported>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
(2.2)在web.xml中配置解決中文亂碼過濾器
<!--解決中文亂碼的過濾器-->
<filter>
<filter-name>characterEncodingFilter</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>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
(2.3)在web.xml中配置ContextLoaderListener監聽器
Spring監聽器,預設隻加載WEB-INF目錄下的Spring核心配置檔案,為了友善配置檔案管理,我們自定義配置加載,友善維護和管理。
ContextLoaderListener監聽器配置:
<!-- Spring監聽器,預設隻加載WEB-INF目錄下的applicationContext.xml配置檔案 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!--加載Spring核心配置檔案 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
(2.4)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"
version="2.5">
<display-name>innersystem</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>
<!-- Spring監聽器,預設隻加載WEB-INF目錄下的applicationContext.xml配置檔案 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!--加載Spring核心配置檔案 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<!--解決中文亂碼的過濾器-->
<filter>
<filter-name>characterEncodingFilter</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>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!--配置前端控制器 -->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 加載SpringMVC的配置檔案 -->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springMVC.xml</param-value>
</init-param>
<!--啟動伺服器,建立該servlet -->
<load-on-startup>1</load-on-startup>
<async-supported>true</async-supported>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
2、日志配置檔案
在resources的資源檔案目錄建立log4j.properties配置檔案
log4j.properties具體配置資訊:
log4j.rootLogger=INFO,fileout,stdout
#如果有特殊的包需要不同于根日志級别,在此配置
log4j.logger.com.ielpm.pay.df.tfb = INFO
# 控制台輸出,上線時注釋該段落
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d (%F:%L) %-5p %c - %m%n
#檔案輸出
log4j.appender.fileout.File=${catalina.home}/logs/innersystem/innersystem.log
log4j.appender.fileout.ImmediateFlush = false
log4j.appender.fileout.layout=org.apache.log4j.PatternLayout
log4j.appender.fileout.layout.ConversionPattern=%d [%t] (%F:%L) %-5p %c - %m%n
#Buffer size 8K
log4j.appender.fileout.BufferSize=8192
log4j.appender.file.encoding=UTF-8
3、整合初始測試
(1)建立jsp頁面,并編寫controller代碼
在webapp下編寫index.jsp頁面
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!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>項目測試</title>
</head>
<body>
<a href="user/test">初始測試</a>
</body>
</html>
在WEB-INF/pages下編寫user.jsp頁面
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!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>測試</title>
</head>
<body>
<h1>測試成功...</h1>
</body>
</html>
在controller層中編寫代碼UserController.java類
package com.sslt.controller;
import javax.servlet.http.HttpServletRequest;
import org.apache.log4j.Logger;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
@Controller
@RequestMapping(value = "/user")
public class UserController {
/**
* 日志對象
*/
private final static Logger logger = Logger.getLogger(UserController.class);
@RequestMapping(value = "/test")
public String Index(HttpServletRequest request, Model model){
System.out.println("請求成功......");
logger.info("日志列印......");
return "user";
}
}
項目目錄結構
(2)整合初始測試結果
tomcat運作innersystem項目,在浏覽器通路位址:http://127.0.0.1:8080/innersystem/
點選 初始測試 背景處理結果:
點選 初始測試 前端響應頁面:
4、Maven中使用MyBatis自動生成代碼
在pom.xml中添加:
<build>
<plugins>
<!-- Mybatis Generator 代碼自動生成插件 -->
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.5</version>
<configuration>
<configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
<overwrite>true</overwrite>
<verbose>true</verbose>
</configuration>
</plugin>
</plugins>
</build>
在resources的資源檔案目錄建立目錄generator和generatorConfig.xml配置檔案
generatorConfig.xml配置檔案具體内容:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<!-- 資料庫驅動:選擇你的本地硬碟上面的資料庫驅動包-->
<classPathEntry location="D:/mysql-connector-java-8.0.18/mysql-connector-java-8.0.18.jar"/>
<context id="DB2Tables" targetRuntime="MyBatis3">
<commentGenerator>
<property name="suppressDate" value="true"/>
<!-- 是否去除自動生成的注釋 true:是 ; false:否 -->
<property name="suppressAllComments" value="true"/>
</commentGenerator>
<!--資料庫連接配接驅動類,URL,使用者名、密碼 -->
<jdbcConnection driverClass="com.mysql.cj.jdbc.Driver" connectionURL="jdbc:mysql://127.0.0.1:3306/innerssm?serverTimezone=UTC" userId="root" password="123456">
<property name="nullCatalogMeansCurrent" value="true" />
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false"/>
</javaTypeResolver>
<!-- 生成(實體)模型的包名和位置-->
<javaModelGenerator targetPackage="com.sslt.entity" targetProject="src/main/java">
<property name="enableSubPackages" value="true"/>
<property name="trimStrings" value="true"/>
</javaModelGenerator>
<!-- 生成XML映射檔案的包名和位置-->
<sqlMapGenerator targetPackage="com.sslt.mapper" targetProject="src/main/resources">
<property name="enableSubPackages" value="true"/>
</sqlMapGenerator>
<!-- 生成DAO接口的包名和位置-->
<javaClientGenerator type="XMLMAPPER" targetPackage="com.sslt.mapper" targetProject="src/main/java">
<property name="enableSubPackages" value="true"/>
</javaClientGenerator>
<!-- 要生成的表 tableName是資料庫中的表名或視圖名 domainObjectName是實體類名-->
<table tableName="user_t" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
</context>
</generatorConfiguration>
其中資料庫驅動包下載下傳:
(1)在CSDN下載下傳位址:驅動下載下傳(https://download.csdn.net/download/u013526643/12566043)
(2)百度雲盤下載下傳:
連結:https://pan.baidu.com/s/1xLNb1LD1rcNbkkgUSJYEXw
提取碼:rriq
(3)官網下載下傳:https://dev.mysql.com/downloads/connector/j/
根據需求選擇下載下傳的Select Operating System下載下傳最新的版本,這裡選擇–Platform Independent
曆史版本選擇–Archives
MyBatis自動生成代碼流程:
選擇系統右擊選擇–Run AS -->Maven build
在Goals框中輸入:mybatis-generator:generate,點選:Run
再次自動生成代碼時:
重新整理項目:
User.java
package com.sslt.entity;
public class User {
private Integer id;
private String username;
private String password;
private Integer age;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username == null ? null : username.trim();
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password == null ? null : password.trim();
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
}
UserMapper.java
package com.sslt.mapper;
import com.sslt.entity.User;
public interface UserMapper {
int deleteByPrimaryKey(Integer id);
int insert(User record);
int insertSelective(User record);
User selectByPrimaryKey(Integer id);
int updateByPrimaryKeySelective(User record);
int updateByPrimaryKey(User record);
}
UserMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.sslt.mapper.UserMapper">
<resultMap id="BaseResultMap" type="com.sslt.entity.User">
<id column="id" jdbcType="INTEGER" property="id" />
<result column="username" jdbcType="VARCHAR" property="username" />
<result column="password" jdbcType="VARCHAR" property="password" />
<result column="age" jdbcType="INTEGER" property="age" />
</resultMap>
<sql id="Base_Column_List">
id, username, password, age
</sql>
<select id="selectByPrimaryKey" parameterType="java.lang.Integer"
resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from user_t
where id = #{id,jdbcType=INTEGER}
</select>
<delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
delete from user_t
where id = #{id,jdbcType=INTEGER}
</delete>
<insert id="insert" parameterType="com.sslt.entity.User">
insert into user_t (id, username, password,
age)
values (#{id,jdbcType=INTEGER}, #{username,jdbcType=VARCHAR},
#{password,jdbcType=VARCHAR},
#{age,jdbcType=INTEGER})
</insert>
<insert id="insertSelective" parameterType="com.sslt.entity.User">
insert into user_t
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">
id,
</if>
<if test="username != null">
username,
</if>
<if test="password != null">
password,
</if>
<if test="age != null">
age,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="id != null">
#{id,jdbcType=INTEGER},
</if>
<if test="username != null">
#{username,jdbcType=VARCHAR},
</if>
<if test="password != null">
#{password,jdbcType=VARCHAR},
</if>
<if test="age != null">
#{age,jdbcType=INTEGER},
</if>
</trim>
</insert>
<update id="updateByPrimaryKeySelective" parameterType="com.sslt.entity.User">
update user_t
<set>
<if test="username != null">
username = #{username,jdbcType=VARCHAR},
</if>
<if test="password != null">
password = #{password,jdbcType=VARCHAR},
</if>
<if test="age != null">
age = #{age,jdbcType=INTEGER},
</if>
</set>
where id = #{id,jdbcType=INTEGER}
</update>
<update id="updateByPrimaryKey" parameterType="com.sslt.entity.User">
update user_t
set username = #{username,jdbcType=VARCHAR},
password = #{password,jdbcType=VARCHAR},
age = #{age,jdbcType=INTEGER}
where id = #{id,jdbcType=INTEGER}
</update>
</mapper>
5、SSM架構整體測試
(1)業務邏輯層
建立接口UserService.java類
package com.sslt.service;
import com.sslt.entity.User;
public interface UserService {
/**
* 使用者資訊查詢
* @param user
* @return
*/
public User selectParma(User user);
}
建立Service實作類UserServiceImpl.java,實作UserService.java的接口,注入資料通路層接口UserMapper
實作類UserServiceImpl.java
package com.sslt.service.impl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.sslt.entity.User;
import com.sslt.mapper.UserMapper;
import com.sslt.service.UserService;
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
/**
* 使用者資訊查詢
*/
public User selectParma(User user) {
return userMapper.selectParma(user);
}
}
(2)資料通路層
在UserMapper.java類中添加接口selectParma()
在UserMapper.xnl配置檔案中添加接口**selectParma()**實作方法
<select id="selectParma" parameterType="com.sslt.entity.User"resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from user_t
where username = #{username,jdbcType=VARCHAR} and password = #{password,jdbcType=VARCHAR}
</select>
(3)控制層
在controller中的UserController.java添加:
/**
* 跳轉登入頁面
* @param request
* @param model
* @return
*/
@RequestMapping(value = "/login")
public String login(HttpServletRequest request, Model model){
logger.info("跳轉登入頁面......");
return "login";
}
/**
* 使用者登入處理
* @param request
* @param model
* @return
*/
@RequestMapping(value = "/userLogin")
public String userLogin(HttpServletRequest request, Model model){
String view = "";
User user = new User();
user.setUsername(request.getParameter("username"));
user.setPassword(request.getParameter("password"));
logger.info("登入請求成功......");
User userParma = userService.selectParma(user);
if (userParma != null) {
model.addAttribute("user", userParma);
model.addAttribute("message", "登入成功");
view = "success";
logger.info("使用者登入成功資料:" + userParma);
} else {
model.addAttribute("message", "登入失敗");
view = "error";
logger.info("登入失敗......");
}
return view;
}
(4)視圖層
建立login.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!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">
<link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/3.3.5/css/bootstrap.min.css">
<script src="https://cdn.bootcss.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
<title>登入</title>
</head>
<body>
<div class="col-md-6 col-md-offset-3">
<form role="form" action="userLogin" method="post">
<div class="form-group"></div>
<div class="form-group">
<label for="username">使用者名</label>
<input type="text" class="form-control" name="username" id="username" value="" required />
</div>
<div class="form-group">
<label for="amount">密碼</label>
<input type="password" class="form-control" name="password" id="password" value="" required />
</div>
<button type="submit" class="btn btn-primary ">登入</button>
</form>
</div>
</body>
</html>
建立成功頁面success.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!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">
<link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/3.3.5/css/bootstrap.min.css">
<script src="https://cdn.bootcss.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
<title>登入成功</title>
</head>
<body>
<div class="col-md-6 col-md-offset-3">
<div class="panel panel-info">
<div class="panel-heading">操作結果</div>
<div class="panel-body">
<p style="word-break: break-word;">${message}</p>
</div>
</div>
<div class="panel panel-info">
<div class="panel-heading">傳回具體參數</div>
<div class="panel-body">
<p style="word-break: break-word;">使用者:${user.username}</p>
<p style="word-break: break-word;">年齡:${user.age}</p>
</div>
</div>
</div>
</body>
</html>
建立失敗頁面error.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!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">
<link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/3.3.5/css/bootstrap.min.css">
<script src="https://cdn.bootcss.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
<title>登入失敗</title>
</head>
<body>
<div class="col-md-6 col-md-offset-3">
<div class="panel panel-info">
<div class="panel-heading">操作結果</div>
<div class="panel-body">
<p style="word-break: break-word;">${message}</p>
</div>
</div>
</div>
</body>
</html>
(5)測試結果
tomcat運作innersystem項目,在浏覽器通路位址:http://127.0.0.1:8080/innersystem/user/login
輸入使用者名和密碼,登入成功頁面:
輸入使用者名和密碼,登入失敗頁面:
三、架構整合源碼的下載下傳
(1)在CSDN下載下傳位址:SSM架構整合源碼下載下傳(https://download.csdn.net/download/u013526643/12567084)
(2)百度雲盤下載下傳:
連結:https://pan.baidu.com/s/13BIJstfgQmO3oYIipidQeQ
提取碼:1s02