What is the relationship between Mapper sql statement fields and entity class attribute names

background:

1. There is a notification table in the database

You can see the

• gmt_create,
• notifier_name,
• outer_title
  

These three fields are underlined.

2. The entity class corresponding to this table is

public class Notification {
  private Long id;
  private Long notifier;
  private Long receiver;
  private Long outerId;
  private Integer type;
  private Long gmtCreate;
  private Integer status;
  private String notifierName;
  private String outerTitle;
}

Use camelCase when writing actual Java code

Note whether camel case mapping is enabled in application.properties

#CamelCase Mapping
mybatis.configuration.map-underscore-to-camel-case=true

3. There is an insert statement in Mapper

//0.Insert a notification
@Insert("insert into questions (title,description,gmt_create,gmt_modified,creator,tag) values ​​(#{title},#{description},#{gmtCreate},#{gmtModified},#{creator},#{tag})")
void createQuestion(Question question);

Conclusion: When doing placeholder, the content in #{} should be gmtCreate

Be careful when writing, writing it as gmt_create may result in an error

There is no getter for property named 'gmt_create' in 'class com.example.com

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.