package com.zzg.common.utils;
|
|
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;
|
|
//AES 是工具方法类,按加密需求设置
|
public class AESEncryptHandler extends BaseTypeHandler {
|
|
@Override
|
public void setNonNullParameter(PreparedStatement ps, int i, Object parameter, JdbcType jdbcType) throws SQLException {
|
ps.setString(i, AESUtil.encrypt((String) parameter));
|
}
|
|
@Override
|
public String getNullableResult(ResultSet rs, String columnName) throws SQLException {
|
String columnValue = rs.getString(columnName);
|
return AESUtil.decrypt(columnValue);
|
}
|
|
@Override
|
public String getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
|
String columnValue = rs.getString(columnIndex);
|
return AESUtil.decrypt(columnValue);
|
}
|
|
@Override
|
public String getNullableResult(CallableStatement cs, int columnIndex)
|
throws SQLException {
|
String columnValue = cs.getString(columnIndex);
|
return AESUtil.decrypt(columnValue);
|
}
|
}
|