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

最新推荐文章于 2024-08-19 03:46:23 发布

ZHOU_VIP

最新推荐文章于 2024-08-19 03:46:23 发布

阅读量4.2k

点赞数

分类专栏： Jsecode

本文链接：https://blog.csdn.net/ZHOU_VIP/article/details/64128650

版权

Jsecode 专栏收录该内容

50 篇文章 0 订阅

订阅专栏

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