Java结果集以相反的顺序显示

Question

我正在测试具有以下代码的非常简单的Java WebApp Doget（）方法：

protected void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException
{
    try 
    {
        Class.forName("oracle.jdbc.OracleDriver");
    }
    catch(ClassNotFoundException ex)
    {
            System.out.println(ex);
    }
    String sql_qrp="select * from HR.EMP_MGMT";
    try
    {
        Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521/XE","HR","HR");
        try(Statement stm=con.createStatement())
        {
            ResultSet rs=stm.executeQuery(sql_qrp);
            while(rs.next())
            {
                int emp_ID=rs.getInt("EMP_ID");
                String name=rs.getString("NAME");
                String address=rs.getString("ADDRESS");
                int tel=rs.getInt("TEL");
                String email=rs.getString("EMAIL");
                System.out.println(emp_ID+", "+name+", "+address+", "+tel+", "+email);
            }
        }
    }
    catch (SQLException ex) {
        Logger.getLogger(Add_Employee.class.getName()).log(Level.SEVERE, null, ex);
    }
}

它可以很好地连接到Oracle DB，并从代码中指定的表中获取所有3行，但以相反的顺序获取。我已经试图强迫fetch_forward没有成功。因此，它获取了以下记录：ID 3.，2，1。而不是ID 1.，2。，3。

Answer 1

add

ORDER BY id ASC

to sql_qrp。