第二部分-SpringBoot程序返回数据库json数据

微博热搜内容接口简单编写

文章只做简单记录和放出完整代码，详细内容可以一起讨论
mybatis+springboot+mysql(使用了Lombok)

第一步

创建WeiBoNewModel.java

package bx.springChart.demoProject.model;

import lombok.*;
import java.io.Serializable;

@Data
@ToString
@NoArgsConstructor
@AllArgsConstructor
@Builder
public class WeiBoNewModel implements Serializable {
    private int id;
    private String note;
    private int noteId;
    private String onboardTime;
    private int flag;
    private int realPos;
    private long num;

}

第二步

创建WeiboService.java

package bx.springChart.demoProject.service;

import bx.springChart.demoProject.model.WeiBoNewModel;
import java.util.List;

public interface WeiboService {
    List<WeiBoNewModel> findAll();
}

第三步

创建WeiboMapper.java

package bx.springChart.demoProject.mapper;

import bx.springChart.demoProject.model.WeiBoNewModel;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface WeiboMapper {
    List<WeiBoNewModel> findAll();
}

第四步

创建WeiboServiceImpl.java

package bx.springChart.demoProject.serviceImpl;

import bx.springChart.demoProject.mapper.WeiboMapper;
import bx.springChart.demoProject.model.WeiBoNewModel;
import bx.springChart.demoProject.service.WeiboService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service("weiboService")
public class WeiboServiceImpl implements WeiboService {

    @Autowired
    private WeiboMapper weiboMapper;

    @Override
    public List<WeiBoNewModel> findAll() {
        return weiboMapper.findAll();
    }
}

第五步

在resources/mapper下创建WeiboMapper.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="bx.springChart.demoProject.mapper.WeiboMapper">

    <resultMap id="WeiBoMap" type="bx.springChart.demoProject.model.WeiBoNewModel">
        <result column="id" jdbcType="INTEGER" property="id"/>
        <result column="note" jdbcType="VARCHAR" property="note"/>
        <result column="num" jdbcType="BIGINT" property="num"/>
        <result column="onboard_time" jdbcType="BIGINT" property="onboardTime"/>
    </resultMap>
    <select id="findAll" resultMap="WeiBoMap">
    SELECT * FROM db_weibo_content
    </select>

</mapper>

第六步

创建WeiboController

package bx.springChart.demoProject.controller;

import ...

@Controller
@RequestMapping("/weibo")
public class WeiboController {

    @Autowired
    private WeiboService weiboService;

    @RequestMapping("/showAll")
    @ResponseBody
    public List<WeiBoNewModel> findAll(){

        return weiboService.findAll();
    }
}

第七步

创建配置文件application.yml

server:
  port: 8081
spring:
  #数据库连接配置
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/echartdemoone?characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true
    username: root
    password: root

#mybatis的相关配置
mybatis:
  #mapper配置文件
  mapper-locations: classpath:mapper/*.xml

  #此配置的功能是UserMapper.xml中type可以简写
  #type-aliases-package: bx.springChart.mybatisDemo.entity

  #configuration:
  #开启驼峰命名
  #此配置的功能是自动对应，就是代替UserMapper.xml中的resultMap
  # map-underscore-to-camel-case: true

  #此配置的功能是禁用Mybatis自动映射
  configuration:
   auto-mapping-behavior: NONE

#LOG输出SQL
logging:
  level:
    bx:
      springChart:
        demoProject: debug

第八步

修改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>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.1.3.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>bx.springChart.demoProject</groupId>
	<artifactId>practiceForEchart</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>practiceForEchart</name>
	<description>Demo project for Spring Boot</description>


	<properties>
		<java.version>1.8</java.version>
		<spring-boot.version>2.1.3.RELEASE</spring-boot.version>
	</properties>


	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-thymeleaf</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>

		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-api</artifactId>
		</dependency>
		<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>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>

</project>

第九步

创建入口程序echartApplication.java

package bx.springChart.demoProject;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.ApplicationArguments;
import org.springframework.boot.ApplicationRunner;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;


@SpringBootApplication
//@MapperScan("bx.springChart.mybatisDemo.mapper")//使用MapperScan批量扫描所有的Mapper接口；
public class echartApplication implements ApplicationRunner {
    public static void main(String[] args) {
        SpringApplication.run(echartApplication.class, args);
    }

    @Override
    public void run(ApplicationArguments args) throws Exception {

    }
}

目录结构

说明：static与template目录不影响本部分运行，可以没有

运行程序

run echartApplication
可以看到发布在8081端口上
访问http://localhost:8081/weibo/showAll在postman中可以看到json效果

浏览器效果

说明：数据库DDL

CREATE TABLE `db_weibo_all` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `note` varchar(45) DEFAULT '',
  `note_id` bigint(18) DEFAULT '0',
  `onboard_time` timestamp NULL DEFAULT NULL,
  `flag` tinyint(1) DEFAULT '0',
  `real_pos` tinyint(4) DEFAULT '1',
  `num` int(11) DEFAULT '1',
  `topic_flag` tinyint(1) DEFAULT '0',
  `word` varchar(45) DEFAULT '',
  `emoji` varchar(8) DEFAULT '',
  `is_fei` tinyint(1) DEFAULT '0',
  `is_new` tinyint(1) DEFAULT '0',
  `is_hot` tinyint(1) DEFAULT '0',
  `is_ad` tinyint(1) DEFAULT '0',
  `content_key` varchar(45) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `index_note` (`note`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8

更多可以查看我的上一篇文章
https://blog.csdn.net/weixin_43596589/article/details/115601133