在jsp中传不过来javabean的值!!!!!　　急呀，谁来帮帮我！呀！！！

jianhui0607 2008-05-07 10:54:43

struts＋javabean来把值传到jsp中:
struts action中的代码：
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {

DB db=new DB();

List list=(List)db.Select();
HttpSession session=request.getSession();
session.setAttribute("list", list);

return mapping.findForward("succ");

}
}

连接数据这个class的代码:

public class DB {
public static Connection getConnection() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
return DriverManager.getConnection("jdbc:odbc:zfzx","sa","");

} catch (Exception e) {
System.out.println("连接出错:"+e.toString());
return null;
}
}
private static String fomart (String str)
{

String result=null;
byte temp[];
try{
temp=str.getBytes("ISO-8859-1");
result=new String(temp);
}catch(Exception e)
{}
return result;

}

public ArrayList Select()
{
try {

String sql="select * from fb";
Connection conn=DB.getConnection();
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery(sql);
ArrayList list=new ArrayList();
while(rs.next())
{
DBbean fb=new DBbean();

fb.setId(rs.getInt(1));
fb.setName(fomart(rs.getString(2)));
fb.setVer(fomart(rs.getString(3)));
fb.setLicense(fomart(rs.getString(4)));
fb.setOs(fomart(rs.getString(5)));
fb.setSoftstate(fomart(rs.getString(6)));
fb.setSite(fomart(rs.getString(7)));
fb.setEmail(fomart(rs.getString(8)));
fb.setDownload(fomart(rs.getString(9)));
fb.setInformation(fomart(rs.getString(10)));
fb.setZt(rs.getInt(11));

list.add(rs);

}
return list;

} catch (Exception ex)
{
ex.printStackTrace();

return null;
}

}

jsp中的代码：

<body>
<%
List list=(ArrayList)request.getAttribute("list");
%>

<table border=1 style="border-collapse:collapse;" align="center" width=100% cellpadding=0 cellspacing=0 bordercolor=#6a7f8a >
<tr>
<td height="20" width=27% align=center>软件名称</td>
<td width=12% align=center>软件版本</td>
<td width=13% align=center>软件授权 </td>
<td width=22% align=center>使用平台</td>
<td width=16% align=center>插件情况</td>
<td width=10% align=center>公司网址</td>
<td width=12% align=center>电子信箱</td>
<td width=13% align=center>下载网址 </td>
<td width=22% align=center>软件简介</td>
<td width=16% align=center>审核否</td>
</tr>
<tr>

<%
for(int i=0;i<list.size();i++)
{
DBbean db=(List)list.get(i);

%>

<td><%=db.getName() %></td>
<td><%=db.getVer() %></td>
<td><%=db.getLicense() %></td>
<td><%=db.getOs() %></td>
<td><%=db.getSoftstate() %></td>
<td><%=db.getSite() %></td>
<td><%=db.getEmail() %></td>
<td><%=db.getDownload() %></td>
<td><%=db.getInformation() %></td>

<%
if(db.getzt()==0)
{
%>
<td>没审核</td>
<%
}
else
{
%>

<td>审核</td>
<%
}
%>
</tr>
</table>
</body>

Bean中代码字段:

private String license;

/** download property */
private String download;

/** information property */
private String information;

/** os property */
private String os;

/** site property */
private String site;

/** email property */
private String email;

/** softstate property */
private String softstate;

/** ver property */
private String ver;

/** name property */
private String name;

/** id property */
private int id;
private int zt;

...全文