Echarts读取数据库数据并展现

前端

ashx

using Newtonsoft.Json;   //引入Newtonsoft用于转化为json格式
  public class Echarts1Data : IHttpHandler
    {
        OracleConnection Oracle_DB = new OracleConnection(WebConfigurationManager.AppSettings["key1"].ToString());
        public void ProcessRequest(HttpContext context)
        {
            ArrayList xAxisData = new ArrayList();
            ArrayList yAxisData = new ArrayList();
            System.Data.DataTable dt = new System.Data.DataTable();
            string sqltext = "select id as id,num as NUM from table1";
            Oracle_DB.Open();
            OracleDataAdapter oda = new OracleDataAdapter(sqltext,Oracle_DB);
            DataSet ds1 = new DataSet();
            oda.Fill(ds1,"product");
            DataTable dt1 = new DataTable();
            dt1=ds1.Tables["product"];
            Oracle_DB.Close();
            for (int i = 0; i < dt1.Rows.Count; i++)   //将datatable数据存入到数组中
            {
                yAxisData.Add(dt1.Rows[i].ItemArray[1]);  //NUM
                xAxisData.Add(dt1.Rows[i].ItemArray[0]);  //id
            }
            var obj = new
            {
                id= xAxisData,
                NUM= yAxisData
            };
            string strjson = JsonConvert.SerializeObject(obj);   //用Newtonsoft，将两个数据一起序列化传递给echarts
            context.Response.Write(strjson);
        }
        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }