表结构:
-----------------
名称|结论|标志|
-----------------
A | A | 1 |
-----------------
A | B | 1 |
-----------------
B | B | 0 |
-----------------
读表内容:
A :结论以 下拉框形式显示(选项A,B)
B :结论以 文本框形式显示(值B)对于表数据多的即:
对应多结论的用下拉显示
单结论的用文本显示
-----------------
名称|结论|标志|
-----------------
A | A | 1 |
-----------------
A | B | 1 |
-----------------
B | B | 0 |
-----------------
读表内容:
A :结论以 下拉框形式显示(选项A,B)
B :结论以 文本框形式显示(值B)对于表数据多的即:
对应多结论的用下拉显示
单结论的用文本显示
String sql="select distinct a.ksmc,b.xmmc,b.xmdw,b.ckxx,b.cksx from tjksb as a,tjxmb as b,grtcxzb as c where a.ksbh=b.ksbh and c.xmbm=b.xmbh and c.grbh='"+grbh+"'";
dbsm.setSqlStr(sql);
dbsm.executeQuery();
ResultSet rs=dbsm.getRs();
%>
<form id="form1" name="form1" method="post" action="count_in3.jsp?grbh=<%=grbh%>">
<table width=90% border="0" align="center" bgcolor="#f1f3f5" >
<tr>
<th colspan="7" class=tableHeaderText>
<input name="grbh" type="hidden" size="16" maxlength="16" value="<%=grbh%>">
</tr>
<tr>
<th class=tableHeaderText width="34%"><div align="center">项目名称</div>
<th class=tableHeaderText width="19%"><div align="center">体检结果</div>
<th colspan="4" class=tableHeaderText><div align="center">参考范围</div>
</tr>
<% while(rs.next())
{
%>
<tr>
<td><div align="center"><input readonly="1" type="text" name="xmmc" value="<%=rs.getObject("xmmc")%>"></div></td>
<td><input type="text" name="date"></td>
<td width="9%"><div align="center"><%=rs.getObject("ckxx")%></div></td>
<td width="5%"><div align="center"><%=rs.getObject("xmdw")%></div></td>
<td width="10%"><div align="center"><%=rs.getObject("cksx")%></div></td>
<td width="3%"><div align="center"><%=rs.getObject("xmdw")%></div></td>
</tr>
<%}%>
<tr>
<td colspan="7"><div align="center">
<input type="submit" name="Submit" value="保存">
<input type="reset" name="Submit2" value="重置">
</div></td></tr>
</table>
</form>
多谢拉!
文本
<%}%>
<%if(下拉框形式){%>下拉框
<%}%>