GINPRO / SQLの窓と銀プログラマ

		Button btnDatabase = new Button(container, SWT.NONE);
		btnDatabase.addSelectionListener(new SelectionAdapter() {

			@Override
			public void widgetSelected(SelectionEvent ex) {

				boolean ret = true;

				Connection con = null;
				Statement stmt = null;
				ResultSet rset = null;

				String DriverName = "sun.jdbc.odbc.JdbcOdbcDriver";
				String connectionString =
						"Provider=MSDASQL" +
						";Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}" +
						";Dbq=C:\\user\\MDB\\syain.xlsx" +
						";Readonly=;";
				String Query = "";
				
				// 日本語設定用プロパティ
				Properties prop = new Properties();
				prop.put("charSet", "MS932");
				System.out.println(connectionString);

				// 接続
				try {
					Class.forName( DriverName );
					con = DriverManager.getConnection(
							"jdbc:odbc:" + connectionString,prop
					);

					stmt = con.createStatement();
				}
				catch( Exception e  ) {
					System.out.println(e.getMessage());
					ret = false;
				}
				// 接続失敗
				if ( !ret ) {
					return;
				}

				System.out.println("接続成功");
				// SQL 作成
				Query = "update 社員マスタ set 氏名 = 'java 更新' where 社員コード = '0001'";
				try {
					stmt.executeUpdate( Query );
				}
				catch( SQLException e ) {
					System.out.println(e.getMessage());
					ret = false;
				}
				// 実行失敗
				if ( !ret ) {
					return;
				}

				// SQL 作成
				Query = "select * from 社員マスタ where 社員コード = '0001'";
				try {
					rset = stmt.executeQuery ( Query );
					ret = rset.next();
				}
				catch( SQLException e ) {
					System.out.println(e.getMessage());
					ret = false;
				}

				// データが存在しないので処理終了
				if ( !ret ) {
					return;
				}

				System.out.println("SQL実行成功");

				try {
					System.out.println( rset.getString( "氏名" ) );
				}
				catch( SQLException e ) {
					System.out.println(e.getMessage());
				}

				System.out.println("列データ取得成功");

				try {
					stmt.close();
					con.close();
				}
				catch( SQLException e ) {
					System.out.println(e.getMessage());
				}

			}
		});

		Button btnDatabase = new Button(container, SWT.NONE);
		btnDatabase.addSelectionListener(new SelectionAdapter() {

			@Override
			public void widgetSelected(SelectionEvent ex) {

				boolean ret = true;

				Connection con = null;
				Statement stmt = null;
				ResultSet rset = null;

				String DriverName = "sun.jdbc.odbc.JdbcOdbcDriver";
				String connectionString =
						"Provider=MSDASQL" +
						";Driver={Microsoft Access Driver (*.mdb, *.accdb)}" +
						";Dbq=C:\\user\\MDB\\社員マスタ.accdb" + ";";

				// 日本語設定用プロパティ
				Properties prop = new Properties();
				prop.put("charSet", "MS932");
				System.out.println(connectionString);

				// 接続
				try {
					Class.forName( DriverName );
					con = DriverManager.getConnection(
							"jdbc:odbc:" + connectionString,prop
					);

					stmt = con.createStatement();
				}
				catch( Exception e  ) {
					System.out.println(e.getMessage());
					ret = false;
				}
				// 接続失敗
				if ( !ret ) {
					return;
				}

				System.out.println("接続成功");

				// SQL 作成
				String Query = "select * from 社員マスタ where 社員コード = '0001'";
				try {
					rset = stmt.executeQuery ( Query );
					ret = rset.next();
				}
				catch( SQLException e ) {
					System.out.println(e.getMessage());
					ret = false;
				}

				// データが存在しないので処理終了
				if ( !ret ) {
					return;
				}

				System.out.println("SQL実行成功");

				try {
					System.out.println( rset.getString( "氏名" ) );
				}
				catch( SQLException e ) {
					System.out.println(e.getMessage());
				}

				System.out.println("列データ取得成功");

				try {
					stmt.close();
					con.close();
				}
				catch( SQLException e ) {
					System.out.println(e.getMessage());
				}

			}
		});

<?php
header( "Content-Type: application/json; Charset=utf-8" );
header( "pragma: no-cache" );
header( "Expires: Wed, 31 May 2000 14:59:58 GMT" );
header( "Cache-control: no-cache" );
header( "Access-Control-Allow-Origin: *" );

if ( $_GET['city'] == '' ) {
	$_GET['city'] = "270000";
}

$work = file_get_contents( "http://weather.livedoor.com/forecast/webservice/json/v1?city={$_GET['city']}" );
$obj = json_decode( $work );
$work = json_encode( $obj, JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT );

print $work;
?>

