#! /usr/bin/jruby
# -*- encoding: utf-8 -*-
#
#	db2_read.rb
#
#					Jun/09/2011
#
#
# ---------------------------------------------------------------------
include Java
import java.sql.DriverManager
import java.lang.System
#
load '/var/www/data_base/common/jruby_common/jruby_sql_manipulate.rb'
# ---------------------------------------------------------------------
puts	"*** 開始 ***"
id_in = ARGV[0]
#
puts id_in
#
Java::JavaClass.for_name("COM.ibm.db2.jdbc.app.DB2Driver")

url = "jdbc:db2:cities"

user = "scott"
pass = "tiger"

conn = DriverManager.getConnection(url,user,pass)

sql_delete_proc(conn,id_in)
sql_read_proc(conn)

conn.close()


puts "*** 終了 ***"

# ---------------------------------------------------------------------