例子一:
使用传统的map进行put后然后执行mapper语句进行数据库插入
Map resMap = new HashMap<>();
resMap.put("inquiryNo", inquery.getInquiryNo());
resMap.put("detailedDescription",content);
resMap.put("createdAt",createTime);
//执行mapper:
userMapper.insertCnInquirySendPhoneRecord(resMap);
//Mapper:
@Insert(" insert cn_inquiry_send_phone_record (inquiry_no, detailed_description, create_time) values (#{inquiryNo}, #{detailedDescription}, #{createdAt});")
void insertCnInquirySendPhoneRecord(Map map);
例子二:
使用jdk9的Map.of进行赋值插入
var sendPhoneMap = Map.of("inquiryNo", inquery.getInquiryNo(),"detailedDescription", content,"createdAt", createTime);
//执行mapper:
userMapper.insertCnInquirySendPhoneRecord(resMap);
//mapper:
@Insert("insert into cn_inquiry_send_phone_record set inquiry_no = #{inquiryNo},detailed_description = #{detailedDescription},create_time = #{createdAt}")
void insertCnInquirySendPhoneRecord(Map map);
注意:二个insert语句不一致,切Map.of不可被更改