如何使用IntelliJ IDEA搭建MyBatis-Plus框架并連接MySQL數(shù)據(jù)庫
0 準(zhǔn)備工作
- 下載并安裝 IntelliJ IDEA
- 下載并安裝 MySQL 數(shù)據(jù)庫
- 下載并安裝Postman測試工具
- 使用 Navicat 創(chuàng)建一個 MySQL 數(shù)據(jù)庫
1 創(chuàng)建Maven項(xiàng)目
- 打開 IntelliJ IDEA,選擇 "File"→ “New” → “Project”。
- 選擇"Maven"作為項(xiàng)目類型,并設(shè)置項(xiàng)目名稱、項(xiàng)目位置。
- 設(shè)置Group Id和Artifact Id,點(diǎn)擊"Create"創(chuàng)建項(xiàng)目。

2 配置Maven依賴
在pom.xml文件中添加SpringBoot和MyBatis-Plus等的依賴:
<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<!-- 定義父項(xiàng)目,使用Spring Boot 的版本管理 -->
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.7.17</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<!-- 項(xiàng)目的基本信息 -->
<groupId>com.z</groupId>
<artifactId>MySSM</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>MySSM</name>
<description>MySSM</description>
<!-- 定義Java版本 -->
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<!-- Spring Boot Web Starter,包含了Spring MVC等 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- MyBatis Spring Boot Starter -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.3.1</version>
</dependency>
<!-- MySQL Connector Java -->
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<scope>runtime</scope>
</dependency>
<!-- Lombok,簡化Java代碼 -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<!-- Spring Boot Starter Test -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!-- MyBatis-Plus Starter -->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.3</version>
</dependency>
<!-- Swagger Annotations -->
<dependency>
<groupId>io.swagger</groupId>
<artifactId>swagger-annotations</artifactId>
<version>1.5.22</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<configuration>
<image>
<builder>paketobuildpacks/builder-jammy-base:latest</builder>
</image>
<excludes>
<exclude>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</exclude>
</excludes>
</configuration>
</plugin>
</plugins>
</build>
</project>使用Maven工具或IDEA的自動構(gòu)建功能,下載依賴。
若出現(xiàn)如下錯誤:

那么點(diǎn)擊Maven設(shè)置,選擇Maven主路徑為本地的Maven下載路徑:


3 配置數(shù)據(jù)源
在application.yml文件中配置數(shù)據(jù)庫連接等信息:
server:
# 端口
port: 8080
spring:
# 數(shù)據(jù)源配置
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/your_database_name?characterEncoding=utf-8
username: your_username
password: your_password
jackson:
time-zone: GMT+8
date-format: yyyy-MM-dd HH:mm:ss
mybatis-plus:
# mapper文件映射路徑
mapper-locations: classpath*:mapper/*.xml
configuration:
# 打印SQL語句
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl替換上面的示例中的your_database_name、your_username、your_password為實(shí)際數(shù)據(jù)庫中的信息和數(shù)據(jù)。
4 項(xiàng)目結(jié)構(gòu)
項(xiàng)目結(jié)構(gòu)如下圖所示:

5 創(chuàng)建實(shí)體類
創(chuàng)建實(shí)體類(entity),例如Student.java:
package com.z.entity;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import java.io.Serializable;
@Data
@TableName("student")
public class Student implements Serializable {
private static final long serialVersionUID = 1L;
/**id*/
@TableId(type = IdType.AUTO)
@ApiModelProperty(value = "id")
private Integer id;
@ApiModelProperty(value = "姓名")
private String name;
@ApiModelProperty(value = "性別")
private String sex;
@ApiModelProperty(value = "年齡")
private Integer age;
@ApiModelProperty(value = "專業(yè)")
private String major;
}6 創(chuàng)建數(shù)據(jù)訪問層
創(chuàng)建數(shù)據(jù)訪問層(mapper),例如StudentMapper.java:
package com.z.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.z.entity.Student;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface StudentMapper extends BaseMapper<Student> {
}創(chuàng)建對應(yīng)的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.z.mapper.StudentMapper"> </mapper>
7 創(chuàng)建服務(wù)層
創(chuàng)建服務(wù)層(service)及其實(shí)現(xiàn),例如StudentService.java:
Service層:
package com.z.service;
import com.baomidou.mybatisplus.extension.service.IService;
import com.z.entity.Student;
public interface StudentService extends IService<Student> {
}Service實(shí)現(xiàn)層:
package com.z.service;
import com.baomidou.mybatisplus.extension.service.IService;
import com.z.entity.Student;
public interface StudentService extends IService<Student> {
}8 創(chuàng)建Controller層
創(chuàng)建Controller層,處理業(yè)務(wù)邏輯,例如StudentController.java(以返回?cái)?shù)據(jù)列表為例):
package com.z.controller;
import com.z.entity.Student;
import com.z.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.List;
@RestController
@RequestMapping("/test")
public class StudentController {
@Autowired
private StudentService studentService;
@GetMapping("/list")
public List<Student> listStudent() {
return studentService.list();
}
}9 啟動項(xiàng)目
編寫Main.java運(yùn)行項(xiàng)目,并通過IDEA的啟動按鈕啟動項(xiàng)目:
package com.z;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class Main {
public static void main(String[] args) {
SpringApplication.run(Main.class, args);
}
}10 使用Postman測試接口
在MySQL數(shù)據(jù)庫中新建一個數(shù)據(jù)表student,其中存放幾條測試數(shù)據(jù):

打開Postman,新建一個Get請求,并輸入對應(yīng)Controller中的請求URL進(jìn)行測試,測試結(jié)果如下:

前端界面可通過該接口展示數(shù)據(jù)表中的數(shù)據(jù)。
到此這篇關(guān)于使用IntelliJ IDEA搭建SSM(MyBatis-Plus)框架并連接MySQL數(shù)據(jù)庫的文章就介紹到這了,更多相關(guān)idea搭建SSM框架內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!
相關(guān)文章
SpringBoot實(shí)現(xiàn)接口統(tǒng)一前綴
本文主要介紹了SpringBoot實(shí)現(xiàn)接口統(tǒng)一前綴,文中通過示例代碼介紹的非常詳細(xì),對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2023-07-07

