📄 goods_modify.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.shop.db.connDB"%>
<%@ page import="com.shop.db.chStr"%>
<%
connDB conn=new connDB();
chStr chStr=new chStr();
String PID="";
String goodsname="";
//int TypeID=-1;
int superID1=-1;
int subID1=-1;
String introduce="";
String picture="";
float price=(float)0.0;
float nowprice=(float)0.0;
int sale=0;
int newgoods=0;
PID=request.getParameter("ID");
if (PID!=null && PID!=""){
int ID=Integer.parseInt(PID);
ResultSet rs=conn.executeQuery("select * from V_goods where ID="+ID);
if(!rs.next()){
out.println("<script lanuage='javascript'>alert('您的操作有误!');window.location.href='index.jsp';</script>");
}else{
//TypeID=rs.getInt("TypeID");
superID1=rs.getInt("superID");
subID1=rs.getInt("subID");
goodsname=rs.getString("goodsname");
introduce=rs.getString("introduce");
price=rs.getFloat("Price");
nowprice=rs.getFloat("nowPrice");
picture=rs.getString("picture");
newgoods=rs.getInt("newgoods");
sale=rs.getInt("sale");
}
ResultSet rs_super=conn.executeQuery("select ID,superType from V_type group by ID,superType");
int superID=-1;
String superName="";
if(rs_super.next()){
superID=rs_super.getInt(1);
}else{
out.println("<script language='javascript'>alert('请先录入类别信息!');window.location.href='index.jsp';</script>");
return;
}
int P_superID=-1;
ResultSet rs_sub=null;
//查询所属小类的默认选项
if(request.getParameter("superID")=="" || request.getParameter("superID")==null){
P_superID=superID1;
//superID
}else{
P_superID=Integer.parseInt(request.getParameter("superID"));
}
rs_sub=conn.executeQuery("select * from tb_subType where superType="+P_superID);
int subID=-1;
String subName="";
%>
<html>
<head>
<title>电子商城后台管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../CSS/style.css" rel="stylesheet">
</head>
<script language="javascript">
function mycheck(){
if (form1.goodsName.value==""){
alert("请输入商品名称！");form1.goodsName.focus();return;
}
if (form1.picture.value==""){
alert("请输入图片文件的路径！");form1.picture.focus();return;
}
if (form1.price.value==""){
alert("请输入商品的定价！");form1.price.focus();return;
}
if (isNaN(form1.price.value)){
alert("您输入的定价错误，请重新输入！");form1.price.value="";form1.price.focus();return;
}
if (form1.introduce.value==""){
alert("请输入商品简介！");form1.introduce.focus();return;
}
form1.submit();
}
</script>
<body>
<table width="777" height="192" border="0" align="center" cellpadding="0" cellspacing="0" class="tableBorder">
<tr>
<td>
<jsp:include page="banner.jsp"/>
<table width="777" height="288" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="182" valign="top"><table width="100%" height="431" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" background="../images/manage_02.gif"><jsp:include page="navigation.jsp"/></td>
</tr>
</table></td>
<td align="center" valign="top"><table width="100%" height="120" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" background="../images/manage_center_goodsmodi.gif"><table width="100%" height="36" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="98%" align="right"><a href="superType.jsp">[ <img src="../images/list.gif" width="11" height="13"> 大分类信息管理]</a> <a href="subType.jsp">[ <img src="../images/list.gif" width="11" height="13"> 小分类信息管理]</a> <a href="goods_add.jsp">[ <img src="../images/list.gif" width="11" height="13"> 添加商品信息]</a></td>
<td width="2%"> </td>
</tr>
</table></td>
</tr>
</table>
<table width="92%" height="192" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<form action="goods_modify_deal.jsp" method="post" name="form1">
<table width="100%" border="0" align="center" cellpadding="-2" cellspacing="-2" bordercolordark="#FFFFFF">
<tr>
<td height="27"> 所属大类：</td>
<td width="31%" height="27">
<script language="javascript">
function F_super(val){
var url="";
eval("window.location.href='goods_modify.jsp?superID="+val+"&ID="+form1.ID.value+"'");
}
</script>
<select name="supertype" class="textarea" id="supertype" onChange="F_super(this.value)">
<%rs_super.first();
do{
superID=rs_super.getInt(1);
superName=rs_super.getString(2);
%>
<option value="<%=superID%>"<%if(superID==P_superID){out.println(" selected");/*注意此处的分号*/}%>><%=superName%></option>
<%}while(rs_super.next());%>
</select></td>
<td width="13%" height="27"> 所属小类：</td>
<td width="42%" height="27">
<select name="typeID" class="textarea" id="typeID">
<%while(rs_sub.next()){
subID=rs_sub.getInt(1);
subName=rs_sub.getString(3);
%>
<option value="<%=subID%>"><%=subName%></option>
<%}%>
</select>
</td>
</tr>
<tr>
<td width="14%" height="27"> 商品名称：
<input name="ID" type="hidden" id="ID" value="<%=ID%>"></td>
<td height="27" colspan="3">
<input name="goodsName" type="text" class="Sytle_text" value="<%=goodsname%>" size="50">
</td>
</tr>
<tr>
<td height="16"> 图片文件：</td>
<td height="27" colspan="3">
<input name="picture" type="text" class="Style_upload" id="picture" value="<%=picture%>" size="30">
(此处只填写图片文件路径即可) </td>
</tr>
<tr>
<td height="27" align="center">定 价：</td>
<td height="27"> <input name="price" type="text" class="Sytle_text" id="price3" value="<%=price%>" size="14">
(元)</td><td height="27" align="center">现 价： </td>
<td height="27"> <input name="nowPrice" type="text" class="Sytle_text" id="price4" value="<%=nowprice%>" size="14">
(元)</td>
</tr>
<tr>
<td height="45"> 是否新品：</td>
<td> <input name="newGoods" type="radio" class="noborder" value="1"<%if(newgoods==1){out.print(" checked");}%>>
是
<input name="newGoods" type="radio" class="noborder" value="0"<%if(newgoods==0){out.print(" checked");}%>>
否</td>
<td> 是否特价：</td>
<td><input name="sale" type="radio" class="noborder" value="1"<%if(sale==1){out.print(" checked");}%>>
是
<input name="sale" type="radio" class="noborder" value="0"<%if(sale==0){out.print(" checked");}%>>
否</td>
</tr>
<tr>
<td height="103"> 商品简介：</td>
<td colspan="3"><span class="style5"> </span>
<textarea name="introduce" cols="60" rows="5" class="textarea" id="introduce"><%=introduce%></textarea></td>
</tr>
<tr>
<td height="38" colspan="4" align="center">
<input name="Button" type="button" class="btn_grey" value="保存" onClick="mycheck()">
<input name="Submit2" type="reset" class="btn_grey" value="重置">
<input name="Submit3" type="button" class="btn_grey" value="返回" onClick="JScript:history.back()">
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<table width="100%" height="46" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="../images/manage_06.gif"> </td>
</tr>
</table></td>
</tr>
</table>
<table width="777" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="54" align="center"><jsp:include page="copyright.jsp"/></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<%}else{
out.println("<script language='javascript'>alert('您的操作有误!');window.location.href='index.jsp';");
}%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -