20170524-SQL数据输出转换，ResultSet，method

pansky-Metadata

1.ResultSet.

Connection conn=new Connection();

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery(sql);

while(rs.nest){

rs返回类型可以根据get*转换，获取的数据是集合类型的sql返回值，获取多条sql的数据返回值时，每条sql语句都会执行while循环

}

2.SQL

select date from (select to_char(date,'dd/mm') as a from table order by a desc) where rownum=1;

date：列名，日期

dd/mm：String类型格式