forked from maxliaops/Java_Web_Examples
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathmodifyPrice1.jsp
More file actions
112 lines (111 loc) · 3.96 KB
/
modifyPrice1.jsp
File metadata and controls
112 lines (111 loc) · 3.96 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<%@ 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>
<%
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"); cd=rsSpname.getString("cd");
jc=rsSpname.getString("jc"); gg=rsSpname.getString("gg");
bz=rsSpname.getString("bz"); sl=rsSpname.getString("kcsl");
je=rsSpname.getString("kcje"); dj=rsSpname.getString("dj");
spname=rsSpname.getString("spname");
}
%>
<table width="584" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="27" colspan="6" bgcolor="#EEEEEE" class="tableBorder_gray">
<span class="word_deepgrey"> 当前位置：库存管理> </span>价格调整 >>></td>
</tr>
<tr>
<td><br>
<table width="550" cellspacing="1" cellpadding="1">
<form action="modifyPrice1.jsp" method="post" name="form1">
<tr>
<td height="25"> </td>
<td><select name="jgspname" onChange="spChange()">
<option selected>请选择调整价格的商品名称:</option>
<%while(rs.next()){%>
<option value=<%=rs.getString("spname")%>><%=rs.getString("spname")%></option>
<%}%>
</select></td>
<td> </td>
</tr>
<tr>
<td width="54" height="25"> </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 height="25"> </td>
<td>商品名称：
<input type="hidden" name="spname" value="<%=spname%>"><%=spname%></td>
<td>简 称：
<input type="hidden" name="jc" value="<%=jc%>"><%=jc%></td>
</tr>
<tr>
<td height="25"> </td>
<td>规 格:
<input type="hidden" name="gg" value="<%=gg%>"><%=gg%></td>
<td>包 装：
<input type="hidden" name="bz" value="<%=bz%>"><%=bz%></td>
</tr>
<tr>
<td height="25"> </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 height="25"> </td>
<td>单 价：
<input type="text" name="dj" size="15" onBlur="autoje()"></td>
<td> </td>
</tr>
<tr>
<td height="25"> </td>
<td colspan="2" align="center">
<input name="Submit1" type="button" class="btn_grey" id="Submit13" onClick="check()" value="确定">
<input name="Submit2" type="reset" class="btn_grey" 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>
</td></tr></table>
</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>