|
|

2.保留2位小数:
import java.text.DecimalFormat;DecimalFormat df=new DecimalFormat("0.00");Double x = 83.3333333333;x=Double.parseDouble(df.format(x)); 3.group by 和 order by
ORDER BY 用于对数据按指定的列和方法排序。select * from syscolumns order by id asc, colorder desc;指示查询出的结果 按 id 正序排列, colOrder 逆序排列。GROUP BY 用于汇总统计。 HAVING 用途和 WHERE类似,但用于对 GROUP BY 的结果进行过滤。select id, count(id) from syscolumns group by id;这条语句以 id 进行汇总,统计出每个不同的 id 出现的个数。select id, count(id) from syscolumns group by id having count(1) > 10;这条语句以 id 进行汇总,统计出每个不同的 id 出现的个数,但 having 后的条件指定了只显示 count(id) 大于 10 的数据。。先Group by ,后 Order by 4.日期
获取当前时间:
1.SimpleDateFormat tempDate = new SimpleDateFormat("yyyy-MM-dd" + " " + "hh:mm:ss");String datetime = tempDate.format(new java.util.Date());2.Calendar now=Calendar.getInstance();String time=now.get(Calendar.YEAR)+"-"+(now.get(Calendar.MONTH)+1)+"-"+now.get(Calendar.DAY_OF_MONTH)+" "+now.get(Calendar.HOUR_OF_DAY)+":"+now.get(Calendar.MINUTE)+":"+now.get(Calendar.SECOND); 3.Date curDate= new Date(System.currentTimeMillis());
- SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//24小时制
- SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");//12小时制
a.获取年、月、日:
String year=String.valueOf(c.get(Calendar.YEAR));String month=String.valueOf(c.get(Calendar.MONTH)+1);String day=String.valueOf(c.get(Calendar.DAY_OF_MONTH));
b.Calendar和Date的转化
(1) Calendar转化为Date
Calendar cal=Calendar.getInstance();Date date=cal.getTime();
(2) Date转化为Calendar
Date date=new Date();Calendar cal=Calendar.getInstance();cal.setTime(date);
c.计算一年中的第几星期
(1)计算某一天是一年中的第几星期
Calendar cal=Calendar.getInstance();cal.set(Calendar.YEAR, 2006);cal.set(Calendar.MONTH,1);cal.set(Calendar.DAY_OF_MONTH, 3);int weekno=cal.get(Calendar.WEEK_OF_YEAR);
(2)计算一年中的第几星期是几号
SimpleDateFormat df=new SimpleDateFormat("yyyy-MM-dd");Calendar cal=Calendar.getInstance();cal.set(Calendar.YEAR, 2006);cal.set(Calendar.WEEK_OF_YEAR, 1);cal.set(Calendar.DAY_OF_WEEK, Calendar.MONDAY);System.out.println(df.format(cal.getTime()));输出:2006-01-02 d:
1天内(注意为add):
Calendar c=Calendar.getInstance(); c.add(Calendar.DAY_OF_MONTH, -1); //得到前一天的时间startDateStr=sf.format(c.getTime());endDateStr=sf.format(java.util.Calendar.getInstance().getTime()); 推荐使用这种方法获取当前时间,不推荐使用new Date() 3天内:
Calendar c=Calendar.getInstance(); c.add(Calendar.DAY_OF_MONTH, -3); //得到前3天的时间startDateStr=sf.format(c.getTime()); 近1月:
Calendar c=Calendar.getInstance();c.add(Calendar.MONTH, -1);startDateStr=sf.format(c.getTime()); 到当前时间的前几年的时间:
Calendar c = Calendar.getInstance(); c.add(Calendar.YEAR, -5);//得到前5年 SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String mDateTime=formatter.format(c.getTime()); String strStart=mDateTime.substring(0, 16);//2002-10-24 09:30
本月(注意为set):
Calendar c=Calendar.getInstance();c.set(Calendar.DATE,1); //把日期设为当月第一天 startDateStr=sf.format(c.getTime()); 上月:
Calendar c2=Calendar.getInstance(); c2.add(Calendar.MONTH,-1); c2.set(Calendar.DATE,1); startDateStr=sf.format(c2.getTime());
5.文本域input的不可编辑属性 disabled 和 readonly 区别
<div class="quote_title"> |
|