Ventuzの接続データ[C#スクリプトで]
9994 ワード
インタフェースJsonフォーマットデータ
Oracleデータベースの自己調査によるデータの取得
string uri = url;// Url , C# 。
HttpWebRequest request = (HttpWebRequest) WebRequest.Create(uri);
request.Proxy = null;
request.KeepAlive = false;
request.Method = "GET";
request.ContentType = "application/json; charset=UTF-8";
request.AutomaticDecompression = DecompressionMethods.GZip;
HttpWebResponse response = (HttpWebResponse) request.GetResponse();
Stream myResponseStream = response.GetResponseStream();
StreamReader myStreamReader = new StreamReader(myResponseStream, Encoding.UTF8);
string str = myStreamReader.ReadToEnd();//Json
Root root = JsonConvert.DeserializeObject<Root>(str);
// , 1:
L30 = root.resources.rwayOperation.westHalfHourCnt.ToString();
//
myStreamReader.Close();
myResponseStream.Close();
if (response != null)
{
response.Close();
}
if (request != null)
{
request.Abort();
}
// , 。
changed = true;
//
public class Root
{
public Resources resources { get; set; }
}
Oracleデータベースの自己調査によるデータの取得
OracleConnection con = new OracleConnection(conStr);//conStr:
con.Open();
OracleCommand cmd = con.CreateCommand();
cmd.CommandText = "select * from table_1";
OracleDataReader o1 = oCommand.ExecuteReader();
// , 。 V , 。
//
for (int i = 0; i < 21; i++)
{
while (o1.Read())
{
bigname1[i] = o1.GetString(0);
break;
}
}
o1.Close();
//
//bigname1 = o1.GetString(0);
con.Dispose();
changed = true;