SSM整合开发过程

SSM整合开发

SSM: SpringMVC + Spring + MyBatis

一.开发理念

1.开发分工

SpringMVC: 视图层,界面层,负责接收请求,显示处理结果的。
Spring: 业务层,管理service,dao,工具类对象的。
MyBatis: 持久层, 访问数据库的

2.业务流程

用户发起请求 – SpringMVC接收 – Spring中的Service对象 – MyBatis处理数据

3.整合中的容器

  • 1.SpringMVC容器

    ​ 用来管理Controller控制器对象

  • 2.Spring容器

    ​ 用来管理ServiceDao,工具类对象的

    我们需要将要用到的对象交给合适的容器去创建,管理

    Springmvc容器是spring的子容器类似于java中的继承

    在子容器的Controller可以反问父容器中的Service对象,就可以完成Controller使用Service对象

二、实现流程

1.设计数据库,设计数据表

/*
 Navicat Premium Data Transfer

 Source Server         : MySQL80
 Source Server Type    : MySQL
 Source Server Version : 80022
 Source Host           : localhost:3306
 Source Schema         : kaoshixitong

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

 Date: 22/07/2021 13:35:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `userId` int NOT NULL AUTO_INCREMENT,
  `userName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`userId`) USING BTREE,
  UNIQUE INDEX `userName`(`userName`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

2.新建Maven Web项目

在这里插入图片描述

3.pom文件中加入需要使用的依赖

pom.xml

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

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <maven.compiler.source>1.8</maven.compiler.source>
        <maven.compiler.target>1.8</maven.compiler.target>
    </properties>

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

        <!--servlet依赖-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>4.0.1</version>
            <scope>provided</scope>
        </dependency>

        <!--jsp依赖-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.2.15.RELEASE</version>
        </dependency>

        <!--springmvc依赖-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.2.15.RELEASE</version>
        </dependency>

        <!--事务依赖-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>5.2.15.RELEASE</version>
        </dependency>

        <!--事务相关-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.2.15.RELEASE</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>

        <!--mybatis整合用到的-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.2</version>
        </dependency>

        <!--mybatis的-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.2</version>
        </dependency>

        <!--jdbc-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.15</version>
        </dependency>

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

    </dependencies>

    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory><!--所在的目录-->
                <includes><!--包括目录下的.properties,.xml 文件都会扫描到-->
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>

            <resource>
                <directory>src/main/resources</directory><!--所在的目录-->
                <includes><!--包括目录下的.properties,.xml 文件都会扫描到-->
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>

        </resources>

        <plugins>
            <plugin>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

3.写web.xml文件

  • 1.注册DispatcherServlet(中央调度器)

    目的: 1.创建springmvc容器对象,才能创建Controller类对象。

    ​ 需要指明springmvc配置文件的位置

    ​ 2.创建的是Servlet,才能接受用户的请求。

     <!--注册中央调度器-->
        <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:conf/springmvc.xml</param-value>
            </init-param>
            <!--程序开始就创建1表示优先级 ,越小优先级越高,不能小于0-->
            <load-on-startup>1</load-on-startup>
        </servlet>
    
        <servlet-mapping>
            <servlet-name>springmvc</servlet-name>
            <url-pattern>*.do</url-pattern>
        </servlet-mapping>
    
    
  • 2.注册spring的监听器:ContextLoaderListener

    目的: 创建spring的容器对象,才能创建service,dao等对象。

        <!--注册spring监听器-->
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:conf/applicationContext.xml</param-value>
            <!--        classpath:conf/applicationContext.xml-->
        </context-param>
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
    
  • 3.注册字符集过滤器,解决post请求乱码的问题

    <!--utf-8编码过滤器器-->
        <filter>
            <filter-name>CharacterEncoding</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>
            <init-param>
                <param-name>forceEncoding</param-name>
                <param-value>true</param-value>
            </init-param>
        </filter>
        <!--/*表示强制所有的请求先通过过滤器处理-->
        <filter-mapping>
            <filter-name>CharacterEncoding</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
    

4.创建包,Controller包,Service包,Dao包,entity包

包结构如下:

在这里插入图片描述

5.写springmvc,spring,mybatis的配置文件

  • 1.springmvc配置文件

    组件扫描器:controller包的位置

    视图解析器

    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: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 https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd">
        <!--springmvc配置文件,声明controller和其他web相关的对象-->
        <!--组件扫描器-->
        <context:component-scan base-package="com.controller"/>
    
        <!--视图解析器-->
        <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
            <property name="prefix" value="/jsp/"/>
            <property name="suffix" value=".jsp"/>
        </bean>
    
        <!--注解驱动 1.响应ajax请求返回json  2.解决静态资源访问问题-->
        <mvc:annotation-driven/>
    </beans>
    
  • spring配置文件

    声明资源包 jdbc的properties文件位置

    声明数据源 dataSource 使用上面的配置文件 ${jdbc.url}这种方式

    SqlSessionFactoryBean 用来指定mybatis配置文件

    声明mybatis的扫描器,创建dao对象

    声明service的注解@Service所在的包名位置

    applicationContext.xml

    事务配置:注解配置,aspectj的配置

    <?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">
    
        <!--spring配置文件:声明service,dao,工具类等对象-->
        <!--声明资源包-->
        <context:property-placeholder location="classpath:conf/jdbc.properties"/>
    
        <!--声明数据源,连接数据库-->
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
              init-method="init" destroy-method="close">
            <property name="url" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
            <property name="maxActive" value="${jdbc.maxActive}"/>
        </bean>
    
        <!--SqlSessionFactoryBean 用来指定mybatis配置文件-->
        <bean id="SqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"/>
            <property name="configLocation" value="classpath:conf/mybatis.xml"/>
        </bean>
    
    
        <!--声明mybatis的扫描器,创建dao对象-->
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="sqlSessionFactoryBeanName" value="SqlSessionFactory"/>
            <property name="basePackage" value="com.dao"/>
        </bean>
    
        <!--声明service的注解@Service所在的包名位置-->
        <context:component-scan base-package="com.service"/>
    
        <!--事务配置:注解配置,aspectj的配置-->
    </beans>
    
  • mybatis主配置文件

    设置别名

    sql映射文件的位置

    需要指明mapper文件的位置

    mybatis.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">
    <!--mabatis 主文件配置-->
    <!--控制mabatis全局行为-->
    <configuration>
        <settings>
            <!--设置mybatis输出日志-->
            <setting name="logImpl" value="STDOUT_LOGGING"/>
        </settings>
    
        <!--设置别名-->
        <typeAliases>
            <!--name:实体类所在的包名-->
            <package name="com.domain"/>
        </typeAliases>
    
        <!-- sql mapper(sql映射文件)的位置-->
        <mappers>
            <!--这个包中的所有mappe.xml一次性都能加载-->
            <!--告诉 mybatis 要执行的 sql 语句的位置-->
            <!--        <mapper resource="mapper文件所在的包名"/>-->
    
            <!--这里如果使用package的要求
                1.mapper文件名称和dao接口必须完全一样,包括大小写
                2.mapper文件和dao接口必须在同一目录
            -->
            <package name="com.dao"/>
        </mappers>
    </configuration>
    
    
  • 数据库的属性配置文件

    jdbc.properties

    jdbc.url=jdbc:mysql://127.0.0.1:3306/kaoshixitong?serverTimezone=UTC
    jdbc.username=root
    jdbc.password=root
    jdbc.maxActive=20
    

6.写各个包中代码,编写mapper映射文件

  • users实体

    package com.domain;
    
    /**
     * Created by IntelliJ IDEA.
     * User: LvHaoIT (asus)
     * Date: 2021/5/24
     * Time: 9:44
     */
    public class Users {
        private Integer userId;
        private String userName;
        private String password;
        private String sex;
        private String email;
    
        public Users() {
        }
    
        public Users(String userName, String password, String sex, String email) {
            this.userName = userName;
            this.password = password;
            this.sex = sex;
            this.email = email;
        }
    
        public Users(Integer userId, String userName, String password, String sex, String email) {
            this.userId = userId;
            this.userName = userName;
            this.password = password;
            this.sex = sex;
            this.email = email;
        }
    
        public Integer getUserId() {
            return userId;
        }
    
        public void setUserId(Integer userId) {
            this.userId = userId;
        }
    
        public String getUserName() {
            return userName;
        }
    
        public void setUserName(String userName) {
            this.userName = userName;
        }
    
        public String getPassword() {
            return password;
        }
    
        public void setPassword(String password) {
            this.password = password;
        }
    
        public String getSex() {
            return sex;
        }
    
        public void setSex(String sex) {
            this.sex = sex;
        }
    
        public String getEmail() {
            return email;
        }
    
        public void setEmail(String email) {
            this.email = email;
        }
    
        @Override
        public String toString() {
            return "Users{" +
                    "userId=" + userId +
                    ", userName='" + userName + '\'' +
                    ", password='" + password + '\'' +
                    ", sex='" + sex + '\'' +
                    ", email='" + email + '\'' +
                    '}';
        }
    }
    
    
  • dao层UsersDao接口

    package com.dao;
    
    import com.domain.Users;
    
    import java.util.List;
    
    /**
     * Created by IntelliJ IDEA.
     * User: LvHaoIT (asus)
     * Date: 2021/7/20
     * Time: 8:41
     */
    public interface UsersDao {
        //    添加用户信息
        public int addUser(Users user);
    
    
        //    查询全部用户
        public List<Users> selectUsers();
    
    //    //    删除用户信息
    //    public int delectUser(Integer id);
    //
    //    //    修改对应用户
    //    public int updateUser(Users users);
    
  • dao层UsersDao.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.UsersDao">
        <select id="selectUsers" resultType="Users">
        select userId,userName,password,sex,email from users order by userId asc
        </select>
    
        <insert id="addUser">
            insert into users(userName,password,sex,email)  values (#{userName},#{password},#{sex},#{email})
        </insert>
    
    
    </mapper>
    
    
  • 编写Service接口与Service接口实现类

    Service接口

     public interface UsersService {
      
          boolean addUsers(Users user);
      
          List<Users> queryUsers();
      }
    

    Service接口实现类

    @Service
    public class UsersServiceImpl implements UsersService {
        //利用类型自动注入@Autowired,@Resource
        @Resource
        private UsersDao usersDao;
    
        @Override
        public boolean addUsers(Users user) {
            int count = 0;
            try {
                count = usersDao.addUser(user);
                if (count == 1)
                    return true;
                else
                    return false;
            } catch (Exception e) {
                return false;
            }
    
        }
    
        @Override
        public List<Users> queryUsers() {
            List<Users> list = usersDao.selectUsers();
            for (Users user : list) {
                user.toString();
            }
            return list;
        }
    }
    
  • Controller

    注意注解

    package com.controller;
    @Controller
    @RequestMapping("/user")
    public class UsersController {
        @Resource
        private UsersService usersService;
    
        //查询全部 ,响应ajax
        @RequestMapping(value = "/queryUsers.do")
        @ResponseBody
        public List<Users> doSome() {
            //可以做一些参数检查与简单的数据处理
            List<Users> list = usersService.queryUsers();
            for (Users users : list) {
                System.out.println("当前的数据" + users.getUserId() + "  " + users.getUserName());
            }
            return list;
        }
    
        //注册用户
        @RequestMapping(value = "/adduser.do", method = RequestMethod.POST)
        @ResponseBody
        public ModelAndView addUser(Users user) {
            ModelAndView mv = new ModelAndView();
            boolean count = usersService.addUsers(user);
            String ref = "注册失败!";
            if (count) {
                //注册成功
                ref = "学生:" + user.getUserName() + "注册成功!";
            }
            //添加数据
            mv.addObject("ref", ref);
            //指定页面显示结果
            mv.setViewName("tishi");
            return mv;
        }
    }
    
    

7.编写jsp页面

  • index.jsp

    <%--
      Created by IntelliJ IDEA.
      User: asus
      Name: 吕昊
      Number: 20180508145
      Date: 2021/7/20
      Time: 10:37
      To change this template use File | Settings | File Templates.
    --%>
    <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <%
        String basePath = request.getScheme() + "://" + request.getServerName() + ":"
                + request.getServerPort() + request.getContextPath() + "/";
    %>
    <html>
    <head>
        <base href="<%=basePath%>"/>
        <title>功能菜单</title>
        <link rel="stylesheet" type="text/css" href="static/css/table.css">
    </head>
    <body>
    <center>
        <div align="centen">
            <p>ssm整合</p>
            <img src="static/images/ssm.jpg">
            <table border="2" style="width: 30%">
                <tr>
                    <td>
                        <a href="jsp/zhuce.jsp">用户注册</a>
                    </td>
                </tr>
                <tr>
                    <td>
                        <a href="jsp/userlist.jsp">查看所有学生列表</a>
                    </td>
                </tr>
            </table>
        </div>
    </center>
    </body>
    </html>
    
    
  • userlist.jsp

    <%--
      Created by IntelliJ IDEA.
      User: asus
      Name: 吕昊
      Number: 20180508145
      Date: 2021/7/20
      Time: 23:09
      To change this template use File | Settings | File Templates.
    --%>
    <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <%
        String basePath = request.getScheme() + "://" + request.getServerName() + ":"
                + request.getServerPort() + request.getContextPath() + "/";
    %>
    <html>
    <head>
        <base href="<%=basePath%>"/>
        <title>查询学生ajax</title>
        <script type="text/javascript" src="static/js/jquery-3.4.1.js"></script>
        <script>
            $(function () {
                $("#btnLoader").click(function () {
                    $.ajax({
                        url: "user/queryUsers.do",
                        type: "get",
                        dataType: "json",
                        success: function (data) {
                            //清除旧数据
                            $("#info").html("");
                            $.each(data, function (i, n) {
                                //回填数据
                                $("#info").append("<tr>")
                                    .append("<td>" + n.userName + "</td>")
                                    .append("<td>" + n.password + "</td>")
                                    .append("<td>" + n.sex + "</td>")
                                    .append("<td>" + n.email + "</td>")
                                    .append("</tr>");
                            })
    
                        }
                    })
                })
            })
    
        </script>
    </head>
    <body>
    <div align="center">
        <table border="2">
            <thead>
            <tr>
                <td>用户名</td>
                <td>密码</td>
                <td>性别</td>
                <td>邮箱</td>
            </tr>
            </thead>
    
            <tbody id="info">
    
            </tbody>
        </table>
        <input type="button" id="btnLoader" value="查询数据">
    
    </div>
    
    </body>
    </html>
    
    

以上就是ssm项目整合开发的全过程,供大家参考!

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

LvhaoIT

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值