1.1实体类
package com.itheima.pojo;
import com.fasterxml.jackson.annotation.JsonFormat;
import jakarta.validation.constraints.NotEmpty;
import lombok.Data;
import java.time.LocalDateTime;
@Data
public class Category {
private Integer id;//主键ID
@NotEmpty
private String categoryName;//分类名称
@NotEmpty
private String categoryAlias;//分类别名
private Integer createUser;//创建人ID
@JsonFormat(pattern = "yyy-MM-dd HH:mm:ss")
private LocalDateTime createTime;//创建时间
@JsonFormat(pattern = "yyy-MM-dd HH:mm:ss")
private LocalDateTime updateTime;//更新时间
}
1.2Controller
@GetMapping
public Result<List<Category>>list(){
List<Category> cs = categoryService.list();
return Result.success(cs);
}
1.3Service
//列表查询
List<Category> list();
1.4ServiceImpl
@Override
public List<Category> list() {
Map<String,Object> map = ThreadLocalUtil.get();
Integer userId = (Integer) map.get("id");
return categoryMapper.list(userId);
}
1.5Mapper
@Select("select * from category where create_user = #{userId}")
List<Category> list(Integer userId);
1.6test