mybatis plus实现curd的方式

最新推荐文章于 2025-08-12 20:29:02 发布

原创最新推荐文章于 2025-08-12 20:29:02 发布 · 1.9k 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

mybatis plus

本文介绍MyBatis实现CURD操作的三种方法：继承IService接口调用方法、继承BaseMapper接口调用方法及在XML中编写SQL实现查询。通过具体的代码示例展示了Controller、Service和Mapper层的实现细节。

mybatis实现curd的方式有三种

一、继承IService接口，直接调用该接口中的方法

方法包含以下接口方法

二、继承BaseMapper，直接调用该接口中的方法

上面两中方法，下面展示代码

controller

package com.tp.mybatisplusstudy.controller;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.tp.mybatisplusstudy.dao.UserMapper;
import com.tp.mybatisplusstudy.service.IUserService;
import com.tp.mybatisplusstudy.vo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.ArrayList;
import java.util.List;

/**
 * @Package: com.tp.mybatisplusstudy.controller
 * @ClassName: UserController
 * @Author: tanp
 * @Description: ${description}
 * @Date: 2020/4/22 9:13
 */
@RestController
@RequestMapping(value = "/user")
public class UserController {

    @Autowired
    private UserMapper userMapper;

    @Autowired
    private IUserService iUserService;


    @RequestMapping(value = "/getUsers")
    public List<User> getUsers() {
        System.out.print("请求次数--");
        List<User> users = userMapper.selectList(null);
        return users;
    }

    @RequestMapping(value = "/getUsers23")
    public List<User> getUsers2() {
        List<User> users = iUserService.list();
        return users;
    }

    @RequestMapping(value = "/save")
    public boolean save() {
        User user = new User();
        user.setId(8L);
        user.setAge(8);
        user.setEmail("123456789@qq,com");
        user.setName("8888");
        return iUserService.save(user);
    }

    @RequestMapping(value = "/svaeList")
    public boolean save2(){
        List<User> userList = new ArrayList<>();
        User user;
        for(int i=0; i<5; i++){
            user = new User();
            user.setName("mike"+i);
            user.setAge(i);
            user.setId(Long.parseLong("10"+i));
            userList.add(user);
        }

        return iUserService.saveBatch(userList);
    }


    @RequestMapping(value = "getUserList2")
    public List<User> getUserList2(){
        QueryWrapper qw = new QueryWrapper();
        qw.likeRight("name","mike");
        return userMapper.selectList(qw);
    }

    @RequestMapping(value = "getUserList3")
    public List<User> getUserList3(){
        QueryWrapper qw = new QueryWrapper();
        qw.likeLeft("name","mike");
        return userMapper.selectList(qw);
    }


}

service

package com.tp.mybatisplusstudy.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.tp.mybatisplusstudy.vo.User;

/**
 * @ClassName: IUserService
 * @Author: tanp
 * @Description: ${description}
 * @Date: 2020/4/22 16:25
 */
public interface IUserService extends IService<User> {
}

package com.tp.mybatisplusstudy.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.tp.mybatisplusstudy.dao.UserMapper;
import com.tp.mybatisplusstudy.service.IUserService;
import com.tp.mybatisplusstudy.vo.User;
import org.springframework.stereotype.Service;

/**
 * @ClassName: UserServiceImpl
 * @Author: tanp
 * @Description: ${description}
 * @Date: 2020/4/22 16:32
 */
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements IUserService {
}

mapper

package com.tp.mybatisplusstudy.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tp.mybatisplusstudy.vo.User;
import org.springframework.stereotype.Repository;

/**
 * @Package: com.tp.mybatisplusstudy.dao
 * @ClassName: UserMapper
 * @Author: tanp
 * @Description: ${description}
 * @Date: 2020/4/21 19:26
 */
@Repository
public interface UserMapper extends BaseMapper<User> {
}