⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 del_iden.jsp

📁 用于后台管理的关于电子商务网站的商品的管理
💻 JSP
字号:
🔍 
<SCRIPT language="javascript">
function backward()
{
      history.back();
}
</SCRIPT>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page info="database handler"%> 
<%@ page import="java.io.*"%> 
<%@ page import="java.util.*"%> 
<%@ page import="java.sql.*"%> 
<%@ page import="javax.servlet.*"%> 
<%@ page import="javax.servlet.http.*"%>

<html>
<head>
<title>北京演出票务网管理中心——确认删除商品信息</title>
</head>

<body>

<%
    StringBuffer url = request.getRequestURL(); 
    if (request.getQueryString() != null) 
    { 
      url.append('?');
      url.append(request.getQueryString()); 
    }
    String delno=null;
    delno=url.toString();
    delno=delno.substring(48);
    
    String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";  
    String sConnStr = "jdbc:odbc:TicketSystem";
    Connection Con = null;
    Statement Stmt = null;
 
    try
    {
    Class.forName(sDBDriver); 
     }
    catch(java.lang.ClassNotFoundException e)
    { 
   out.print("Connect to Database error: " + e.getMessage());
     }
   try 
    {
   Con = DriverManager.getConnection(sConnStr); 
     }
   catch(SQLException e)
   {
   out.print(e.toString());
    }
   
  Stmt = Con.createStatement();    /*创建JDBC声明*/ 
  ResultSet RS= Stmt.executeQuery("SELECT TicketName,Category,TicketAdd,TicketTime,TicketPrice,TicketCount,TicketOrdered,TicketHot,TicketImg,TicketDesc FROM TicketInfo_table WHERE TicketId='"+delno+"'"); 
 while (RS.next()) {
 %>
 <form action="del_succ.jsp" method="post">
 	<input type="hidden" name="TicketId" value="<%=delno%>">
  <table width="50%" border="1" align="center">
 <tbody>
 <tr>
 <td colspan="2"><div align="center"><font size=5><b>请确认你要删除的商品:</b></font>
 <tr>
   <td width="30%" align=center>商品名称：
   <td width="70%"><%=RS.getString("TicketName")%>
 <tr>
   <td width="30%" align=center>商品类别：
  <td width="70%"><%=RS.getString("Category")%>
<tr>
  <td width="30%" align=center>演出场馆：
  <td width="70%"><%=RS.getString("TicketAdd")%>
<tr>
  <td width="30%" align=center>演出时间：
  <td width="70%"><%=RS.getString("TicketTime")%>
<tr>
  <td width="30%" align=center>商品单价：
  <td width="70%"><%=RS.getString("TicketPrice")%>
<tr>
  <td width="30%" align=center>总票量：
  <td width="70%"><%=RS.getString("TicketCount")%>
<tr>
  <td width="30%" align=center>已订票量：
  <td width="70%"><%=RS.getString("TicketOrdered")%>
<tr>
  <td width="30%" align=center>是否热推：
  <td width="70%"><%=RS.getString("TicketHot")%>
<tr>
  <td width="30%" align=center>商品图片：
  <td width="70%"><img src="<%=RS.getString("TicketImg")%>">
<tr>
  <td width="30%" align=center>商品简介：
  <td width="70%"><%=RS.getString("TicketDesc")%>
<tr>
   <td colspan="2"><center><input type="submit" value="删除" />
  	<input type="button" onclick="backward()" value="返回上一步"/></center></td>

<tr>
   </td>
</tr>
</table>

<%
  }
   
%>


</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -