个人笔记之SSM

最新推荐文章于 2024-05-31 10:46:10 发布

雨桐Miracle

最新推荐文章于 2024-05-31 10:46:10 发布

阅读量143

点赞数

本文链接：https://blog.csdn.net/qq_52315336/article/details/129777322

版权

张老师这周末讲的上课笔记，整理分享一下。
在这里插入图片描述

SSM

SSM整合

SSM整合

SSH:Spring+Struts+Hibernate
SSM:Spring+SpringMVC+Mybatis(MyBatisPlus)

一.版本

Spring6+JDK17+Tomcat10+MySql18+Maven
Spring5+JDK17(或之前)+Tomcat9+MySql18+Maven

二.思路

Spring+Mybatis
SpringMVC+Spring+Mybatis

三.步骤

新建Maven Web项目
配置poom.xml依赖
Mybatis,Spring-webMVC,Mysql驱动，lombok,jstl,Servlet,junit,Mybatis-Spring,Spring-orm，druid(连接池)
Mybatis相关配置文件
mybatis-config.xml,db.properties,mapper.xml
mybatis-config.xml:别名，SQL日志，数据源配置（username,password,driver）
mapper.xml:insert,select,update,delete
Spring+Mybatis相关配置
spring.xml:扫描基包
DataSource,SessionFactory,扫描Mapper接口包
数据库的设计及初始化

