Springboot整合SSM

访问:http://localhost:8080/car/get
返回:{ 
   "name":"BMW","color":"red","price":9.9}

CREATE TABLE `car` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(10) default NULL,
  `color` varchar(10) default NULL,
  `price` double default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

<?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>springbootcgb2103</artifactId>
        <groupId>cn.tedu</groupId>
        <version>0.0.1-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>testSSM</artifactId>

    <dependencies>
        <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>5.1.48</version>
            <scope>runtime</scope>
        </dependency>
    </dependencies>

</project>

package cn.tedu.pojo;

import org.springframework.stereotype.Component;

@Component
public class Car { 
   
    private int id;
    private String name;
    private String color;
    private double price;

    public int getId() { 
   
        return id;
    }

    @Override
    public String toString() { 
   
        return "Car{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", color='" + color + '\'' +
                ", price=" + price +
                '}';
    }

    public void setId(int id) { 
   
        this.id = id;
    }

    public String getName() { 
   
        return name;
    }

    public void setName(String name) { 
   
        this.name = name;
    }

    public String getColor() { 
   
        return color;
    }

    public void setColor(String color) { 
   
        this.color = color;
    }

    public double getPrice() { 
   
        return price;
    }

    public void setPrice(double price) { 
   
        this.price = price;
    }

}

package cn.tedu.dao;

import cn.tedu.pojo.Car;
import org.springframework.stereotype.Repository;

public interface CarDao { 
   
    Car get();
}

<?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 where price=9.9
    </select>
</mapper>

package cn.tedu.service;

import cn.tedu.pojo.Car;

public interface CarService { 
   
    Car get() ;
}

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;

@Service
public class CarServiceImpl implements CarService{ 
   

    @Autowired
    private CarDao carDao;

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

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.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
@RequestMapping("/car/")
public class CarController { 
   

    @Autowired
    private CarService carService;

    @RequestMapping("get")
    public Car get(){ 
   
        return carService.get();
    }
}

#SpringBoot配置mysql信息
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql:///mybatisdb?useUnicode=true&characterEncoding=utf8&useSSL=false
    username: root
    password: root
#SpringBoot整合Mybatis配置
mybatis:  
	#别名包
  type-aliases-package: cn.tedu.pojo
  #指定UserMapper.xml文件的位置
  mapper-locations: classpath:*.xml
  #开启驼峰映射
  configuration:
    map-underscore-to-camel-case: true

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")//扫描DAO接口文件所在的包
public class Runapp { 
   
    public static void main(String[] args) { 
   
        SpringApplication.run(Runapp.class);
    }
}

访问:http://localhost:8080/car/get
返回:{ 
   "name":"BMW","color":"red","price":9.9}

<!DOCTYPE html>
<html>
	<head>
		<meta charset="utf-8">
		<title></title>
		<script src="vue.js"></script>
		<script src="axios.min.js"></script>
	</head>
	<body>
		<div id="app">
			<table style="font-size: 20px;" cellspacing="0" border="1px" bgcolor="lightgray">
				<h3 align="center">京淘电商平台</h3>
				<button>新增</button>
			   <head>
			      <tr>
			         <th style="text-align: center;" width="320">姓名</th>
			         <th style="text-align: center;" width="280">年龄</th>
			         <th style="text-align: center;">爱好</th>
			         <th style="text-align: center;">学历</th>
			         <th style="text-align: center;">入学时间</th>
			         <th style="text-align: center;">[操作]</th>
			      </tr>
			   </head>
			   <body>
			      <tr v-for="o in msg" align="center">
			         <td>{
  
  {o.name}}</td>
			         <td>{
  
  {o.age}}</td>
			         <td align="right"><span style="color: red;">{
  
  {o.hobby}}</span></td>
					 <td v-if="o.edu==3">本科</td>
					 <td>{
  
  {o.intime.substring(0,9)}}</td>
					 <td>
						 <button>修改</button>
						 <button>删除</button>
					 </td>
			      </tr>
			   </body>
			</table>	
		</div>
	</body>
	<script> new Vue({ 
      el:"#app", data:{ 
      msg: "暂无数据" }, mounted() { 
      axios({ 
      method: "post", url: "http://localhost:8080/car/get" }) .then( res => { 
      this.msg = res.data; } ) } }) </script>
</html>

访问:http://localhost:8080/car/getById?id=2
返回: { 
   "id":2,"name":"Audi","color":"black","price":0.3}