查询半小时段记录

最新推荐文章于 2024-07-05 02:14:15 发布

原创最新推荐文章于 2024-07-05 02:14:15 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#vector #date #sql

oracle 10g 专栏收录该内容

4 篇文章

订阅专栏

对半小时段记录的查询，及提取

首先使用SQL语句

select sum(decode(op_cat_next,'S',0,'R',0,qty)) as qty,to_char(track_out_date,'hh24')|| DECODE( lpad((to_number(to_char(描述日期字段,'mi'))-30),1),'-','00','30') as hour from p_lot_opsu t group by to_char(描述日期字段,'hh24') || DECODE( lpad((to_number(to_char(track_out_date,'mi'))-30),1),'-','00','30') order by hour

之后，可以得到一组数据；使用Vector hourVec = new Vector();进行取得其值

****************************

ps = conn.prepareStatement(strBuf.toString());

rs = ps.executeQuery(); while(rs.next())

{

hourVec.add(rs.getString("hour"));

}

*******************************

之后，即可自己定义一个数据，如int[] hourAro={0,30,100,130,200,230,300,330,400,430,500,530,600,630,700,730,800,830,900,930,1000,1030,1100,1130,1200,1230,1300,1330,1400,1430,1500,1530,1600,1630,1700,1730,1800,1830,1900,1930,2000,2030,2100,2130,2200,2230,2300,2330};

即可搞定啦！