页面中有下拉列表和按钮,点击按钮时传递列表的值,刷新数据库,刷新当前页,不跳转页面。
String sql = "SELECT *FROM tb where xy=7(从列表获取);
//out.print(sql);
ResultSet rs = stmt.executeQuery(sql);
//if (user!=null) {
%>
<form id="frm" name="frm" method="post" action="1.jsp" >
<select name="select">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
</select>
<input type="button" name="Submit" value="提交">
<table width="98%" border="0" cellpadding="2" cellspacing="1" bgcolor="#D1DDAA" align="center" style="margin-top:8px">
<tr bgcolor="#7DD5FF">
<th height="24" colspan="13" background="skin/images/tbg.gif">7天之内过生日的优质客户</th>
</tr>
</table>
</form>