写程序与的时候,有些地方需要js或者jQuery取值,然后将50000000.00格式化成50,000,000.00这种形式;
首先创建formatCurrency.js,代码如下:
function formatCurrency(num) {
num = num.toString().replace(/\$|\,/g,'');
if(isNaN(num))
num = "0";
var sign = (num == (num = Math.abs(num)));
num = Math.floor(num*100+0.50000000001);
var cents = num%100;
num = Math.floor(num/100).toString();
if(cents<10)
cents = "0" + cents;
for (var i = 0; i < Math.floor((num.length-(1+i))/3); i++)
num = num.substring(0,num.length-(4*i+3))+','+
num.substring(num.length-(4*i+3));
return (((sign)?'':'-') + num + '.' + cents);
}
在使用的jsp中引入上面的formatCurrency.js后,进行取值显示,如下:
$('#showInput').val(formatCurrency(500000000.00));
在将数值存入到数据库之前,要将50,000,000.00再格式化回50000000.00,再进行持久化,代码如下:
var lastNum = parseFloat(500,000,000.00.replace(/,/g,""));