查看“IntelliJ IDEA Spring Boot”的源代码

Spring Boot

* 环境: IntelliJ IDEA 2023.1 (Ultimate Edition)
* 实现: web, mysql
* Step:
# New project -> Spring Initializr -> type: maven: testSprintBoot
# Dependency -> Web: Spring Web，SQL: MyBatis Framework, MySQL Driver/H2 Database
# src/main/resources: application.properties -> application.yml
# src/main/resources/static: index.html
# com.example.testspringboot: bean, controller, mapper, service

=== application.yml ===
 <small><nowiki>spring.application.name:
  testSprintBoot
server:
  port: 8083

spring:
  datasource:
    url: jdbc:mysql://192.168.0.83:3306/mysql?serverTimezone=Asia/Shanghai&characterEncoding=utf-8
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver


mybatis:
  type-aliases-package: com.example.testspringboot.bean</nowiki></small>


=== index.html ===
 <small><nowiki><!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
This is a test web page.
</body>
</html>

# main.java/com.example.testspringboot.TestspringbootApplication
package com.example.testspringboot;

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

@SpringBootApplication
public class TestspringbootApplication {
    public static void main(String[] args) {
        SpringApplication.run(TestspringbootApplication.class, args);
    }
}

# test.java/com.example.testspringboot.TestspringbootApplicationTests
package com.example.testspringboot;

import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
class TestspringbootApplicationTests {
    @Test
    void contextLoads() {
    }
}</nowiki></small>

=== bean ===
==== SysUser ====
 <small><nowiki>package com.example.testsprintboot.bean;

import org.springframework.format.annotation.DateTimeFormat;

import java.time.LocalDateTime;
import java.util.Date;

public class SysUser {

    private String host;
    private String user;
    private String passwordLastChanged;

    public String getHost() {
        return host;
    }
    public void setHost(String host) {
        this.host = host;
    }

    public String getUser() {
        return user;
    }
    public void setUser(String user) {
        this.user = user;
    }

    public String getPasswordLastChanged() {
        return passwordLastChanged;
    }
    public void setPasswordLastChanged(String passwordLastChanged) {
        this.passwordLastChanged = passwordLastChanged;
    }
}</nowiki></small>

=== mapper ===
==== SysUserMapper ====
 <small><nowiki>package com.example.testsprintboot.mapper;

import com.example.testsprintboot.bean.SysUser;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import java.util.List;

@Mapper
public interface SysUserMapper {
    @Select({
            "select",
            "host, user, date_format(password_last_changed, '%Y-%m-%d %H:%i:%s') password_last_changed",
            "from user"
    })
    List<SysUser> selectAll();
}</nowiki></small>

=== service ===
==== SysUserService ====
 <small><nowiki>package com.example.testsprintboot.service;

import com.example.testsprintboot.bean.SysUser;
import java.util.List;

public interface SysUserService {
    public List<SysUser> selectAll();
}


# service: SysUserServiceImpl
package com.example.testsprintboot.service;

import com.example.testsprintboot.bean.SysUser;
import com.example.testsprintboot.mapper.SysUserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service("SysUserService")
public class SysUserServiceImpl implements SysUserService {
    @Autowired
    private SysUserMapper sysUserMapper;

    @Override
    public List<SysUser> selectAll() {
        return sysUserMapper.selectAll();
    }
}</nowiki></small>

=== controller ===
==== SysUserController ====
 <small><nowiki>package com.example.testsprintboot.controller;

import com.example.testsprintboot.bean.SysUser;
import com.example.testsprintboot.service.SysUserService;
import com.example.testsprintboot.service.SysUserServiceImpl;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;

import jakarta.annotation.Resource;
import java.util.List;

@RestController
@RequestMapping("/sysuser")
public class SysUserController {
    @Resource
    private SysUserService sysUserService = new SysUserServiceImpl();

    @RequestMapping(value = "/selectAll", method = RequestMethod.GET)
    public List<SysUser> selectAll() {
        List<SysUser> list = sysUserService.selectAll();
        return list;
    }
}</nowiki></small>


=== Test ===
 <small><nowiki>http://192.168.0.15:8083/sysuser/selectAll
[{"host":"%","user":"root","passwordLastChanged":null},{"host":"localhost","user":"mysql.infoschema","passwordLastChanged":null},{"host":"localhost","user":"mysql.session","passwordLastChanged":null},{"host":"localhost","user":"mysql.sys","passwordLastChanged":null},{"host":"localhost","user":"root","passwordLastChanged":null}]</nowiki></small>


== 参考 ==
# [https://www.cnblogs.com/detailNew/p/14967528.html IDEA搭建一个SpringBoot项目]
# [https://www.cnblogs.com/caizhaokai/p/10982727.html SpringBoot + MyBatis(注解版)，常用的SQL方法]
# [https://springdoc.cn/spring-and-cors/ 在 Spring 应用中处理 CORS 跨域]
[[分类:Develop]]
[[分类:Java]]