#! /usr/bin/java org.mozilla.javascript.tools.shell.Main // ------------------------------------------------------------------ // // mysql_create.js // // Jul/16/2011 // // ------------------------------------------------------------------ importPackage(java.lang); importPackage(java.sql); load ("/var/www/data_base/common/rhino_common/sql_manipulate.js"); load ("/var/www/data_base/common/rhino_common/text_manipulate.js"); print ("*** 開始 ***"); var id_in=arguments[0]; var population_in=arguments[1]; var url = "jdbc:mysql://host_mysql/city"; var user = "scott"; var passwd = "tiger"; var conn = DriverManager.getConnection( url, user, passwd ); drop_table_proc (conn); create_table_proc (conn); insert_data_proc (conn); conn.close(); print ("*** 終了 ***"); // ------------------------------------------------------------------ function insert_data_proc (conn) { insert_record_proc (conn,"t3321","岡山",41353,"1951-3-1"); insert_record_proc (conn,"t3322","倉敷",34241,"1951-6-14"); insert_record_proc (conn,"t3323","津山", 78592,"1951-5-27"); insert_record_proc (conn,"t3324","玉野",24687,"1951-9-29"); insert_record_proc (conn,"t3325","笠岡",12975,"1951-10-16"); insert_record_proc (conn,"t3326","井原",29734,"1951-11-24"); insert_record_proc (conn,"t3327","総社",58217,"1951-12-30"); insert_record_proc (conn,"t3328","高梁",45189,"1951-11-18"); insert_record_proc (conn,"t3329","新見",59642,"1951-9-21"); } // ------------------------------------------------------------------