jsp页面查询显示 急!!!

我写的一个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; }

告诉我的显示页面应该怎么写?

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值