package com.ruoyi.common.data.typeHandler;
import org.apache.ibatis.type.BaseTypeHandler;
import org.apache.ibatis.type.JdbcType;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Arrays;
public class StringArrayTypeHandler extends BaseTypeHandler<String[]> {
private String[] getList(String string){
if (string == null) return null;
String[] split = string.split(",");
return split;
}
@Override
public void setNonNullParameter(PreparedStatement preparedStatement, int i, String[] strings, JdbcType jdbcType) throws SQLException {
String string = Arrays.toString(strings).replaceAll(" ","");
preparedStatement.setString(i, string.substring(1,string.length() - 1));
}
@Override
public String[] getNullableResult(ResultSet resultSet, String s) throws SQLException {
return this.getList(resultSet.getString(s));
}
@Override
public String[] getNullableResult(ResultSet resultSet, int i) throws SQLException {
return this.getList(resultSet.getString(i));
}
@Override
public String[] getNullableResult(CallableStatement callableStatement, int i) throws SQLException {
return this.getList(callableStatement.getString(i));
}
}
mybatis StringArrayTypeHandler
最新推荐文章于 2023-12-26 01:01:06 发布