📄 sendinfo.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%request.setCharacterEncoding("gb2312");%>
<%@ include file="Connections/myesale.jsp" %>
<%
// *** Edit Operations: declare variables
// set the form action variable
String MM_editAction = request.getRequestURI();
if (request.getQueryString() != null && request.getQueryString().length() > 0) {
String queryString = request.getQueryString();
String tempStr = "";
for (int i=0; i < queryString.length(); i++) {
if (queryString.charAt(i) == '<') tempStr = tempStr + "<";
else if (queryString.charAt(i) == '>') tempStr = tempStr + ">";
else if (queryString.charAt(i) == '"') tempStr = tempStr + """;
else tempStr = tempStr + queryString.charAt(i);
}
MM_editAction += "?" + tempStr;
}
// connection information
String MM_editDriver = null, MM_editConnection = null, MM_editUserName = null, MM_editPassword = null;
// redirect information
String MM_editRedirectUrl = null;
// query string to execute
StringBuffer MM_editQuery = null;
// boolean to abort record edit
boolean MM_abortEdit = false;
// table information
String MM_editTable = null, MM_editColumn = null, MM_recordId = null;
// form field information
String[] MM_fields = null, MM_columns = null;
%>
<%
// *** Update Record: set variables
if (request.getParameter("MM_update") != null &&
request.getParameter("MM_update").toString().equals("form1") &&
request.getParameter("MM_recordId") != null) {
MM_editDriver = MM_myesale_DRIVER;
MM_editConnection = MM_myesale_STRING;
MM_editUserName = MM_myesale_USERNAME;
MM_editPassword = MM_myesale_PASSWORD;
MM_editTable = "orders";
MM_editColumn = "ord_id";
MM_recordId = "" + request.getParameter("MM_recordId") + "";
MM_editRedirectUrl = "checkout.jsp";
String MM_fieldsStr = "ord_toname|value|ord_tel|value|ord_address|value|ord_email|value";
String MM_columnsStr = "ord_toname|',none,''|ord_tel|',none,''|ord_address|',none,''|ord_email|',none,''";
// create the MM_fields and MM_columns arrays
java.util.StringTokenizer tokens = new java.util.StringTokenizer(MM_fieldsStr,"|");
MM_fields = new String[tokens.countTokens()];
for (int i=0; tokens.hasMoreTokens(); i++) MM_fields[i] = tokens.nextToken();
tokens = new java.util.StringTokenizer(MM_columnsStr,"|");
MM_columns = new String[tokens.countTokens()];
for (int i=0; tokens.hasMoreTokens(); i++) MM_columns[i] = tokens.nextToken();
// set the form values
for (int i=0; i+1 < MM_fields.length; i+=2) {
MM_fields[i+1] = ((request.getParameter(MM_fields[i])!=null)?(String)request.getParameter(MM_fields[i]):"");
}
// append the query string to the redirect URL
if (MM_editRedirectUrl.length() != 0 && request.getQueryString() != null) {
MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + request.getQueryString();
}
}
%>
<%
// *** Update Record: construct a sql update statement and execute it
if (request.getParameter("MM_update") != null &&
request.getParameter("MM_recordId") != null) {
// create the update sql statement
MM_editQuery = new StringBuffer("update ").append(MM_editTable).append(" set ");
for (int i=0; i+1 < MM_fields.length; i+=2) {
String formVal = MM_fields[i+1];
String elem;
java.util.StringTokenizer tokens = new java.util.StringTokenizer(MM_columns[i+1],",");
String delim = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
String altVal = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
String emptyVal = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
if (formVal.length() == 0) {
formVal = emptyVal;
} else {
if (altVal.length() != 0) {
formVal = altVal;
} else if (delim.compareTo("'") == 0) { // escape quotes
StringBuffer escQuotes = new StringBuffer(formVal);
for (int j=0; j < escQuotes.length(); j++)
if (escQuotes.charAt(j) == '\'') escQuotes.insert(j++,'\'');
formVal = "'" + escQuotes + "'";
} else {
formVal = delim + formVal + delim;
}
}
MM_editQuery.append((i!=0)?",":"").append(MM_columns[i]).append(" = ").append(formVal);
}
MM_editQuery.append(" where ").append(MM_editColumn).append(" = ").append(MM_recordId);
if (!MM_abortEdit) {
// finish the sql and execute it
Driver MM_driver = (Driver)Class.forName(MM_editDriver).newInstance();
Connection MM_connection = DriverManager.getConnection(MM_editConnection,MM_editUserName,MM_editPassword);
PreparedStatement MM_editStatement = MM_connection.prepareStatement(MM_editQuery.toString());
MM_editStatement.executeUpdate();
MM_connection.close();
// redirect with URL parameters
if (MM_editRedirectUrl.length() != 0) {
response.sendRedirect(response.encodeRedirectURL(MM_editRedirectUrl));
return;
}
}
}
%>
<%
String recsend__MMColParam = "1";
if (session.getValue("ordid") !=null) {recsend__MMColParam = (String)session.getValue("ordid");}
%>
<%
Driver Driverrecsend = (Driver)Class.forName(MM_myesale_DRIVER).newInstance();
Connection Connrecsend = DriverManager.getConnection(MM_myesale_STRING,MM_myesale_USERNAME,MM_myesale_PASSWORD);
PreparedStatement Statementrecsend = Connrecsend.prepareStatement("SELECT * FROM orders WHERE ord_id = " + recsend__MMColParam + "");
ResultSet recsend = Statementrecsend.executeQuery();
boolean recsend_isEmpty = !recsend.next();
boolean recsend_hasData = !recsend_isEmpty;
Object recsend_data;
int recsend_numRows = 0;
%>
<%
String reccust__MMColParam = "1";
if (session.getValue("MM_Username") !=null) {reccust__MMColParam = (String)session.getValue("MM_Username");}
%>
<%
Driver Driverreccust = (Driver)Class.forName(MM_myesale_DRIVER).newInstance();
Connection Connreccust = DriverManager.getConnection(MM_myesale_STRING,MM_myesale_USERNAME,MM_myesale_PASSWORD);
PreparedStatement Statementreccust = Connreccust.prepareStatement("SELECT * FROM customers WHERE username = '" + reccust__MMColParam + "'");
ResultSet reccust = Statementreccust.executeQuery();
boolean reccust_isEmpty = !reccust.next();
boolean reccust_hasData = !reccust_isEmpty;
Object reccust_data;
int reccust_numRows = 0;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>在线购物－填写送货信息</title>
<style type="text/css">
<!--
.style4 {color: #000000}
.样式7 {color: #FFFFFF}
.style5 {font-size: 14px}
.style7 {color: #000000; font-size: 14px; }
.BOX {
border: thick dashed #E68989;
}
.style8 { font-family: "金梅浪漫反白字";
font-weight: bold;
font-size: 24px;
color: #FF7F0F;
}
.style10 {
font-family: "金梅浪漫反白字";
font-size: 36px;
}
.style13 {color: #C70000}
.style6 {color: #009933}
-->
</style>
</head>
<body>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="8"><table width="200" border="3" align="center" cellpadding="2" cellspacing="1" bordercolor="#FFDEC1" class="style6">
<tr>
<td><img src="images/esale_title.jpg" width="760" height="120"></td>
</tr>
</table></td>
</tr>
<tr background="images/life_23.gif">
<td height="20" colspan="8" background="images/line_top.gif"> </td>
</tr>
<tr>
<td width="16" rowspan="3" background="images/line_top.gif"> </td>
<td width="14" rowspan="3" valign="top"> </td>
<td align="right" valign="top"><img src="images/border_ul.gif" width="50" height="51"></td>
<td colspan="2"><div align="center" class="style10"><img src="images/shop_car.gif" width="35" height="35" align="absmiddle"><span class="style13">送货方式</span></div></td>
<td width="50" align="left" valign="top"><img src="images/border_ur.gif" width="50" height="51"></td>
<td width="14" rowspan="3"> </td>
<td width="16" rowspan="3" background="images/line_top.gif"> </td>
</tr>
<tr>
<td width="50" height="172"> </td>
<td width="20%" rowspan="2" valign="top"><table width="100%" border="1" align="center" cellpadding="2" cellspacing="2" bordercolor="#3399FF">
<tr>
<td bgcolor="#FF9900"><div align="center"><font color="#000000" size="2">购物流程</font></div></td>
</tr>
<tr>
<td><div align="justify" class="style4 style5">1.会员登入</div></td>
</tr>
<tr>
<td><div align="center" class="style7">↓</div></td>
</tr>
<tr>
<td><div align="justify" class="style7">2.检查购物內容</div></td>
</tr>
<tr>
<td><div align="center" class="style7">↓</div></td>
</tr>
<tr>
<td bgcolor="#000000"><div align="center" class="style7">
<div align="justify" class="样式7">3.填写寄送信息</div>
</div></td>
</tr>
<tr>
<td><div align="center" class="style7">↓</div></td>
</tr>
<tr>
<td height="20"><div align="justify" class="style7">4.购物结帐确认</div></td>
</tr>
</table></td>
<td rowspan="2" valign="top"><form name="form1" method="POST" action="<%=MM_editAction%>">
<table width="96%" border="0" align="center" cellpadding="2" cellspacing="1" class="BOX">
<tr>
<td width="120"><div align="right"><font color="#000066">收件人：</font></div></td>
<td width="320"><font color="#FF9900" size="2"> </font>
<input name="ord_toname" type="text" id="ord_toname" value="<%=(((reccust_data = reccust.getObject("cust_toname"))==null || reccust.wasNull())?"":reccust_data)%>"></td>
</tr>
<tr>
<td><div align="right"><font color="#000066">联系电话：</font></div></td>
<td><font color="#FF9900" size="2"> </font>
<input name="ord_tel" type="text" id="ord_tel" value="<%=(((reccust_data = reccust.getObject("cust_totel"))==null || reccust.wasNull())?"":reccust_data)%>"></td>
</tr>
<tr>
<td><div align="right"><font color="#000066">住址：</font></div></td>
<td><font color="#FF9900" size="2"> </font>
<input name="ord_address" type="text" id="ord_address" value="<%=(((reccust_data = reccust.getObject("cust_toaddr"))==null || reccust.wasNull())?"":reccust_data)%>" size="40"></td>
</tr>
<tr>
<td><div align="right"><font color="#000066">Email：</font></div></td>
<td><font color="#FF9900" size="2"> </font>
<input name="ord_email" type="text" id="ord_email" value="<%=(((reccust_data = reccust.getObject("cust_toemail"))==null || reccust.wasNull())?"":reccust_data)%>" size="40"></td>
</tr>
<tr>
<td height="70" colspan="2"><table width="80%" height="54" border="0" align="center">
<tr>
<td width="18%"><div align="center"> </div>
<div align="center"> </div>
<div align="center"> </div>
<div align="center"> </div></td>
<td width="68%"><div align="center"><a href="checkout.jsp"><img src="images/ico_next.gif" width="37" height="32" border="0" align="absmiddle"></a><span class="style8">下一步
<input type="submit" name="Submit" value="送出">
</span> </div></td>
<td width="14%"><div align="center"> </div></td>
</tr>
</table></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="form1">
<input type="hidden" name="MM_recordId" value="<%=(((recsend_data = recsend.getObject("ord_id"))==null || recsend.wasNull())?"":recsend_data)%>">
</form> </td>
<td width="50"> </td>
</tr>
<tr>
<td align="right" valign="top"><img src="images/border_dl.gif" width="50" height="51"></td>
<td align="left" valign="top" background="ima"><img src="images/border_dr.gif" width="50" height="51"></td>
</tr>
<tr>
<td height="20" colspan="8" background="images/line_top.gif"> </td>
</tr>
</table>
</body>
</html>
<%
recsend.close();
Statementrecsend.close();
Connrecsend.close();
%>
<%
reccust.close();
Statementreccust.close();
Connreccust.close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -