SSM三大框架整合案列

1 项目结构

各个包里面的结构与配置文件的结构：

 1.1 数据表的内容

 1.2 修改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">
    <parent>
        <artifactId>debugdemo</artifactId>
        <groupId>cn.tedu</groupId>
        <version>0.0.1-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>ssm</artifactId>
    <dependencies>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.19</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
        </dependency>
    </dependencies>
</project>

 1.3 创建配置文件application.yml

#SpringBoot配置mysql信息
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql:///school?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai
    username: root
    password: root
#SpringBoot整合Mybatis配置
mybatis:
  #指定UserMapper.xml文件的位置
  mapper-locations: classpath:*.xml
  #开启驼峰映射
  configuration:
    map-underscore-to-camel-case: true
server:
  port: 8888

 1.4 创建映射文件CarMapper.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="cn.tedu.dao.CarDao">
    <select id="get" resultType="cn.tedu.pojo.Car">
        select * from car
    </select>
    <select id="getById" parameterType="int" resultType="cn.tedu.pojo.Car">
        select * from car where id = #{id}
    </select>
    <insert id="insert">
        insert into car values(7,"zzz","black",55555.55)
    </insert>
    <insert id="insertIn" parameterType="cn.tedu.pojo.Car">
        insert into car values(#{id},#{name},#{color},#{price})
    </insert>
</mapper>

1.5 创建Car类与启动类

car类：

package cn.tedu.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.experimental.Accessors;
import org.springframework.stereotype.Component;
import java.io.InputStream;
//使用了lombok,使用了以下注解，可以不写get和set、无参构造、全参构造、toString
@Data
@AllArgsConstructor
@NoArgsConstructor
@Accessors(chain = true)
@Component
public class Car {
    private Integer id;
    private String name;
    private String color;
    private Double price;
}

 启动类：

package cn.tedu;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan("cn.tedu.dao")//使用这个注解让spring管理dao包下面的接口并创建对象
//但是接口不能直接创建对象，这里spring创建了一个代理对象,(class com.sun.proxy.$Proxy63)
public class RunApp {
    public static void main(String[] args) {
        SpringApplication.run(RunApp.class);
    }
}

1.6 创建CarDao接口

package cn.tedu.dao;
import cn.tedu.pojo.Car;
import org.springframework.stereotype.Repository;
import java.util.List;
//方法名对应每个SQL的id,参数类型对应SQL里的parameterType，返回值类型对应SQL里的resultType
public interface CarDao {
    List<Car> get();
    Car getById(Integer id);
    void insert();
    void insertIn(Car car);
}

1.7 创建CarService接口与CarServiceImpl实现类

CarService接口：

package cn.tedu.service;
import cn.tedu.pojo.Car;
import java.util.List;
public interface CarService {
    List<Car> get();
    Car getById(Integer id);
    void insert();
    void insertIn(Car car);
}

CarServiceImpl实现类：

package cn.tedu.service;
import cn.tedu.dao.CarDao;
import cn.tedu.pojo.Car;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;

@Service
public class CarServiceImpl implements CarService{

    @Autowired//注入依赖
    private CarDao carDao;//如果报错，可以不用管

    @Override
    public List<Car> get() {
        return carDao.get();
    }

    @Override
    public Car getById(Integer id) {
        return carDao.getById(id);
    }
    @Override
    public void insert(){
        carDao.insert();
    }
    @Override
    public void insertIn(Car car){
        carDao.insertIn(car);
    }
}

1.8 创建CarController类

package cn.tedu.controller;
import cn.tedu.pojo.Car;
import cn.tedu.service.CarService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
@CrossOrigin//解决跨域问题
@RestController//接收浏览器传过来的请求
@RequestMapping("/car/")
public class CarController {
    @Autowired
    private CarService carService;
    @RequestMapping("get")
    public List<Car> get(){
        return carService.get();
    }
    @RequestMapping("getById")
    public Car getById(Integer id){
        return carService.getById(id);
    }
    @RequestMapping("insertIn/{x}/{y}/{z}/{w}")
    public void insertIn(@PathVariable Integer x,
                       @PathVariable String y,
                       @PathVariable String z,
                       @PathVariable Double w){
        Car car = new Car(x,y,z,w);
        carService.insertIn(car);
        System.out.println("插入成功");
    }
    @RequestMapping("insert")
    public void insert(){
        carService.insert();
    }
    @RequestMapping("insertis")
    public void insertis(Car car){
        carService.insertIn(car);
        System.out.println("成功");
    }
}

1.9 创建前端网页

<!DOCTYPE html>
<html>
	<head>
		<meta charset="utf-8">
		<title></title>
		<script src="jquery-1.8.3.min.js"></script>
		<script>
			function a(){
				$.ajax({
					type:"get",
					url: "http://localhost:8888/car/getById",
					data:{
							"id":"3"
							},
					success:function(data){
						console.log(data);
					},
				})
			}
			function b(){
				$.ajax({
					type:"get",
					url: "http://localhost:8888/car/get",
					
					success:function(data){
						console.log(data);
					},
				})
			}
			function c(){
				$.ajax({
					type:"get",
					url: "http://localhost:8888/car/insert",
					data:{},
					success:function(data){
						console.log("成功");
					},
				})
			}
			function d(){
				$.ajax({
					type:"get",
					url: "http://localhost:8888/car/insertis",
					data:{
						"id":"11",
						"name":"zzz",
						"color":"black",
						"price":"55555.55"
					},
					success:function(data){
						console.log("成功");
					},
				})
			}
		</script>
	</head>
	<body>
		<a onclick="a();" href="#">id获取元素</a>
		<a onclick="b();" href="#">获取全部元素</a>
		<a onclick="c();" href="#">增加指定元素</a>
		<a onclick="d();" href="#">自定义增加元素</a>
	</body>
</html>

网页内容：

 1.10 测试结果

1.10.1 获取全部元素

点击获取全部元素链接。结果显示内容：

 1.10.2 根据id获取元素

点击id获取元素链接。结果显示内容：

 1.10.3 增加指定元素

点击增加指定元素。结果如下：

1.10.4 自定义增加元素

点击自定义增加元素，结果如下：

 

 2 SSM执行流程图