保留两位小数：数据库字段类型NUMBER，Java字段类型Double类型

来源：互联网发布：sqlserver mm dd 编辑：程序博客网时间：2024/05/17 02:20

1.数据库字段类型

查出的数据小数点后带两位小数

2.后台查出的json却没有两位小数

[{recordId : 20170320142740038015948,appSysId : 23551,appDeptId : 3,orgDeptName : null,carHostNO : 1019,secureNo : 111,secureStartTime : 2017 - 03 - 21,secureEndTime : 2017 - 03 - 22,secureHandle : xxx,secureInform : null,vehicleModel : null,securePay : 11122,secureAccNo : 222,secureAccPay : 22233.0,secureTax : 111.0,secureRemark : sdadada,secureNum : 33466.0,extraMap : null}, null, null, null, null, null, null, null, null, null]

因为：

CarSecureListResp中这几个字段都是Double类型

3.修改代码：

这几个几个字段格式化带.00，再在CarSecureListResp加在几个字段用于存放格式化过的值

4.最后查出的json

{    "retCode":1,    "retMsg":"操作成功",    "list":[        {            "recordId":"20170320162514963019983",            "appSysId":2009,            "appDeptId":2,            "orgDeptName":"盐城供电公司_响水供电公司",            "carHostNO":"苏JF6772",            "secureNo":"AAA",            "secureStartTime":"2016-11-01",            "secureEndTime":"2016-11-02",            "secureHandle":"啊哈哈的",            "securePay":102,            "securePayStr":"102.00",            "secureAccNo":"BBB",            "secureAccPay":156,            "secureAccPayStr":"156.00",            "secureTax":452,            "secureTaxStr":"452.00",            "secureRemark":"黄磊1",            "secureNum":710,            "secureNumStr":"710.00"        },        {            "recordId":"20170320145248466019516",            "appSysId":2009,            "appDeptId":2,            "orgDeptName":"盐城供电公司_响水供电公司",            "carHostNO":"苏JF6772",            "secureNo":"AAAA",            "secureStartTime":"2017-01-01",            "secureEndTime":"2017-02-01",            "secureHandle":"张三88",            "securePay":1000,            "securePayStr":"1000.00",            "secureAccNo":"CCCC",            "secureAccPay":550.1,            "secureAccPayStr":"550.10",            "secureTax":120,            "secureTaxStr":"120.00",            "secureRemark":"啊哈哈",            "secureNum":1670.1,            "secureNumStr":"1670.10"        },        {            "recordId":"20170320145248968014513",            "appSysId":2009,            "appDeptId":2,            "orgDeptName":"盐城供电公司_响水供电公司",            "carHostNO":"苏JF6772",            "secureNo":"BBBB",            "secureStartTime":"2017-02-01",            "secureEndTime":"2017-03-01",            "secureHandle":"李四88",            "securePay":2000,            "securePayStr":"2000.00",            "secureAccNo":"DDDD",            "secureAccPay":650.22,            "secureAccPayStr":"650.22",            "secureTax":101,            "secureTaxStr":"101.00",            "secureRemark":"额呵呵",            "secureNum":2751.22,            "secureNumStr":"2751.22"        },        {            "recordId":"20170320142740038015948",            "appSysId":23551,            "appDeptId":3,            "orgDeptName":"警保部_人事处",            "carHostNO":"1019",            "secureNo":"111",            "secureStartTime":"2017-03-21",            "secureEndTime":"2017-03-22",            "secureHandle":"xxx",            "securePay":11122,            "securePayStr":"11122.00",            "secureAccNo":"222",            "secureAccPay":22233,            "secureAccPayStr":"22233.00",            "secureTax":111,            "secureTaxStr":"111.00",            "secureRemark":"sdadada",            "secureNum":33466,            "secureNumStr":"33466.00"        }    ],    "totalNum":4,    "curRecordNum":4,    "startRow":0,    "nextStartRow":4}

5.前台可以取带两位小数的值，OK~~

参考：

http://blog.csdn.net/huaishuming/article/details/17752365

http://www.cnblogs.com/nayitian/p/3214178.html

0 0