SSM框架整合

最新推荐文章于 2024-06-02 22:31:51 发布

Van-bo

最新推荐文章于 2024-06-02 22:31:51 发布

阅读量171

点赞数

分类专栏：框架学习文章标签： spring mybatis java springmvc

本文链接：https://blog.csdn.net/qq_41573860/article/details/115873575

版权

框架学习专栏收录该内容

13 篇文章 3 订阅

订阅专栏

整合思路

主要分为Controller，service层，dao层

整合dao:mybatis和spring的整合，通过spring来管理mapper接口，数据源，使用mapper的扫描器自动扫描mapper接口

service层：通过spring来管理service类，并将dao层的实例注入到service中使用，另事务相关的操作也通过spring进行管理

整合controller层：springMVC是spring中的一部分，不需要进行整合，spring管理将service层实例注入到controller层

1.数据库与实体类

以student表的信息为例：

根据数据库，建立对应的实体类Student

package com.bean;

/**
 * Description :
 * Created by Resumebb
 * Date :2021/4/19
 */
public class Student {
    /**
     * 和数据库中的Student表对应
     */
    private Integer SID;
    private String Sname;
    private String Ssex;
    private Integer Sage;
    //省略的getter和setter方法

    public Integer getSID() {
        return SID;
    }

    public void setSID(Integer SID) {
        this.SID = SID;
    }

    public String getSname() {
        return Sname;
    }

    public void setSname(String sname) {
        Sname = sname;
    }

    public String getSsex() {
        return Ssex;
    }

    public void setSsex(String ssex) {
        Ssex = ssex;
    }

    public Integer getSage() {
        return Sage;
    }

    public void setSage(Integer sage) {
        Sage = sage;
    }

    @Override
    public String toString() {
        return "com.pojo{" +
                "SID=" + SID +
                ", Sname='" + Sname + '\'' +
                ", Ssex='" + Ssex + '\'' +
                ", Sage=" + Sage +
                '}';
    }
}

2.引入依赖

依赖中包含了spring四个核心依赖，mybatis依赖，springmvc依赖，mybats-spring整合依赖，数据库连接池依赖等。

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

  <name>springMVC 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>

<!--    spring依赖-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>5.2.8.RELEASE</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>5.2.8.RELEASE</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>5.2.8.RELEASE</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-expression</artifactId>
      <version>5.2.8.RELEASE</version>
    </dependency>

    <!--web依赖/spring mvc依赖-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>5.2.8.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>5.2.8.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>3.1.0</version>
    </dependency>

    <!--tomcat servlet api -->
    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>
    <dependency>
      <groupId>taglibs</groupId>
      <artifactId>standard</artifactId>
      <version>1.1.2</version>
    </dependency>

<!--mybatis依赖-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.1</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.39</version>
    </dependency>

<!--    整合-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.0</version>
    </dependency>

<!--    连接池-->
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>0.9.5.2</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>5.2.8.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.2.8.RELEASE</version>
    </dependency>

  </dependencies>

  <build>
    <finalName>springMVC</finalName>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <!--Jetty福服务器插件-->
        <plugin>
          <groupId>org.mortbay.jetty</groupId>
          <artifactId>maven-jetty-plugin</artifactId>
          <version>6.1.24</version>
          <configuration>
            <connectors>
              <connector implementation="org.mortbay.jetty.nio.SelectChannelConnector">
                <port>8089</port>
                <maxIdleTime>30000</maxIdleTime>
              </connector>
            </connectors>
            <contextPath>/</contextPath>
          </configuration>
        </plugin>
        <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>

3.mybatis设计

StudentMapper接口：

public interface StudentMapper {
    public List<Student> findAll();
}

StudentService：

@Service
public class StudentService {
    @Autowired
    private StudentMapper studentMapper;

    public List<Student> selectAllStudents(){
        return studentMapper.findAll();
    }
}

StudentMapper.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.dao.StudentMapper">
    <select id="findAll" resultType="com.bean.Student">
        select * from Student
    </select>
</mapper>

4.spring设计

主要配置数据源，注入mapper映射文件，配置会话工厂。

<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-3.0.xsd
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context-3.0.xsd">

    <!--开启注解-->
    <context:component-scan base-package="com"/>

    <!--配置数据源：借助连接池c3p0-->
    <bean id ="dataSource" class="com.mchange.v2.c3p0.DriverManagerDataSource">
        <!--注入属性-->
        <property name="driverClass" value="com.mysql.jdbc.Driver"/>
        <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/test"/>
        <property name="user" value="root"/>
        <property name="password" value="123456"/>
    </bean>


    <bean id="sqlSessionFactory" scope="singleton" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <!--注入mapper映射文件-->
<!--        <property name="configLocation" value="mmapper/StudentMapper.xml"></property>-->
        <property name="mapperLocations" value="classpath:mapper/*.xml"/>

    </bean>


    <bean class="org.mybatis.spring.mapper.MapperFactoryBean">
        <property name="mapperInterface" value="com.dao.StudentMapper"/>
        <!--会话工厂-->
        <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
    </bean>

</beans>

5.springmvc设计

配置处理器

<?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:mvc="http://www.springframework.org/schema/mvc"
       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.1.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd">


    <!--扫描controller写注解-->
    <context:component-scan base-package="com.controller"/>

    <!--配置映射器-->
    <mvc:annotation-driven/>

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

        <!--jsp后缀-->
        <property name="suffix" value=".jsp"/>
    </bean>


</beans>

设计视图studentlist.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
    <title>学生信息展示</title>
