//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); } }