ZC:主要是测试解决 时间转成JSON不一样的问题
ZC:java中转换时间格式的关键是“JSONUtils.getMorpherRegistry().registerMorpher(new DateMorpher(new String[]{ strDatetimeFormat }));”
ZC:C#中转换时间格式的关键是“IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss.fff";”
1、java
导入 第三方:
1.1、TestJson.java
package shh.Main; import java.io.FileOutputStream; import java.io.IOException; import java.io.ObjectOutputStream; import java.sql.Timestamp; import java.text.SimpleDateFormat; import java.util.Date; import net.sf.ezmorph.object.DateMorpher; import net.sf.json.JSONArray; import net.sf.json.JSONObject; import net.sf.json.JsonConfig; import net.sf.json.util.JSONUtils; import shh.GlobalParam.GlobalParam; import shh.entity.communicate.JsonDateValueProcessor; import shh.entity.db.RealTimeCoalFlowWidth; // java中json的使用和解析 - Java_Panda - 博客园.html “https://www.cnblogs.com/LearnAndGet/p/10009646.html” // JSON数据转换之net.sf.json包的使用 - 娜娜娜娜小姐姐 - 博客园.html “https://www.cnblogs.com/nananana/p/9263708.html” public class TestJson { public static void main(String[] args) throws Exception { String strDatetimeFormat = "yyyy-MM-dd HH:mm:ss.SSS"; // ZC: 用于 java object --> json JsonConfig jsonConfig = new JsonConfig(); jsonConfig.registerJsonValueProcessor(Date.class, new JsonDateValueProcessor(strDatetimeFormat));
// ZC: 测试下来 下面你的这个是关键!! 上面的 jsonConfig 用不用都无所谓... // ZC: 用于 json --> java object JSONUtils.getMorpherRegistry().registerMorpher(new DateMorpher(new String[]{ strDatetimeFormat })); // *** System.out.println(""); long l01 = System.currentTimeMillis(); java.util.Date pp = new Timestamp(l01); System.out.println("pp : " + pp); SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS"); RealTimeCoalFlowWidth cfw = new RealTimeCoalFlowWidth(); cfw.setCameraID(1); cfw.setCoalFlowDateTime(new Timestamp(l01)); cfw.setCoalFlowWidth((short)3); cfw.setCoalFlowSectionArea((short)4); cfw.setCoalFlowVelocity((short)5); RealTimeCoalFlowWidth cfw1 = new RealTimeCoalFlowWidth(); cfw1.setCameraID(2); cfw1.setCoalFlowDateTime(new Timestamp(l01-100)); cfw1.setCoalFlowWidth((short)30); cfw1.setCoalFlowSectionArea((short)40); cfw1.setCoalFlowVelocity((short)50); RealTimeCoalFlowWidth[] cfws = {cfw, cfw1}; JSONArray jarr = JSONArray.fromObject(cfws, jsonConfig); System.out.println(jarr); // *** JSONArray jarr1 = JSONArray.fromObject(jarr.toString()); RealTimeCoalFlowWidth[] ttt = (RealTimeCoalFlowWidth[])JSONArray.toArray(jarr1, RealTimeCoalFlowWidth.class); System.out.println("ttt.length :" + ttt.length); for (int i=0; i<ttt.length; i++) { RealTimeCoalFlowWidth t = ttt[i]; System.out.println("["+i+"] :" + t.getCameraID()+", "+sdf.format(t.getCoalFlowDateTime())+", " +t.getCoalFlowWidth()+", "+t.getCoalFlowSectionArea()+", "+t.getCoalFlowVelocity()); // System.out.println("["+i+"] :" + t.getCameraID()+", "+(t.getCoalFlowDateTime())+", " // +t.getCoalFlowWidth()+", "+t.getCoalFlowSectionArea()+", "+t.getCoalFlowVelocity()); } //Json_CoalFlowWidth(); } // 分析结果数据(DB:煤流宽度表) public static void Json_CoalFlowWidth() throws IOException { System.out.println(""); long l01 = System.currentTimeMillis(); java.util.Date pp = new Timestamp(l01); System.out.println("pp : " + pp); SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS"); System.out.println("sdf.format(pp) : " + sdf.format(pp)); System.out.println("sdf.format(pp) : " + sdf.format(new Timestamp(l01-100))); RealTimeCoalFlowWidth cfw = new RealTimeCoalFlowWidth(); cfw.setCameraID(1); cfw.setCoalFlowDateTime(new Timestamp(l01)); cfw.setCoalFlowWidth((short)3); cfw.setCoalFlowSectionArea((short)4); cfw.setCoalFlowVelocity((short)5); RealTimeCoalFlowWidth cfw1 = new RealTimeCoalFlowWidth(); cfw1.setCameraID(2); cfw1.setCoalFlowDateTime(new Timestamp(l01-100)); cfw1.setCoalFlowWidth((short)30); cfw1.setCoalFlowSectionArea((short)40); cfw1.setCoalFlowVelocity((short)50); GlobalParam.JsonConfig1.setRootClass(RealTimeCoalFlowWidth.class); RealTimeCoalFlowWidth[] cfws = {cfw, cfw1}; JSONArray jarr = JSONArray.fromObject(cfws, GlobalParam.JsonConfig1); System.out.println(jarr); RealTimeCoalFlowWidth[] ttt = (RealTimeCoalFlowWidth[])JSONArray.toArray(jarr, RealTimeCoalFlowWidth.class); System.out.println("ttt.length :" + ttt.length); for (int i=0; i<ttt.length; i++) { RealTimeCoalFlowWidth t = ttt[i]; System.out.println("["+i+"] :" + t.getCameraID()+", "+sdf.format(t.getCoalFlowDateTime())+", " +t.getCoalFlowWidth()+", "+t.getCoalFlowSectionArea()+", "+t.getCoalFlowVelocity()); //System.out.println(t.getCoalFlowDateTime()); } } }
1.2、RealTimeCoalFlowWidth.java
package shh.entity.db; import java.io.Serializable; // sqlserver数据库类型对应Java中的数据类型 - _萨瓦迪卡 - 博客园.html(https://www.cnblogs.com/cunkouzh/p/5504052.html) // ZC: Timestamp没有默认构造函数,无法反射... import java.util.Date; public class RealTimeCoalFlowWidth { int CameraID; //Timestamp CoalFlowDateTime; Date CoalFlowDateTime; short CoalFlowWidth; short CoalFlowSectionArea; short CoalFlowVelocity; public int getCameraID() { return CameraID; } public void setCameraID(int cameraID) { CameraID = cameraID; } // public Timestamp getCoalFlowDateTime() { // return CoalFlowDateTime; // } // public void setCoalFlowDateTime(Timestamp coalFlowDateTime) { // CoalFlowDateTime = coalFlowDateTime; // } public Date getCoalFlowDateTime() { return CoalFlowDateTime; } public void setCoalFlowDateTime(Date coalFlowDateTime) { CoalFlowDateTime = coalFlowDateTime; } public short getCoalFlowWidth() { return CoalFlowWidth; } public void setCoalFlowWidth(short coalFlowWidth) { CoalFlowWidth = coalFlowWidth; } public short getCoalFlowSectionArea() { return CoalFlowSectionArea; } public void setCoalFlowSectionArea(short coalFlowSectionArea) { CoalFlowSectionArea = coalFlowSectionArea; } public short getCoalFlowVelocity() { return CoalFlowVelocity; } public void setCoalFlowVelocity(short coalFlowVelocity) { CoalFlowVelocity = coalFlowVelocity; } }
1.3、JsonDateValueProcessor.java
package shh.entity.communicate; import java.text.SimpleDateFormat; import java.util.Date; import java.util.Locale; import net.sf.ezmorph.object.DateMorpher; import net.sf.json.JsonConfig; import net.sf.json.processors.JsonValueProcessor; import net.sf.json.util.JSONUtils; // net.sf.json 时间格式的转化 - LinVan - 博客园.html(https://www.cnblogs.com/linvan/p/5979820.html) public class JsonDateValueProcessor implements JsonValueProcessor { private String format = "";//"yyyy-MM-dd HH:mm:ss"; public JsonDateValueProcessor() { super(); } public JsonDateValueProcessor(String format) { super(); this.format = format; } @Override public Object processArrayValue(Object paramObject, JsonConfig paramJsonConfig) { // System.out.println("<-- <-- <-- <-- <-- <-- <-- <-- <-- "); return process(paramObject); } @Override public Object processObjectValue(String paramString, Object paramObject, JsonConfig paramJsonConfig) { // System.out.println("--> --> --> --> --> --> --> --> --> "+paramString); return process(paramObject); } private Object process(Object value) { if (value instanceof Date) { // System.out.println("<== <== <== <== <== <== <== <== <== <== <== <== <== <== <== <== <== <== "); //SimpleDateFormat sdf = new SimpleDateFormat(format, Locale.CHINA); SimpleDateFormat sdf = new SimpleDateFormat(format); return sdf.format(value); } return value == null ? "" : value.toString(); } public static JsonConfig JsonConfig_Z() { JSONUtils.getMorpherRegistry().registerMorpher(new DateMorpher(new String[] {"yyyy-MM-dd HH:mm:ss.SSS"})); JsonConfig jsonConfig = new JsonConfig(); jsonConfig.registerJsonValueProcessor(Date.class, new JsonDateValueProcessor("yyyy-MM-dd HH:mm:ss.SSS")); return jsonConfig; } }
2、C#
引入:
2.1、
private void Click_JsonTest(object sender, RoutedEventArgs e) { IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss.fff"; // *** DateTime dt = DateTime.Now; RealTimeCoalFlowWidth cfw = new RealTimeCoalFlowWidth(); cfw.CameraID = 1; //Timestamp CoalFlowDateTime; cfw.CoalFlowDateTime = dt; cfw.CoalFlowWidth1 = 3; cfw.CoalFlowSectionArea = 4; cfw.CoalFlowVelocity = 5; dt.AddDays(-1); RealTimeCoalFlowWidth cfw1 = new RealTimeCoalFlowWidth(); cfw1.CameraID = 10; //Timestamp CoalFlowDateTime; cfw1.CoalFlowDateTime = dt.AddSeconds(-3); cfw1.CoalFlowWidth1 = 30; cfw1.CoalFlowSectionArea = 40; cfw1.CoalFlowVelocity = 50; RealTimeCoalFlowWidth[] cfws = { cfw, cfw1 }; string str = JsonConvert.SerializeObject(cfws, timeConverter); Console.WriteLine(str); RealTimeCoalFlowWidth[] cfws1 = JsonConvert.DeserializeObject<RealTimeCoalFlowWidth[]>(str, timeConverter); Console.WriteLine("cfws1 : "); Console.WriteLine(" " + cfws1[0].CameraID); Console.WriteLine(" " + cfws1[0].CoalFlowDateTime.ToString("yyyy-MM-dd HH:mm:ss.fff")); Console.WriteLine(" " + cfws1[0].CoalFlowWidth1); Console.WriteLine(" " + cfws1[0].CoalFlowSectionArea); Console.WriteLine(" " + cfws1[0].CoalFlowVelocity); Console.WriteLine(); Console.WriteLine(" " + cfws1[1].CameraID); Console.WriteLine(" " + cfws1[1].CoalFlowDateTime.ToString("yyyy-MM-dd HH:mm:ss.fff")); Console.WriteLine(" " + cfws1[1].CoalFlowWidth1); Console.WriteLine(" " + cfws1[1].CoalFlowSectionArea); Console.WriteLine(" " + cfws1[1].CoalFlowVelocity); // *** //DateTime dt = DateTime.Now; //string str = JsonConvert.SerializeObject(dt, GlobalParam.IsoDateTimeConverter1); //Console.WriteLine(str); ////string s = @"2019-12-17T12:45:07.8048002+08:00"; //string s = ""2019-12-17 12:45:07.888""; //DateTime dt1 = JsonConvert.DeserializeObject<DateTime>(s, GlobalParam.IsoDateTimeConverter1); ////DateTime dt1 = JsonConvert.DeserializeObject<DateTime>(str, timeConverter); //Console.WriteLine(dt1.ToString("yyyy-MM-dd HH:mm:ss.fff")); }
2.2、
public class RealTimeCoalFlowWidth { public int CameraID; //Timestamp CoalFlowDateTime; public DateTime CoalFlowDateTime; public short CoalFlowWidth1; public short CoalFlowSectionArea; public short CoalFlowVelocity; }
2.3、经测试,C#中 list转json 和 数组转json 生成的结果是一样的:
RealTimeCoalFlowWidth[] cfws = { cfw, cfw1 };
// 下面是 数组转json的结果 // [{"CameraID":1,"CoalFlowDateTime":"2019-12-24 08:31:50.879","CoalFlowWidth1":3,"CoalFlowSectionArea":4,"CoalFlowVelocity":5},{"CameraID":10,"CoalFlowDateTime":"2019-12-24 08:31:47.879","CoalFlowWidth1":30,"CoalFlowSectionArea":40,"CoalFlowVelocity":50}] //List<RealTimeCoalFlowWidth> cfws = new List<RealTimeCoalFlowWidth>(); //cfws.Add(cfw); //cfws.Add(cfw1);
// 下面是 List转json的结果 // [{"CameraID":1,"CoalFlowDateTime":"2019-12-24 08:31:23.328","CoalFlowWidth1":3,"CoalFlowSectionArea":4,"CoalFlowVelocity":5},{"CameraID":10,"CoalFlowDateTime":"2019-12-24 08:31:20.328","CoalFlowWidth1":30,"CoalFlowSectionArea":40,"CoalFlowVelocity":50}] string str = JsonConvert.SerializeObject(cfws, timeConverter); Console.WriteLine(str);
2.4、测试:
string str = "{ "CameraID":"1","CoalFlowDateTime":"2019-12-24 08:31:50.879","CoalFlowWidth1":"3","CoalFlowSectionArea":4,"CoalFlowVelocity":5}"; RealTimeCoalFlowWidth cfw = JsonConvert.DeserializeObject<RealTimeCoalFlowWidth>(str, timeConverter); Console.WriteLine(" " + cfw.CameraID); Console.WriteLine(" " + cfw.CoalFlowDateTime.ToString("yyyy-MM-dd HH:mm:ss.fff")); Console.WriteLine(" " + cfw.CoalFlowWidth1); Console.WriteLine(" " + cfw.CoalFlowSectionArea); Console.WriteLine(" " + cfw.CoalFlowVelocity);
输出:(这里测试,C#里面的 int型、short型 可以从 json的string型里面正确的转换得到,于是 java的服务端代码,可以无脑的将SQL查到的数据都转成string了 [未测试 时间上的转换能否OK...])
1 2019-12-24 08:31:50.879 3 4 5
2.5、测试发现,Newtonsoft.Json 在执行 序列化操作时,无法指定是 序列化 子类还是基类。要想 只序列化 一个对象实例的基类部分属性的话,貌似 我没找到如何做...(反序列化 貌似倒是 可以指定使用具体哪种类型进行反序列化操作的...)
PS:我发现,需要 序列化的对象,如果 属性中 有代理(delegate)的话,序列化 操作会报错 ! ! !
现在想到一个 折中的方式:通过反射 创建基类实例X,然后 将子类中相关的属性赋值给 实例X,然后对 实例X 进行序列化,最后释放 实例X。
测试代码:
(1)、子类+基类:
class Base { public int Base1 { get; set; } public int Base2 { get; set; } public virtual string SerializeSHH(Type baseType) { Type childType = this.GetType(); object baseObj = Activator.CreateInstance(baseType); PropertyInfo[] basePI = baseType.GetProperties(); for (int i = 0; i < basePI.Length; i++) { PropertyInfo childPI = childType.GetProperty(basePI[i].Name); if (childPI != null) basePI[i].SetValue(baseObj, childPI.GetValue(this)); } string rst = JsonConvert.SerializeObject(baseObj); baseObj = null; return rst; //return null; } } class Child1 : Base { public int C1 { get; set; } }
(2)、序列化代码
Child1 c1 = new Child1(); Console.WriteLine(((Base)c1).SerializeSHH(typeof(Base))); Console.WriteLine(((Base)c1).SerializeSHH(typeof(Child1)));
(3)、控制台输出
{"Base1":0,"Base2":0} {"Base1":0,"Base2":0,"C1":0}
3、
4、
5、