📄 blist.jsp

📁 这是一个简单但是很实用的JSP应用实例
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.lang.*,java.io.*,java.util.*" %>
<%@include file="/db/dbPool.inc"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="/lib/main.css" rel="stylesheet" type="text/css">
<title>生产计划确认</title>
<style type="text/css">
<!--
body {
	margin-left: 3px;
	margin-top: 3px;
	margin-right: 3px;
	margin-bottom: 3px;
}
-->
</style>
</head>
<script src="/lib/jsFunc.js"></script>
<jsp:useBean id="pageList" scope="session" class="myLib.PageList" />
<jsp:useBean id="queryBean" scope="page" class="Query.Query"/>
<%
	String sql="";//sql查询语句串
	String whereStr="";
	String query_bID=request.getParameter("query_bID");
	pageList.Init(15,request);//分页初始化
	queryBean.initialize(conn1);//数据库连接初始化
	sql="select * from pTab where cFlags=1";
    if(query_bID!=null && !query_bID.equals("")){
			sql="select * from pTab where cFlags=1 and bID like '%"+query_bID+"%' ";
	}
	sql=pageList.setOrderBy(sql,"bID","desc");
	ResultSet rs=queryBean.executeQuery(sql);
	int recordCount=0;
	if(rs.last())
		recordCount=rs.getRow();
	else
		recordCount=0;
	pageList.splitPage(recordCount);
%>
<BODY style="background-color:#FFFFFF " text="000000" link="000099"  vlink="000099" alink="ff0000" bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
	<tr>
		<td>【<strong><a href="../schManage/index.jsp">生产计划管理</a></strong>→生产计划确认】&nbsp;<a href='../schManage/pDown.jsp'>生产计划下载</a>&nbsp;<a href='../schManage/batchToCal.jsp'>生产计划细化</a>&nbsp;<a href="bList.jsp">生产计划确认</a>&nbsp;<a href="../schManage/sendPlan.jsp">生产计划下发</a></td>
	</tr>
</table>
<br>
>>请选择要确认的批次 
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<form name="queryForm" method="post" action="bList.jsp">
  <td width="240" align="left">批次号:
    <input type="text" name="query_bID" class="border1Pixel"></td>
  <td align="left"><input type="submit" name="btnQuery" onMouseOut="this.style.color='000000'" onMouseOver="this.style.color='FF0000'" class="logonBtn" value="查询"></td>
</form>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
	<tr>
		<td width="100%">
		<table width="100%"  border="1" cellpadding="1" cellspacing="0"  align="center"  class="officeTab"   bordercolor="cccccc">
			<tr height="26"  bgcolor="#efefef"  class="OfficeTitTd" >
				<th width="188" height="26"  align="center"><strong><%=pageList.setSortTit("bID","批次号","按批次号排序","#000099")%></strong></td>
				<th width="213" align="center"><strong><%=pageList.setSortTit("lineID","生产线","按生产线排序","#000099")%></strong></td>
				<th width="213" align="center"><strong><%=pageList.setSortTit("prodID","机型","按机型排序","#000099")%></strong></td>
				<th width="187" align="center"><strong><%=pageList.setSortTit("pNum","计划数","按计划数排序","#000099")%></strong></td>
				<th width="181" align="center"><strong><%=pageList.setSortTit("proTo","贴花后走向","按贴花后走向排序","#000099")%></strong></td>
				<th width="212" align="center"><strong><%=pageList.setSortTit("cFlags","计划状态","按计划状态排序","#000099")%></strong></td>
			</tr>
<%if(recordCount==0){ %>
			<tr bgcolor="#FFFFFF">
				 <td height="25" colspan="7" align="center" class="tdBottom"><b><font color="#FF0000">没有待确认的计划</font></b></td>
			</tr>
<% }else{
		int c=0;
		if(!rs.absolute((pageList.m_curPage-1)*pageList.m_pageSize+1))
			c=pageList.m_pageSize;
		else
			c=0;		
		int i=0;
		String bID="";
		String lineID="";
		String prodID="";
		String sID="";
		int pNum=0;
		String proTo="";
		String cFlags="待确认";
		while( c<pageList.m_pageSize){
			bID=rs.getString("bID");
			lineID=rs.getString("lineID");
			pNum=rs.getInt("pNum");
			prodID=rs.getString("prodID");
			sID=rs.getString("sID");		
			byte temp=rs.getByte("proTo");
			switch(temp)
			{
			    case 1:proTo="整装";break;
				case 2:proTo="包装";break;
				default:proTo="走向未知";
			}
%>
      <tr id="RowItem" class="SelRowItem" bgcolor="#FFFFFF" height="23" > 
        <td align="center"><a href="bInfo.jsp?bID=<%=bID%>&lineID=<%=lineID%>&prodID=<%=prodID%>&sID=<%=sID%>&pNum=<%=pNum%>&proTo=<%=proTo%>"><%=bID%></a></td>
		<td align="center"><%=lineID%></td>
		<td align="center"><%=prodID%></td>
       	<td align="center"><%=pNum%></td>
        <td align="center"><%=proTo%></td>
        <td align="center"><font color="#CC0066"><%=cFlags%></font></td>
      </tr>
<%	
			c++;
			if(!rs.next())
				break;	
		}
}
%>
</table>
<%out.print(pageList.showPage("",false));%>
</td>
</tr>
</table>
</body>
</html>
<%@ include file="/db/dbpoolEnd.inc" %>
<script src="/lib/jsFooter.js"></script>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -