📄 modifyprice1.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.io.*,java.sql.*"%>
<jsp:useBean id="rst" scope="page" class="com.mingri.dbconn.DBResult"/>
<html>
<title>商品价格调整</title>
<link href="../CSS/style.css" rel="stylesheet" type="text/css">
<body bgcolor="#F2F2F2">
<%
request.setCharacterEncoding("gb2312");//对字符串统一编码解决表单提交中的中文乱玛问题
String spbh="",cd="",spname="",jc="",gg="",bz="",sl="",je="",dj="";
String jgspname=request.getParameter("jgspname");
String strSql="select * from tb_kucun ";
String strSpname="select * from tb_kucun where spname='"+jgspname+"'";
ResultSet rs=rst.getResult(strSql);
ResultSet rsSpname=rst.getResult(strSpname);
if(rsSpname.next()){
spbh=rsSpname.getString("id");
spname=rsSpname.getString("spname");
jc=rsSpname.getString("jc");
cd=rsSpname.getString("cd");
gg=rsSpname.getString("gg");
bz=rsSpname.getString("bz");
dj=rsSpname.getString("dj");
sl=rsSpname.getString("kcsl");
je=rsSpname.getString("kcje");
}
%>
<img src="../KCM/modifyprice.gif" width="565" height="70">
<table width="550" cellspacing="1" cellpadding="1">
<form action="modifyPrice1.jsp" method="post" name="form1">
<tr>
<td> </td>
<td><select name="jgspname" onChange="spChange()">
<option selected>请选择调整价格的商品名称:</option>
<%String s1 = null;%>
<%
while(rs.next()){
s1 = rs.getString("spname");
%>
<option value=<%=s1%>><%=s1%></option>
<%}%>
</select></td>
<td> </td>
</tr>
<tr>
<td width="54"> </td>
<td width="228">商品编号:
<input type="hidden" name="spbh" value="<%=spbh%>"><%=spbh%></td>
<td width="256">产 地:
<input type="hidden" name="cd" value="<%=cd%>"> <%=cd%></td>
</tr>
<tr>
<td> </td>
<td>商品名称:
<input type="hidden" name="spname" value="<%=spname%>"><%=spname%></td>
<td>简 称:
<input type="hidden" name="jc" value="<%=jc%>"><%=jc%></td>
</tr>
<tr>
<td> </td>
<td>规 格:
<input type="hidden" name="gg" value="<%=gg%>"><%=gg%></td>
<td>包 装:
<input type="hidden" name="bz" value="<%=bz%>"><%=bz%></td>
</tr>
<tr>
<td> </td>
<td>库存数量:
<input name="kcsl" type="text" size="15" value="<%=sl%>" readonly></td>
<td>库存金额:
<input type="text" name="kcje" size="15" value="<%=je%>"readonly></td>
</tr>
<tr>
<td> </td>
<td>单 价:
<input type="text" name="dj" size="15" onBlur="autoje()"></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><div align="center">
<input name="Submit1" type="button" id="Submit13" value="确定" onClick="check()">
</div></td>
<td><input type="reset" name="Submit2" value="取消"></td>
</tr>
</form>
</table>
<form name="form2" action="modifyPrice.jsp" method="POST">
<input type="hidden" name="hid">
<input type="hidden" name="hkcje">
<input type="hidden" name="hdj">
</form>
<body>
<html>
<script language="JavaScript">
function spChange(){
form1.submit();
}
function autoje(){
if(isNaN(form1.dj.value)){
alert("请输入数字");form1.dj.value=0;form1.dj.focus();return}
form1.kcje.value=form1.dj.value*form1.kcsl.value;
}
function check(){
form2.hid.value=form1.spbh.value;
form2.hkcje.value=form1.kcje.value;
form2.hdj.value=form1.dj.value;
if(form1.dj.value==0){
alert("请输入单价!");form1.dj.focus();return}
form2.submit();
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -