📄 spquest.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.io.*,java.sql.*"%>
<%@ page import="com.mingri.info.Quest"%>
<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">
<style type="text/css">
<!--
.style2 {color: #336699}
-->
</style>
<body>
<form name="form1" action="../spServletdel" method="post">
<%
String table="tb_brand",httpFile="spquest.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));//通过qu.getString(table)得到要查询的结果集sql
int i=0,Page=qu.getCurPage(),pagesize=qu.getPageSize();
while(rs.next()){
if(i>(Page-1)*pagesize-1){
%>
<table width="500" height="104" border="1" align="center" cellpadding="-1" cellspacing="0">
<tr bgcolor="#DDDDDD">
<td width="202" height="26" bgcolor="#D9ECFF"><span class="style2">商品编号:</span><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;String s11=null;
s1 = rs.getString("ID");
s2 = rs.getString("spname");
s3 = rs.getString("jc");
s4 = rs.getString("cd");
s5 = rs.getString("dw");
s6 = rs.getString("gg");
s7 = rs.getString("bz");
s8 = rs.getString("ph");
s9 = rs.getString("pzwh");
s10 = rs.getString("gysname");
s11 = rs.getString("memo");
%>
<td width="202" height="26" bgcolor="#D9ECFF"><span class="style2">商品编号:</span><font color="#336699"><input type="text" name="ID" readonly="yes" value=<%=s1%>></font></td>
<td width="185" bgcolor="#D9ECFF"><font color="#336699">规格:
<%=s6%></font></td>
<td width="195" bgcolor="#D9ECFF"><font color="#336699">简称:
<%=s3%></font></td>
</tr>
<tr bgcolor="#DDDDDD">
<td width="202" height="25" bgcolor="#D9ECFF"><font color="#336699">商品名称：
<%=s2%></font></td>
<td width="202" bgcolor="#D9ECFF"><font color="#336699">包装:
<%=s7%></font></td>
<td width="202" bgcolor="#D9ECFF"><font color="#336699">产地:
<%=s4%></font></td>
</tr>
<tr bgcolor="#DDDDDD">
<td width="202" height="24" bgcolor="#D9ECFF"><font color="#336699">批号:
<%=s8%></font></td>
<td width="202" bgcolor="#D9ECFF"><font color="#336699">供应商全称:
<%=s10%></font></td>
<td width="202" bgcolor="#D9ECFF"><font color="#336699">计量单位:
<%=s5%></font></td>
</tr>
<tr bgcolor="#DDDDDD">
<td height="20" bgcolor="#D9ECFF"><font color="#336699">批准文号:
<%=s9%></font></td>
<td colspan="2" bgcolor="#D9ECFF"><font color="#336699">备注:
<%=s11%></font></td>
</tr>
<tr bgcolor="#DDDDDD">
<td><label>
<input type="submit" name="Submit" value="Edit_sp" />
</label></td>
<td><label>
<input type="submit" name="Submit" value="Del_sp" />
</label></td>
</tr>
</table><br>
</form>
<%}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 + -