liutengjian66 / covid Goto Github PK

因为我看到你那里的id后面总是加了一个id+”L“

错误是这样的：
[Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException:

Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: '13L'

The error may exist in com/liu/covid/mapper/EmpMapper.java (best guess)

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: DELETE FROM emp_health WHERE id=?

Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: '13L'

; Data truncation: Truncated incorrect DOUBLE value: '13L'; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: '13L'] with root cause

com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: '13L'

JDBC Connection [HikariProxyConnection@1604670627 wrapping com.mysql.cj.jdbc.ConnectionImpl@47b27fd7] will not be managed by Spring
==> Preparing: SELECT id,username,password,depart FROM user WHERE (username LIKE ?)
==> Parameters: %admin%(String)
<== Columns: id, username, password, depart
<== Row: 1, admin, e10adc3949ba59abbe56e057f20f883e, 人力资源部
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@35f0f769]