📄 dingdanchaxun.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!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">
<!--
body {
}
body,td,th {
font-size: 14px;
}
.style16 {
color: #0099CC;
font-weight: bold;
}
.style18 {
color: #FF6633;
font-weight: bold;
}
.style20 {
font-size: 36px;
color: #FF3300;
}
.style2 {color: #3333FF;
font-size: 18px;
font-family: "幼圆";
}
.style5 {font-family: "幼圆";
font-size: 18px;
}
-->
</style>
<link href="css/ds.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style23 {color: #FF6633}
.style1 {font-size: 16px}
.style3 {font-size: 24px}
.style24 {font-size: 18px; color: #000000; }
.style25 {font-size: 14px}
.style26 {color: #FF9900}
-->
</style>
</head>
<body>
<div align="center">
<p> </p>
<table width="991" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="991" height="7" align="left"> </p> <div align="center"> </div>
<div align="center"></div>
</td>
</tr>
<tr>
<td height="8" align="left"><p> </p>
<p align="center" class="style20">订单查询及删除</p></td>
</tr>
<tr>
<td height="15" align="left"><table width="957" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#C6D8E7">
<tr bgcolor="#E3E4E8" class="style16">
<td width="72"><div align="center" class="style23">
<div align="center">客户名</div>
</div></td>
<td width="89" height="31"><div align="center" class="style18">
<div align="center">地址</div>
</div></td>
<td width="92" class="style16"><div align="center" class="style23">
<div align="center">邮编</div>
</div></td>
<td width="79"><div align="center" class="style23">
<div align="center">电话</div>
</div></td>
<td width="78"><div align="center" class="style23">
<div align="center">email</div>
</div></td>
<td width="73"><div align="center" class="style23">
<div align="center">付款方式</div>
</div></td>
<td width="181"><div align="center" class="style23">
<div align="center">产品信息</div>
</div></td>
<td width="117"><div align="center"><span class="style23">选购日期</span></div></td>
<td width="74"><div align="center"><span class="style23">总计</span></div></td>
</tr>
<%String sql="select name,dizhi,youbian,dianhua,email,fukuan,xinxi,riqi,zonghe from dingdan";
ResultSet rs=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载JDBC驱动程序
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("database:"+e.getMessage());
out.println("驱动没有加载");
}
try
{
Connection conn=DriverManager.getConnection("jdbc:odbc:c","sa","123");
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next())
{String name=rs.getString(1);
%>
<tr>
<td><div align="center"><%=name%>
</div></td>
<td height="25"><div align="center"><%=rs.getString(2)%>
</div></td>
<td><div align="center"><%=rs.getString(3)%></div></td>
<td><div align="center"><%=rs.getString(4)%></div></td>
<td><div align="center"><%=rs.getString(5)%></div></td>
<td><div align="center"><%=rs.getString(6)%></div></td>
<td><div align="center"><%=rs.getString(7)%></div></td>
<td><div align="center"><%=rs.getString(8)%></div></td>
<td><div align="center"><%=rs.getString(9)%>元</div></td>
</tr>
<%} stmt.close();
conn.close();}
catch(SQLException e)
{
System.err.println("executeQuery:"+e.getMessage());
out.println("数据没有写入");
}
%>
</table></td>
</tr>
<tr>
<td height="12" align="center"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="104" align="center"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="34" align="center"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="12" align="center"><p align="center" class="style12"><span class="style2"><span class="style5"></span></span></p></td>
</tr>
<tr>
<td height="27" align="center"><hr size="1" class="style12">
<p align="center" class="style12"> </p>
<p align="center" class="style12"> </p></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -