/**自定義typeHandler<br/> * 1 插入數(shù)據(jù)庫， 加密 * 2 查詢，解密 * @author Administrator * */ public class CryptTypeHandler implements TypeHandler<CryptType> { public CryptType getResult(ResultSet rs, String columnName) throws SQLException { String value=""; CryptType v=new CryptType(value); value=rs.getString(columnName); if(value!=null){ value=decrypt(value.toString()); v.setValue(value); } return v; } public CryptType getResult(ResultSet rs, int columnIndex) throws SQLException { String value=""; CryptType v=new CryptType(value); value =rs.getString(columnIndex); if(value!=null){ v.setValue(value); } return v; } public CryptType getResult(CallableStatement cs, int columnIndex) throws SQLException { String value=""; CryptType v=new CryptType(); value =cs.getString(columnIndex); if(value!=null){ v.setValue(value); } return v; } public void setParameter(PreparedStatement ps, int i, CryptType parameter, JdbcType arg3) throws SQLException { String value=""; if(parameter!=null && parameter.toString()!=null){ value=encrypt(parameter.toString()); } ps.setString(i, value.toString()); } /**插入數(shù)據(jù)庫 * @param value * @return */ private String encrypt(String value) { value=CryptUtils.encrypt(value); return value; } /** 從數(shù)據(jù)庫讀出 * @param value * @return */ private String decrypt(String value){ value=CryptUtils.decrypt(value); return value; } }

import java.io.Serializable; /** * 自定義類型 * 定義為該類型的實體屬性會走CryptTypeHandler.java做加解密處理 * * @author yy * */ public class MyString implements Serializable, CharSequence, Comparable<String>{ private static final long serialVersionUID = 1L; private String value; public MyString (){ } public CryptType(String value){ this.value=value; } public String getValue() { return value; } public void setValue(String value) { this.value = value; } public int compareTo(String arg0) { // TODO Auto-generated method stub return 0; } public char charAt(int arg0) { // TODO Auto-generated method stub return 0; } public int length() { // TODO Auto-generated method stub return 0; } public CharSequence subSequence(int arg0, int arg1) { // TODO Auto-generated method stub return null; } @Override public String toString() { return value; } } 

<!-- 自定義類型 --> <typeHandlers> <typeHandler javaType="com.***.MyString" handler="com.***.MyTypeHandler"/> </typeHandlers>

public class LoanEnterprise{ private MyString name; //注意： //如果頁面有查詢條件也被加密時，mybatis sql中的條件判斷會無法匹配，暫時的一種解決辦法是在 public CryptType getName() { if(name!=null && name.getValue().equals("")){ return null; }else { return name; } } public void setName(CryptType name) { this.name = name; } }