JSP页面不能显示一个数据·求解决,该如何解决
JSP页面不能显示一个数据·求解决
dAL的代码
servlet的跳回去部分的代码
JSP页面的代码
dAL的代码
public givebean querygive(int rid) throws Exception {
Connection con = db.Shujuku();
Statement sts = null;
givebean customer1 = new givebean();
try {
sts = con.createStatement();
String sql = "select * from giveback where readerID='" + rid
+ "';";
ResultSet rs1 = sts.executeQuery(sql);
while (rs1.next()) { 断点设了这里可以会跑2次 ,能读出所有需要的查询
customer1.setBookName(rs1.getString("bookName"));
customer1.setReaderName(rs1.getString("readerName"));
customer1.setReadertime(rs1.getString("readertime"));
customer1.setGivebacktime(rs1.getString("givebacktime"));
customer1.setGuotime(rs1.getString("guotime"));
}
return customer1;
} catch (Exception ex) {
} finally {
try {
sts.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return null;
}
servlet的跳回去部分的代码
int rid =Integer.parseInt(request.getParameter("rid"));
// System.out.println("输入账号"+rid);
readerbean userArray = null;
queryDal queryreader = new queryDal();
givebean userArray1 = null;
queryDal querygive = new queryDal();
try {
userArray = queryreader.queryreader(rid);
request.setAttribute("rs", userArray);
userArray1 =querygive.querygive(rid);这个是需要输出多个值得对应上面那个DAL
request.setAttribute("rs1", userArray1);
request.getRequestDispatcher("/jieyeu.jsp").forward(request, response);
JSP页面的代码
<%
givebean rb1 = (givebean) request.getAttribute("rs1");
if (null != rb1) {
%>
<tr>
<td height="32" background="Images/borrow_if.gif"> 添加的依据:
<input name="f" type="radio" class="noborder" value="barcode" checked>
图书条形码
<input name="f" type="radio" class="noborder" value="bookname">
图书名称
<input name="inputkey" type="text" id="inputkey" size="50">
<input name="submit2" type="button" class="btn_grey" value="确定" >
</td>
</tr>
<tr>
<td valign="top" bgcolor="#FCEC9A" style="padding:5px"><table width="99%" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#F6B83B" bgcolor="#FFFFFF">
<tr align="center" bgcolor="#F9D16B">
<td width="23%" height="25">图书名称</td>
<td width="12%">借书人</td>
<td width="17%">借书日期</td>
<td width="14%">到期时间</td>
<td colspan="2">借书天数</td>
<td width="14%">操作</td>
</tr>
<tr bgcolor=white>