SpringBoot整合Mybatis实现增删改查

最新推荐文章于 2024-05-30 10:07:45 发布

CV_J

最新推荐文章于 2024-05-30 10:07:45 发布

阅读量315

点赞数 2

本文链接：https://blog.csdn.net/qq_49420571/article/details/130713296

版权

JAVA 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

1.pom.xml

<?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>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.7.11</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.wzkj.jsj</groupId>
    <artifactId>test</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>test</name>
    <description>test</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.3.0</version>
        </dependency>

        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
        </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.2.8</version>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

2.controller

package com.wzkj.jsj.controller;
import com.wzkj.jsj.pojo.User;
import com.wzkj.jsj.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
public class TestController {
    @Autowired
    private UserService userService;
    @GetMapping("/getAllUsers")
    public List<User> getAllUsers() {
        return userService.findAllUser();
    }
    @PostMapping("/addUser")
    public String addUser(User user) {
      int res = userService.addUser(user);
      if (res>=1){
          return "添加成功";
      }else {
          return "添加失败";
      }
    }
    @DeleteMapping("/delById/{id}")
    public String delById(@PathVariable("id") Integer id) {
        int res = userService.delById(id);
        if (res>=1){
            return "删除成功";
        }else {
            return "删除失败";
        }
    }
    @PutMapping("/updateUser")
    public String updateUser(User user) {
        int res = userService.updateUser(user);
        if (res>=1){
            return "修改成功";
        }else {
            return "修改失败";
        }
    }
    @GetMapping("/getUserInfo/{id}")
    public User getUserInfo(@PathVariable("id") Integer id){
        return userService.getUserInfo(id);
    }
}

3.mapper

package com.wzkj.jsj.mapper;
import com.wzkj.jsj.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;

@Mapper
public interface UserMapper {

    User getUserInfo(int id);

    int addUser(User user);

    int updateUser(User user);

    int delById(int id);

    List<User> findAllUser();

}

4.pojo5

package com.wzkj.jsj.pojo;

public class User {
    private Integer id;
    private String name;
    private String type;
    private Integer age;
    private String sex;
    private String hobby;
    private String identity;

    public User() {
    }

    public User(Integer id, String name, String type, Integer age, String sex, String hobby, String identity) {
        this.id = id;
        this.name = name;
        this.type = type;
        this.age = age;
        this.sex = sex;
        this.hobby = hobby;
        this.identity = identity;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getHobby() {
        return hobby;
    }

    public void setHobby(String hobby) {
        this.hobby = hobby;
    }

    public String getIdentity() {
        return identity;
    }

    public void setIdentity(String identity) {
        this.identity = identity;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", type='" + type + '\'' +
                ", age=" + age +
                ", sex='" + sex + '\'' +
                ", hobby='" + hobby + '\'' +
                ", identity='" + identity + '\'' +
                '}';
    }
}

5.service

package com.wzkj.jsj.service;
import com.wzkj.jsj.pojo.User;
import org.springframework.stereotype.Repository;
import java.util.List;

@Repository
public interface UserService {

    User getUserInfo(int id);

    int addUser(User user);

    int updateUser(User user);

    int delById(int id);

    List<User> findAllUser();

}

impl

package com.wzkj.jsj.service.impl;

import com.wzkj.jsj.mapper.UserMapper;
import com.wzkj.jsj.pojo.User;
import com.wzkj.jsj.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserMapper userMapper;
    @Override
    public List<User> findAllUser() {
        return userMapper.findAllUser();
    }

    @Override
    public User getUserInfo(int id) {
        return userMapper.getUserInfo(id);
    }

    public int addUser(User user) {
        return userMapper.addUser(user);
    }

    @Override
    public int updateUser(User user) {
        return userMapper.updateUser(user);
    }

    @Override
    public int delById(int id) {
        return userMapper.delById(id);
    }
}

6.mapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.wzkj.jsj.mapper.UserMapper">

    <select id="findAllUser" resultType="User">
        select * from user;
    </select>
    <insert id="addUser" parameterType="User">
        insert into user (name,type,age,sex,hobby,identity) values(#{name},#{type},#{age},#{sex},#{hobby},#{identity});
    </insert>
    <delete id="delById" parameterType="java.lang.Integer">
        delete from user where id=#{id};
    </delete>
    <update id="updateUser" parameterType="User">
        update user set name=#{name},type=#{type},age=#{age},sex=#{sex},hobby=#{hobby},identity=#{identity} where id=#{id};
    </update>
    <select id="getUserInfo" parameterType="User" resultType="User">
        select * from user where id=#{id};
    </select>

</mapper>

7.yml

server:
  port: 8088


logging:
  level:
    com:
      wzkj:
        jsj: debug


spring:
  datasource:
    druid:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://localhost:3306/studb?useUnicode=true&characterEncoding=utf-8
      username: root
      password: root

#mybatis
mybatis:

  mapper-locations: classpath:/mapper/*.xml

  map-underscore-to-camel-case: true

  type-aliases-package: com.wzkj.jsj.pojo

最后运行效果