java使用mapper操作mysql

上半部分搭建springboot 简单使用数据库查询
添加链接描述

在impl接口实现操作

如

package com.service.impl;
import com.dao.UserMapper;
import com.pojo.User;
import com.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> dade() {
        return userMapper.selectAll();
    }
    @Override
    public User oneUser(Long id) {
        return userMapper.selectByPrimaryKey(id);
    }
}

1、selectAll查所有

	@Override
    public List<User> dade() {
        return userMapper.selectAll();
    }

2、selectByPrimaryKey根据id查询

    @Override
    public User oneUser(Long id) {
        return userMapper.selectByPrimaryKey(id);
    }

3、insert保存

    @Override
    public User oneUser(Long id) {
        User user = new User();
        user.setAge((long) 18);
        user.setName("dade");
        user.setPhone("14796178000");
        user.setDate("2023-12-23");
        userMapper.insert(user);
        return userMapper.selectByPrimaryKey(id);
    }

4、updateByPrimaryKey修改

    @Override
    public User oneUser(Long id) {
        User user = userMapper.selectByPrimaryKey(id);
        user.setName("大得");
        userMapper.updateByPrimaryKey(user);
        return userMapper.selectByPrimaryKey(id);
    }

5、deleteByPrimaryKey删除

    @Override
    public User oneUser(Long id) {
        userMapper.deleteByPrimaryKey(2);
        return userMapper.selectByPrimaryKey(id);
    }

6、selectByExample多条件查询

@Override
    public List<User> oneUser(Long id) {
        Example example=new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        //根据id查询
        criteria.andEqualTo("id", 3);
        //模糊查询
        criteria.andLike("name","%d%");
        return userMapper.selectByExample(example);
    }

7、分页
UserService文件

引入类
import com.github.pagehelper.Page;

接口方法
Page<User> pageUser(int page, int size);

UserServiceImpl文件

引入类型
import com.github.pagehelper.Page;

实现方法
@Override
public Page<User> pageUser(int page, int size) {
        PageHelper.startPage(page,size);
        return (Page<User>)userMapper.selectAll();
}

AdminController文件

引入类
import com.github.pagehelper.Page;

@GetMapping("page/{page}/{size}")
    public Page<User> pageUsel(@PathVariable int page, @PathVariable int size){
        Page<User> dade = userService.pageUser(page, size);
        return dade;
    }

8、多条件查询分页

@Override
    public Page<User> pageUser(int page, int size) {
        PageHelper.startPage(page,size);

        Example example=new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        //根据id查询
        criteria.andEqualTo("id", 3);
        //模糊查询
        criteria.andLike("name","%d%");

        return (Page<User>)userMapper.selectByExample(example);
    }