java - 如何使用注释存储时将实体类中的列值设为小写

Question

I want an entity class through which I can store data to DB, for specific columns I want in case-sensitive, is there any annotation to be used above these specific columns to store as requested? please let me if the question is not clear,Thanks in advance.

@Column(name = "EMAIL",unique=true)  //i want store this email id as lower case,
private String email;               //never mind in what case user enters

Answer 1

您可以使用@ColumnTransformer来做到这一点

 @Column(name = "email") 
@ColumnTransformer(write = "LOWER(email)") 
 private String email;