mybatis中boolean类型自动保存到oracle中

ゝ一纸荒年。 2023-07-13 03:15 19阅读 0赞

背景

前台用的angularJs，后台是springmvc，数据库矿建是mybatis

1、前台为checkBox传值，如下

![20200309203038575.png][]

2、Unify对象定义为bolean类型

![20200309204226526.png][]

3、后台把值映射到Unify对象中，如下图所示

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4MzI5MjU_size_16_color_FFFFFF_t_70][]

4、字符串自动转为bolean类型

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4MzI5MjU_size_16_color_FFFFFF_t_70 1][]

5、数据库字段类型，如下图

![20200309205821431.png][]

6、保存到数据库的值为1

![20200309204543988.png][]

7、查询时字段映射，如下图

![20200309204628218.png][]

8、界面展示，如下图

![20200309204729279.png][]

[20200309203038575.png]: https://img-blog.csdnimg.cn/20200309203038575.png
[20200309204226526.png]: https://img-blog.csdnimg.cn/20200309204226526.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4MzI5MjU_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200309204054417.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4MzI5MjU=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4MzI5MjU_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/202003092039573.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4MzI5MjU=,size_16,color_FFFFFF,t_70
[20200309205821431.png]: https://img-blog.csdnimg.cn/20200309205821431.png
[20200309204543988.png]: https://img-blog.csdnimg.cn/20200309204543988.png
[20200309204628218.png]: https://img-blog.csdnimg.cn/20200309204628218.png
[20200309204729279.png]: https://img-blog.csdnimg.cn/20200309204729279.png