web3-202226701039/UserMapper.java

package cn.flea.chexnetmaster.mapper;

import cn.flea.chexnetmaster.pojo.User;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface UserMapper {

//    @Select("SELECT * FROM user WHERE id = #{id}")
//    User getUserById(Integer id);

//    @Select("SELECT * FROM user")
//    List<User> getAllUsers();

//    @Select("SELECT * FROM user WHERE name = #{name} and password = #{name}")
//    User getUserByNameAndPassword(String name, String password);

//    @Delete("DELETE FROM user WHERE id = #{id}")
//    int deleteUserById(Integer id);

    int addUser(User user);

    int deleteUserByOpenid(String wechatOpenid);

    int updateUserById(User user);

    int updateUserByOpenid(User user);

    User getUserByOpenid(String wechatOpenid);

    User getUserById(Integer id);

}