Ventuzの接続データ[C#スクリプトで]

9994 ワード

インタフェースJsonフォーマットデータ
        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;