📄 neworderform.jsp
字号:
<%@ page language="java" import="java.util.*" import="java.sql.*" import="db.LineItem"
import="db.Cart"
contentType="text/html;charset=gb2312" %>
<%request.setCharacterEncoding("gb2312");%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ include file="../header.htm"%>
<jsp:useBean id = "connBean" scope="page" class="db.DbAccess"/>
<%
try{
String username = (String)session.getAttribute("username");
Connection conn = connBean.getConnection();
if(conn != null){
java.sql.Statement dstmt = conn.createStatement();
ResultSet rs = dstmt.executeQuery("select * from account where userid = '"+username+"'");
while(rs.next()){
String email = rs.getString("email");
String firstname = rs.getString("firstname");
String lastname = rs.getString("lastname");
String addr1 = rs.getString("addr1");
String addr2 = rs.getString("addr2");
String city = rs.getString("city");
String state = rs.getString("state");
String zip = rs.getString("zip");
String country = rs.getString("country");
String phone = rs.getString("phone");
%>
<table width="100%" border="0">
<tr>
<td width="32%"> </td>
<td width="42%"><form action="submitOrder.jsp" method="post">
<TABLE width="378">
<TR bgcolor=#FFFF88>
<TD colspan=2> <FONT color=#9900CC size=2 face="Verdana, Arial, Helvetica, sans-serif"><B>Payment Details</B></FONT> </TD>
</TR>
<TR bgcolor=#FFFF88>
<TD width="149" bgcolor="#FFFF88"> <font size="1" face="Verdana, Arial, Helvetica, sans-serif">Card Type:</font></TD>
<TD width="217" bgcolor="#FFFF88">
<font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<SELECT name="cardtype">
<OPTION value="visa">visa</OPTION>
<OPTION value="AmericanEexpress">American express </OPTION>
<OPTION value="MasterCard">master card </OPTION>
</SELECT>
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD bgcolor="#FFFF88"> <font size="1" face="Verdana, Arial, Helvetica, sans-serif">Card Number:</font></TD>
<TD bgcolor="#FFFF88"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="creditcard" type="text" value="0000-0000-0000"/>
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD bgcolor="#FFFF88"> <font size="1" face="Verdana, Arial, Helvetica, sans-serif">Expiry Date (y-m-d):</font></TD>
<TD bgcolor="#FFFF88"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="expirydate" type="text" value="2005-11-20"/>
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD colspan=2> <FONT color=#9900CC size=2 face="Verdana, Arial, Helvetica, sans-serif"><B>Billing Address</B></FONT> </TD>
</TR>
</TABLE>
<TABLE width="381">
<TR bgcolor=#FFFF88>
<TD width="144" bgcolor="#FFFF88"> <font size="1" face="Verdana, Arial, Helvetica, sans-serif">First name:</font></TD>
<TD width="225"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="billfirstname" value=<%=firstname%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD bgcolor="#FFFF88"> <font size="1" face="Verdana, Arial, Helvetica, sans-serif">Last name:</font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="billlastname" type="text" value=<%=lastname%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD bgcolor="#FFFF88"> <font size="1" face="Verdana, Arial, Helvetica, sans-serif">Email:</font></TD>
<TD bgcolor="#FFFF88"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="billemail" value=<%=email%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Phone:</font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="billphone" value=<%=phone%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Address 1:</font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="billaddress1" value=<%=addr1%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Address 2:</font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="billaddress2" value=<%=addr2%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> City: </font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="billcity" value=<%=city%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> State:</font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="billstate" value=<%=state%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Zip:</font></TD>
<TD bgcolor="#FFFF88"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="billzip" value=<%=zip%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Country: </font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="billcountry" value=<%=country%> />
</font></TD>
</TR>
</TABLE>
<div align="center"></div>
<TABLE width="383">
<TR bgcolor=#FFFF88>
<TD colspan=2> <FONT color=#9900CC size=2 face="Verdana, Arial, Helvetica, sans-serif"><B>Shipping Address</B></FONT> </TD>
</TR>
<TR bgcolor=#FFFF88>
<TD width="143"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> First name:</font></TD>
<TD width="228" bgcolor="#FFFF88"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="shipfirstname" value=<%=firstname%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Last name:</font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="shiplastname" type="text" value=<%=lastname%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Email:</font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="shipemail" value=<%=email%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Phone:</font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="shipphone" value=<%=phone%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Address 1:</font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="shipaddress1" value=<%=addr1%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Address 2:</font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="shipaddress2" value=<%=addr2%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> City: </font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="shipcity" value=<%=city%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> State:</font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="shipstate" value=<%=state%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Zip:</font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="shipzip" value=<%=zip%> />
</font></TD>
</TR>
<TR bgcolor=#FFFF88>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Country: </font></TD>
<TD><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="shipcountry" value=<%=country%> />
</font></TD>
</TR>
</TABLE>
<div align="center">
<font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="submit" name="Submit" value="提交">
</font></div>
</form></td>
<td width="26%"> </td>
</tr>
</table>
<%
}
rs.close();
dstmt.close();
conn.close();
}
}
catch(Exception e){
out.println(e.getMessage());
}
%>
<%@include file="../bottom.htm"%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -