您好,登錄后才能下訂單哦!
mybatis plus中空字符串無(wú)法保存到數(shù)據(jù)庫(kù)如何解決?針對(duì)這個(gè)問(wèn)題,這篇文章詳細(xì)介紹了相對(duì)應(yīng)的分析和解答,希望可以幫助更多想解決這個(gè)問(wèn)題的小伙伴找到更簡(jiǎn)單易行的方法。
在字段上加上
@TableField(strategy = FieldStrategy.IGNORED)
strategy字段更新插入策略屬性說(shuō)明:
IGNORED(0): “忽略判斷”, 所有字段都更新和插入
NOT_NULL(1): “非 NULL 判斷”, 只更新和插入非NULL值
NOT_EMPTY(2): “非空判斷”, 只更新和插入非NULL值且非空字符串
另外一種方式可全局配置,未親手實(shí)踐。
補(bǔ)充:Mybatis查詢數(shù)據(jù)部分字段顯示為null,怎么轉(zhuǎn)成空串("")
1、先定義一個(gè)handler,來(lái)把字段為null的轉(zhuǎn)成空串("")
2、在Mapper.xml中,把可能為空的字段,加上typeHandler屬性,指定處理的handler類的全路徑。
CustomStringTypeHandler.java
package com.wang.common.mybatis.handler; import org.apache.ibatis.executor.result.ResultMapException; import org.apache.ibatis.type.BaseTypeHandler; import org.apache.ibatis.type.JdbcType; import org.apache.ibatis.type.MappedJdbcTypes; import org.apache.ibatis.type.MappedTypes; import java.sql.CallableStatement; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; /** * @Name: CustomStringTypeHandler * @Desc: 自定義mybatis處理類,將null返回為空串(‘') * @Author: Administrator * @Date: 2019-09-03 18:20 */ @MappedTypes({String.class}) @MappedJdbcTypes(JdbcType.VARCHAR) public class CustomStringTypeHandler extends BaseTypeHandler<String> { @Override public String getResult(ResultSet rs, String columnName) { String result; try { result = getNullableResult(rs, columnName); } catch (Exception e) { throw new ResultMapException("Error attempting to get column '" + columnName + "' from result set. Cause: " + e, e); } return result; } @Override public void setNonNullParameter(PreparedStatement ps, int i, String parameter, JdbcType jdbcType) throws SQLException { ps.setString(i, parameter); } @Override public String getNullableResult(ResultSet rs, String columnName) throws SQLException { return rs.getString(columnName) == null? "" : rs.getString(columnName); } @Override public String getNullableResult(ResultSet rs, int columnIndex) throws SQLException { return rs.getString(columnIndex) == null? "" : rs.getString(columnIndex); } @Override public String getNullableResult(CallableStatement cs, int columnIndex) throws SQLException { return cs.getString(columnIndex) == null? "" : cs.getString(columnIndex); } }
Mapper.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.wang.sss.fw.mapper.BusinessTripMapper"> <resultMap id="BaseResultMap" type="com.wang.sss.fw.pojo.BusinessTrip"> <result column="REQUEST_ID" jdbcType="VARCHAR" property="requestId" /> <result column="JOB_NUMBER" jdbcType="VARCHAR" property="jobNumber" /> <result column="REQUEST_DATE" jdbcType="VARCHAR" property="requestDate" /> <result column="DEPARTMENT" jdbcType="VARCHAR" property="department" /> <result column="BUSINESS_DAYS" jdbcType="VARCHAR" property="businessDays"/> <result column="CFD" jdbcType="VARCHAR" property="cfd" /> <result column="MDD" jdbcType="VARCHAR" property="mdd" /> <result column="START_TIME" jdbcType="VARCHAR" property="startTime" /> <result column="END_TIME" jdbcType="VARCHAR" property="endTime" /> <result column="REASON" jdbcType="VARCHAR" property="reason" typeHandler="com.wang.common.mybatis.handler.CustomStringTypeHandler"/> <result column="REMARK" jdbcType="VARCHAR" property="remark" typeHandler="com.wang.common.mybatis.handler.CustomStringTypeHandler"/> </resultMap> </mapper>
沒有加typeHandler屬性,處理之前的查詢結(jié)果:
BusinessTrip(requestId=11925, jobNumber=5721, requestDate=2019-05-06, department=57, businessDays=21, cfd=上海, mdd=南京, startTime=2019-05-06 13:36, endTime=2019-05-07 13:36, reason=null, remark=null)
增加typeHandler屬性,處理后的結(jié)果:(reason和remark字段都變成了空串)
BusinessTrip(requestId=11925, jobNumber=5721, requestDate=2019-05-06, department=57, businessDays=21, cfd=上海, mdd=南京, startTime=2019-05-06 13:36, endTime=2019-05-07 13:36, reason=, remark=)
關(guān)于mybatis plus中空字符串無(wú)法保存到數(shù)據(jù)庫(kù)如何解決問(wèn)題的解答就分享到這里了,希望以上內(nèi)容可以對(duì)大家有一定的幫助,如果你還有很多疑惑沒有解開,可以關(guān)注億速云行業(yè)資訊頻道了解更多相關(guān)知識(shí)。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。