springboot mybatis获取字段为null时候不显示

mapper的写法

<select id="gettable" resultType="java.util.Map">
    select *
    from table
</select>

现象:

table表中有10个字段,如果字段为null,为空返回的结果集字段就不显示了

 

解决方法:

mysql

CallSettersOnNulls设置这个属性为ture

 

增加代码:

org.apache.ibatis.session.Configuration configuration = new  org.apache.ibatis.session.Configuration();
configuration.setCallSettersOnNulls(true);
sessionFactory.setConfiguration(configuration);
final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
        configuration.setCallSettersOnNulls(true);
        sessionFactory.setConfiguration(configuration);
        sessionFactory.setDataSource(mysqlDataSource);
        sessionFactory.setMapperLocations(
                new PathMatchingResourcePatternResolver().getResources(MysqlDataSourceConfig.MAPPER_LOCATION));
        return sessionFactory.getObject();

 


版权声明:本文为ying456baby原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。