오늘도 행복하다.

처음 이클립스를 사용하면서 제일 마음에 들었던 것이 Mark Occurrences 기능이었다.
어떤 변수나 메서드가 사용된 곳을 표시해 주는 아주 유용한 기능이다.

텍스트 편집기에서 코딩할 때는 Ctrl + F3, F4 를 애용했었는데.

그런데 하나 불만인 것이 연한 회색으로 표시되어서 눈에 잘 띄지가 않는다는 것이다.

오늘 마음 먹고 뒤져 봤다.
여기저기 뒤져보니 나온다. 음하하

Box나 Dashed Box보다 Highlighted가 낫다.
Squiggly Line 구불구불한 선
Vertical Bar

2011-01-10 추가

색은 다른거와 구별되는 밝은 노란색...이 좋네. Warning과 중복되어서 구별 안됨.

2021-07-05 빨간색 계열은 에러, 검은색은 에디터에서 안보임.

  초록색ㅋ

public class DatabaseExampleTest {
    @Test
    public void testReadAbc() throws SQLException {
       
        MockResultSet rs = new MockResultSet();
        rs.addRow(new Object[]{101, "John"});
       
        //MockStatement st = new MockStatement();
        //st.setResultSet(rs);
        Statement st = mock(Statement.class);
        stub(st.executeQuery("SELECT empno, empid FROM TestTable")).toReturn(rs);
       
        //MockConnection con = new MockConnection();
        //con.setStatement(st);
        Connection con = mock(Connection.class);
        stub(con.createStatement()).toReturn(st);
       
        DatabaseExample example = new DatabaseExample();
        assertEquals("1:101,John\n", example.readAbc(con, "TestTable"));
    }
}

stub(st.executeQuery("SELECT ... FROM TestTable")).toReturn(rs);
stub(st.executeQuery(anyString())).toReturn(rs);
stub(st.executeQuery(startsWith("SELECT"))).toReturn(rs);

@RunWith(MockitoJUnitRunner.class)
public class DatabaseExampleTest {

    @Mock private Connection con;
    @Mock private Statement st;
    private MockResultSet rs;
    DatabaseExample example;
   
    @Before
    public void setUp() throws Exception {
        rs = new MockResultSet();
       
        st = mock(Statement.class);
        stub(st.executeQuery(anyString())).toReturn(rs);
       
        con = mock(Connection.class);
        stub(con.createStatement()).toReturn(st);
       
        example = new DatabaseExample();
    }
   
    @Test
    public void testReadAbc() throws SQLException{       
        rs.addRow(new Object[]{101, "John"});
        assertEquals("1:101,John\n", example.readAbc(con, "TestTable"));
    }

    @Test
    public void testReadAbcWithMultiRow() throws SQLException{       
        rs.addRow(new Object[]{101, "John"});
        rs.addRow(new Object[]{102, "Jane"});
        assertEquals("1:101,John\n2:102,Jane\n", example.readAbc(con, "TestTable"));
    }
}

public class DatabaseExample {
    public String readAbc(Connection con, String tableName) throws SQLException{
        int resultNum = 1;
        Statement st = con.createStatement(); //대상(#1)
        ResultSet rs = st.executeQuery("SELECT empno, empid FROM " + tableName); //대상(#1)
        String result = "";
        
        while(rs.next()){ //대상(#2)
            int no = rs.getInt(1); //대상(#2)
            String id = rs.getString(2); //대상(#2)
            result += resultNum++ + ":" + no + "," + id + "\n";
        }
        return result;
    }
}

public class MockConnection implements Connection {
    ...
    @Override
    public Statement createStatement() throws SQLException {
        return new MockStatement();
    }
}

public class MockStatement implements Statement {
    ...
    @Override
    public ResultSet executeQuery(String sql) throws SQLException {
        return new MockResultSet();
    }
}

public class MockResultSet implements ResultSet

public class DatabaseExampleTest {
    @Test
    public void testReadAbc() throws SQLException {
        Connection con = new MockConnection();
        DatabaseExample example = new DatabaseExample();
        assertEquals("1:101,John\n", example.readAbc(con, "TestTable"));
    }
}

public class DatabaseExampleTest {
    @Test
    public void testReadAbc() throws SQLException {
        
        MockResultSet rs = new MockResultSet();
        rs.addRow(new Object[]{101, "John"});
        
        MockStatement st = new MockStatement();
        st.setResultSet(rs);
        
        MockConnection con = new MockConnection();
        con.setStatement(st);
        
        DatabaseExample example = new DatabaseExample();
        assertEquals("1:101,John\n", example.readAbc(con, "TestTable"));
    }
}

public class MockResultSet implements ResultSet {

	List<Object[]> list;
	Object[] currentRow;
	int index = -1;
	
	public MockResultSet(){
		list = new ArrayList<Object[] >();
	}
	
	public void addRow(Object[] row){
		list.add(row);
	}

	@Override
	public boolean next() throws SQLException {
		if(++index < list.size()){
			currentRow = list.get(index);
			return true;
		}else{
			return false;
		}
	}
	
	@Override
	public String getString(int columnIndex) throws SQLException {
		return currentRow[columnIndex - 1].toString();
	}
	
	@Override
	public int getInt(int columnIndex) throws SQLException{
		return ((Number)currentRow[columnIndex - 1]).intValue();
	}
	...
}