import java.net.URL;
import java.sql.*;

class Select {
  public static void main(String argv[]) {
    try {
      Class.forName("COM.imaginary.sql.msql.MsqlDriver");
      String url = "jdbc:msql://xxx.yyy.zzz:4333/mydb";
      Connection con = DriverManager.getConnection(url, "yoonforh", "");
      Statement stmt = con.createStatement();
      ResultSet rs = stmt.executeQuery("SELECT * from dict ORDER BY dict_id");

      System.out.println("Got results:");
      while(rs.next()) {
	int a= rs.getInt(1);
	String str2 = rs.getString(2);
	String str3 = rs.getString(3);
	String str4 = rs.getString(4);
	str2=convert_to_ksc(str2);
	str3=convert_to_ksc(str3);
	str4=convert_to_ksc(str4);
	

	System.out.print(" id= " + a);
	System.out.print(" init= " + str2);
	System.out.print(" origin= " + str3);
	System.out.print(" mean= " + str4);
	System.out.println("");
      }
      stmt.close();
      con.close();
    }
    catch( Exception e ) {
      System.out.println(e.getMessage());
      e.printStackTrace();
    }
  }

  private static String convert_to_ksc(String str) {
      String result=null;
      try {
      byte[] rawBytes=str.getBytes("8859_1");
      result=new String(rawBytes, "KSC5601");
      } catch (java.io.UnsupportedEncodingException e) {
      	System.err.println(e.toString());
      }
      return  result;
  }
}