📄 gysquest.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.io.*,java.sql.*"%>
<jsp:useBean id="rst" scope="page" class="com.mingri.dbconn.DBResult"/>
<jsp:useBean id="qu" scope="page" class="com.mingri.info.QuestString"/>
<jsp:useBean id="trans" scope="page" class="com.mingri.chinese.ToChinese"/>
<html>
<title>供应商信息查询</title>
<link href="../CSS/style.css" rel="stylesheet" type="text/css">
<body>
<%
String table="tb_supplier",httpFile="gysquest.jsp";
String pages=request.getParameter("pages");
String cif=request.getParameter("cif");
String ccif=request.getParameter("ccif");
String qvalue=trans.trans(request.getParameter("qvalue"));
qu.setCcif(ccif);qu.setCif(cif);qu.setQValue(qvalue);
String strCount=qu.getCount(table);
if(pages==null||pages.equals("null")){
pages="0";
}
qu.setQuerySql(httpFile,pages,strCount);
ResultSet rs=rst.getResult((String)qu.getString(table));
int i=0,Page=qu.getCurPage(),pagesize=qu.getPageSize();
%>
<form action="../spServletdel" method="post">
<%
while(rs.next()){
%>
<%
if(i>(Page-1)*pagesize-1){
%>
<input type="hidden" name="ID" value=<%=rs.getString("ID")%>>
<table width="500" border="1" cellpadding="-1" cellspacing="0" align="center">
<tr bgcolor="#DDDDDD">
<td height="27" colspan="2" bgcolor="#D9ECFF"><font color="#336699">供应商全称:
<%
String s1=null;
String s2=null;
String s3=null;
String s4=null;
String s5=null;
String s6=null;
String s7=null;
String s8=null;
String s9=null;
String s10=null;
s1=rs.getString("gysname");
s2=rs.getString("jc");
s3=rs.getString("address");
s4=rs.getString("postcode");
s5=rs.getString("tel");
s6=rs.getString("fax");
s7=rs.getString("lxr");
s8=rs.getString("lxrtel");
s9=rs.getString("khyh");
s10=rs.getString("email");
%>
<%=s1%></font></td>
<td bgcolor="#D9ECFF"><font color="#336699">简称:
<%=s2%></font></td>
</tr>
<tr bgcolor="#DDDDDD">
<td width="202" height="28" bgcolor="#D9ECFF"><font color="#336699">地址：
<%=s3%></font></td>
<td width="202" bgcolor="#D9ECFF"><font color="#336699">邮政编码:
<%=s4%></font></td>
<td width="202" bgcolor="#D9ECFF"><font color="#336699">电话:
<%=s5%></font></td>
</tr>
<tr bgcolor="#DDDDDD">
<td width="202" height="28" bgcolor="#D9ECFF"><font color="#336699">传真:
<%=s6%></font></td>
<td width="202" bgcolor="#D9ECFF"><font color="#336699">联系人:
<%=s7%></font></td>
<td width="202" bgcolor="#D9ECFF"><font color="#336699">联系人电话:
<%=s8%></font></td>
</tr>
<tr bgcolor="#DDDDDD">
<td height="29" colspan="2" bgcolor="#D9ECFF"><font color="#336699">E-Mail:
<%=s10%></font></td>
<td bgcolor="#D9ECFF"><font color="#336699">开户银行:
<%=s9%></font></td>
</tr>
<tr>
<td><label>
<input type="submit" name="Submit" value="Edit_gys" />
</label></td>
<td><label>
<input type="submit" name="Submit" value="Del_gys" />
</label></td>
</tr>
</table>
</form>
<br>
<%}i++;}
rs.close();
String str_parameter="&cif="+qu.getCif()+"&ccif="+qu.getCcif()+"&qvalue="+qu.getQValue()+"";
//session.setAttribute("str_parameter",str_parameter);
qu.setStr_parameter(str_parameter);
%>
<%=qu.pageFooter()%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -