软工日报23-9-9

package com.example.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.entity.User;
import org.apache.ibatis.annotations.*;

import java.util.List;
@Mapper
public interface UserMapper {
    /* extends BaseMapper<User>    */

    @Select("select * from user")
    public List<User> find();

    @Select("select * from user where username=#{username}")
    public List<User> findOne(String username);

    @Insert("insert into user values(#{username}, #{password})")
    public int insert(User user);

    @Delete("delete from user where username=#{username}")
    public int del(String username);

    @Update("update user set password=#{password} where username=#{username}")
    public int update(String password,String username);

}