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"}
