如何使用java命令对列的元素进行排序?(How to sort elements of a column using java commands?)

优质
小牛编辑
128浏览
2023-12-01

问题描述 (Problem Description)

如何排序表的内容?

解决方案 (Solution)

以下示例使用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);
      }
   }
}

结果 (Result)

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

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