WebRoot/shenpi/shenpilist.jsp

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

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>
<%
DBO db=new DBO();
request.setCharacterEncoding("gb2312");
ResultSet rs=null;
String sql="";
String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
			 sql="select a.*,b.bt from shenpi a,gongyi b  where  1=1 and a.ywbh=b.gyid";//查询 审批sql语句
			 
			 
			 if(session.getAttribute("yhm")!=null){
			 sql+=" and a.czr='"+session.getAttribute("yhm")+"' and a.zt='已审批'";
			 }
db.open();//打开数据库链接
 rs=db.query(sql);//查询结果
%>
<html>
<head>

<LINK href="<%=path %>/images/style.css" type=text/css rel=stylesheet>

<link rel="stylesheet" type="text/css" media="screen" href="<%=path %>/css/tinyTips.css" />
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
	background-color: #EEF2FB;
}
a:hover{
color:#FF0000;
text-decoration:underline;
}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>审批信息列表</title>
<body>
<%


%>

<form name="form" action="" method="post" >
<font color="#FF0000">
<%
if(request.getAttribute("flag")!=null){
out.println("操作提示："+(String)request.getAttribute("flag"));
}
%>
</font>
<table class="border" width="98%" border="0" align="center" cellpadding="1" cellspacing="0">
  <tr>
    <td height="565" align="center" valign="top" class="bg_low"><table width="100%" height="25" border="0" cellpadding="0" cellspacing="0">
      <tr>