WebRoot/shenqing/shenqinglist.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>
<%
request.setCharacterEncoding("gb2312");//设置页面字符集
DBO db=new DBO();//初始链接数据库类
String sql="select a.*,b.ckmc,c.spmc from shenqing a,cangku b ,shangpin c where 1=1 and a.ck=b.ckid and a.sp=c.spid order by a.sqid desc ";//查询 申请sql语句
db.open();//打开数据库链接
ResultSet rs=db.query(sql);//查询结果
//申请信息查询
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>申请列表</title>
</head>
<LINK href="../images/style.css" type=text/css rel=stylesheet>
<link rel="stylesheet" type="text/css" media="screen" href="../css/tinyTips.css" />

<body>
<form name="form" action="" method="post" >
<div class=formzone>
<div class=namezone>申请管理</div>
<DIV class=listzone>
<TABLE cellSpacing=0 cellPadding=3 width="100%" align=center border=0>
  <TBODY>
 
				 		<tr align="center" bgcolor="#ebf0f7">
 <td width="9%" height="25" >申请编号</td>
 <td width="9%" height="25" >申请标题</td>
 <td width="9%" height="25" >申请类型</td>
 <td width="9%" height="25" >申请类别</td>
 <td width="9%" height="25" >申请人</td>
 <td width="9%" height="25" >仓库</td>
 <td width="9%" height="25" >数量</td>
 <td width="9%" height="25" >商品</td>
 <td width="9%" height="25" >状态</td>
 <td width="10%">操作</td>
</tr>

			
					<%
					if(rs!=null){
					while(rs.next()){
					%>
                  	  <tr align='center' bgcolor='#FFFFFF' onmouseover='this.style.background="#F2FDFF"' onmouseout='this.style.background="#FFFFFF"'>
 <td height="24" ><%=rs.getString("sqid")%></td>
 <td height="24" ><%=rs.getString("sqbt")%></td>
 <td height="24" ><%=rs.getString("sqlx")%></td>
 <td height="24" ><%=rs.getString("sqlb")%></td>
 <td height="24" ><%=rs.getString("sqsp")%></td>
 <td height="24" ><%=rs.getString("ckmc")%></td>
 <td height="24" ><%=rs.getString("sl")%></td>
 <td height="24" ><%=rs.getString("spmc")%></td>
 <td height="24" ><%=rs.getString("zt")%></td>
<td ><%
if(rs.getString("zt").equals("未审核")){
%><a href="shenqingupdate.jsp?keyid=<%=rs.getString("sqid")%>">审核</a>| <a href="shenqingdelete.jsp?keyid=<%=rs.getString("sqid")%>"   onClick="javascript:if(confirm('是否删除')){return true;}else{return false;}">删除</a><% }%>|<a href="shenqingdetail.jsp?keyid=<%=rs.getString("sqid")%>">查看</a></td>
</tr>