📄 orderdetail.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="BeanLink.DBBean"%>
<jsp:useBean id="db" class="BeanLink.DBBean" scope="page"/>
<%
ResultSet rs=null;
String driver="sun.jdbc.odbc.JdbcOdbcDriver"; //驱动程序
String url="jdbc:odbc:airline"; //数据源的url
String user1="tangbohu"; //连接数据库的用户名
String pass1=""; //连接数据库的口令
String strSQL1; //要执行的sql语句
String strSQL2; //要执行的sql语句
String id=request.getParameter("id");
String dingdanhao=null;
String shangpinName=null;
String userTruename=null;
String userZhengjianhao=null;
String userAddr=null;
String userTel=null;
String fuyan=null;
String chuliFlg=null;
int i=0;
if(!db.initialization(driver,url,user1,pass1)) //进行初始化
{
out.println(db.getHint());
}
else try{
strSQL1="select * from airline_yunhuodingdan with(READCOMMITTED)";//判断是否有用户存在
strSQL1=strSQL1+" where id="+id;
rs=db.executeQuery(strSQL1);
rs.next();
dingdanhao=rs.getString(2);
shangpinName=rs.getString(3);
userTruename=rs.getString(4);
userZhengjianhao=rs.getString(5);
userAddr=rs.getString(6);
userTel=rs.getString(7);
fuyan=rs.getString(8);
chuliFlg=rs.getString(9);
}
catch(SQLException e2){
out.println("数据库异常！");
out.println(e2.toString());
}
finally{
try{
if(rs!=null) rs.close();
}
catch(Exception e){}
}
%>
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<TITLE>订单维护</TITLE>
<LINK HREF="../../../../css/style.css" REL="stylesheet" TYPE="text/css">
</HEAD>
<BODY>
<FORM NAME="form1" METHOD="post" ACTION="orderlist.jsp">
<TABLE WIDTH="780" BORDER="0" ALIGN="CENTER" CELLPADDING="0" CELLSPACING="2">
<TR>
<TD COLSPAN="4" CLASS="TITLE2">订单信息</TD>
</TR>
<TR>
<TD COLSPAN="4"> </TD>
</TR>
<TR>
<TD HEIGHT="13" COLSPAN="4" CLASS="TEXT"> </TD>
</TR>
<TR>
<TD CLASS="RIGHT">订单号：</TD>
<TD WIDTH="216" CLASS="TEXT"><%=dingdanhao%></TD>
<TD WIDTH="139" CLASS="RIGHT">是否完成：</TD>
<TD WIDTH="219" CLASS="TEXT"><%=chuliFlg%></TD>
</TR>
<TR>
<TD CLASS="RIGHT">商品名称：</TD>
<TD COLSPAN="3" CLASS="TEXT"><%=shangpinName%></TD>
</TR>
<TR>
<TD CLASS="RIGHT">真实姓名：</TD>
<TD COLSPAN="3" CLASS="TEXT"><%=userTruename%></TD>
</TR>
<TR>
<TD CLASS="RIGHT">证件号码：</TD>
<TD COLSPAN="3" CLASS="TEXT"><%=userZhengjianhao%></TD>
</TR>
<TR>
<TD CLASS="RIGHT">交货地点：</TD>
<TD COLSPAN="3" CLASS="TEXT"><%=userAddr%></TD>
</TR>
<TR>
<TD CLASS="RIGHT">联系电话： </TD>
<TD COLSPAN="3" CLASS="TEXT"><%=userTel%></TD>
</TR>
<TR>
<TD CLASS="RIGHT">附言：</TD>
<TD COLSPAN="3" CLASS="TEXT"><%=fuyan%></TD>
</TR>
<TR>
<TD COLSPAN="4"><HR COLOR="#999999" SIZE="1"></TD>
</TR>
<TR>
<TD COLSPAN="4">
<CENTER>
<INPUT NAME="return" TYPE="submit" onclick="history.back();"ID="return" VALUE="返回">
</CENTER>
</TD>
</TR>
</TABLE>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -