addware.jsp

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

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<%
String admin=(String)session.getValue("admin");
if(admin=="" || admin==null)
{%>
<script language="javascript">
alert("请登陆后再执行管理操作");
self.location="index.jsp";
</script>
<%}else{
String sql="select * from admin where admin='"+admin+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="javascript">
alert("对不起，无此管理员帐号");
history.back();
</script>
<%}}%>
<style type="text/css">
<!-- @import url(../images/css.css); -->
</style>
<script language="JavaScript">
function check()
{
 if(document.addware.big_class.value=="" || document.addware.big_class.value==null)
 {
    alert("请添加商品的大类");
	document.addware.big_class.focus();
	return false;
 }
 if(document.addware.small_class.value=="" || document.addware.small_class.value==null )
 {
    alert("请为该大类添加小类后在进行操作");
	document.addware.small_class.focus();
	return false;
 }
 if(document.addware.warename.value.length==0)
 {
    alert("请填写商品名称");
	document.addware.warename.focus();
	return false;
 }
 if(document.addware.marketprice.value.length==0)
 {
    alert("请填写市场价格");
	document.addware.marketprice.focus();
	return false;
 }
 if(document.addware.managerprice.value.length==0)
 {
    alert("请填写会员价格");
	document.addware.managerprice.focus();
	return false;
 }
 if(document.addware.vipprice.value.length==0)
 {
    alert("请填写VIP价格");
	document.addware.vipprice.focus();
	return false;
 }
 if(document.addware.number.value.length==0)
 {
    alert("请填写商品编号");
	document.addware.number.focus();
	return false;
 }
 if(document.addware.small_pic.value.length==0)
 {
    alert("请上传商品的小图片");
	document.addware.small_pic.focus();
	return false;
 }
}
</script>
<%
int count=0;
String sql = "select id,name,bigid,smallid from  class_small order by id desc";
ResultSet rs=data.executeQuery(sql);
%>
<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<%
while(rs.next()) 
{
%>
subcat[<%=count%>] = new Array("<%=rs.getString("name")%>","<%=rs.getInt("bigid")%>","<%=rs.getInt("smallid")%>");
<%
count = count + 1;
}
rs.close();
%>
onecount=<%=count%>;

function changelocation(locationid)
{
document.addware.small_class.length = 0; 
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{ 
document.addware.small_class.options[document.addware.small_class.length] = new Option(subcat[i][0], subcat[i][2]);
}        
}
}    
</script>
<br><br>
<form action="saveware.jsp" method="post" name="addware" onSubmit="return check()" ENCTYPE="multipart/form-data">
<table width="602" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="30" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">添加新商品</font></div></td>
  </tr>
</table>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  <tr>
    <td>
	<table width="600" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
          <tr> 
            <td height="15" colspan="3"></td>
          </tr>
          <tr> 
            <td width="150" height="25" valign="top"><div align="right"> 
                <table width="100%" height="5" border="0" cellpadding="0" cellspacing="0">
                  <tr> 
                    <td height="5"></td>
                  </tr>
                </table>
                选择商品分类:</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="<%=getid%>"><%=rs.getString("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="+getid;
            rs=data.executeQuery(sql);
			if(!rs.next())
			{%>
			<option value='smallnull'>此类尚空</option>
			<%}else{%>
             <option selected 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">
              　 　 </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">
              会员价: 
              <input type="text" size="4" name="managerprice" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
              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">
              　</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">
              颜　色: 
              <input type="text" name="color" size="4" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
              包 装: 
              <input type="text" name="package" size="4" 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">　　　　　　　商品编号: 
              <input type="text" name="number" size="4" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
              商品数量: 
              <input type="text" name="quantity" size="4" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
              商品单位: 
              <select name="wareunit" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
                <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"></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"></td>
          </tr>
          <tr> 
            <td height="31" colspan="3">　　　　　　商品大图片: 
              <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">　　　　　　商品小图片: 
              <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="5"></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"></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="5"></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"></textarea></td>
                </tr>
              </table></td>
          </tr>
          <tr> 
            <td height="30" colspan="3">　　　　　　　是否推荐: 
              <input type="checkbox" name="nominate" value="1"></td>
          </tr>
          <tr> 
            <td height="50" colspan="3"><div align="center"> 
                <input type="submit" value="添加" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
                <input type="reset" value="取消" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
              </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">&nbsp;</td>
    </tr>
  </table>
</form>