</head>
<body>
<table align="center" border="1">
    <thead>
    <tr>
        <td>学生ID</td>
        <td>用户名</td>
        <td>性别</td>
        <td>年龄</td>
    </tr>
    </thead>
    <tbody>
    <c:forEach items="${students}" var="student">
        <tr>
            <td>${student.SID}</td>
            <td>${student.sname}</td>
            <td>${student.ssex}</td>
            <td>${student.sage}</td>
        </tr>
    </c:forEach>
    </tbody>
</table>
</form>

</body>
</html>

web.xml

在web.xml配置文件中读取spring配置

    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:spring-core.xml</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
    http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:spring-core.xml</param-value>
  </context-param>
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>

  <!--前端控制器-->
  <servlet>
    <servlet-name>springMVC</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <!--将springMVC的配置文件进行配置-->
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:spring-mvc2.xml</param-value>
    </init-param>
  </servlet>

  <servlet-mapping>
    <servlet-name>springMVC</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>

</web-app>

StudentController

package com.controller;

import com.bean.Student;
import com.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

import java.util.List;

/**
 * Description :
 * Created by Resumebb
 * Date :2021/4/19
 */
@Controller
public class StudentController {

    @Autowired
    //将service层对象注入
    private UserService userService;

    @RequestMapping("/list")
    public ModelAndView list(){
        List<Student> students = userService.selectAllStudents();

        ModelAndView modelAndView = new ModelAndView();
        modelAndView.addObject("students",students);
        modelAndView.setViewName("studentlist");
        return modelAndView;
    }
}

运行结果

可能出现的问题

报错java.lang.NoClassDefFoundError: org/springframework/dao/support/DaoSupport

包没有导全，检查spring的包，我整合的时候少导入了两个包：

  <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>5.2.8.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.2.8.RELEASE</version>
    </dependency>

报错[/mapper/]cannot be resolved to URL because it does not exist

在注入mapper的映射文件时，没有找到对应的xml文件，这两种写法不要用混了，configLocation指明单个xml，mapperLocation是可以指多个的，如果找不到，就在前面加classpath：

     <property name="configLocation" value="mapper/StudentMapper.xml"></property>

        <property name="mapperLocations" value="classpath:mapper/*.xml"/>

报错没有某个数据库的数据，比如com.Student doe not have the property ‘Sname’

用拿值的时候根据提示去拿，Sname找不到，正确的应该是student.sname，根据系统提示输入。

参数绑定与返回值

SPringMVC，在客户端提交数据的过程中，客户端将数据以key-value形式进行提交，在SPringMVC中通过参数绑定器将参数绑定到方法的形参上，这里涉及到一个参数绑定器，将请求的数据转化为需要的数据。

以上个Demo为例进行测试，目的是通过一个超链接跳转至url，新的jsp为一个修改页面。

Handler开发

    @RequestMapping(value = "/{id}")
    //{id} 通过符   @PathVariable注解将注解括号中的属性名绑定到当前的参数上
    public ModelAndView edit(@PathVariable("id")int id) throws Exception {
        Student student = userService.selectStudentById(id);

        //修改页面将原数据进行回显
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.addObject("user",student);
        modelAndView.setViewName("editStudent");
        return modelAndView;
    }

视图开发

修改界面，editStudent.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt"  prefix="fmt"%>
<!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>

<form action="${pageContext.request.contextPath }/editUserSubmit" method="post">
    <table width="60%" border="1"align="center">
        <h1 align="center">修改用户信息</h1>
        <tr>
            <td>用户ID</td>
            <td> <input type="text" name="id" value="${user.SID }" readonly ></td> </td>
        </tr>
        <tr>
            <td>用户名</td>
            <td> <input id="username" type="text" name="username" value="${user.sname }"></td> </td>
        </tr>
        <tr>
            <td>性别</td>
            <td> <input id="sex" type="text" name="sex" value="${user.ssex }"></td> </td>
        </tr>
        <tr>
            <td>地址</td>
            <td> <input id="address" type="text" name="address" value="${user.sage }"></td> </td>
        </tr>
        <tr ><td colspan="2" align="center"><input   type="submit" value="提交"/></td></tr>
    </table>
</form>
</body>
</html>

学生界面

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
    <title>学生信息展示</title>
</head>
<body>
<table align="center" border="1">
    <thead>
    <tr>
        <td>学生ID</td>
        <td>用户名</td>
        <td>性别</td>
        <td>年龄</td>
        <td>编辑</td>
    </tr>
    </thead>
    <tbody>
    <c:forEach items="${students}" var="student">
        <tr>
            <td>${student.SID}</td>
            <td>${student.sname}</td>
            <td>${student.ssex}</td>
            <td>${student.sage}</td>
            <td><a href="${pageContext.request.contextPath}/student/${student.SID}"/>修改</td>
        </tr>
    </c:forEach>
    </tbody>
</table>
</form>

</body>
</html>

StudentMapper

添加新的查询语句

    <select id="selectStudentById" resultType="com.bean.Student">
        select * from Student where SID = #{id}
    </select>

运行结果

Van-bo

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SSM框架整合

整合思路主要分为Controller，service层，dao层整合dao:mybatis和spring的整合，通过spring来管理mapper接口，数据源，使用mapper的扫描器自动扫描mapper接口service层：通过spring来管理service类，并将dao层的实例注入到service中使用，另事务相关的操作也通过spring进行管理整合controller层：springMVC是spring中的一部分，不需要进行整合，spring管理将service层实例注入..
复制链接

扫一扫

专栏目录