The perfect solution for JSON date format transfer between Java and C #

Transferred from: http://blog.csdn.net/wilsonke/article/details/24362851

The role of a simple and convenient data transmission scheme, JSON has become an alternative to XML fact standard. However, in JSON, the time (datetime,timestamp,date, etc.) format has not been well-integrated, and when cross-platform serialization/deserialization is required, there is a lot of trouble. The author has repeatedly tried to solve the difficulty of C # and Java time transmission through JSON.

C # parsing Java/javascript generated JSON is not difficult, but Java parsing C # generated JSON is difficult. The following focuses on this issue.

1. Basic situation

Java side:
Java-side commonly used Json-lib library does not support the timestamp type of deserialization (some say you can change the data type Ah, sorry, many of the historical code is not to change it can be changed). and Jackson and Gson can support deserialization in the form of milliseconds. It should be said that the serialization behavior of Java is relatively simple and commonsense.

C # side:
By default, C # time will be formatted as "/date (1294499956278+0800)/" in this form. Obviously, this form is difficult to deal with.

Fortunately, the JsonConvert third-party library provides two additional formats:

A. Isodatetimeconverter

C # code

1. Isodatetimeconverter convert = new Isodatetimeconverter ();
2. string ret = Jsonconvert.serializeobject (bean, formatting.none, convert);

[C #]View Plaincopy

1. Isodatetimeconverter convert = new Isodatetimeconverter ();
2. string ret = Jsonconvert.serializeobject (bean, formatting.none, convert);

The result of formatting using this method is
"2013-05-31t15:14:13.1294788+08:00"

B. Javascriptdatetimeconverter

C # code

1. Javascriptdatetimeconverter convert = new Javascriptdatetimeconverter ();
2. string ret = Jsonconvert.serializeobject (bean, formatting.none, convert);

[C #]View Plaincopy

1. Javascriptdatetimeconverter convert = new Javascriptdatetimeconverter ();
2. string ret = Jsonconvert.serializeobject (bean, formatting.none, convert);

The result of formatting using this method is
New Date (1369984667554)

However, even so, there is no one of the three formats of C # that is the same as Java and still cannot be properly docked.

2. Solutions

After repeated testing, the final decision is to use "Yyyy-mm-dd HH:mm:ss" on both ends. SSS "format for transmission, which is the only scenario that has been successfully tested so far.

Java side:

Java code

2. Jsongenerator jsongenerator = null;
4. Objectmapper objectmapper = null;
8. Objectmapper = new Objectmapper ();
10. SimpleDateFormat formatter = new SimpleDateFormat ("Yyyy-mm-dd HH:mm:ss.   SSS ");
12. Objectmapper.getdeserializationconfig (). Setdateformat (formatter);
16. try {
18. Jsongenerator = Objectmapper.getjsonfactory (). Createjsongenerator (System.out, Jsonencoding.utf8);
20. } catch (IOException e) {
22. E.printstacktrace ();
24. }
26. String json = "{\" name\ ": \" Yk\ ", \" value\ ": 3,\" tm\ ": \" 2013-05-31 02:53:20.123\ "}";
28. try {
30. Mybean B = Objectmapper.readvalue (JSON, Mybean.   Class);
32. System.out.println (B.gettm ());
34. } catch (Exception e) {
36. E.printstacktrace ();
38. }

[Java]View Plaincopy

2. Jsongenerator jsongenerator = null;
4. Objectmapper objectmapper = null;
8. Objectmapper = new Objectmapper ();
10. SimpleDateFormat formatter = new SimpleDateFormat ("Yyyy-mm-dd HH:mm:ss.   SSS ");
12. Objectmapper.getdeserializationconfig (). Setdateformat (formatter);
16. try {
18. Jsongenerator = Objectmapper.getjsonfactory (). Createjsongenerator (System.out, Jsonencoding.utf8);
20. } catch (IOException e) {
22. E.printstacktrace ();
24. }
26. String json = "{\" name\ ": \" Yk\ ", \" value\ ": 3,\" tm\ ": \" 2013-05-31 02:53:20.123\ "}";
28. try {
30. Mybean B = Objectmapper.readvalue (JSON, Mybean.   Class);
32. System.out.println (B.gettm ());
34. } catch (Exception e) {
36. E.printstacktrace ();
38. }

C # code

1. Isodatetimeconverter convert = new Isodatetimeconverter ();
2. Convert.  DateTimeFormat = "Yyyy-mm-dd HH:mm:ss.fff";
3. string ret = Jsonconvert.serializeobject (bean, formatting.none, convert);

[C #]View Plaincopy

1. Isodatetimeconverter convert = new Isodatetimeconverter ();
2. Convert.  DateTimeFormat = "Yyyy-mm-dd HH:mm:ss.fff";
3. string ret = Jsonconvert.serializeobject (bean, formatting.none, convert);

The Mybean type definition is used in this article:
Java code

2. Import Java.sql.Timestamp;
6. Public class Mybean {
10. private String name;
12. private String value;
14. Private Timestamp TM;
16. Public String GetName () {
18. return name;
20. }
22. public void SetName (String name) {
24. this.name = name;
26. }
28. Public String GetValue () {
30. return value;
32. }
34. public void SetValue (String value) {
36. this.value = value;
38. }
40. Public Timestamp Gettm () {
42. return TM;
44. }
46. public void Settm (Timestamp tm) {
48. This.tm = TM;
50. }
54. }

[Java]View Plaincopy

2. Import Java.sql.Timestamp;
6. Public class Mybean {
10. private String name;
12. private String value;
14. Private Timestamp TM;
16. Public String GetName () {
18. return name;
20. }
22. public void SetName (String name) {
24. this.name = name;
26. }
28. Public String GetValue () {
30. return value;
32. }
34. public void SetValue (String value) {
36. this.value = value;
38. }
40. Public Timestamp Gettm () {
42. return TM;
44. }
46. public void Settm (Timestamp tm) {
48. This.tm = TM;
50. }
54. }

Postscript:

I'm using older. NET 2.0, and the JSON conversion for C # is native-supported in a high-level version, and there's a better solution in the framework of 4.0/4.5, and we look forward to feedback.

In addition, C # when passing data to Java, its generated JSON often contains extra fields, the server-side parsing may error, the workaround is as follows:

The perfect solution for JSON date format transfer between Java and C #