이게 잘되는지 아직 확인은 못했다....
select
*
from (
select * from
(select
Idx,CompanyName,wdate
from
Tbl
where
1=1
order by
Wdate desc)
as cnvv
group by cnvv.CompanyName
)as anv
order by
anv.Wdate Desc
limit 0,10
폴더 리스트 가져오기 String path="C:\"; File dirFile=new File(path); File []fileList=dirFile.listFiles(); for(File tempFile : fileList) { if(tempFile.isFile()) { String tempPath=tempFile.getParent(); String tempFileName=tempFile.getName(); System.out.println("Path="+tempPath); System.out.println("FileName="+tempFileName); /*** Do something withd tempPath and temp FileName ^^; ***/ } } 정렬해서 가져오기 import java.io.FileFilter; import java.io.IOException; import java.util.Arrays; import java.util.Date; import org.apache.commons.io.comparator.LastModifiedFileComparator; import org.apache.commons.io.filefilter.FileFileFilter; public class LastModifiedFileComparatorTest { public static void main(String[] args) throws IOException { File directory = new File("."); // get just files, not directories File[] files = directory.listFiles((FileFilter) FileFileFilter.FILE); System.out.println("Defaul...
댓글
댓글 쓰기