karian7

-- insert
insert into account_history (email, create_time, description) values (:email, CURRENT_TIMESTAMP, :description)

-- select
select email, create_time, description from account_history where email = :email

-- delete
delete from account_history where email = :email

karian7

package com.daumcorp.be;

import org.junit.Test;
import org.postgresql.ds.PGSimpleDataSource;

import java.util.List;

import static org.hamcrest.CoreMatchers.is;
import static org.junit.Assert.assertThat;

karian7

	/**
	 * This method ensures that the output String has only
	 * valid XML unicode characters as specified by the
	 * XML 1.0 standard. For reference, please see
	 * <a href=”http://www.w3.org/TR/2000/REC-xml-20001006#NT-Char”>the
	 * standard</a>. This method will return an empty
	 * String if the input is null or empty.
	 * 
	 * @param in The String whose non-valid characters we want to remove.
	 * @return The in String, stripped of non-valid characters.

karian7

        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>9.3-1100-jdbc41</version>
        </dependency>

karian7

package com.daumcorp.be;

/**
 * Created by karian7 on 1/20/14.
 */
public interface AccountRepository {
    Account findByEmail(String email);
    void save(Account account);
    int deleteByEmail(String email);
}

karian7

package com.daumcorp.be;

import org.junit.Before;
import org.junit.Test;

import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.HashMap;

karian7

package com.springapp.mvc;

import static org.springframework.test.web.servlet.request.MockMvcRequestBuilders.*;
import static org.springframework.test.web.servlet.result.MockMvcResultMatchers.*;
import static org.springframework.test.web.servlet.setup.MockMvcBuilders.*;

import java.util.List;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;

karian7

<div id="emptySwf"></div> ## 최신 크롬브라우저에서 iframe내에 플래시로드시 화면깜빡임 발생버그를 회피하기위해 가짜 플래시를 임베드시킨다.
<script type="text/javascript">
	//<![CDATA[
	try {
		if(daum.Browser.chrome) {
			var swfParam = {
				swfurl: 'http://cafeimg.daum-img.net/swf/',
				params: {
					wmode: 'transparent',
					base: 'http://cafeimg.daum-img.net/swf/'

karian7

import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;

public class MessageDigestHelper {
	/**
	 * input 을 SHA1 해시로 변환함.
	 */
	public String toSHA1Hash(String input) {
		MessageDigest sha1;
		try {

karian7

public abstract class AntiLogarithm62 {

	private static final long base = 62; // 62진수로 표현위해 나누는 변수 값
	
	/**
	 * 10진수를 62진수로 변환.
	 * 
	 * @param num10
	 *            long type의 10진수.
	 * @param length