亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定

insert時沒有生成id

????@Test
????public?void?insert(){
????????User?user?=?new?User();
????????user.setName("tom");
????????user.setManagerId(1088248166370832385L);
????????user.setCreateTime(new?Date());
????????int?insert?=?userMapper.insert(user);
????????System.out.println("insert?=?"?+?insert);
????}

org.springframework.dao.DataIntegrityViolationException:?

### Error updating database.? Cause: java.sql.SQLException: Field 'id' doesn't have a default value

### The error may exist in com/exam/demo/mapper/UserMapper.java (best guess)

### The error may involve com.exam.demo.mapper.UserMapper.insert-Inline

### The error occurred while setting parameters

### SQL: INSERT INTO user? ( name,? ?manager_id, create_time )? VALUES? ( ?,? ??, ? )

### Cause: java.sql.SQLException: Field 'id' doesn't have a default value

; Field 'id' doesn't have a default value; nested exception is java.sql.SQLException: Field 'id' doesn't have a default value


正在回答

1 回答

同學,你主鍵策略設置的是什么?包括mp和數據庫的,我懷疑你mp設置的為自增,但數據庫沒設置。

0 回復 有任何疑惑可以回復我~

舉報

0/150
提交
取消

insert時沒有生成id

我要回答 關注問題
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號