// ----------------------------------------------------------------------
/*
	db2_delete.java

				May/30/2011

*/
// ----------------------------------------------------------------------
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Connection;

// ----------------------------------------------------------------------
public class db2_delete
{

// ----------------------------------------------------------------------
public static void main (String[] args)
	throws SQLException, ClassNotFoundException
{
	System.out.println ("*** 開始 ***");

	String	id = args[0];
	System.out.println ("\tid = " + id);

	try
		{
		Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
		}
	catch (Exception ee)
		{
		ee.printStackTrace();
		}

	System.out.println ("*** db2_read *** aaa ***");

	Connection conn = null;

	String url = "jdbc:db2:cities";

	String user = "scott";
	String pass = "tiger";
	
	conn = DriverManager.getConnection (url,user,pass);

	System.out.println ("connected.");

	rdb_common.delete_proc	(conn,id);

	rdb_common.display_proc	(conn);

	conn.close ();

	System.out.println ("*** 終了 ***");
}

// ----------------------------------------------------------------------
}
// ----------------------------------------------------------------------