@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
可以后端返回就排好。 或者前端自己 用sort排序
和前后端协商好,根据实际情况开谁排序方便或加载效率高就谁做排序