1.基本配置:
引入pom依赖:
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.17</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.32</version>
</dependency>
</dependencies>
application.yaml配置文件:
spring:
datasource:
druid:
url: jdbc:mysql://localhost:3306/java2204?useSSL=false&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
username: root
password: 123456
driver-class-name: com.mysql.cj.jdbc.Driver
mybatis:
mapper-locations: classpath:mapper/*.xml
2.实例测试:
数据库表:
![](https://img-blog.csdnimg.cn/img_convert/6983748202d04051a495415fbf8f4e6c.png)
实体类:
package com.example.springboot.bean;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;
@Data
@AllArgsConstructor
@NoArgsConstructor
@ToString
public class User {
private Integer uid;
private String userName;
private String userPasswd;
}
mapper接口:
package com.example.springboot.mapper;
import com.example.springboot.bean.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
@Mapper
public interface UserMapper {
public Integer insertUser(User user);
public User queryByUser(
@Param("userName") String userName,
@Param("userPasswd") String userPasswd
);
public User queryById(@Param("uid") Integer uid);
}
service类:
package com.example.springboot.service;
import com.example.springboot.bean.User;
import com.example.springboot.mapper.UserMapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class UserService {
@Autowired
UserMapper userMapper;
public Integer insertUser(User user) {
Integer integer = userMapper.insertUser(user);
return integer;
}
public User queryByUser(String userName, String userPasswd) {
User user = userMapper.queryByUser(userName, userPasswd);
return user;
}
public User queryById(Integer uid) {
return userMapper.queryById(uid);
}
}
controller类:
package com.example.springboot.controller;
import com.example.springboot.bean.User;
import com.example.springboot.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
@RestController
public class UserController {
@Autowired
UserService userService;
@RequestMapping(value = "insertUser",method = RequestMethod.POST)
public Integer insertUser(User user) {
Integer integer = userService.insertUser(user);
return integer;
}
@RequestMapping(value = "queryByUser",method = RequestMethod.GET)
public User queryByUser(
@RequestParam("userName") String userName,
@RequestParam("userPasswd") String userPasswd) {
User user = userService.queryByUser(userName, userPasswd);
return user;
}
@RequestMapping(value = "queryById",method = RequestMethod.GET)
public User queryById(@RequestParam("uid") Integer uid) {
User user = userService.queryById(uid);
return user;
}
}
APIpost测试:
![](https://img-blog.csdnimg.cn/img_convert/bbdc0cf4c1b349ae9cd4415bcb5b53f0.png)