IntelliJ IDEA-Gradle-SpringBoot搭建

前提条件

JAVA安装
Gradle安装

创建项目

配置项目设置

指定自己的gradle的安装位置,以及仓库位置(用户主目录)

用户主目录: Gradle仓库目录用于存储全局配置属性和初始化脚本以及缓存和日志文件。

结构

build.gradle

plugins {
    id 'java'
    id 'org.springframework.boot' version '2.7.7'
    id 'io.spring.dependency-management' version '1.0.15.RELEASE'
}

group = 'com.example'
version = '0.0.1-SNAPSHOT'
sourceCompatibility = '1.8'

configurations {
    compileOnly {
        extendsFrom annotationProcessor
    }
}

repositories {
    mavenLocal()
    mavenCentral()

}

dependencies {
    implementation 'org.springframework.boot:spring-boot-starter-web'
    implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:2.3.0'
    compileOnly 'org.projectlombok:lombok'
    runtimeOnly 'com.mysql:mysql-connector-j'
    annotationProcessor 'org.springframework.boot:spring-boot-configuration-processor'
    annotationProcessor 'org.projectlombok:lombok'
    testImplementation 'org.springframework.boot:spring-boot-starter-test'
}

tasks.named('test') {
    useJUnitPlatform()
}

其他

application.yml

server:
  port: 9874

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: root
    url: jdbc:mysql://127.0.0.1:3306/demo?characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false&maxReconnects=10&useSSL=false

mybatis:
  #1.classpath：只会到你的classes路径中查找找文件。
  #2.classpath*：不仅会到classes路径，还包括jar文件中(classes路径)进行查找。
  mapper-locations: classpath*:/mapper/**/*Mapper.xml    # mapper映射文件位置
  type-aliases-package: com.**.entity    # 实体类所在的位置
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl   #用于控制台打印sql语句
    map-underscore-to-camel-case: true #开启将带有下划线的表字段 映射为驼峰格式的实体类属性

UserMapper.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="com.example.gradledemo.dao.UserDao">
  <!--查询全部数据条数-->
  <select id="users" resultType="com.example.gradledemo.entity.UserEntity">
    SELECT * FROM t_user limit 10
  </select>
</mapper>

UserDao

package com.example.gradledemo.dao;

import com.example.gradledemo.entity.UserEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

@Mapper
public interface UserDao {
    @Select("select count(*) from t_user")
    String userCount();

    List<UserEntity> users();

    @Update("UPDATE t_user SET age=#{add} WHERE id=#{id}")
    Integer upDateAge(int add,int id);

    @Select("SELECT age  FROM t_user WHERE id=#{id}")
    Integer getdateAge(int id);
}

UserEntity

package com.example.gradledemo.entity;


import lombok.*;

import java.util.Date;
import java.util.Objects;

@Data
public class UserEntity {
    private Long id;
    private String name;
    private String email;
    private String phone;
    private String password;
    private Integer age;
    private Integer sex;
    private Integer status;
    private Date creationTime;
    private String site;
}

UserController

package com.example.gradledemo.controller;

import com.example.gradledemo.dao.UserDao;
import com.example.gradledemo.entity.UserEntity;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
public class UserController {

    @Autowired
    private UserDao userDao;
    @GetMapping("/user")
    public ResponseEntity<List<UserEntity>> getUser(){
        return ResponseEntity.ok(userDao.users()) ;
    }

}

GradleDemoApplication

package com.example.gradledemo;

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

@SpringBootApplication
public class GradleDemoApplication {

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

}