java - 执行 order by 语句 by preparedstatement 不排序

Question

我尝试通过preparedstatement查询一个带有order by语句的select sql，它执行了，但是打印时，它没有排序。有人帮助我吗？

Connection conn = ConnectionUtils.getConnect();
        String sql = "SELECT  * FROM student ORDER BY ?";
        List<Student> listStudent = new ArrayList<>();
        try {
            PreparedStatement prepareStatement = conn.prepareStatement(sql);
            prepareStatement.setString(1, name);
            ResultSet rs = prepareStatement.executeQuery();
            while (rs.next()) {
                Student student = new Student();
                student.setId();
                ......vv
                listStudent.add(student);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return listStudent;

Answer 1

在准备好的语句中，您使用 ? 参数或占位符来传递实际值而不是列名称，如在 WHERE 子句中: WHERE column1 = ?。

所以改成这样:

String sql = "SELECT  * FROM student ORDER BY " + name;

并删除此行:

prepareStatement.setString(1, name);