冯强军

//mapper文件
package com.yunjiani.mapper;

import com.yunjiani.pojo.User;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface UserMapper {
    /**
    * 查询所有用户
    */
    @Select("select id, username, password, name, age from user")
    public List<User> findAll();

    /**
    * 根据ID删除用户
    */
    @Delete("delete from user where id=#{id}")
    public Integer deleteById(Integer id);

    /**
     * 新增数据
     */
    @Insert("insert into user(username,password,name,age) values(#{username},#{password},#{name},#{age})")
    public Integer insertUser(User user);


    /**
     * 修改用户信息
     */
    @Update("update user set username = #{username},password = #{password},name = #{name},age = #{age} where id = #{id}")
    public Integer updateUser(User user);

    /**
     * 根据用户名和密码查询用户
     */
    @Select("select * from user where username = #{username} and password = #{password}")
    public User queryInfo(String username, String password);

}
}

git config --global credential.helper store

记住git密码命令