select.jsp

来自「在线购物,只不过写的有点乱」· JSP 代码 · 共 57 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="shopbean.ConnDB"%>
<%@ page import="shopbean.Convert" %>

<%
	ConnDB conn=new ConnDB();
	String t_type="";
	String sql="select t_type from main_type";
	ResultSet rs=conn.doQuery(sql);

 %>
<style type="text/css">
<!--
.STYLE1 {font-size: 12px}
-->
</style>
<script language="javascript">
<!--
	function check_Found(form)
	{
		if(form.select_type.value=="")
		{
			alert("请选择搜索的类型");
			form.select_type.focus();
			return false;
		}
	}
-->	
</script>

<center>
<form action="select_ok.jsp" method="post" onsubmit="return check_Found(this);">
<table width="782" border="1"  bordercolor="#99CCFF" cellpadding="0" cellspacing="0" style="border-collapse:collapse">
  <!--DWLayoutTable-->
  <tr>
    <td width="122" height="45" align="right" bgcolor="#99CCFF"><span class="STYLE1">类型</span>：</td>
    <td width="108" bgcolor="#99CCFF"><select name="select_type">
	<option value="">-商品类型-</option>
    <% 
    	while(rs.next())
    	{
    		t_type=rs.getString("t_type");
     %>
    <option value="<%= t_type %>"><%= t_type %></option>
    <% 
    	}
     %>
    </select>
    </td>
    <td width="58" align="right" bgcolor="#99CCFF"><span class="STYLE1">商品名</span>：</td>
    <td width="230" bgcolor="#99CCFF"><input type="text" name="select_p_name" value="" size="30" /></td>
    <td width="156" bgcolor="#99CCFF"><input type="submit" name="Submit" value=" 搜索 " /></td>
  </tr>
</table>
</form>
</center>