📄 queryachievement.java
字号:
package servlet;import java.io.IOException;import java.io.PrintWriter;import java.sql.ResultSet;import java.sql.SQLException;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import dao.AchievementDao;public class QueryAchievement extends HttpServlet { protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setCharacterEncoding("utf-8"); PrintWriter out = response.getWriter(); List list = null; String course = ""; String score = ""; //BasicDao dao = new BasicDao(); String number = request.getParameter("number") == null ? "" : request.getParameter("number").trim(); if(number.length()!=0){ AchievementDao dao = new AchievementDao(number); ResultSet result = dao.queryAchievement(); try { out.print("<html>"); out.print("<table>"); out.print("<table align=\"center\" border=\"1\">"); out.print("<tr><td align=\"center\">瀛﹀彿</td><td align=\"center\">绉戠洰</td><td align=\"center\">鎴愮哗</td></tr>"); while(result.next()){ number = result.getString("number"); course = result.getString("course"); score = result.getString("score"); out.print("<tr><td align=\"center\">" + number + "</td><td align=\"center\">" + course + "</td><td align=\"center\">" + score + "</td></tr>"); } out.print("</table>"); out.print("<center><a href=\"index.jsp\">杩斿洖涓荤晫闈
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -