package com.jini.ch4;
import java.io.*;
import junit.framework.*;
public class FileReaderTester extends TestCase {
private FileReader _input;
private FileReader _empty;
private static final String FILE_NAME = "c:/Users/jini/Desktop/data.txt";
public static void main (String[] args) {
//1. 기본적인 Test 실행 방식.
junit.textui.TestRunner.run(suite());
//2. 해당 클래스에서 test로 시작하는 모든 메소드를 테스트 하도록 함.
junit.textui.TestRunner.run(new TestSuite(FileReaderTester.class));
//3. 여러 클래스의 Test Suite를 연결하기 위한 MasterTester 클래스 방식/
junit.textui.TestRunner.run( suite2());
}
public FileReaderTester(String name) {
super(name);
}
/**
* 메소드명을 파라미터로 하는 TestSuite
* @throws IOException
*/
public static Test suite() {
TestSuite suite = new TestSuite();
suite.addTest(new FileReaderTester("testRead"));
suite.addTest(new FileReaderTester("testReadAtEnd"));
return suite;
}
public static Test suite2() {
TestSuite result = new TestSuite();
result.addTest(new TestSuite(FileReaderTester.class));
result.addTest(new TestSuite(FileReaderTester.class));
return result;
}
public void testRead() throws IOException {
char ch = '&';
for(int x = 0; x < 4; x++) {
ch = (char)_input.read();
}
assertEquals('d', ch);
}
public void testReadAtEnd() throws IOException {
int ch = -1234;
for(int x = 0; x < 141; x++) {
ch = _input.read();
}
assertEquals("read at end", -1, _input.read());
}
public void testReadBoundaries() throws IOException {
assertEquals("read first char", 'B', _input.read());
int ch;
for(int x = 0; x < 140; x++) {
ch = _input.read();
}
assertEquals("read last char", '6', _input.read());
assertEquals("read at end", -1, _input.read());
assertEquals("read past end", -1, _input.read());
}
public void testEmptyRead() throws IOException {
assertEquals(-1, _empty.read());
}
public void testReadAfterClose() throws Exception {
_input.close();
try {
_input.read();
fail("read past end에 예외가 발생하지 않음");
} catch (IOException e) {
e.printStackTrace();
}
}
protected void setUp() {
try {
_input = new FileReader(FILE_NAME);
_empty = newEmptyFile();
} catch (IOException e) {
throw new RuntimeException(e.toString());
}
}
protected void tearDown() {
try {
_input.close();
} catch (IOException e) {
throw new RuntimeException("테스트 파일을 닫는 중 에러 발생");
}
}
private FileReader newEmptyFile() throws IOException {
File empty = new File(FILE_NAME);
FileOutputStream out = new FileOutputStream(empty);
out.close();
return new FileReader(empty);
}
}
WITH T AS
(SELECT TO_DATE('201309', 'yyyymm') YM FROM DUAL)
SELECT *
FROM (
SELECT MIN(DECODE(TO_CHAR(YM + LEVEL - 1, 'D'), '1', LEVEL)) SUN
, MIN(DECODE(TO_CHAR(YM + LEVEL - 1, 'D'), '2', LEVEL)) MON
, MIN(DECODE(TO_CHAR(YM + LEVEL - 1, 'D'), '3', LEVEL)) TUE
, MIN(DECODE(TO_CHAR(YM + LEVEL - 1, 'D'), '4', LEVEL)) WED
, MIN(DECODE(TO_CHAR(YM + LEVEL - 1, 'D'), '5', LEVEL)) THU
, MIN(DECODE(TO_CHAR(YM + LEVEL - 1, 'D'), '6', LEVEL)) FRI
, MIN(DECODE(TO_CHAR(YM + LEVEL - 1, 'D'), '7', LEVEL)) SAT
FROM T
CONNECT BY
LEVEL <= LAST_DAY(YM) - YM + 1
GROUP BY
TRUNC(YM + LEVEL, 'IW')
ORDER BY
SAT
)
org.apache.commons.lang.builder.ToStringBuilder
ToStringBuilder.reflectionToString(this, ToStringStyle.SHORT_PREFIX_STYLE);
[원본자료] EMP_ID ---- A001 -> 1, 1 B001 -> 1, 2 C001 -> 1, 3 D001 -> 1, 4 E001 -> 2, 1 F001 -> 2, 2 G001 -> 2, 3 H001 -> 2, 4 I001 -> 3, 1 J001 -> 3, 2 K001 -> 3, 3 L001 -> 3, 4
SELECT NO
, CEIL(NO/4) AS ROWINDEX
, MOD(NO, 4) AS COLINDEX
, EMP_ID
FROM ( SELECT ROWNUM AS NO
, EMP_ID
FROM TEMP )
▶결과는 다음과 같다(COLINDEX값이 0인 경우를 좌표에서는 4번째 위치라고 생각)NO ROWINDEX COLINDEX EMP_ID 1 1 1 A001 2 1 2 B001 3 1 3 C001 4 1 0 D001 5 2 1 E001 [중략] 12 3 0 L001
SELECT CEIL(NO/4) AS ROWINDEX
, DECODE(MOD(NO, 4), 1, EMP_ID) AS COL1
, DECODE(MOD(NO, 4), 2, EMP_ID) AS COL2
, DECODE(MOD(NO, 4), 3, EMP_ID) AS COL3
, DECODE(MOD(NO, 4), 0, EMP_ID) AS COL4
FROM ( SELECT ROWNUM AS NO
, EMP_ID
FROM TEMP )
▶결과는 다음과 같다.ROWINDEX COL1 COL2 COL3 COL4 1 A001 1 B001 1 C001 1 D001 2 E001 2 F001 2 G001 2 H001 [중략]
SELECT CEIL(NO/4) AS ROWINDEX
, MAX(DECODE(MOD(NO, 4), 1, EMP_ID)) AS COL1
, MAX(DECODE(MOD(NO, 4), 2, EMP_ID)) AS COL2
, MAX(DECODE(MOD(NO, 4), 3, EMP_ID)) AS COL3
, MAX(DECODE(MOD(NO, 4), 0, EMP_ID)) AS COL4
FROM ( SELECT ROWNUM AS NO
, EMP_ID
FROM TEMP )
GROUP BY CEIL(NO/4)
UPDATE PROPS$ SET VALUE$ ='KO16MSWIN949' WHERE NAME = 'NLS_CHARACTERSET'; UPDATE PROPS$ SET VALUE$ = 'AMERICAN_AMERICA.KO16MSWIN949' WHERE NAME = 'NLS_LANGUAGE'; COMMIT; SHUTDOWN IMMEDIATE; STARTUP;
SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';
public class NutritionFacts {
private final int servingSize;
private final int servings;
private final int calories;
private final int fat;
private final int sodium;
public static class Builder {
private final int servingSize;
private final int servings;
private int calories = 0;
private int fat = 0;
private int sodium = 0;
public Builder(int servingSize, int servings) {
this.servingSize = servingSize;
this.servings = servings;
}
public Builder calories(int val) {
this.calories = val;
return this;
}
public Builder fat(int val) {
this.fat = val;
return this;
}
public Builder sodium(int val) {
this.sodium = val;
return this;
}
public NutritionFacts build() {
return new NutritionFacts(this);
}
}
private NutritionFacts(Builder builder) {
servingSize = builder.servingSize;
servings = builder.servings;
calories = builder.calories;
fat = builder.fat;
sodium = builder.sodium;
}
}