📄 query_sellermcsave.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.io.*,java.sql.*" errorPage="errorpage.jsp" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>姓名查询</title>
<style type="text/css">
<!--
.STYLE1 {
font-family: "方正新舒体简体";
font-size: 12px;
}
.STYLE5 {font-size: 12px}
.STYLE7 {font-family: "方正新舒体简体"; font-size: 14px; }
-->
</style>
</head>
<body>
<table width="950" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#99CC33">
<!--DWLayoutTable-->
<tr>
<td height="100" valign="top"><table width="100%" height="100" border="0">
<tr>
<td width="29%"><img src="image/logo1.jpg" width="270" height="100" /></td>
<td width="71%"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="670" height="100">
<param name="movie" value="flash/fm.swf" />
<param name="quality" value="high" />
<embed src="flash/fm.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="670" height="100"></embed>
</object></td>
</tr>
</table></td>
</tr>
<tr>
<td height="20" valign="middle"><img src="image/daoheng.jpg" width="950" height="20" border="0" usemap="#Map" /></td>
</tr>
<tr>
<td height="20" valign="middle"><marquee behavior="scroll" align="bottom" direction="right" bgcolor="#99CC33" width="950" loop="-1" scrollamount="2" scrolldelay="10">
<span class="STYLE1">欢迎光临中南公司科技有限公司</span>
</marquee></td>
</tr>
<tr>
<td height="430" align="center" valign="middle"><table width="500" border="1">
<tr>
<td width="100"><div align="center">姓名</div></td>
<td width="100" valign="middle"><div align="center">经营类型</div></td>
<td width="100"><div align="center">铺位编码</div></td>
<td width="100"><div align="center">可信等级</div></td>
<td width="100"><div align="center">联系方式</div></td>
</tr>
<%
String mc=new String(request.getParameter("mc").getBytes("iso8859_1"),"gbk");
Connection con=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:zn","","");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from seller where mc='"+mc+"'");
while(rs.next()){
%>
<tr><td align=center><font color="#3366FF"><%=mc%></font></td>
<td align=center><font color="#3366FF"><%=rs.getString("style")%></font></td>
<td align=center><font color="#3366FF"><%=rs.getString("bm")%></font></td>
<td align=center><font color="#3366FF"><%=rs.getString("grade")%></font></td>
<td align=center><font color="#3366FF"><%=rs.getString("tel")%></font></td>
<%
}
rs.close();
stmt.close();
con.close();
}catch(Exception e){
out.println(e.getMessage());
}
%>
</table></td>
</tr>
<tr>
<td height="40" valign="top"><table width="100%" border="0">
<tr>
<td height="30" align="center" valign="middle"><span class="STYLE7">本系统适合于在１０２４＊７６８分辨率下使用<br />
联系方式：０７５９－２４７０３３１</span></td>
</tr>
<tr>
<td height="10" bgcolor="#99CC33"> </td>
</tr>
</table></td>
</tr>
</table>
<map name="Map" id="Map"><area shape="rect" coords="55,2,105,22" href="index.html" />
<area shape="rect" coords="134,2,212,17" href="zddh.html" />
<area shape="rect" coords="250,3,324,21" href="scgk.html" />
<area shape="rect" coords="359,4,435,26" href="jyzx.html" />
<area shape="rect" coords="469,3,550,26" href="gkxs.html" />
<area shape="rect" coords="583,3,658,27" href="zszq.html" />
<area shape="rect" coords="695,1,773,21" href="lxwm.html" />
<area shape="rect" coords="804,3,885,30" href="htgl.jsp" />
</map></body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -