Java 示例 - 对表的内容进行排序

• 

  问题描述

  如何对表格的内容进行排序？
• 

  解决方案

  以下示例使用 Order by SQL 命令对表进行排序。

  
  import java.sql.*;
  public class jdbcConn {
     public static void main(String[] args) throws Exception {
        Class.forName("org.apache.derby.jdbc.ClientDriver");
        Connection con = DriverManager.getConnection (
           "jdbc:derby://localhost:1527/testDb","name","pass");
        
        Statement stmt = con.createStatement();
        String query = "select * from emp order by name";
        String query1 = "select * from emp order by name, job";
        
        ResultSet rs = stmt.executeQuery(query);
        System.out.println("Table contents sorted by Name");
        System.out.println("Id Name Job");
        
        while (rs.next()) {
           int id = rs.getInt("id");
           String name = rs.getString("name");
           String job = rs.getString("job");
           System.out.println(id + "  " + name+"   "+job);
        }
        rs = stmt.executeQuery(query1);
        System.out.println("Table contents after sorted by Name & job");
        System.out.println("Id Name    Job");
        
        while (rs.next()) {
           int id = rs.getInt("id");
           String name = rs.getString("name");
           String job = rs.getString("job");
           System.out.println(id + "  " + name+"   "+job);
        }
     }
  }
  

• 

  结果

  上面的代码示例将产生以下结果。结果可能会有所不同。

  
  Table contents after sorting by Name
  Id Name    Job
  1  ravi   trainee
  5  ravi   MD
  4  ravi   CEO
  2  ravindra   CEO
  2  ravish   trainee
  Table contents after sorting by Name & job
  Id Name    Job
  4  ravi   CEO
  5  ravi   MD
  1  ravi   trainee
  2  ravindra   CEO
  2  ravish   trainee