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

📄 add_succ.jsp

📁 用于后台管理的关于电子商务网站的商品的管理
💻 JSP
字号:
🔍 
<%@ 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>
<%
    String Guidstr=(java.util.UUID.randomUUID()).toString();//
    String tid=Guidstr.substring(0,8);
    
    String tname=request.getParameter("TicketName");
    byte tn[]=tname.getBytes("ISO-8859-1");
    tname=new String(tn);
    
    String cate=request.getParameter("Category");
    byte ca[]=cate.getBytes("ISO-8859-1");
    cate=new String(ca);
    
    String tadd=request.getParameter("TicketAdd");
    byte ta[]=tadd.getBytes("ISO-8859-1");
    tadd=new String(ta);
    
    String tyear=request.getParameter("year");
    String tmonth=request.getParameter("month");
    String tdate=request.getParameter("date");
    String thour=request.getParameter("hour");
    String tmin=request.getParameter("min");
    String ttime=tyear+"-"+tmonth+"-"+tdate+" "+thour+":"+tmin;
    
    String tprice=request.getParameter("TicketPrice");
    
    String tcount=request.getParameter("TicketCount");
    
    String timg=request.getParameter("TicketImg");
    byte ti[]=timg.getBytes("ISO-8859-1");
    timg=new String(ti);
    
    String thot=request.getParameter("TicketHot");
    
    String tdesc=request.getParameter("TicketDesc");
    byte td[]=tdesc.getBytes("ISO-8859-1");
    tdesc=new String(td);

    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();
   String sql = "insert into TicketInfo_table(TicketId,Category,TicketName,TicketAdd,TicketTime,TicketImg,TicketDesc,TicketPrice,TicketHot,TicketCount) values('"+tid+"','"+cate+"','"+tname+"','"+tadd+"','"+ttime+"','"+timg+"','"+tdesc+"','"+tprice+"','"+thot+"','"+tcount+"')";
   Stmt.executeUpdate(sql);
   out.print("商品添加成功！");
%>
    
</body>
</html>

⌨️ 快捷键说明

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