81,092
社区成员
发帖
与我相关
我的任务
分享读取两个表的信息，循环插入在
String sql = "select * from tb_ZhiHang order by zhid ";
ResultSet rs = stmt.executeQuery(sql);
String sql2 = "select * from tb_KeHu_GeRen ";
ResultSet rs2 = stmt.executeQuery(sql2);
....
<tr align="left" bgcolor="#FAFAF1" height="22">
<td width="171" height="30">选择支行：</td>
<td width="1024" height="30" align="left">
<select name="zhihang" id="zhihang">
<option value="0" selected>请选择</option>
<%
while (rs.next()){
%>
<option value="<%=rs.getString("zhid")%>"><%=rs.getString("zhname")%></option>
<%
}
%>
</select></td>
</tr>
.....
<tr align="left" bgcolor="#FAFAF1" height="22">
<td width="171" height="30">选择客户：</td>
<td width="1024" height="30" align="left">
<select name="select" id="select">
<%
while (rs2.next()){
%>
<option value="<%=rs2.getString("zhid")%>"><%=rs2.getString("zhname")%></option>
<%
}
%>
</select></td>
</tr>
ResultSet rs = stmt.executeQuery(sql);
String sql2 = "select * from tb_KeHu_GeRen ";
ResultSet rs2 = stmt.executeQuery(sql2);
....
<tr align="left" bgcolor="#FAFAF1" height="22">
<td width="171" height="30">选择支行：</td>
<td width="1024" height="30" align="left">
<select name="zhihang" id="zhihang">
<option value="0" selected>请选择</option>
<%
while (rs.next()){
%>
<option value="<%=rs.getString("zhid")%>"><%=rs.getString("zhname")%></option>
<%
}
%>
</select></td>
</tr>
.....
<tr align="left" bgcolor="#FAFAF1" height="22">
<td width="171" height="30">选择客户：</td>
<td width="1024" height="30" align="left">
<select name="select" id="select">
<%
while (rs2.next()){
%>
<option value="<%=rs2.getString("zhid")%>"><%=rs2.getString("zhname")%></option>
<%
}
%>
</select></td>
</tr>
...全文
请发表友善的回复…
发表回复
wrong1111 2015-10-26
- 打赏
- 举报
String sql = "select * from tb_ZhiHang order by zhid ";
ResultSet rs = stmt.executeQuery(sql);
String sql2 = "select * from tb_KeHu_GeRen ";
ResultSet rs2 = stmt2.executeQuery(sql2);
