mybatis + mysql +spring mvc date字段报错java.lang.NumberFormatException

最新推荐文章于 2023-05-23 19:50:37 发布

原创最新推荐文章于 2023-05-23 19:50:37 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

spring mvc 专栏收录该内容

2 篇文章

订阅专栏

本文探讨了在数据库操作中遇到日期格式转换问题的解决方案，特别关注了使用MySQL时将日期字符串正确转化为日期类型的方法，以及如何避免在查询和更新过程中出现的NumberFormatException错误。通过提供具体的代码示例，本文旨在帮助开发者解决实际开发中常见的日期格式不匹配问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<select id="findMapByCondition" resultType="java.util.HashMap">
SELECT
pc_user_id as userId,
username as username,
password as password,
email as email,
cellphone as cellphone,
nickname as nickname,
realname as realname,
photo as photo,
signature as signature,
lvl as lvl,
experience as experience,
credits as credits,

CAST(login_time AS CHAR) AS loginTime,
email_authentication as emailAuthentication,
cellphone_authentication as cellphoneAuthentication,
realname_authentication as realnameAuthentication,
status as status,
image_name as imageName,
image_path as imagePath,
expand_info_id as expandInfoId,
school_id as schoolId,
school_name as schoolName,
area_id as areaId,
specialty_id as specialtyId,
specialty_name as specialtyName,
year_of_admission as yearOfAdmission,
year_of_graduate as yearOfGraduate
FROM view_user
${whereCondition}

</select>

前提：model和数据库字段属性全为date

若使用

DATE_FORMAT(login_time , '%Y-%m-%d %H:%i') as loginTime,

查询出来没问题，但是修改时，若会报

Caused by: java.lang.NumberFormatException: For input string: "2013-10-29 10:10"，

若改成 CAST(login_time AS CHAR) AS loginTime,则解决问题