edit_ware.jsp

用JSP写的一个在线购物网站的代码

                选择商品分类:</div></td>
            <td width="5">&nbsp; </td>
            <td width="445"> 
            <% 
			int getid=0;
            sql = "select * from class_big where habitus='"+"0"+"' and dustbin='"+"0"+"'";
            rs=data.executeQuery(sql);
	        if(!rs.next())
	        {%>
              <font color="#FF0000">暂无可使用的类，请添加</font> 
              <%}else{
	        rs.previous();
	        if(rs.next())
	        {
	        getid=rs.getInt("id");
	         %>
              <select name="big_class" onChange="changelocation(document.addware.big_class.options[document.addware.big_class.selectedIndex].value)" size="1" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
                <option selected value="<%=class_big%>"><%=name%></option>
                <%       
             while(rs.next())
		     {
             %>
                <option value="<%=rs.getInt("id")%>"><%=rs.getString("name")%></option>
                <%
              }}}
	         rs.close(); 
			 %>
              </select> <select name="small_class" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
                <%
            sql="select * from class_small where bigid="+class_big;
            rs=data.executeQuery(sql);
			if(!rs.next())
			{%>
                <option value='smallnull'>此类尚空</option>
                <%}else{%>
                <option selected value="<%=class_small%>"><%=smallname%></option>
				<option value='<%=rs.getInt("smallid")%>'><%=rs.getString("name")%></option>
                <%  
            while(rs.next())
            {%>
                <option value="<%=rs.getInt("smallid")%>"><%=rs.getString("name")%></option>
                <% 
            }}
            rs.close();
            %>
              </select></td>
          </tr>
          <tr> 
            <td height="30" colspan="3">　　　　　　　商品名称: 
              <input type="text" name="warename" size="20" maxlength="20" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=warename%>">
              　 　 </td>
          </tr>
          <tr> 
            <td height="30" colspan="3">　　　　　　　市 场 价: 
              <input type="text" size="4" name="marketprice" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=marketprice%>">
              会员价: 
              <input type="text" size="4" name="managerprice" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=managerprice%>">
              VIP价: 
              <input type="text" size="4" name="vipprice" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=vipprice%>">
              　</td>
          </tr>
          <tr> 
            <td height="30" colspan="3">　　　　　　　规　　格: 
              <input type="text" name="specification" size="4" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=specification%>">
              颜　色: 
              <input type="text" name="color" size="4" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=color%>">
              包 装: 
              <input type="text" name="package" size="4" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=getpackage%>"> 
            </td>
          </tr>
          <tr> 
            <td height="30" colspan="3">　　　　　　　商品编号: 
              <input type="text" name="number" size="4" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=number%>">
              商品数量: 
              <input type="text" name="quantity" size="4" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=quantity%>">
              商品单位: 
              <select name="wareunit" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
                <option value='<%=wareunit%>' selected><%=wareunit%></option>
				<option value='件'>件</option>
                <option value='台'>台</option>
                <option value='部'>部</option>
                <option value='套'>套</option>
                <option value='盒'>盒</option>
                <option value='瓶'>瓶</option>
                <option value='块'>块</option>
              </select></td>
          </tr>
          <tr> 
            <td height="30" colspan="3">　　　　　　　生产厂家: 
              <input type="text" name="produce" size="40" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=produce%>"></td>
          </tr>
          <tr> 
            <td height="30" colspan="3">　　　　　　　出厂日期: 
              <input type="text" name="cctime" size="25" maxlength="15" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=cctime%>"></td>
          </tr>
          <tr> 
            <td height="31" colspan="3">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td>　　　　　　　　　　　　　　　　
				  <%if(big_pic.equals("")){%>
				  <img src="../images/nopic.gif" width="80" height="80" border="0">
				  <%}else{%>
				  <img src="../upload/<%=big_pic%>" width="80" height="80" border="0">
				  <%}%></td>
                </tr>
              </table>
              　　　　　　商品大图片: 
              <input type="file" name="big_pic" size="40" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></td>
          </tr>
          <tr> 
            <td height="30" colspan="3">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td height="100">　　　　　　　　　　　　　　　　   <img src="../upload/<%=small_pic%>" width="80" height="80" border="0"></td>
                </tr>
              </table>
              　　　　　　商品小图片: 
              <input type="file" name="small_pic" size="40" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></td>
          </tr>
          <tr> 
            <td colspan="3"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr> 
                  <td width="150" height="100" valign="top"><div align="right"> 
                      <table width="100%" border="0" cellspacing="0" cellpadding="0">
                        <tr> 
                          <td height="15"></td>
                        </tr>
                      </table>
                      商品简单说明: </div></td>
                  <td width="7"></td>
                  <td><textarea name="explain" cols="30" rows="5" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"><%=explain%></textarea></td>
                </tr>
              </table></td>
          </tr>
          <tr> 
            <td colspan="3"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr> 
                  <td width="150" height="160" valign="top"><div align="right"> 
                      <table width="100%" border="0" cellspacing="0" cellpadding="0">
                        <tr> 
                          <td height="15"></td>
                        </tr>
                      </table>
                      商品详细说明:</div></td>
                  <td width="7"></td>
                  <td><textarea name="text" cols="50" rows="10" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"><%=text%></textarea></td>
                </tr>
              </table></td>
          </tr>
          <tr> 
            <td height="30" colspan="3">　　　　　　　是否推荐: 
			<%if(nominate.equals("0")){%>
			<input type="checkbox" name="nominate" value="1">
			<%}else{%>
			<input type="checkbox" name="nominate" value="1" checked>
			<%}%>
              </td>
          </tr>
          <tr> 
            <td colspan="3" height="30">　　　　　　　　添加人: 
              <font color="#FF0000"><%=addware%></font></td>
          </tr>
          <tr> 
            <td height="50" colspan="3"><div align="center"> 
                <input name="submit" type="submit" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="修改">
                <input name="reset" type="reset" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="复位">
              </div></td>
          </tr>
          <tr> 
            <td height="20" colspan="3"> </tr>
        </table></td>
    </tr>
  </table>
  <table width="602" height="25" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td bgcolor="3969A5"></td>
    </tr>
  </table>
</form>
<%}%>