// ---------------------------------------------------------------------
//	mssql/groovy/update/mssql_update.groovy
//
//					Jan/11/2013
//
// ---------------------------------------------------------------------
import groovy.sql.Sql

import sql_manipulate

// ---------------------------------------------------------------------
class mssql_update
{
// ---------------------------------------------------------------------
static void main (args)
{
	println ("*** 開始 ***");

	def id_in=args[0]
	def population_in=args[1]

	println (id_in + "\t" +  population_in)

	def driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"

	String user     = "sa"
	String password = "scott_tiger"

//	def protocol = "jdbc:sqlserver://host_mssql\\SQLEXPRESS;databaseName=city"
	def protocol = "jdbc:sqlserver://host_mssql;databaseName=city"

	def sql = Sql.newInstance (protocol,user,password,driver)

	sql_manipulate.update_proc (sql,id_in,population_in)

	sql_manipulate.display_proc (sql)

	sql.close ()

	println ("*** 終了 ***");
}
// ---------------------------------------------------------------------
}
// ---------------------------------------------------------------------