CREATE TABLE `book` (
  `bookid` int NOT NULL AUTO_INCREMENT,
  `bookname` varchar(50) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `author` varchar(50) DEFAULT NULL,
  `pubDate` date DEFAULT NULL,
  `addDate` datetime DEFAULT NULL,
  `modDate` datetime DEFAULT NULL,
  PRIMARY KEY (`bookid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

如图：
在这里插入图片描述

代码：
pojo(实体类)
dao接口
service
编写mapper.xml,编写SQL

SpringMVC相关配置
web.xml,springmvc.xml

四.详细步骤

1.建库建表

CREATE TABLE `book` (
  `bookid` int NOT NULL AUTO_INCREMENT,
  `bookname` varchar(50) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `author` varchar(50) DEFAULT NULL,
  `pubDate` date DEFAULT NULL,
  `addDate` datetime DEFAULT NULL,
  `modDate` datetime DEFAULT NULL,
  PRIMARY KEY (`bookid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

2.新建MavenWeb项目

3.配置pom.xml文件

Mybatis,Spring-webMVC,Mysql驱动，lombok,jstl,Servlet,junit,Mybatis-Spring,Spring-orm，druid(连接池)

完整的配置

<?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>ssm2023</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>ssm2023 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>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
<!--mybatis依赖-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.6</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-orm</artifactId>
      <version>4.0.4.RELEASE</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>5.2.6.RELEASE</version>
    </dependency>

    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>2.0.7</version>
    </dependency>
<!--mysql驱动-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.29</version>
    </dependency>

    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.18.24</version>
    </dependency>

    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>

    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>servlet-api</artifactId>
      <version>2.5</version>
    </dependency>

    <!--连接池-->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.24</version>
    </dependency>

  </dependencies>

  <build>
    <finalName>ssm2023</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>

4.配置Mybatis

新建mybatis-config.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>
    <settings>
        <!--日志配置-->
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
    <typeAliases>
        <package name="com.wdzl.pojo"/>
    </typeAliases>
</configuration>

连接数据库----映射文件----Dao接口----POJO实体类
1.新建实体类

package com.wdzl.pojo;

import lombok.Data;

import java.util.Date;

@Data
public class Book {
    private  Integer bookId;
    private String bookName;
    private float price;
    private String author;
    private Date pubDate;//出版日期
    private Date moDate;//修改日期
    private Date addDate;//添加日期

}

2.Dao接口

package com.wdzl.dao;

import com.wdzl.pojo.Book;

import java.util.List;

public interface IBookDao {
    List<Book> queryAll();
    void save (Book book);

}

3.mapper映射

<?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.wdzl.dao.IBookDao">
<select id="queryAll" resultType="book">
select bookid,bookname,price,author,pubDate,addDate,modDate from book
</select>
<insert id="save" parameterType="book">
insert into book(bookid,bookname,price,author,pubDate,addDate,modDate)
values(#{bookName},#{price},#{author},#{pubDate},#{addDate},#{modDate})
</insert>
</mapper>

5.Spring整合Mybatis的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"
       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">

       <context:component-scan base-package="com.wdzl"/>
       <context:property-placeholder location="classpath:db.properties"/>
    <!--Spring+Mybatis整合
    请求>Dispatcher>Controller>Service>Dao>SessionFactory>DataSource>Mysql
    -->
    <!--DataSource-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"/>
    <property name="username" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
    <property name="driverClassName" value="${jdbc.driver}"/>
    <property name="url" value="${jdbc.url}"/>
</bean>
    <!--SessionFactory-->
    <bean id="SessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="mapperLocations" value="classpath:mapper/*.xml"/>
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
    </bean>
    <!--Mybatis接口扫描-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.wdzl.dao"/>
        <property name="sqlSessionFactoryBeanName" value="sessionFactory"/>
    </bean>
</beans>

6.新建业务并注解

新建接口

package com.wdzl.service;

import com.wdzl.pojo.Book;

import java.util.List;

public interface IBookService {
    List<Book> queryAll();
    void save(Book book);
}

新建实现类

package com.wdzl.service;

import com.wdzl.dao.IBookDao;
import com.wdzl.pojo.Book;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public class BookServiceImpl implements IBookService {
@Autowired
private IBookDao bookDao;

    @Override
    public List<Book> queryAll() {
        return bookDao.queryAll();
    }

    @Override
    public void save(Book book) {
        bookDao.save(book);

    }
}

7.单元测试

测试Spring和Mybatis是否整合成功

添加juint和Spring-Test依赖
新建test测试目录
编写测试用例
+在src目录下新建test目录

添加junit 4的依赖

<dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>

添加Spring-test依赖

<dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>5.2.6.RELEASE</version>
    </dependency>

编写测试用例

新建test目录
新建测试用例类
- 使用注解
- 依赖注入

import com.wdzl.dao.IBookDao;
import com.wdzl.service.IBookService;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.junit.jupiter.SpringJUnitConfig;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

@SpringJUnitConfig(locations="classpath:spring-dao.xml")
@RunWith(SpringJUnit4ClassRunner.class)
public class SSMTest {
    @Autowired
    private IBookDao bookDao;

    @Test
    public void testSsm(){
        bookDao.queryAll().forEach(System.out::println);
    }
}

五.SpringMVC+Spring

web.xml
SpringMVC.xml
编写控制器
+依赖业务

1.配置web.xml文件

<!DOCTYPE web-app PUBLIC
        "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
        "http://java.sun.com/dtd/web-app_2_3.dtd" >

<web-app>
    <display-name>Archetype Created Web Application</display-name>
    <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:spring-mvc.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>
</web-app>

2.新建和配置Spring-MVC.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">
<!--视图解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/jsp"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>
</beans>

3.新建控制器

package com.wdzl.control;

import com.wdzl.pojo.Book;
import com.wdzl.service.IBookService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.ui.ModelMap;
import sun.misc.Contended;

import java.util.List;

@Contended
public class BookController {
    @Autowired
    private IBookService bookService;
    public String queryAll(ModelMap modelMap){
        List<Book> books=bookService.queryAll();
        modelMap.put("list",books);
        return "list";

    }

}

4.新建list.jsp

<%--
  Created by IntelliJ IDEA.
  User: 我的电脑
  Date: 2023/3/27
  Time: 18:00
  To change this template use File | Settings | File Templates.
--%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<c:forEach items="${list}" var="book">
    ${book}
</c:forEach>
</body>
</html>

5.部署和运行

注意：访问 list 时，爆出404 异常
原因： web 项目元数据文件为 web.xml （程序入口）
发现通过web.xml 不能关联所有的其他 spring-dao.xml和其他映射文件等
解决办法：
新建 spring文件命名 spring-ssm.xml
在此文件中导入其他的文件：spring-dao.xml 和 spring-mvc.xml
再修改 web.xml ：导入加载的文件为：spring-ssm.xml

新建 spring-ssm.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="classpath:spring-dao.xml"/>
<import resource="classpath:spring-mvc.xml"/>
</beans>

修改web.xml

<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-ssm.xml</param-value>
</init-param>

完整web.xml

<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >
<web-app>
<display-name>Archetype Created Web Application</display-name>
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servletclass>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-ssm.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>
</web-app>

在这里插入图片描述

雨桐Miracle

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
个人笔记之SSM

SSM整合SSH:Spring+Struts+HibernateSSM:Spring+SpringMVC+Mybatis(MyBatisPlus)Spring6+JDK17+Tomcat10+MySql18+MavenSpring5+JDK17(或之前)+Tomcat9+MySql18+Maven如图：代码：pojo(实体类)dao接口service编写mapper.xml,编写SQL2.新建MavenWeb项目3.配置pom.xml文件Mybatis
复制链接

扫一扫