一登失、實體類沒有提供無參構(gòu)造函數(shù)導(dǎo)致查詢時字段映射失敗
錯誤信息如下
Resolved [org.springframework.dao.DataIntegrityViolationException: Error attempting to get column 'person_name' from result set. Cause: java.sql.SQLDataException: Cannot determine value type from string 'AC'
; ]; Cannot determine value type from string 'AC'; nested exception is java.sql.SQLDataException: Cannot determine value type from string 'AC']
解決方案：在Person類里提供無參構(gòu)造函數(shù)
場景2：@Builder導(dǎo)致實體類沒有無參構(gòu)造函數(shù)
@Builder
@AllArgsConstructor
@NoArgsConstructor
@Data
@TableName("t_member_value_member_task")
public class MemberValueMemberTask{
//代碼省略
}
解決：需要加@AllArgsConstructor``@NoArgsConstructor 注解莺褒，提供無參構(gòu)造函數(shù)
@Builder
@Data
@TableName("t_member_value_member_task")
public class MemberValueMemberTask{
//代碼省略
}
二、mybatis比較date和datetime大小的問題
三传泊、mysql從數(shù)據(jù)庫查詢的時間與實際時間相差8小時（時區(qū)問題）
將serverTimezone =GMT設(shè)置為serverTimezone =GMT%2B8
jdbc:mysql://47.*.*.74:3306/test_db?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone =GMT%2B8
