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版权协议,转载请附上原文出处链接和本声明。