{
	"pinpointLocations": [
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2710000",
			"name": "大阪市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2714000",
			"name": "堺市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2720200",
			"name": "岸和田市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2720300",
			"name": "豊中市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2720400",
			"name": "池田市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2720500",
			"name": "吹田市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2720600",
			"name": "泉大津市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2720700",
			"name": "高槻市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2720800",
			"name": "貝塚市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2720900",
			"name": "守口市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2721000",
			"name": "枚方市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2721100",
			"name": "茨木市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2721200",
			"name": "八尾市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2721300",
			"name": "泉佐野市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2721400",
			"name": "富田林市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2721500",
			"name": "寝屋川市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2721600",
			"name": "河内長野市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2721700",
			"name": "松原市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2721800",
			"name": "大東市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2721900",
			"name": "和泉市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2722000",
			"name": "箕面市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2722100",
			"name": "柏原市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2722200",
			"name": "羽曳野市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2722300",
			"name": "門真市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2722400",
			"name": "摂津市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2722500",
			"name": "高石市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2722600",
			"name": "藤井寺市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2722700",
			"name": "東大阪市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2722800",
			"name": "泉南市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2722900",
			"name": "四條畷市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2723000",
			"name": "交野市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2723100",
			"name": "大阪狭山市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2723200",
			"name": "阪南市"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2730100",
			"name": "島本町"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2732100",
			"name": "豊能町"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2732200",
			"name": "能勢町"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2734100",
			"name": "忠岡町"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2736100",
			"name": "熊取町"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2736200",
			"name": "田尻町"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2736600",
			"name": "岬町"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2738100",
			"name": "太子町"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2738200",
			"name": "河南町"
		},
		{
			"link": "http:\/\/weather.livedoor.com\/area\/forecast\/2738300",
			"name": "千早赤阪村"
		}
	],
	"link": "http:\/\/weather.livedoor.com\/area\/forecast\/270000",
	"forecasts": [
		{
			"dateLabel": "今日",
			"telop": "晴れ",
			"date": "2015-05-24",
			"temperature": {
				"min": null,
				"max": null
			},
			"image": {
				"width": 50,
				"url": "http:\/\/weather.livedoor.com\/img\/icon\/1.gif",
				"title": "晴れ",
				"height": 31
			}
		},
		{
			"dateLabel": "明日",
			"telop": "晴のち曇",
			"date": "2015-05-25",
			"temperature": {
				"min": {
					"celsius": "17",
					"fahrenheit": "62.6"
				},
				"max": {
					"celsius": "30",
					"fahrenheit": "86.0"
				}
			},
			"image": {
				"width": 50,
				"url": "http:\/\/weather.livedoor.com\/img\/icon\/5.gif",
				"title": "晴のち曇",
				"height": 31
			}
		},
		{
			"dateLabel": "明後日",
			"telop": "晴時々曇",
			"date": "2015-05-26",
			"temperature": {
				"min": null,
				"max": null
			},
			"image": {
				"width": 50,
				"url": "http:\/\/weather.livedoor.com\/img\/icon\/2.gif",
				"title": "晴時々曇",
				"height": 31
			}
		}
	],
	"location": {
		"city": "大阪",
		"area": "近畿",
		"prefecture": "大阪府"
	},
	"publicTime": "2015-05-24T17:00:00+0900",
	"copyright": {
		"provider": [
			{
				"link": "http:\/\/tenki.jp\/",
				"name": "日本気象協会"
			}
		],
		"link": "http:\/\/weather.livedoor.com\/",
		"title": "(C) LINE Corporation",
		"image": {
			"width": 118,
			"link": "http:\/\/weather.livedoor.com\/",
			"url": "http:\/\/weather.livedoor.com\/img\/cmn\/livedoor.gif",
			"title": "livedoor 天気情報",
			"height": 26
		}
	},
	"title": "大阪府 大阪 の天気",
	"description": {
		"text": " 近畿地方は、東シナ海に中心を持つ高気圧に覆われて北部や中部では概ね\n晴れていますが、南部では南海上に停滞する前線の影響で雲の広がっている\nところがあります。\n\n 今夜の近畿地方は、高気圧に覆われて概ね晴れるでしょう。\n\n 明日の近畿地方は、高気圧に覆われて昼頃までは晴れますが、その後は気\n圧の谷や上空の寒気の影響で雲が広がりやすく、雨の降るところがある見込\nみです。",
		"publicTime": "2015-05-24T16:33:00+0900"
	}
}

@echo off
setlocal
set path=c:\php;%PATH%

php test.php "アップロードする\n文 字 列\nの指定"

endlocal

<?php

$url = "http://localhost/basic/log/log.php";

mb_language( "ja" );
mb_internal_encoding("UTF-8");

$data["text"] = str_replace( "\\n", "\n", $argv[1] );
$data["text"] = mb_convert_encoding( $data["text"], "UTF-8", "CP932" );
$data["send"] = "送信";
// ▼ 連想配列を URL エンコードされたクエリ文字列に変換します
$post_data = http_build_query( $data );

$curl = curl_init();

// ▼ 接続の試行を待ち続ける秒数。0 だと永遠に待ちます。
curl_setopt($curl, CURLOPT_CONNECTTIMEOUT, 30);
// ▼ TRUE を設定すると、ヘッダの内容も出力します(通常は必要無いので)。
curl_setopt($curl, CURLOPT_HEADER, false);
// ▼ 結果を直接出力しないで、引数として戻します
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
// ▼ PHP 5.1.3 以降では、CURLOPT_BINARYTRANSFER は効果ありません。
curl_setopt($curl, CURLOPT_BINARYTRANSFER, true);

curl_setopt($curl, CURLOPT_URL, $url );
// ▼ TRUE を設定すると、HTTP POST を行います。
// POST は、 application/x-www-form-urlencoded 形式で 行われます。
// これは一般的な HTML のフォームと同じ形式です。
// CURLOPT_POSTFIELDS で文字列をセットする場合は、自動的に
// application/x-www-form-urlencoded になります
curl_setopt($curl, CURLOPT_POST, true);
// 連想配列を渡すと、データを multipart/form-data でエンコードするので注意
curl_setopt($curl, CURLOPT_POSTFIELDS, $post_data );

$result = curl_exec($curl);
curl_close($curl);

?>