Mybatis 动态更新数据
方法一:使用 set 标签
- update cx_customer_message MESSAGEE_CLASSIFY = # {
- messageClassify,
- jdbcType = VARCHAR
- },
- MESSAGE_CODE = # {
- messageCode,
- jdbcType = VARCHAR
- },
- MESSAGE_CONTENT = # {
- messageContent,
- jdbcType = VARCHAR
- },
- where ID = # {
- id,
- jdbcType = VARCHAR
- }
- and MEMBERID = # {
- memberId,
- jdbcType = VARCHAR
- }
方法二:使用 trim 标签
- update cx_customer_message MESSAGEE_CLASSIFY = # {
- messageClassify,
- jdbcType = VARCHAR
- },
- MESSAGE_CODE = # {
- messageCode,
- jdbcType = VARCHAR
- },
- MESSAGE_CONTENT = # {
- messageContent,
- jdbcType = VARCHAR
- },
- where ID = # {
- id,
- jdbcType = VARCHAR
- }
- and MEMBERID = # {
- memberId,
- jdbcType = VARCHAR
- }
就爱阅读 www.92to.com 网友整理上传, 为您提供最全的知识大全, 期待您的分享,转载请注明出处。
来源: