各位大侠帮忙看下这个问题:
我现在想在JSP页面获得表floor中name的值怎么获得啊.
表room结构如下:
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| code | varchar(255) | NO | | NULL | |
| inCount | varchar(255) | NO | | NULL | |
| description | varchar(255) | NO | | NULL | |
| floorid | int(11) | YES | MUL | NULL | |
+-------------+--------------+------+-----+---------+----------------+
表floor结构如下:
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | NO | | NULL | |
+-------+--------------+------+-----+---------+----------------+
表room中的floorid当作外键关联表floor
ACTION代码:
public String getRoom()
{
list = roomDAO.getRoom();
for(Iterator it=list.iterator(); it.hasNext(); )
{
Room room = (Room)it.next();
System.out.println(room.getCode());
System.out.println(room.getInCount());
System.out.println(room.getFloor().getName());
}
return "getRoom";
}
JSP页面代码:
<table align="center" border="1">
<tr>
<td>
code
</td>
<td>
incount
</td>
<td>
floorname
</td>
</tr>
<s:if test="list!=null">
<s:iterator id="list" value="list">
<tr>
<td>
<s:property value="code" />
</td>
<td>
<s:property value="inCount" />
</td>
<td>
</td>
</tr>
</s:iterator>
</s:if>
</table>
现在if循环中的前面两个值都能获取到了。那第三个TD如何写才能获取到表floor中的name值啊。
谢谢!
我现在想在JSP页面获得表floor中name的值怎么获得啊.
表room结构如下:
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| code | varchar(255) | NO | | NULL | |
| inCount | varchar(255) | NO | | NULL | |
| description | varchar(255) | NO | | NULL | |
| floorid | int(11) | YES | MUL | NULL | |
+-------------+--------------+------+-----+---------+----------------+
表floor结构如下:
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | NO | | NULL | |
+-------+--------------+------+-----+---------+----------------+
表room中的floorid当作外键关联表floor
ACTION代码:
public String getRoom()
{
list = roomDAO.getRoom();
for(Iterator it=list.iterator(); it.hasNext(); )
{
Room room = (Room)it.next();
System.out.println(room.getCode());
System.out.println(room.getInCount());
System.out.println(room.getFloor().getName());
}
return "getRoom";
}
JSP页面代码:
<table align="center" border="1">
<tr>
<td>
code
</td>
<td>
incount
</td>
<td>
floorname
</td>
</tr>
<s:if test="list!=null">
<s:iterator id="list" value="list">
<tr>
<td>
<s:property value="code" />
</td>
<td>
<s:property value="inCount" />
</td>
<td>
</td>
</tr>
</s:iterator>
</s:if>
</table>
现在if循环中的前面两个值都能获取到了。那第三个TD如何写才能获取到表floor中的name值啊。
谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货