Functional Requirements Specification 功能需求的规格
----------------------------------------------------------------
Java float精度计算的问题,无法截取小数点后两位
使用了网上普遍采用的几种方式:
(一):
float a = 123.2334f;
float b = (float)(Math.round(a*100))/100;(这里的100就是2位小数点,如果要其它位,如4位,这里两个100改成10000)
(二):
import java.text.DecimalFormat;
String a = new DecimalFormat("###,###,###.##").format(100.12345);
(三):
float ft = 134.3435f;
int scale = 2;//设置位数
int roundingMode = 4;//表示四舍五入,可以选择其他舍值方式,例如去尾,等等.
BigDecimal bd = new BigDecimal((double)ft);
bd = bd.setScale(scale,roundingMode);
ft = bd.floatValue();
这几种在打印显示的时候都没问题,但是在数据库中存在的真实值(float字段,上面几种方式在格式化后结果正确,我再转成float后结果就错了)并没有截取成两位小数,例如:0.333333343267441
在我取出数据后转成double后就变成了真实值,而不是0.33
--------------------------------------------------------------
public static NumberFormat getDf(){
if(df==null){
df = NumberFormat.getFormat("##,##0.00"); }
return df;
}
--------------------------------------------------------------
decode(条件,值1,翻译值1,值2,翻译值2,...值n,翻译值n,缺省值)
--------------------------------------------------------------
set lin 5000;
spool filename
...
spool off
--执行sql导出console结果到c:/log.txt;
sqlplus ecpuser/ecpuser@EPDEV
SQL> set lin 1000;
SQL> spool c:/log.txt;
SQL> @ 5.DB_IMPORT(MEMS_PAYMENT_BILLO).sql
SQL> /
SQL> spool off;
--------------------------------------------------------------
为了允许两个或两个以上的变量控制循环,Java 允许你在for 循环的初始化部分和反复部分声明多个变量,每个变量之间用逗号分开。
使用逗号,前面的for循环将更高效,改写后的程序如下:
// Using the comma.
class Comma {
public static void main(String args[]) {
int a, b;
for(a=1, b=4; a<b; a++, b--) {
System.out.println("a = " + a);
System.out.println("b = " + b);
}
}
}
--------------------------------------------------------------
/**
* 得到本月的第一天
* @return
*/
public static String getMonthFirstDay() {
Calendar calendar = Calendar.getInstance();
calendar.set(Calendar.DAY_OF_MONTH, calendar
.getActualMinimum(Calendar.DAY_OF_MONTH));
return dateFormat("yyyy-MM-dd", calendar.getTime());
}
/**
* 得到本月的最后一天
*
* @return
*/
public static String getMonthLastDay() {
Calendar calendar = Calendar.getInstance();
calendar.set(Calendar.DAY_OF_MONTH, calendar
.getActualMaximum(Calendar.DAY_OF_MONTH));
return dateFormat("yyyy-MM-dd", calendar.getTime());
}
/**
*
* @param year
* int 年份
* @param month
* int 月份
*
* @return int 某年某月的最后一天
*/
private int getLastDayOfMonth(int year, int month) {
Calendar cal = Calendar.getInstance();
cal.set(Calendar.YEAR, year);
cal.set(Calendar.MONTH, month);
// 某年某月的最后一天
return cal.getActualMaximum(Calendar.DATE);
}
----------------------------------------------------------------
得到当月最大天数是getMaximum(Calendar.DAY_OF_MONTH);
得到当年最大天数是getMaximum(Calendar.DAY_OF_YEAR);
得到当月最大周数是getMaximum(Calendar.WEEK_OF_MONTH);
----------------------------------------------------------------
int year = summaryDate.getYear();
int month = summaryDate.getMonth();
int day = summaryDate.getDate();
Calendar cal = Calendar.getInstance();
cal.set(Calendar.YEAR, year);
cal.set(Calendar.MONTH, month);
// 某年某月的最后一天
int maxday = cal.getActualMaximum(Calendar.DATE);
if (type.equals(Constants.PAYMENT_BILL_SUMMARY_YEAR)) {
ssDate = new Date(year, 0, 1, 0, 0, 0);
esDate = new Date(year, 11, 31, 23, 59, 59);
} else if (type.equals(Constants.PAYMENT_BILL_SUMMARY_MOUTH)) {
ssDate = new Date(year, month, 1, 0, 0, 0);
esDate = new Date(year, month, maxday, 23, 59, 59);
} else if (type.equals(Constants.PAYMENT_BILL_SUMMARY_DAY)) {
ssDate = new Date(year, month, day, 0, 0, 0);
esDate = new Date(year, month, day, 23, 59, 59);
}
----------------------------------------------------------------
方法一:
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
java.util.Date now = df.parse("2008-03-26 13:31:40");
java.util.Date date=df.parse("2008-01-02 11:30:24");
long l=now.getTime()-date.getTime();
long day=l/(24*60*60*1000);
long hour=(l/(60*60*1000)-day*24);
long min=((l/(60*1000))-day*24*60-hour*60);
long s=(l/1000-day*24*60*60-hour*60*60-min*60);
System.out.println(""+day+"天"+hour+"小时"+min+"分"+s+"秒");
方法二:
SimpleDateFormat dfs = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
java.util.Date begin=dfs.parse("2008-01-02 11:30:24");
java.util.Date end = dfs.parse("2008-03-26 13:31:40");
long between=(end.getTime()-begin.getTime())/1000;//除以1000是为了转换成秒
long day1=between/(24*3600);
long hour1=between%(24*3600)/3600;
long minute1=between%3600/60;
long second1=between%60/60;
System.out.println(""+day1+"天"+hour1+"小时"+minute1+"分"+second1+"秒");