idea搭建springboot项目

一、创建项目

1.文件----new----project

2.选择Spring Initializr---点击下一个

 3.勾选Spring web、Thymeleaf、JDBC API、MyBatis Framework、MySQL Driver---点击完成

4. 完成

二、项目介绍

1.项目结构

三、注意事项

1.jdk配置。文件---项目结构

2.Maven配置。文件---设置---右上角搜索maven

配置完后，如果没有自动导包，可以点击左上角重新导包按钮，或者呢个下载按钮，选择下载所有源文件和文档

 四、代码展示

1.实体类bean(entity)

package com.example.demo.entity;

public class Zzg {
    
    private int id;
    private String name;
    private int age;
    private String sex;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }
    public String getSex() {
        return sex;
    }
    public void setSex(String sex) {
        this.sex = sex;
    }
   }

2.Mapper层

package com.example.demo.mapper;

import com.example.demo.entity.Zzg;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ZzgMapper{
    @Select("select * from zzg")
    public List<Zzg> sel();
}

3.Service层

package com.example.demo.service;

import com.example.demo.entity.Zzg;

import java.util.List;

   public interface ZzgService {
        public List<Zzg> sel();
}

 4.ServiceImpl层

package com.example.demo.service.impl;

import com.example.demo.entity.Zzg;
import com.example.demo.mapper.ZzgMapper;
import com.example.demo.service.ZzgService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class ZzgServiceImpl  implements ZzgService {
    @Autowired
    private ZzgMapper zzgMapper;
    @Override
    public List<Zzg> sel() {
        return zzgMapper.sel();
    }
}

5.Controller层

package com.example.demo.controller;

import com.example.demo.entity.Zzg;
import com.example.demo.service.ZzgService;
import org.springframework.beans.factory.annotation.Autowired;
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
@RequestMapping("zzg")
public class ZzgController {
     @Autowired
     private ZzgService zzgService;
     @GetMapping("/sel")
     public List<Zzg> sel(){
          return zzgService.sel();
     }
}

五、mysql配置---application.properties重命名为application.yml

spring:
  datasource:
    name: test  #数据库名
    url: jdbc:mysql://localhost:3306/test #url
    username: root  #用户名
    password: 123456  #密码
    driver-class-name: com.mysql.cj.jdbc.Driver  #数据库链接驱动
server:
  port: 8080

mybatis:
  mapper-locations: classpath:mapper/*.xml  #配置映射文件
  type-aliases-package: com.example.test.entity #配置实体类

导入数据库文件（mysql）

/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50737
Source Host           : localhost:3306
Source Database       : test

Target Server Type    : MYSQL
Target Server Version : 50737
File Encoding         : 65001

Date: 2022-03-31 08:52:03
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for zzg
-- ----------------------------
DROP TABLE IF EXISTS `zzg`;
CREATE TABLE `zzg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zzg
-- ----------------------------
INSERT INTO `zzg` VALUES ('1', '小王', '1', '男');
INSERT INTO `zzg` VALUES ('2', '小郭', '2', '女');
INSERT INTO `zzg` VALUES ('3', '小刘', '5', '男');
INSERT INTO `zzg` VALUES ('4', '小王纸', '18', '男');

六、运行---浏览器访问localhost:8080/zzg/sel