摸爬滚打-SSM整合（Maven版）

最新推荐文章于 2024-05-11 01:56:48 发布

呐呐呐-

最新推荐文章于 2024-05-11 01:56:48 发布

阅读量295

点赞数

分类专栏： ssm spring Java 文章标签： spring mybatis java

本文链接：https://blog.csdn.net/Sky_for_me/article/details/104850782

版权

Java 同时被 3 个专栏收录

28 篇文章 0 订阅

订阅专栏

ssm

9 篇文章 0 订阅

订阅专栏

spring

5 篇文章 0 订阅

订阅专栏

了解SSM

SSM整合准备步骤

工程目录

目录说明

包	所属层	作用
java	无	里面保存着 java 源代码
resources	无	存放各种资源文件，SSM配置文件等
webapp	无	存放静态资源
com.vue.controller	controller	主要负责业务模块的控制，存放各种的控制器
com.vue.service	service	负责业务的主要逻辑，在这里才会调用 dao层
com.vue.entity	dao/在SSM中也叫 mapper	存放实体类的包
com.vue.mapper	dao/在SSM中也叫 mapper	存放 mapper接口和 mapper.xml 的包

com.vue.mapper包的问题：mapper.xml 放在 java 包里可能导致运行时不能正确编译，需要在 Maven 中手动添加一些属性，在下面会写出。

创建数据库

vuespring：


