thymeleaf 对返回值为DTO对象的sql语句列表方法的列名进行重命名

最新推荐文章于 2022-05-31 11:59:41 发布

weixin_40781373

最新推荐文章于 2022-05-31 11:59:41 发布

阅读量273

点赞数

分类专栏： sql语句文章标签： mysql sql

本文链接：https://blog.csdn.net/weixin_40781373/article/details/104975055

版权

sql语句专栏收录该内容

2 篇文章 0 订阅

订阅专栏

报错信息：org.thymeleaf.exceptions.TemplateInputException: An error happened during template parsing (template: “class path resource [templates/manage/evaluation.html]”)

以及
org.springframework.expression.spel.SpelEvaluationException: EL1007E: Property or field ‘evaluation’ cannot be found on null

这是因为没有对返回值为DTO对象的sql语句查出来的列表的列名进行重命名
Mybatis 注解自定义对象返回值必须用AS重命名
例：

@Select("SELECT evaluation.*, software.`name`, `user`.user_name "
            + "FROM evaluation INNER JOIN software ON evaluation.software_id = software.pk_soft_id , `user` "
            + "WHERE evaluation.software_id = software.pk_soft_id AND evaluation.submitter = `user`.user_id")
    public List<EvaluationDTO> queryAll();

改为

@Select("SELECT evaluation.pk_evaluation_id AS 'evaluation.pk_evaluation_id',"
            + "evaluation.software_id AS 'evaluation.software_id',"
            + "evaluation.submitter AS 'evaluation.submitter',"
            + "evaluation.star AS 'evaluation.star',"
            + "evaluation.content AS 'evaluation.content',"
            + "evaluation.evaluate_time AS 'evaluation.evaluate_time',"
            + "software.`name` AS softName, `user`.user_name AS submitterName "
            + "FROM evaluation INNER JOIN software ON evaluation.software_id = software.pk_soft_id , `user` "
            + "WHERE evaluation.software_id = software.pk_soft_id AND evaluation.submitter = `user`.user_id "
            + "ORDER BY evaluation.evaluate_time DESC")
    public List<EvaluationDTO> queryAll();

EvaluationDTO：

package com.zstu.software.model.dto;

import com.zstu.software.model.Evaluation;
import lombok.*;

@Data
@ToString
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class EvaluationDTO {

    /**
     * 软件评价
     */
    private Evaluation evaluation;

    /**
     * 软件名称
     */
    private String softName;

    /**
     * 评价人姓名
     */
    private String submitterName;

}

Evaluation：

package com.zstu.software.model;

import lombok.*;

import java.util.Date;
import javax.persistence.*;

@Data
@ToString
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class Evaluation {
    /**
     * 评价编号
     */
    @Id
    @Column(name = "pk_evaluation_id")
    private Integer pkEvaluationId;

    /**
     * 软件ID
     */
    @Column(name = "software_id")
    private Integer softwareId;

    /**
     * 评价人
     */
    private String submitter;

    /**
     * 评价星级
     */
    private Integer star;

    /**
     * 评价内容
     */
    private String content;

    /**
     * 时间戳
     */
    @Column(name = "evaluate_time")
    private Date evaluateTime;
}