//
//	mssql_create.bsh
//
//						Sep/26/2012
//
// ---------------------------------------------------------------------
source ("/var/www/data_base/common/bsh_common/text_manipulate.bsh");
source ("/var/www/data_base/common/bsh_common/sql_manipulate.bsh");
// ---------------------------------------------------------------------
Map data_prepare_proc ()
{
	Map dict_aa = new HashMap ();

	dict_aa = dict_append_proc
		(dict_aa,"t1071","前橋",19237,"2000-8-5");

	dict_aa = dict_append_proc
		(dict_aa,"t1072","高崎",52186,"2000-2-23");

	dict_aa = dict_append_proc
		(dict_aa,"t1073","桐生",29856,"2000-3-14");

	dict_aa = dict_append_proc
		(dict_aa,"t1074","沼田",35624,"2000-9-14");

	dict_aa = dict_append_proc
		(dict_aa,"t1075","伊勢崎",72138,"2000-10-12");

	dict_aa = dict_append_proc
		(dict_aa,"t1076","水上",28614,"2000-7-28");

	dict_aa = dict_append_proc
		(dict_aa,"t1077","太田",39427,"2000-6-19");

	dict_aa = dict_append_proc
		(dict_aa,"t1078","安中",61284,"2000-10-15");

	dict_aa = dict_append_proc
		(dict_aa,"t1079","みどり",74391,"2000-11-24");

	return	dict_aa;
}

// ---------------------------------------------------------------------
System.out.println ("*** 開始 ***");

Map dict_aa = data_prepare_proc ();

String url="jdbc:sqlserver://host_mssql;databaseName=city;";
String user="sa";
String passwd="scott_tiger";

Connection conn = DriverManager.getConnection (url,user,passwd);

sql_dict_to_db_proc (conn,dict_aa);

conn.close ();
System.out.println ("*** 終了 ***");
// ---------------------------------------------------------------------