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

public class DbSamp2
{
	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");

			{
				System.out.println("日本語テスト: テーブルの内容を一旦クリア");
				Statement stmt=conn.createStatement();
				stmt.executeUpdate("DELETE FROM chartest");
				stmt.close();
			}

			Calendar calStart=Calendar.getInstance();

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

			PreparedStatement stmt=conn.prepareStatement("INSERT INTO chartest VALUES(?,?)");

			String strSeparator=System.getProperty("file.separator");
			BufferedReader reader=new BufferedReader(new InputStreamReader(new FileInputStream(".."+strSeparator+"TestChar"+strSeparator+"TestChar.txt"),"MS932"));

			for(String strRead=reader.readLine();strRead!=null;strRead=reader.readLine())
			{
				String char_id=strRead.substring(0,4);
				String char_data=strRead.substring(6,7);
				System.out.println(char_id+":"+char_data);
				stmt.setString(1,char_id);
				stmt.setString(2,char_data);
				stmt.executeUpdate();
			}

			reader.close();
			stmt.close();

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

			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());
		}
	}
}