Springboot Project MyBatis plus settings jdbctypefornull (Oracle database needs to be configured Jdbctype.null, default is Other)

Method 1:application.yml

mybatis-plus:  configuration:    jdbc-type-for-null: ‘null‘ #注意：单引号

Method 2:

View mp-starter-source code, Mybatisplusautoconfiguration, you can find that the 119th line has a configurationcustomizers, you can modify the configuration

Custom one, with the completion

    @BeanPublicConfigurationcustomizerConfigurationcustomizer(){ReturnNew Mybatispluscustomizers (); }Class Mybatispluscustomizers implements  configurationcustomizer { @Override  public  void  customize (Org.apache.ibatis.session.Configuration Configuration)  {configuration.setjdbctypefornull (jdbctype.null);} 
                 /span>       

Method 3:

First step: Add the JavaBean attribute with the updatable null to the previous annotation: @TableField (el = "username, Jdbctype=varchar")

@Email
@TableField (el = "email, jdbctype=varchar")
Private String Email;

Step two: Use the Updateallcolumnbyid method instead of the Updatebyid. such as: this.baseMapper.updateAllColumnById (user);

     

Springboot Project MyBatis plus settings jdbctypefornull (Oracle database needs to be configured Jdbctype.null, default is other)