关于#java#的问题,如何解决?

java

@WebServlet({"/grade"})
public class querSerlvet extends HttpServlet {
    @Override
    protected void service(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=utf-8");
        PrintWriter out = response.getWriter();


        Connection con = null;
        PreparedStatement pre = null;
        ResultSet rs = null;
        String sql = "";
        HttpSession session = request.getSession(false);
        String sno = (String) session.getAttribute("sno");
        Grade grade = new Grade();
        try {
            con = myutil.utilDbc();
            sql = "select 数学,c语言,羽毛球,英语 from t_grade where sno = ?";
            pre = con.prepareStatement(sql);
            pre.setString(1,sno);
            rs = pre.executeQuery();
            if(rs.next()){

                grade.setMath(rs.getInt(1));
                grade.setC(rs.getInt(2));
                grade.setBadminton(rs.getInt(3));
                grade.setEnglish(rs.getInt(4));
            }

        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            myutil.myclose(con,pre,rs);
        }

        String json = JSON.toJSONString(grade);
        out.print(json);


    }
}
html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>成绩查询title>
    <link rel="stylesheet" href="./css/welcome.css">
head>

<body>
    <div class="box w">
        <ul class="nav">
            <li>
                <a href="javascript:void(0)" class="message">信息查询a>
                <ul class="menu">
                    <li>成绩查询li>
                    <li>课表查询li>
                    <li>个人信息li>
                ul>
            li>

            <li>
                <a href="javascript:void(0)">信息查询a>
            li>
            <li>
                <a href="javascript:void(0)">学校简介a>
            li>
            <li>
                <a href="javascript:void(0)">选课a>
            li>
            <li>
                <a href="javascript:void(0)">教学评价a>
            li>
            <li class="name">li>
            <li class="exit">退出li>
        ul>
    div>



    <div class="box3 w">
        <table border="1px" cellspacing="0" cellspacing="0">
            <thead>
                <tr>
                    <th>课程名th>
                    <th>成绩th>
                tr>
            thead>
            <tr>
                <td>td>
                <td>td>
            tr>
            <tbody>

            tbody>
        table>
    div>

body>
 <script>
    window.onload = function () {
        //创建对象
        var xmr = new XMLHttpRequest();

        myajax1(xmr, "GET", "/mystudent/wel", true, function (xmr) {
            var name = document.querySelector(".name");
            name.innerHTML = xmr.responseText;
            myajax1(xmr, "GET", "/mystudent/grade", true, function (xmr) {
                var grade = JSON.parse(xmr.responseText);
                var tbody = document.querySelector("tbody");
                // console.log(grade);
                for (var a in grade) {
                    var tr = document.createElement("tr");
                    tbody.appendChild(tr);
                    var td = document.createElement("td");
                    if (a == "badminton")
                        td.innerHTML = "羽毛球";
                    if (a == "c")
                        td.innerHTML = "C语言";
                    if (a == "english")
                        td.innerHTML = "英语";
                    if (a == "math")
                        td.innerHTML = "数学";
                    tr.appendChild(td);

                    var td = document.createElement("td");
                    td.innerHTML = grade[a];
                    tr.appendChild(td);
                }


            })
        })

script>

html

img

如何对这个表格进行排序

可以后端返回就排好。 或者前端自己 用sort排序

和前后端协商好,根据实际情况开谁排序方便或加载效率高就谁做排序