<META http-equiv=Content-Type content="text/html; charset=gb2312"></HEAD>
<BODY style=scrollbar-arrow-color:#227776;scrollbar-base-color:#C6DCDE text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0 background="img/bg.gif" marginwidth="0" marginheight="0" ><form name="form" method="post">
<div align="center">
<table width="959" height="359" border="0">
<input type="hidden" id="hid" name="hid" value="<%=(String)session.getAttribute("user")%>" />
<tr>
<td width="335" height="52" align="right">用户名</td>
<td width="528" height="52" colspan="-3" align="right"><label>
<div align="left">
<input type="text" name="regname">
</div>
</label></td>
<td width="82" rowspan="5"> </td>
</tr>
<tr>
<td height="55" align="right">存钱时间</td>
<td height="55" colspan="-3" align="right"><label>
<div align="left">
<input type="text" name="cqdate">
</div>
</label></td>
</tr>
<tr>
<td height="49" align="right">存钱银行</td>
<td height="49" colspan="-3" align="right"><div align="left">
<select name="cqbank" id="cqbank" >
<%
String strError2 = null;
String userid2=(String)session.getAttribute("user");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:goodschaginfo");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select cqselect from selectform where regname like '%"+userid2+"%'"; ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
%>
<option value="<%=rs.getString("cqselect")%>"> <%=rs.getString("cqselect")%></option>
<%
}
rs.close();
stmt.close();
con.close();
}
catch(ClassNotFoundException e){
strError2 = e.toString();
}
catch(SQLException e){
strError2 = e.toString();
}
%>
</select>
</div></td>
</tr>
<tr>
<td height="52" align="right">存多少钱</td>
<td height="52" colspan="-3" align="right"><label>
<div align="left">
<input type="text" name="cqmoney">
</div>
</label></td>
</tr>
<tr>
<td height="52" align="right">备注</td>
<td height="52" colspan="-3" align="right"><label>
<div align="left">
<input type="text" name="cqbeizhu">
</div>
</label></td>
</tr>
<tr>
<td height="51" align="center"><label>
<input type="submit" name="Submit" value="提交" onClick="check()">
</label></td>
<td height="51" align="center"><input type="button" name="Submit2" value="返回" onClick="window.history.go(-1);"></td>
</tr>
</table>
</div>
</form>
</TD>
</td>
</tr>
</table></BODY></HTML>
<BODY style=scrollbar-arrow-color:#227776;scrollbar-base-color:#C6DCDE text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0 background="img/bg.gif" marginwidth="0" marginheight="0" ><form name="form" method="post">
<div align="center">
<table width="959" height="359" border="0">
<input type="hidden" id="hid" name="hid" value="<%=(String)session.getAttribute("user")%>" />
<tr>
<td width="335" height="52" align="right">用户名</td>
<td width="528" height="52" colspan="-3" align="right"><label>
<div align="left">
<input type="text" name="regname">
</div>
</label></td>
<td width="82" rowspan="5"> </td>
</tr>
<tr>
<td height="55" align="right">存钱时间</td>
<td height="55" colspan="-3" align="right"><label>
<div align="left">
<input type="text" name="cqdate">
</div>
</label></td>
</tr>
<tr>
<td height="49" align="right">存钱银行</td>
<td height="49" colspan="-3" align="right"><div align="left">
<select name="cqbank" id="cqbank" >
<%
String strError2 = null;
String userid2=(String)session.getAttribute("user");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:goodschaginfo");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select cqselect from selectform where regname like '%"+userid2+"%'"; ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
%>
<option value="<%=rs.getString("cqselect")%>"> <%=rs.getString("cqselect")%></option>
<%
}
rs.close();
stmt.close();
con.close();
}
catch(ClassNotFoundException e){
strError2 = e.toString();
}
catch(SQLException e){
strError2 = e.toString();
}
%>
</select>
</div></td>
</tr>
<tr>
<td height="52" align="right">存多少钱</td>
<td height="52" colspan="-3" align="right"><label>
<div align="left">
<input type="text" name="cqmoney">
</div>
</label></td>
</tr>
<tr>
<td height="52" align="right">备注</td>
<td height="52" colspan="-3" align="right"><label>
<div align="left">
<input type="text" name="cqbeizhu">
</div>
</label></td>
</tr>
<tr>
<td height="51" align="center"><label>
<input type="submit" name="Submit" value="提交" onClick="check()">
</label></td>
<td height="51" align="center"><input type="button" name="Submit2" value="返回" onClick="window.history.go(-1);"></td>
</tr>
</table>
</div>
</form>
</TD>
</td>
</tr>
</table></BODY></HTML>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货