我写的一个jsp的查询页面,如下:
<%@ page language="java" pageEncoding="gbk"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean" %>
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html" %>
<%@ taglib uri="http://struts.apache.org/tags-logic" prefix="logic" %>
<%@ taglib uri="http://struts.apache.org/tags-tiles" prefix="tiles" %>
<html:html lang="true">
<head>
<html:base />
<title>queryResult1.jsp</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!-- <link rel="stylesheet" type="text/css" href="styles.css"> -->
</head>
<body>
<div align="center"><b>Result page</b></div><br>
<div>
<table border="2" bordercolor="#ffff" cellSpacing=1 align=center bgColor=#c8d6f7 width="675" height="78">
<tr bgColor=#c8d6f7>
<th>id</th>
<th>name</th>
<th>code</th>
<th>note</th>
<th>sequenceNo</th>
</tr>
<logic:notEmpty name="c1" scope="request">
<logic:iterate id="codeManager" name="c1" scope="request">
<tr>
<td bgColor="#ffffff"><bean:write name="codeManager" property="id"/></td> <td bgColor="#ffffff"><bean:write name="codeManager" property="name"/></td>
<td bgColor="#ffffff"><bean:write name="codeManager" property="code"/></td>
<td bgColor="#ffffff"><bean:write name="codeManager" property="note"/></td>
<td bgColor="#ffffff"><bean:write name="codeManager" property="sequenceNo"/></td>
</tr> </logic:iterate>
</logic:notEmpty>
</table>
</div>
</body>
</html:html> 运行效果:
Result page
id name code node sequenceNo
我用的是Struts框架的
Action类:
public ActionForward query(ActionMapping mapping, ActionForm form, HttpServletRequest request,HttpServletResponse response) throws Exception
{
//CodeMngForm codeMngForm = (CodeMngForm) form;// TODO Auto-generated method stub
HttpSession session=request.getSession(true);
String key=(String)session.getAttribute("name");
CodeManager codeManager = new CodeManager(true);
ArrayList cl = codeManager.query(key);
codeManager.close();
request.setAttribute("cl", cl);
return mapping.findForward("querysuccess");
}
bean类:
public ArrayList query(String key)
{
ArrayList codelist = new ArrayList();
try
{ String sql = "select * from srms_dmk order by id";
ResultSet rs = dbc.executeQuery(sql);
rs.last();
int row= rs.getRow();
System.out.println("---测试:总记录数---"+row);
if(row<=0){return null;}
else {// 如果有子结点 rs.beforeFirst();
while (rs.next()) {
CodeManager codeManager = new CodeManager(false);
codeManager.setId(rs.getInt("ID"));
System.out.println(rs.getInt("ID"));
codeManager.setName(rs.getString("NAME"));
System.out.println(rs.getString("NAME"));
codeManager.setCode(rs.getString("CODE"));
codeManager.setNote(rs.getString("NOTE"));
codeManager.setSequenceno(rs.getString("sequenceno"));
codelist.add(codeManager); }
rs.close();
return codelist;// 返回该记录的所有子结点 }
}
catch(Exception e) { System.err.println(e); }
return codelist; }
告诉我的显示页面应该怎么写?