Java之【SpringBoot+tk

三、创建配置文件

---

server:

port: 8080

#datasource

spring:

datasource:

url: jdbc:mysql://127.0.0.1:3306/test?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai

username: root

password: root

driver-class-name: com.mysql.cj.jdbc.Driver

mybatis:

configuration:

log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

四、创建数据库

---

CREATE TABLE sys_user (

id bigint NOT NULL AUTO_INCREMENT,

name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

age int NULL DEFAULT NULL,

PRIMARY KEY (id) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

五、创建实体类

---

package cn.itbluebox.domain;

import lombok.AllArgsConstructor;

import lombok.Data;

import lombok.NoArgsConstructor;

import javax.persistence.Table;

@Data

@NoArgsConstructor

@AllArgsConstructor

@Table(name = “sys_user”)

public class SysUser {

private Long id;

private String name;

private Integer age;

}

六、创建mapper和对应的映射文件

---

package cn.itbluebox.mapper;

import cn.itbluebox.domain.SysUser;

import tk.mybatis.mapper.common.Mapper;

public interface SysUserMapper extends Mapper {

}

<?xml version="1.0" encoding="UTF-8" ?>

七、创建Service和实现类

---

package cn.itbluebox.service;

public interface SysUserService {

}

package cn.itbluebox.service.impl;

import cn.itbluebox.mapper.SysUserMapper;

import cn.itbluebox.service.SysUserService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

@Service

public class SysUserServiceImpl implements SysUserService {

@Autowired

private SysUserMapper sysUserMapper;

}

八、controller

---

package cn.itbluebox.controller;

import cn.itbluebox.service.SysUserService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.web.bind.annotation.GetMapping;

import org.springframework.web.bind.annotation.RestController;

@RestController

public class SysUserController {

@Autowired

private SysUserService sysUserService;

@GetMapping(“/userSelect”)

public String userSelect(){

return sysUserService.userSelect();

}

}

实现对应的Service

package cn.itbluebox.service;

import cn.itbluebox.domain.SysUser;

import java.util.List;

public interface SysUserService {

List userSelect();

}

对应的实现类

package cn.itbluebox.service.impl;

import cn.itbluebox.domain.SysUser;

import cn.itbluebox.mapper.SysUserMapper;

import cn.itbluebox.service.SysUserService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import java.util.List;

@Service

public class SysUserServiceImpl implements SysUserService {

@Autowired

private SysUserMapper sysUserMapper;

@Override

public List userSelect() {

return sysUserMapper.selectAll();

}

}

九、创建启动类

---

package cn.itbluebox;

import org.springframework.boot.SpringApplication;

import org.springframework.boot.autoconfigure.SpringBootApplication;

import tk.mybatis.spring.annotation.MapperScan;

@SpringBootApplication

@MapperScan(“cn.itbluebox.mapper”)

public class SpringBootTestApplication {

public static void main(String[] args) {

SpringApplication.run(SpringBootTestApplication.class);

}

}

JavaScript 和 ES6

在这个过程你会发现，有很多 JS 知识点你并不能更好的理解为什么这么设计，以及这样设计的好处是什么，这就逼着让你去学习这单个知识点的来龙去脉，去哪学？第一，书籍，我知道你不喜欢看，我最近通过刷大厂面试题整理了一份前端核心知识笔记，比较书籍更精简，一句废话都没有，这份笔记也让我通过跳槽从8k涨成20k。