Error attempting to get column ‘sendTime‘ from result set. Cause: java.sql.SQLException: Error

可以看出，映射结果出了问题，查看数据库，发现里面有大量的空数据：

 因此我们，不能继续使用LocalDateTime,进行映射数据库字段DateTime:

解决方法：

将映射的VO SendTime的类型改为 java.util.Date:

@Data
public class OrderListVO implements Serializable {
    private Integer orderId;
    private String memberName;
    private String orderNumber;
    private BigDecimal orderPrice;
    private String logisticsNo;
    private String status;
    private LocalDateTime createTime;
    private Date sendTime;
}

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        order_id, member_id, order_number, order_price, pay_method, is_send, logistics_no, order_fapiao_title, order_fapiao_company, order_fapiao_content, consignee_addr, status, create_time, send_time
    </sql>
    <resultMap id="orderPageList" type="net.wanho.qz112.shop.order.vo.OrderListVO">
        <id column="orderId" property="orderId"/>
        <result column="memberName" property="memberName"/>
        <result column="orderNumber" property="orderNumber"/>
        <result column="orderPrice" property="orderPrice"/>
        <result column="isSend" property="isSend"/>
        <result column="logisticsNo" property="logisticsNo"/>
        <result column="status" property="status"/>
        <result column="createTime" property="createTime"/>
        <result column="sendTime" property="sendTime" jdbcType="DATE" javaType="java.util.Date"/>
    </resultMap>

再次查询：

 不会再次报错了……

倘若发现数据显示的日期格式不正确，我们可以在属性上添加注解

@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")