我把代碼貼出來，首先是dao層的方法
public List<Student> selectStudent(){
List<Student> studentList = new ArrayList<Student>(); //創建集合
Connection conn = DataBaseConnection.getConnection();
String sql = "select * from student"; //SQL查詢陳述句
try {
PreparedStatement pst = conn.prepareStatement(sql);
ResultSet rs = pst.executeQuery();
while (rs.next()) {
Student student = new Student();
student.setId(rs.getInt("id")); //得到ID
student.setStuno(rs.getString("stuno"));
student.setStuname(rs.getString("stuname"));
student.setStusex(rs.getString("stusex"));
student.setStubirth(rs.getString("stubirth"));
student.setStuclass(rs.getString("stuclass"));
student.setStumajor(rs.getString("stumajor"));
student.setStudept(rs.getString("studept"));
student.setStuphone(rs.getString("stuphone"));
studentList.add(student);
}
rs.close(); //關閉
pst.close(); //關閉
} catch (SQLException e) {
e.printStackTrace(); //拋出例外
}
return studentList; //回傳一個集合
}
然后是servlet
public class selectStudentServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
StudentDao dao = new StudentDao();
List<Student> studentList = dao.selectStudent();
HttpSession session=request.getSession();
session.setAttribute("studentList", studentList);
request.getRequestDispatcher("student/student_all.jsp").forward(request, response);
}
}
最后是jsp頁面的代碼
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
<head>
<base href="https://bbs.csdn.net/topics/">
<title>查看所有學生</title>
</head>
<body>
<table>
<thead>
<tr>
<td align="center">學號</td>
<td align="center">姓名</td>
<td align="center">性別</td>
<td align="center">出生年月</td>
<td align="center">班級</td>
<td align="center">專業</td>
<td align="center">學院</td>
<td align="center">電話</td>
</tr>
</thead>
<tbody>
<c:forEach items="${requestScope.studentList}" var="student">
<tr>
<td>${student.stuno}</td>
<td>${student.stuname}</td>
<td>${student.stusex}</td>
<td>${student.stubirth}</td>
<td>${student.stuclass}</td>
<td>${student.stumajor}</td>
<td>${student.studept}</td>
<td>${student.stuphone}</td>
<td>
<a href="https://bbs.csdn.net/topics/deleteStudentServlet?id=${student.id }">洗掉</a>
<a href="https://bbs.csdn.net/topics/updateStudentServlet?id=${student.id }">修改</a>
</td>
</tr>
</c:forEach>
<tr>
<td colspan="8" style="text-align: left;"><a href="https://bbs.csdn.net/topics/student/student_add.jsp">添加</a></td>
</tr>
</tbody>
</table>
</body>
</html>
運行后取c:foreach標簽的資料，有沒有大佬幫幫忙
我用的是intellij idea
uj5u.com熱心網友回復：
很久沒用jsp了，先確診下servlet中 List<Student> studentList = dao.selectStudent(); 是否有資料
然后jsp頁面 ${requestScope.studentList} 改成 ${studentList} 試下
uj5u.com熱心網友回復：
<c:forEach items="${requestScope.studentList}" var="student">改成<c:forEach items="${studentList}" var="student">轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/252330.html
標籤：Web 開發
上一篇：密碼輸入顯示為*****