editware.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.addware.value.length==0)
 {
    alert("请填写商品的添加人");
	document.addware.addware.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>
<%
String small=request.getParameter("small");
int intsmall=Integer.parseInt(small);
String big=request.getParameter("big");
int intbig=Integer.parseInt(big);
String id=request.getParameter("id");
int intid=Integer.parseInt(id);

sql="select * from ware where id='"+intid+"' and class_small='"+intsmall+"' and class_big='"+intbig+"'";
rs=data.executeQuery(sql);
if(rs.next())
{
String warename=rs.getString("warename");
String explain=rs.getString("explain");
String text=rs.getString("text");
int marketprice=rs.getInt("marketprice");
int managerprice=rs.getInt("managerprice");
int vipprice=rs.getInt("vipprice");
String big_pic=rs.getString("big_pic").trim();
String small_pic=rs.getString("small_pic").trim();
String addware=rs.getString("addware");
String censor_yes=rs.getString("censor_yes");
int class_small=rs.getInt("class_small");
int class_big=rs.getInt("class_big");
String nominate=rs.getString("nominate");
String produce=rs.getString("produce");
String specification=rs.getString("specification");
String color=rs.getString("color");
String number=rs.getString("number");
String getpackage=rs.getString("package");
String cctime=rs.getString("cctime");
int quantity=rs.getInt("quantity");
String wareunit=rs.getString("wareunit");

sql="select * from class_big where id='"+class_big+"'";
rs=data.executeQuery(sql);
rs.next();
String name=rs.getString("name");
rs.close();

sql="select * from class_small where bigid='"+class_big+"' and smallid='"+class_small+"'";
rs=data.executeQuery(sql);
rs.next();
String smallname=rs.getString("name");
rs.close();
%>
<form action="upware.jsp" method="post" name="addware" onSubmit="return check()" ENCTYPE="multipart/form-data">
<input type="hidden" name="bigpic" value="<%=big_pic%>">
<input type="hidden" name="smallpic" value="<%=small_pic%>">
<input type="hidden" name="censor_yes" value="<%=censor_yes%>">
<input type="hidden" name="class_big" value="<%=class_big%>">
<input type="hidden" name="class_small" value="<%=class_small%>">
<input type="hidden" name="intid" value="<%=intid%>">
  <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>