Json关于java.sql.Date的处理

步骤一 、 VO类

import java.sql.Date;

 

public class User {

    //实体类的属性和表的字段名称一一对应

    private int id;

    private String name;

    private int age;

    private Date hire_date;

}

 

 

步骤二 、数据库表：

/*

Navicat MySQL Data Transfer

Source Server         : localhost

Source Server Version : 50051

Source Host           : localhost:3306

Source Database       : test

 

Target Server Type    : MYSQL

Target Server Version : 50051

File Encoding         : 65001

Date: 2016-05-17 20:46:04

*/

 

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for `user`

-- ----------------------------

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (

  `id` int(11) NOT NULL auto_increment,

  `name` varchar(30) default NULL,

  `age` int(11) default NULL,

  `hire_date` datetime default NULL,

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

 

-- ----------------------------

-- Records of user

-- ----------------------------

INSERT INTO `user` VALUES ('1', 'zhangsan', '12', '2016-05-17 20:06:38');

 

步骤三、开始转换

Exception in thread "main" net.sf.json.JSONException: java.lang.reflect.InvocationTargetException

at net.sf.json.JSONObject.defaultBeanProcessing(JSONObject.java:818)

at net.sf.json.JSONObject._fromBean(JSONObject.java:699)

at net.sf.json.JSONObject.fromObject(JSONObject.java:172)

at net.sf.json.AbstractJSON._processValue(AbstractJSON.java:274)

at net.sf.json.JSONObject._processValue(JSONObject.java:2655)

at net.sf.json.JSONObject.processValue(JSONObject.java:2721)

at net.sf.json.JSONObject.setInternal(JSONObject.java:2736)

at net.sf.json.JSONObject.setValue(JSONObject.java:1424)

at net.sf.json.JSONObject.defaultBeanProcessing(JSONObject.java:765)

at net.sf.json.JSONObject._fromBean(JSONObject.java:699)

at net.sf.json.JSONObject.fromObject(JSONObject.java:172)

at net.sf.json.JSONObject.fromObject(JSONObject.java:134)

at mybatistest.mybatisdemo.MultiDataSource.main(MultiDataSource.java:50)

 

解决方案一：datetime  -->String

   select id,name ,age,CONCAT(hire_date,'') from user

 

解决方案二：增加函数转为util.Date进行处理

      /** 

* 将java.util.Date日期转化为java.sql.Date 

* @param udate 

* @return 

*/  

public static java.sql.Date converUtilToSql(java.util.Date udate) {  

   return new java.sql.Date(udate.getTime());  

}  

 

/** 

* 将java.sql.Date日期转化为java.util.Date 

* @param udate 

* @return 

*/  

public static java.util.Date converSqlToUtil(java.sql.Date udate) {  

   return new java.util.Date(udate.getTime());  

} 

 

 

处理结果如下：

{"age":12,"hire_date":{"date":17,"day":2,"hours":0,"minutes":0,"month":4,"seconds":0,"time":1463414400000,"timez

oneOffset":-480,"year":116},"id":1,"name":"zhangsan"}

 

解决方案三：自定义转换器

核心代码如下：

               JsonConfig jsonConfig = new JsonConfig();

jsonConfig.registerJsonValueProcessor(java.sql.Date.class, new JsonDateValueProcessor());

JSONObject json = JSONObject.fromObject(user,jsonConfig);

System.out.println("=====total count getUser====" + json);

 

        public class JsonDateValueProcessor implements JsonValueProcessor {

      private String format = "yyyy-MM-dd";

     public Object processArrayValue(Object arg0, JsonConfig arg1) {

System.out.println("====processArrayValue======== "+arg0);

return null;

      } 

 

    public Object processObjectValue(String arg0, Object arg1, JsonConfig arg2) {

System.out.println("====processObjectValue======== "+arg0 +",arg1="+arg1);

return processJsonDateValue(arg1);

   }

 

private Object processJsonDateValue(Object arg0) {

SimpleDateFormat sdf=new SimpleDateFormat(format);

return sdf.format(arg0);

}

 

}

处理结果如下：

=====total count getUser====User [id=1, name=zhangsan, age=12,hire_date=2016-05-17]

====processObjectValue======== hire_date,arg1=2016-05-17

=====total count getUser===={"age":12,"hire_date":"2016-05-17","id":1,"name":"zhangsan"}