SpringMVC中查询结果转json,不用自己去转了,直接在controller中返回Object类型,通过配置SpringMVC的messageConverters就可自动转成json格式,配置如下:
<bean id="handlerAdapter" class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
<property name="messageConverters">
<list>
<ref bean="jsonHttpMessageConverter"/>
</list>
</property>
</bean>
<!-- json转换,需配置编码格式,否则乱码 -->
<bean id="jsonHttpMessageConverter" class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<value>text/html;charset=UTF-8</value>
</list>
</property>
</bean>
转换过程中还有个问题,Date类型将会被转成数字,可以通过以下方法解决,定义JsonDateSerializer:
package system.homebank.utils;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Date;
import org.codehaus.jackson.JsonGenerator;
import org.codehaus.jackson.JsonProcessingException;
import org.codehaus.jackson.map.JsonSerializer;
import org.codehaus.jackson.map.SerializerProvider;
public class JsonDateSerializer extends JsonSerializer<Date>
{
@Override
public void serialize(Date arg0, JsonGenerator arg1, SerializerProvider arg2) throws IOException, JsonProcessingException
{
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String formattedDate = formatter.format(arg0);
arg1.writeString(formattedDate);
}
}
然后在javabean的set方法上加标注:
@JsonSerialize(using=JsonDateSerializer.class)
public Date getCrttime()
{
return crttime;
}
这样Date类型将被转成自定义格式。