<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %> <%@ include file = "../research/inc/incfile.jsp"%> 杭州百货大楼=黄金周英语温情使者征集活动 <% try{ %> <%@ include file = "../research/inc/JDBC.jsp"%> <% String Name="", Age="",BYZS="",Phone="",School="",PhotoPath=""; String sql=""; if(request.getParameter("Name")!=null) Name = con.converStr(request.getParameter("Name")); if(request.getParameter("Age")!=null) Age = request.getParameter("Age"); if(request.getParameter("BYZS")!=null) BYZS = con.converStr(request.getParameter("BYZS")); if(request.getParameter("Phone")!=null) Phone = request.getParameter("Phone"); if(request.getParameter("School")!=null) School = con.converStr(request.getParameter("School")); if(request.getParameter("XCTP")!=null) PhotoPath = con.converStr(request.getParameter("XCTP")); %>
<% sql = "insert into tbl_sign(SS_Id,Name,Age,BYZS,Phone,School,PhotoPath) values("; sql = sql + "'2'" + ",'" + Name + "','" + Age + "','" + BYZS + "','" + Phone + "','" + School + "','" + PhotoPath +"')"; stmt.executeUpdate(sql); out.println(""); %> <% }catch(Exception e){ response.sendRedirect("lose.jsp"); // out.print("操作数据库失败!"); //out.print(e); } %>