mybatis plus实现curd的方式

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> {
}

三、在xml中写sql实现查询

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值