/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80017
 Source Host           : localhost:3306
 Source Schema         : vuespring

 Target Server Type    : MySQL
 Target Server Version : 80017
 File Encoding         : 65001

 Date: 31/03/2020 20:51:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `upwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'aaa', '111');
INSERT INTO `user` VALUES (2, '老王', '222');


SET FOREIGN_KEY_CHECKS = 1;

添加Maven依赖

<?xml version="1.0" encoding="UTF-8"?>

<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>org.example</groupId>
  <artifactId>VueSpring</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>VueSpring Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.7</maven.compiler.source>
    <maven.compiler.target>1.7</maven.compiler.target>
    <spring.version>5.2.3.RELEASE</spring.version>
    <mybatis.version>3.5.2</mybatis.version>
    <mysql.version>5.1.47</mysql.version>
    <slf4j.version>1.6.6</slf4j.version>
    <log4j.version>1.2.17</log4j.version>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <scope>compile</scope>
    </dependency>
    <dependency>
      <groupId>org.junit.jupiter</groupId>
      <artifactId>junit-jupiter</artifactId>
      <version>RELEASE</version>
      <scope>compile</scope>
    </dependency>
    <!--Spring 核心依赖 -->
    <dependency>
      <groupId>commons-logging</groupId>
      <artifactId>commons-logging</artifactId>
      <version>1.2</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-context</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context-support</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-aspects</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <!-- Spring 事务 依赖 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-orm</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <!-- Spring AOP 依赖 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aop</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>aopalliance</groupId>
      <artifactId>aopalliance</artifactId>
      <version>1.0</version>
    </dependency>
    <dependency>
      <groupId>org.aspectj</groupId>
      <artifactId>aspectjweaver</artifactId>
      <version>1.9.5</version>
    </dependency>
    <!-- SpringMVC 依赖 -->
    <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>
    <!-- Spring 测试依赖 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <!-- Mybatis 依赖 -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>${mybatis.version}</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.2</version>
    </dependency>
    <!-- mysql 驱动 -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>${mysql.version}</version>
      <scope>runtime</scope>
    </dependency>
    <!-- 连接池 -->
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>0.9.5.2</version>
    </dependency>
    <!-- 日志 -->
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>${log4j.version}</version>
    </dependency>
    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-log4j12</artifactId>
      <version>${slf4j.version}</version>
    </dependency>
    <!-- web -->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>servlet-api</artifactId>
      <version>2.5</version>
      <scope>provided</scope>
    </dependency>
    <dependency>
      <groupId>javax.servlet.jsp</groupId>
      <artifactId>jsp-api</artifactId>
      <version>2.0</version>
      <scope>provided</scope>
    </dependency>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>

    <!-- 转换json依赖：使用@ResponseBody向页面传json数据的依赖包，不用可以去掉 -->
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-annotations</artifactId>
      <version>2.9.8</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-core</artifactId>
      <version>2.9.8</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
      <version>2.9.8</version>
    </dependency>

    <!-- 文件上传：不用可以去掉 -->
    <dependency>
      <groupId>commons-fileupload</groupId>
      <artifactId>commons-fileupload</artifactId>
      <version>1.3.1</version>
    </dependency>
    <dependency>
      <groupId>commons-io</groupId>
      <artifactId>commons-io</artifactId>
      <version>2.4</version>
    </dependency>

  </dependencies>

  <build>
    <resources>
      <resource>
        <directory>src/main/java</directory>
        <includes>
          <include>com/vue/mapper/*.xml</include>
        </includes>
        <filtering>true</filtering>
      </resource>
    </resources>
    <finalName>VueSpring</finalName>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.1.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.8.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.22.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <version>3.2.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
      </plugins>
    </pluginManagement>
  </build>
</project>

解决 mapper.xml 文件没有编译的配置：

<build>
	<resources>
      <resource>
        <directory>src/main/java</directory>
        <includes>
          <include>com/vue/mapper/*.xml</include>
        </includes>
        <filtering>true</filtering>
      </resource>
    </resources>
</build>

配置db.properties数据库连接属性

db.properties：

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/vuespring?ucharacterEncoding=utf8&useSSL=false
jdbc.username=root
jdbc.password=这里的密码看自己的数据库密码是什么就写什么

配置log4j.properties日志

log4j.properties：

# rootLogger 第一参数为日志级别, 其后参数为日志载体
log4j.rootLogger=DEBUG,Console,File

log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.Target=System.out

log4j.appender.Console.layout = org.apache.log4j.PatternLayout
#设定输出格式
log4j.appender.Console.layout.ConversionPattern=[%d][%p][%c] %m%n

log4j.appender.File = org.apache.log4j.RollingFileAppender

log4j.appender.File.File = logs/ssm.log

log4j.appender.File.MaxFileSize = 10MB

log4j.appender.File.Threshold = ALL
log4j.appender.File.layout = org.apache.log4j.PatternLayout
log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH\:mm\:ss}][%c]%m%n

配置applicationContext.xml（service层）

<?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.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
        http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd">

    <context:component-scan base-package="com.vue">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

    <!-- 配置事务管理器 -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!-- 配置通知类 -->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <!-- 设置传播行为 -->
        <tx:attributes>
            <tx:method name="*" propagation="REQUIRED" read-only="false"/>
            <!-- select/find开头的所有方法为只读 -->
            <tx:method name="select*" propagation="SUPPORTS" read-only="true"/>
            <tx:method name="find*" propagation="SUPPORTS" read-only="true"/>
        </tx:attributes>
    </tx:advice>

    <!-- aop配置 -->
    <aop:config>
        <!-- 切面配置 -->
        <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.vue.service.*.*(..))"/>
    </aop:config>

    <!-- 引入peroperties文件 -->
    <context:property-placeholder location="classpath:db.properties"/>
    <!-- 配置连接池 -->
    <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}"/>
        <!-- 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>

    <!-- 配置mybatis中的SqlSessionFactory工厂 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
        <property name="typeAliasesPackage" value="com.vue.entity"/>
    </bean>

    <!-- 配置mapper包扫描，创建mapper代理对象，如果mapper.xml和mapper.java在同一个文件夹下这样写就行了 -->
    <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.vue.mapper"/>
    </bean>

</beans>

配置springmvc.xml（controller层）

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       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-4.3.xsd
                           http://www.springframework.org/schema/mvc
                           http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
                           http://www.springframework.org/schema/context
                           http://www.springframework.org/schema/context/spring-context-4.3.xsd">

    <!-- 扫描controller包下的类，注册进spring容器中 -->
    <context:component-scan base-package="com.vue.controller"/>

    <!-- 开启springmvc注解支持，自动创建处理器映射器和处理器适配器 -->
    <mvc:annotation-driven/>

    <!-- 过滤静态资源 -->
    <mvc:default-servlet-handler />

    <!-- 配置视图解析器 -->
    <bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/"/>
        <property name="suffix" value=".jsp"/>
    </bean>

</beans>

配置mybatis-config.xml（dao层）

<?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>
    <!-- 因为在applicationContext.xml中的SqlSessionFactory配置中可以配置大部分属性，
    并且在这个教程中不涉及其Mybatis设置，因此不需要在此配置属性-->
</configuration>

项目测试

dao层

UserMapper.java

package com.vue.mapper;

import com.vue.entity.User;

/**
 * @author wsw16
 */
public interface UserMapper {
    User selectByAccount(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.vue.mapper.UserMapper">
    <resultMap id="baseResultMap" type="com.vue.entity.User">
        <id property="uid" jdbcType="INTEGER" column="uid"/>
        <result property="uname" jdbcType="VARCHAR" column="uname"/>
        <result property="upwd" jdbcType="VARCHAR" column="upwd"/>
    </resultMap>
    <select id="selectByAccount" parameterType="com.vue.entity.User" resultMap="baseResultMap">
        select * from user where uname = #{uname,jdbcType=VARCHAR} and upwd = #{upwd,jdbcType=VARCHAR}
    </select>
</mapper>

service层

UserService.java

package com.vue.service;

import com.vue.entity.User;
import com.vue.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * @author wsw16
 */
@Service
public class UserService {
    @Autowired
    private UserMapper userMapper;

    public User selectByAccount(User record) {
        return userMapper.selectByAccount(record);
    }
}

controller层

UserController.java

package com.vue.controller;

import com.vue.entity.User;
import com.vue.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.*;

@Controller
@SessionAttributes("user")
public class UserController {
    @Autowired
    private UserService userService;

    @GetMapping("/login")
    public String tologin(){
        return "login";
    }

    @PostMapping("/login")
    public String login(ModelMap modelMap, String uname, String upwd) {
        // 将要登录的账号密码封装进bean里面
        User userLogin = new User();
        userLogin.setUname(uname);
        userLogin.setUpwd(upwd);
        // 连接数据库判断账号密码是否正确，如果userSuccess==null，就代表登录失败
        User userSuccess = userService.selectByAccount(userLogin);
        if (userSuccess != null) {
            // 将用户信息保存到request域中，用于页面获取数据
            modelMap.addAttribute("user", userSuccess);
            // 正确则跳转成功界面
            return "redirect: success.jsp";
        } else {
            // 如果userSuccess为空，代表登录失败，输出错误信息
            modelMap.addAttribute("errMsg", "账号或密码错误");
            return "login";
        }
    }
}

@SessionAttributes属性：
value：字符串数组，用于将模型中的同名的数据存储到session中，如果只有单个属性，可以省略 value = “user” 中的前缀：value =。
name：与value功能相同。
type：可以指定多个参数类型，将模型中相同类型的数据存储到session中。

测试：登录功能

login.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>登录</title>
</head>
<body>
<form action="login" method="post">
    <c:if test="${errMsg != null}">
        <h1>${errMsg}</h1>
    </c:if>
    <label><input type="text" name="uname" placeholder="请输入账户名"></label>
    <label><input type="text" name="upwd" placeholder="请输入密码"></label>
    <button type="submit">登录</button>
</form>
</body>
</html>

success.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>成功</title>
</head>
<body>
    <h1>欢迎，${user.uname}</h1>
</body>
</html>

登录：先输入错误的账号（数据库中已有账号）

在这里插入图片描述
报错，显示错误信息

输入正确的账号密码

在这里插入图片描述
登录成功，回显账号名

总结

总结一下难点：编写配置文件时要注意；编写class类时不要忘记加上对应的注解；mapper.xml 容易写错。
测试模块就不搞太复杂，CRUD操作感兴趣的可以自己编写一下。


如果该文章有帮到你的忙，我会很开心。

知识点引用：
@SessionAttributes属性： https://www.cnblogs.com/caoyc/p/5635914.html

呐呐呐-

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
摸爬滚打-SSM整合（Maven版）

SSM（Maven）项目复习
复制链接

扫一扫

专栏目录

摸爬滚打-SSM整合（Maven版）

整合过程

了解SSM

SSM整合准备步骤

工程目录

目录说明

创建数据库

添加Maven依赖

配置db.properties数据库连接属性

配置log4j.properties日志

配置applicationContext.xml（service层）

配置springmvc.xml（controller层）

配置mybatis-config.xml（dao层）

项目测试

dao层

UserMapper.java

UserMapper.xml

service层

UserService.java

controller层

UserController.java

测试：登录功能

login.jsp

success.jsp

登录：先输入错误的账号（数据库中已有账号）

输入正确的账号密码

总结