📄 shangpinxiugai2.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>
<p>
<%
String image=request.getParameter("tupian");
String xinghao=request.getParameter("xinghao");
String maijia=request.getParameter("maijia");
String didian=request.getParameter("didian");
String jiage=request.getParameter("jiage");
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);
if(!rs.next())
return;
else if(image.equals("")||xinghao.equals("")||maijia.equals("")||didian.equals("")||jiage.equals(""))
{
out.println("请填写完整信息<p><a href=shangpinxiugai1.jsp>返回商品修改页</a></p>");
return;}
%>
<%Statement aa=con.createStatement();
String sql="update product set image='"+image+"',xinghao='"+xinghao+"',maijia='"+maijia+"',didian='"+didian+"',jiage='"+jiage+"'where xinghao='"+xinghao+"'";
aa.executeUpdate(sql);
%>
</p>
<p align="center"><font color="#FF0000" size="+2" face="隶书">商品信息修改成功！</font></p>
<p align="center">修改过的商品信息为：</p>
<table width="60%" border="0" align="center" bgcolor="#E8E8FF">
<tr>
<td><div align="center">产品图片:</div></td>
<td><%out.print(rs.getString("image"));%> </td>
</tr>
<tr>
<td width="30%">
<p align="center">商品型号：</td>
<td width="70%"><%out.print(rs.getString("xinghao"));%></td>
</tr>
<tr>
<td width="30%">
<p align="center">卖家：</td>
<td width="70%"><%out.print(rs.getString("maijia"));%></td>
</tr>
<tr>
<td width="30%">
<p align="center"> 地点：</td>
<td width="70%"><%out.print(rs.getString("didian"));%></td>
</tr>
<tr>
<td width="30%"><p align="center">价格：</td>
<td width="70%"><%out.print(rs.getString("jiage"));%></td>
</tr>
</table>
<p align="center"> </p>
<p>
<%rs.close();
st.close();
aa.close();
%>
</p>
<p align="center"><span class="style2"><span class="style5"><a href="shangpinshanchu.jsp">商品删除及修改</a>|<a href="shangpinchaxun.jsp">商品查询</a>|<a href="shangpintianjia.htm">商品添加</a></span></span></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -