本文目錄一覽：
C# 怎麼將json 轉換成 datatable
主要包含兩個方法：
1. 獲取的DataTable 對象 轉換為Json 字元串
2. Json 字元串 轉換為 DataTable數據集合
#region DataTable 轉換為Json字元串實例方法
/// summary
/// GetClassTypeJosn 的摘要說明
/// /summary
public class GetClassTypeJosn : IHttpHandler
{
/// summary
/// 文件名:DataTable 和Json 字元串互轉
/// 版權所有:Copyright (C) Create Family Wealth liangjw
/// 創建標示：2013-08-03
/// /summary
//用法說明實例
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = “application/json”;
context.Response.Charset = “utf-8”;
HttpRequest req = context.Request;
string method = req[“method”].ToStr().ToLower();
//獲取合同明細列表 DataTable 轉換為Json字元串
if (method == “txtdate”)
{
string json = “”;
BO.MakeContractMx bll = new MakeContractMx();
DataSet ds = bll.GetDataTable();
if (ds.Tables.Count 0)
{
json =ToJson(ds.Tables[0]);
}
context.Response.Write(json);
return;
}
}
public bool IsReusable
{
get
{
return false;
}
}
}
#endregion
#region Json字元串轉換為DataTable 實例方法
public DataTable JsonToDataTable(json)
{
DataTable dt= ToDataTable(json);
return dt;
}
#endregion
#region DataTable 轉換為Json 字元串
/// summary
/// DataTable 對象 轉換為Json 字元串
/// /summary
/// param name=”dt”/param
/// returns/returns
public static string ToJson(this DataTable dt)
{
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
javaScriptSerializer.MaxJsonLength = Int32.MaxValue; //取得最大數值
ArrayList arrayList = new ArrayList();
foreach (DataRow dataRow in dt.Rows)
{
Dictionarystring, object dictionary = new Dictionarystring, object(); //實例化一個參數集合
foreach (DataColumn dataColumn in dt.Columns)
{
dictionary.Add(dataColumn.ColumnName, dataRow[dataColumn.ColumnName].ToStr());
}
arrayList.Add(dictionary); //ArrayList集合中添加鍵值
}
return javaScriptSerializer.Serialize(arrayList); //返回一個json字元串
}
#endregion
#region Json 字元串 轉換為 DataTable數據集合
/// summary
/// Json 字元串 轉換為 DataTable數據集合
/// /summary
/// param name=”json”/param
/// returns/returns
public static DataTable ToDataTable(this string json)
{
DataTable dataTable = new DataTable(); //實例化
DataTable result;
try
{
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
javaScriptSerializer.MaxJsonLength = Int32.MaxValue; //取得最大數值
ArrayList arrayList = javaScriptSerializer.DeserializeArrayList(json);
if (arrayList.Count 0)
{
foreach (Dictionarystring, object dictionary in arrayList)
{
if (dictionary.Keys.Countstring() == 0)
{
result = dataTable;
return result;
}
if (dataTable.Columns.Count == 0)
{
foreach (string current in dictionary.Keys)
{
dataTable.Columns.Add(current, dictionary[current].GetType());
}
}
DataRow dataRow = dataTable.NewRow();
foreach (string current in dictionary.Keys)
{
dataRow[current] = dictionary[current];
}
dataTable.Rows.Add(dataRow); //循環添加行到DataTable中
}
}
}
catch
{
}
result = dataTable;
return result;
}
#endregion
#region 轉換為string字元串類型
/// summary
/// 轉換為string字元串類型
/// /summary
/// param name=”s”獲取需要轉換的值/param
/// param name=”format”需要格式化的位數/param
/// returns返回一個新的字元串/returns
public static string ToStr(this object s, string format = “”)
{
string result = “”;
try
{
if (format == “”)
{
result = s.ToString();
}
else
{
result = string.Format(“{0:” + format + “}”, s);
}
}
catch
{
}
return result;
}
#endregion
Java將Json字元串轉成對象的問題
用Gson。下載地址：
定義Java類：
class Feature {
public Attributes attributes;
public Geometry geometry;
}
class Attributes {
public String OBJECTID, ID, CD, HG, DP_AS…….;
}
class Geometry {
public Float x, y;
}
Feature feature;
public static MyObject fromJson(String json) {
return new Gson().fromJson(json, MuObject.class);
}
}
然後在需要的地方調用：
MyObject obj = MyObject.fromJson(“{……}”);
MyObject.Attributes attributes = obj.feature.attributes;
MyObject.Geometry geometry = obj.feature.geometry;
json 這個格式怎麼獲取data值
下載一個 Newtonsoft.Json.dll 插件
然後給你貼一個我做過的方法 自己改改
C# code
?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Runtime.Serialization.Json;
using System.Runtime.Serialization;
using System.IO;
using System.Web.Script.Serialization;
using System.Web;
namespace MicroBlog.Common.APIHelper
{
public class Resolve
{
/// summary
/// JSON文本轉對象,泛型方法
/// /summary
/// typeparam name=”T”類型/typeparam
/// param name=”jsonText”JSON文本/param
/// returns指定類型的對象/returns
public static T JSONToObjectT(string jsonText, HttpContext context)
{
JavaScriptSerializer jss = new JavaScriptSerializer();
try
{
return jss.DeserializeT(jsonText);
}
catch (Exception ex)
{
//
}
}
/// summary
/// 將JSON文本轉換成數據行
/// /summary
/// param name=”jsonText”JSON文本/param
/// returns數據行的字典/returns
public static Dictionarystring, object DataRowFromJSON(string jsonText, HttpContext context)
{
return JSONToObjectDictionarystring, object(jsonText, context);
}
}
}
json中包含json數組怎麼轉換成java對象
下面是JSON轉pojo的工具類，複製就可以用了。
import java.util.List;
import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.JavaType;
import com.fasterxml.jackson.databind.ObjectMapper;
/**
* 淘淘商城自定義響應結構
*/
public class JsonUtils {
// 定義jackson對象
private static final ObjectMapper MAPPER = new ObjectMapper();
/**
* 將對象轉換成json字元串。
*/
public static String objectToJson(Object data) {
try {
return MAPPER.writeValueAsString(data);
} catch (JsonProcessingException e) {
e.printStackTrace();
}
return null;
}
/**
* 將json結果集轉化為對象
*
* @param jsonData
* json數據
* @param clazz
* 對象中的object類型
* @return
*/
public static T T jsonToPojo(String jsonData, ClassT beanType) {
try {
T t = MAPPER.readValue(jsonData, beanType);
return t;
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
/**
* 將json數據轉換成pojo對象list
*/
public static T ListT jsonToList(String jsonData, ClassT beanType) {
JavaType javaType = MAPPER.getTypeFactory().constructParametricType(List.class, beanType);
try {
ListT list = MAPPER.readValue(jsonData, javaType);
return list;
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
}
原創文章，作者：小藍，如若轉載，請註明出處：https://www.506064.com/zh-tw/n/303513.html
微信掃一掃 
支付寶掃一掃 