import java.io.*;
import java.sql.*;
import java.util.*;

public class DbSamp3
{
	public static void main(String[] args)
	{
		try{
			System.out.println("日本語テスト: 日本語一覧取り出しテスト開始");

			DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
			Connection conn=DriverManager.getConnection("jdbc:odbc:test1",
				"user1","user1");

			Calendar calStart=Calendar.getInstance();

			System.out.println("日本語テスト: SELECT開始");

			PreparedStatement stmt=conn.prepareStatement("SELECT * FROM chartest ORDER BY char_id");

			String strSeparator=System.getProperty("file.separator");
			BufferedWriter writer=new BufferedWriter(new OutputStreamWriter(new FileOutputStream("DbSamp3.out"),"MS932"));

			ResultSet rs=stmt.executeQuery();

			for(;rs.next();)
			{
				String char_id=rs.getString(1);
				String char_data=rs.getString(2);

				System.out.println(char_id+": "+char_data);
				writer.write(char_id+": "+char_data);
				writer.newLine();
			}

			writer.flush();
			writer.close();
			rs.close();
			stmt.close();

			System.out.println("日本語テスト: SELECT終了");

			Calendar calEnd=Calendar.getInstance();
			System.out.println("所要ミリ秒:"+(calEnd.getTime().getTime()-calStart.getTime().getTime()));

			conn.close();

			System.out.println("日本語テスト: 日本語一覧取り出しテスト終了");
		}catch(SQLException ex){
			System.out.println("日本語テスト: 日本語一覧取り出しテスト失敗");
			System.out.println(ex.toString());
		}catch(IOException ex){
			System.out.println("日本語テスト: 日本語一覧取り出しテスト失敗");
			System.out.println(ex.toString());
		}
	}
}