📄 shangpinxiugai1.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>
<style type="text/css">
<!--
.style2 {color: #3333FF;
font-size: 18px;
font-family: "幼圆";
}
.style5 {font-family: "幼圆";
font-size: 18px;
}
.style7 {font-family: "幼圆"; font-size: 18px; color: #0000FF; }
-->
</style>
</head>
<body>
<div align="center">
<%String xinghao=request.getParameter("xinghao");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:e";
Connection con=DriverManager.getConnection(url,"","");
Statement st=con.createStatement();
String strSql="select * from product where xinghao='"+xinghao+"'";
ResultSet rs=st.executeQuery(strSql);
String id=null;
String image=null;
String leixing=null;
xinghao=null;
String maijia=null;
String didian=null;
String jiage=null;
while(rs.next()){
id=rs.getString(1);
image=rs.getString(2);
leixing=rs.getString(3);
xinghao=rs.getString(4);
maijia=rs.getString(5);
didian=rs.getString(6);
jiage=rs.getString(7);
}
%>
</div>
<table width="884" border="0" align="center" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="884" height="40" align="center" valign="top"><span class="style2"><span class="style5"><a href="shangpinshanchu.jsp">商品删除及修改</a>|<a href="shangpinchaxun.jsp">商品查询</a>|<a href="shangpintianjia.htm">商品添加</a></span></span></td>
</tr>
<tr>
<td height="40" align="center" valign="top"><span class="style2"></span></td>
</tr>
<tr>
<td height="40" align="center" valign="top"><font color="#FF0000" size="6" face="华文彩云"><strong>请修改下列信息</strong></font></td>
</tr>
<tr>
<td height="341"><form name="form1" method="post" action="shangpinxiugai2.jsp">
<table width="50%" height="387" border="0" align="center" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td height="41" colspan="2" align="right" valign="middle"><input name="hiddenField" type="hidden" value="<%=id%>"></td>
<td colspan="4" valign="middle"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle"><!--DWLayoutEmptyCell--> </td>
<td colspan="4" valign="middle"><div align="left"><img src="<%=image%>"></div></td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle">产品图片：</td>
<td colspan="4" valign="middle"><input name="tupian" type="text" id="tupian" value="<%=image%>"></td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle">商品类型：</td>
<td colspan="4" valign="middle"><input name="textfield" type="text" value="<%=leixing%>"></td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle">商品型号：</td>
<td colspan="4" valign="middle"> <input name="xinghao" type="text" id="xinghao2" value="<%=xinghao%>"></td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle">卖家：</td>
<td colspan="4" valign="middle"> <input name="maijia" type="text" id="maijia" value="<%=maijia%>"></td>
</tr>
<tr>
<td height="41" colspan="2" align="right" valign="middle">地点：</td>
<td colspan="4" valign="middle"> <input name="didian" type="text" id="didian" value="<%=didian%>"></td>
</tr>
<tr>
<td height="42" colspan="2" align="right" valign="middle">价格：</td>
<td colspan="4" valign="middle"><input name="jiage" type="text" id="jiage" value="<%=jiage%>"></td>
</tr>
<tr>
<td width="77" height="42"> </td>
<td colspan="2" valign="middle"> <div align="center">
<input type="submit" name="Submit" value="修改">
</div></td>
<td width="35"> </td>
<td width="48" valign="middle"> <input type="reset" name="Submit2" value="重填"></td>
<td width="178"> </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="20"></td>
<td width="35"></td>
<td></td>
<td></td>
<td></td>
</tr>
</table>
</form></td>
</tr>
<tr>
<td height="50"><div align="center"></div></td>
</tr>
</table>
<%rs.close();
st.close();%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -