--

String sql="select * from students order by id ASC";//学号从小到大排列

DESC  按倒序排列