本文章主要介绍idea工具创建springboot+mybatis+mysql项目进行查询,需用到postman工具进行接口调用测试,话不多说,往下看!!!
第一步先创建新项目module,若没有工作区间,需创建工作区间project,图如下
第二步
第三步
第四步,勾选需要的依赖(可不勾选,需要时去pom.xml文件引入依赖即可),点击next下一步
第五步创建项目
第六步引入依赖,pom.xml文件内容如下,可根据自己需求引入对应jar包
<?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">
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.7.5</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<modelVersion>4.0.0</modelVersion>
<groupId>com.hp</groupId>
<artifactId>springboot-mybatis-mysql-demo</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>springboot-mybatis-mysql-demo</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<!--springboot核心包-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<!--lombok包,get,set,构造函数-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<!--springboot测试包-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!--springboot web包,前端-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!--mybatis和springboot整合包-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.0</version>
</dependency>
<!--mysql数据库包-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.21</version>
</dependency>
<!--json包-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>2.0.7</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<configuration>
<excludes>
<exclude>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</exclude>
</excludes>
</configuration>
</plugin>
</plugins>
</build>
</project>
第七步,创建项目结构目录,大致如下
第八步 编写application.yml配置文件,基础如下,自行更改对应端口,数据库地址密码等,若mapper.xml,不位于resources目录下或者存在多级目录,则更改为对应的路径再加上/*.xml即可
#设置项目端口号
server:
port: 8090
#数据库地址,驱动,账号,密码配置
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: 1234
url: jdbc:mysql://localhost:3306/t277?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC
# 应用名称
application:
name: springboot-mybatis-mysql-demo
#配置mybatis映射文件地址
mybatis:
mapper-locations: classpath:mapper/*.xml
#sql日志
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
第九步对应数据库创建相关表,此处以学生表为例
第十步,创建对应entity,controller, service,serviceImpl,mapper,mapper.xml
StudentController.java代码如下
package com.hp.controller;
import com.hp.entity.Student;
import com.hp.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
@RestController
@RequestMapping("/student")
public class StudentController {
@Autowired
StudentService studentService;
@RequestMapping("/getStudent")
//下方注解加上代表直接返回数据
@ResponseBody
public List<Student> getStudent(){
return studentService.getStudent();
}
}
Student.java实体对象如下,使用lombok注解,不写get,set,以及有参无参构造函数
package com.hp.entity;
import lombok.*;
/**
* get,set方法的注释
*/
@Data
/**
* 携带所有属性的构造函数 等同于下方
* public Student(String name, String password) {
* this.name = name;
* this.password = password;
* }
*/
@AllArgsConstructor
/**
* 无参数的构造函数
* public Student() {}
*/
@NoArgsConstructor
public class Student {
private int id;
private String name;
private String phone;
private String pwd;
private String address;
}
StudentMapper.java代码
package com.hp.mapper;
import com.hp.entity.Student;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
@Mapper
public interface StudentMapper {
List<Student> getStudent();
}
StudentService.java代码如下
package com.hp.service;
import com.hp.entity.Student;
import java.util.List;
public interface StudentService {
List<Student> getStudent();
}
StudentServiceImpl.java代码如下
package com.hp.service.impl;
import com.hp.entity.Student;
import com.hp.mapper.StudentMapper;
import com.hp.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class StudentServiceImpl implements StudentService {
@Autowired
StudentMapper studentMapper;
@Override
public List<Student> getStudent() {
return studentMapper.getStudent();
}
}
StudentMapper.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.hp.mapper.StudentMapper">
<!-- 通用查询映射结果 -->
<resultMap id="BaseResultMap" type="com.hp.entity.Student">
<result column="id" property="id" jdbcType="INTEGER" />
<result column="name" property="name" jdbcType="VARCHAR" />
<result column="phone" property="phone" jdbcType="VARCHAR" />
<result column="pwd" property="pwd" jdbcType="VARCHAR" />
<result column="address" property="address" jdbcType="VARCHAR" />
</resultMap>
<!-- 通用查询结果列 -->
<sql id="Base_Column_List">
id,name,phone,pwd,address
</sql>
<select id="getStudent" resultMap="BaseResultMap">
select * from student
</select>
</mapper>
至此查询代码编写完成,打开postman进行调用测试,下图为查询结果
也可直接浏览器进行调用,因为controller层内方法请求注解为@RequestMapping,包含get,post等请求方式,浏览器请求结果如下
感谢采纳!!!