mybatis五、注解开发sql

//实体类
@Data
//Data:无参构造，get,set,tostring,hashcode,equals
@AllArgsConstructor
@NoArgsConstructor
@Getter
@Setter
@ToString
@Alias("hello")//起别名
public class User {
    private int id;
    private String name;
    private String password;
}

public interface UserMapper {
    @Select("select *from mybatis.user")
   List<User> getUsers();
    //方法存在多个参数，所有的参数前面必须加上@Param注解。如getUserById(@Param("id") int id,@Param("name") String name);
    //这里匹配主要是以Param()里的参数为主，int id可以写成int id2也同样能查询到
    @Select("select * from mybatis.user where id = #{id}")
    User getUserById(@Param("id") int id);
    //这里做映射，因为没有resultMap，数据库里是pwd，实体类是password，所以要相对应，前面是pwd，后面是password
    @Insert("insert into mybatis.user (id,name,pwd) values (#{id},#{name},#{password})")
    int addUser(User user);

    @Update("update mybatis.user set name=#{name},pwd=#{password} where id =#{id}")
    int updateUser(User user);

    @Delete("delete from mybatis.user where id = #{uid}")
    int deleteUser(@Param("uid") int id);
}