📄 upnum.jsp
字号:
<%@page info="database handler" language="java" import="java.sql.*" import="java.util.*" import="java.io.*"%>
<%@page import="javax.servlet.*"%>
<%@page import="javax.servlet.http.*"%>
<%@page contentType="text/html;charset=gb2312"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改数量</title>
</head>
<body >
<div align="center">
<%String xinghao=request.getParameter("xinghao");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:c";
Connection con=DriverManager.getConnection(url,"","");
Statement st=con.createStatement();
String strSql="select * from buy where xinghao='"+xinghao+"'";
ResultSet rs=st.executeQuery(strSql);
String id=null;
String nu=null;
xinghao=null;
String maijia=null;
String didian=null;
String jiage=null;
while(rs.next()){
id=rs.getString(1);
xinghao=rs.getString(2);
maijia=rs.getString(3);
didian=rs.getString(4);
jiage=rs.getString(5);
nu=rs.getString(6);
}
%>
</div>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td height="40" colspan="3" align="center" valign="top"><font color="#FF0000" size="6" face="华文彩云"><strong>请修改数量</strong></font></td>
</tr>
<tr>
<td height="341" colspan="3"><form name="form1" method="post" action="upnum2.jsp">
<table width="84%" height="315" border="0" align="center" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td height="41" colspan="2" align="right" valign="middle"><!--DWLayoutEmptyCell--> </td>
<td colspan="4" valign="middle">
<div align="left">
<input name="xinghao" type="hidden" id="xinghao" value="<%=xinghao%>">
</div></td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle">商品型号：</td>
<td colspan="4" valign="middle"><div align="left"><%=xinghao%> </div></td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle">卖家：</td>
<td colspan="4" valign="middle"><div align="left"><%=maijia%> </div></td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle">地点：</td>
<td colspan="4" valign="middle"><div align="left"><%=didian%> </div></td>
</tr>
<tr>
<td height="42" colspan="2" align="right" valign="middle">价格：</td>
<td colspan="4" valign="middle"><div align="left"><%=jiage%></div></td>
</tr>
<tr>
<td height="42" colspan="2" align="right" valign="middle">数量：</td>
<td colspan="4" valign="middle">
<div align="left">
<input name="num" type="text" id="num" value="<%=nu%>" size="4" maxlength="4">
</div></td>
</tr>
<tr>
<td width="106" height="42"> </td>
<td colspan="2" valign="middle"> <input type="submit" name="Submit" value="修改"></td>
<td width="56"> </td>
<td width="55" valign="middle"> <input type="reset" name="Submit2" value="重填"></td>
<td width="224"> </td>
</tr>
<tr>
<td height="0"></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="3"></td>
<td width="46"></td>
<td width="5"></td>
<td></td>
<td></td>
<td></td>
</tr>
</table>
</form></td>
</tr>
<tr>
<td width="198" height="50"><div align="center"></div></td>
<td width="134"><div align="center"><a href="gouwuche.jsp">返回购物车</a></div></td>
<td width="268"> </td>
</tr>
</table>
<%rs.close();
st.close();%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -