想用servlet将数据库中的内容显示在jsp页面上,试了很久就是不成功,把代码贴上来,望各位能帮忙
想用servlet将数据库中的内容显示在jsp页面上,试了很久就是不成功,把代码贴上来,望各位能帮忙
jsp testList.jsp ,如下:
<%@ page contentType="text/html; charset=GBK" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<center>
<h1>考题管理</h1>
<table border="1">
<c:forEach var="list" items="${requestScope.list}">
<tr>
<td>${list.test_ID}</td><td>${list.test_Theme}
</tr>
</c:forEach>
</table>
<table>
</table>
</center>
javabean DataBean.java 中的一部分:
public ArrayList TestList() {
ArrayList list = new ArrayList();
try {
while (res.next()) {
TestBean tb = new TestBean();
tb.setTest_ID(res.getInt("Test_ID"));
tb.setTest_Theme(res.getString("Test_Theme"));
list.add(tb);
}
} catch (SQLException ex) {
System.out.println("服务器异常发生在 getTestList()");
ex.printStackTrace();
}
return list;
}
javabean TestPage.java,如下:
package bean;
public class TestBean {
private int test_ID;
private String test_Theme;
public TestBean() {
}
public void setTest_ID(int test_ID) {
this.test_ID = test_ID;
}
public void setTest_Theme(String test_Theme) {
this.test_Theme = test_Theme;
}
public int getTest_ID() {
return this.test_ID;
}
public String getTest_Theme() {
return this.test_Theme;
}
}
servlet TestPage.java的一部分:
public void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
DataBean db=new DataBean();
ArrayList list=db.TestList();
request.setAttribute("list",list);
db.Close();
request.getRequestDispatcher("addTest.jsp").forward(request,response);
}