sql查询

查询前10条：

  select rownum,mains.* from (select * from WX_Notices_TB  order by sys_add_time desc) mains where rownum<=10
 
 查询前10条：   
select * from WX_Notices_TB t  
where to_date((substr(t.sys_add_time,0,10) ),'yyyy-mm-dd hh24:mi:ss')  >=TRUNC(SYSDATE, 'MM')       
and to_date((substr(t.sys_add_time,0,10) ),'yyyy-mm-dd hh24:mi:ss') <=last_day(SYSDATE)

查询多条数据类型转换：

System.err.println("objList.size()大小："+objList.size());

Object[] obj = null;

for(int i=0; i < objList.size();i++){
obj = (Object[])objList.get(i);
    System.out.println(obj[0]+"\t"+obj[1]);
  }

@Test

public void ceee(){
Object num[];
List list;
List<Alarms>  listAlarm= new ArrayList<Alarms>();
Session session = HibernateSessionFactory.getSessionFactory().openSession();
String sql = "select nvl(carid,' ') ,nvl(types,' ')  ,time from alarms where state1=0 order by time desc";
try {
list = session.createSQLQuery(sql).list();
System.out.println("大小为"+list.size());
int i ,j = list.size();
for(i=0;i<j;i++) {
num =(Object[]) list.get(i);
 
System.out.print(num[0]);
System.out.println(num[1]);

Alarms alarm = new Alarms();
 alarm.setComments(num[0].toString());
 alarm.setTypes(num[1].toString());
listAlarm.add(alarm);
}
} catch (Exception e) {
e.printStackTrace();
}
for (Alarms alarms : listAlarm) {
System.err.println(">>"+alarms.getComments()+alarms.getTypes());
}

}