MyBatis vs postgreSQL 암호화 성능 분석 - rdevnoah/final_shoppingmall GitHub Wiki

// org.apache.ibatis.type.TypeHandler 인터페이스를 구현하는 추상화 클래스 AbstractCipherTypeHandler 구현
package com.cafe24.mybatistest.handler;

import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.TypeHandler;


public abstract class AbstractCipherTypeHandler implements TypeHandler<String> {
	
  //test할 key
	private static final String key = "abcdefghijklmnop";
	
	
	public void setParameter(PreparedStatement ps, int i, String parameter, JdbcType jdbcType) throws SQLException {
		// 암호화 여부 확인
		// 암호화 해야되면 받은 파라메터 인코딩
		if (isCipher()) {
			parameter = encode(parameter);
		}

		ps.setString(i, parameter);
	}

	
	public String getResult(ResultSet rs, String columnName) throws SQLException {
		String value = rs.getString(columnName);

		// 암호화 여부 확인
		// 암호화 되는 컬럼이라면 반환값 디코딩
		if (isCipher()) {
			value = decode(value);
		}

		return value;
	}

	public String getResult(ResultSet rs, int columnIndex) throws SQLException {
		String value = rs.getString(columnIndex);

		// 암호화 여부 확인
		// 암호화 되는 컬럼이라면 반환값 디코딩
		if (isCipher()) {
			value = decode(value);
		}

		return value;
	}

	public String getResult(CallableStatement cs, int columnIndex) throws SQLException {
		String value = cs.getString(columnIndex);

		// 암호화 여부 확인
		// 암호화 되는 컬럼이라면 반환값 디코딩
		if (isCipher()) {
			value = decode(value);
		}

		return value;
	}

	protected abstract boolean isCipher();

	protected String encode(String value) {
		try {
			value = AES128.encrypt(value, key);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return value;
	}

	private String decode(String value) {
		try {
			value = AES128.decrypt(value, key);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return value;
	}

}

// NameCipherTypeHandler
package com.cafe24.mybatistest.handler;

public class NameCipherTypeHandler extends AbstractCipherTypeHandler {
	@Override
	protected final boolean isCipher() {
		return true;
	}

}

// IdCipherTypeHandler
package com.cafe24.mybatistest.handler;

public class IdCipherTypeHandler extends AbstractCipherTypeHandler {
	@Override
	protected final boolean isCipher() {
		return true;
	}

}

package mybatistest;

import java.util.ArrayList;
import java.util.List;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import com.cafe24.mybatistest.vo.MokDao;
import com.cafe24.mybatistest.vo.MokVo;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = { "classpath:applicationContext.xml" }) // root wac에 저장된 bean들 사용
public class MybatisTest {

	@Autowired
	private MokDao mokDao;

	@Test
	public void test01() {

		List<MokVo> list = new ArrayList<MokVo>();

		for (int i = 0; i < 1000001; i++) {
			list.add(new MokVo(null, "abcdefghijkl", "김영호"));
		}

		Long startP = System.currentTimeMillis();

		for (int i = 0; i < 1000001; i++) {
			mokDao.insertP(list.get(i));
		}

		Long endP = System.currentTimeMillis();

		Long startM = System.currentTimeMillis();
		for (int i = 0; i < 1000001; i++) {
			mokDao.insertM(list.get(i));
		}
		Long endM = System.currentTimeMillis();

		System.out.println("ENCRYPT TEST : PostgreSQL 모듈 : " + (endP - startP) / 1000.0);
		System.out.println("ENCRYPT TEST : Mybatis Handler : " + (endM - startM) / 1000.0);

		startP = System.currentTimeMillis();
		List<MokVo> list2 = mokDao.selectP("abcdefghijklmnop");
		endP = System.currentTimeMillis();

		startM = System.currentTimeMillis();
		List<MokVo> list3 = mokDao.selectM();
		endM = System.currentTimeMillis();

		System.out.println("DECRYPT TEST : PostgreSQL 모듈 : " + (endP - startP) / 1000.0);
		System.out.println("DECRYPT TEST : Mybatis Handler : " + (endM - startM) / 1000.0);
	}
}

ENCRYPT TEST : PostgreSQL 모듈 : 769.313
ENCRYPT TEST : Mybatis Handler : 792.37
DECRYPT TEST : PostgreSQL 모듈 : 8.665
DECRYPT TEST : Mybatis Handler : 11.359