MyBatisPLus3.x中代码生成器自定义数据库表字段类型转换

ゝ一纸荒年。 2023-10-18 17:41 98阅读 0赞

## 场景 ##

MyBatisPlus3.x中使用代码生成器(全注释)：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/89518466][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_89518466]

数据库字段为

[available_flag] tinyint  NULL,
      [deleted_flag] tinyint  NULL,
      [sync_flag] tinyint  NULL,

在使用MyBatisPlus的代码生成器时要将生成后的实体类中的属性转换为Boolean类型的。

## 实现 ##

在上面代码生成器的基础上：

//数据源配置
            DataSourceConfig dataSourceConfig = new DataSourceConfig();
            //数据库类型 枚举
            dataSourceConfig.setDbType(DbType.SQL_SERVER)
                    //设置url
                    .setUrl(dbUrl)
                    //设置用户名
                    .setUsername("")
                    //设置密码
                    .setPassword("")
                    //设置数据库驱动
                    .setDriverName("com.microsoft.sqlserver.jdbc.SQLServerDriver")
                    // 自定义数据库表字段类型转换【可选】
                    .setTypeConvert(new MySqlTypeConvert() {
                        @Override
                        public DbColumnType processTypeConvert(GlobalConfig globalConfig, String fieldType) {
                            System.out.println("转换类型：" + fieldType);
                            //tinyint转换成Boolean
                             if ( fieldType.toLowerCase().contains( "tinyint" ) ) {
                                return DbColumnType.BOOLEAN;
                             }
                             //将数据库中datetime转换成date
                            if ( fieldType.toLowerCase().contains( "datetime" ) ) {
                                return DbColumnType.DATE;
                            }
                            return (DbColumnType) super.processTypeConvert(globalConfig, fieldType);
                        }
                    });

## 效果 ##

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70][]

[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_89518466]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/89518466
[Image 1]: 
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190425164303555.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70