?? qydb.jsp
字號:
<%@page contentType="text/html; charset=gb2312" language="java" errorPage="" %>
<jsp:useBean id="list1" scope="page" class="JXC.web.Lists" />
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
</head><body>
<table width="100%" height="44" border="1" cellspacing="0" cellpadding="0" bordercolor="#FFFFFF">
<tr>
<td bordercolor="#FFFFFF" bgcolor="#206AB3">
<table width="100%" border="0" cellspacing="0" cellpadding="0" bordercolor="#86c2fe">
<tr>
<td bgcolor="#206AB3" bordercolor="#FFFFFF" width="100%" nowrap>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="left">
<tr>
<td align="center" width="100%" >
<font color="#FFFFFF">
企 業(yè) 調(diào) 撥 信 息 管 理</font>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<% String selfweb="qydb"; %>
<table width="20%" >
<tr>
<td >
<a href="<%=selfweb%>_Add.jsp"><img border="0" src="../images/new.jpg"></a></td>
<td height="100%" >
<a href="<%=selfweb%>_Find.jsp"><img border="0" src="../images/find.jpg"></a></td>
<td height="100%" >
<a href="<%=selfweb%>_Print.jsp"><img border="0" src="../images/print.jpg"></a></td>
</tr>
</Table>
<link rel="stylesheet" href="../other/customer.css">
<table width="100%" cellspacing="1" >
<tr>
<td height="100%" colspan="2">
<table width="100%" cellspacing="1" bgcolor="#86c2fe">
<tr bgcolor="#D8EBF5" class="big_b">
<td width="10%"> <div align="center">單據(jù)編號</div></td>
<td width="15%"> <div align="center">源倉庫名稱</div></td>
<td width="15%"> <div align="center">目的倉庫名稱</div></td>
<td width="10%"> <div align="center">業(yè)務員</div></td>
<td width="10%"> <div align="center">調(diào)撥日期</div></td>
<td width="10%"> <div align="center">備注</div></td>
<td width="8%"> <div align="center">查看</div></td>
<td width="8%"> <div align="center">修改</div></td>
<td width="8%"> <div align="center">刪除</div></td>
</tr>
<%
int PageSize=10;
int ShowPage=1;
int PageCount=0;
String Page=request.getParameter("page");
if (Page!=null)
{
ShowPage=Integer.parseInt(Page);
}
list1.setPageSize(PageSize);
list1.setPage(ShowPage);
list1.setSql("qydblist");
if (list1.excute()){
ShowPage=list1.getPage();
PageCount=list1.getPageCount();
PageSize=list1.getPageSize();
for (int i=0;i<PageSize;i++){
String Color="#Ffffff";//"#F4F4E0";
if (i % 2==0)
Color="#F6f6f6";
if (i<list1.getListCount()) {
list1.setRow(i);
String id=list1.getString("id");
%>
<tr bgcolor=<%=Color%> >
<td class='small' ><a href="<%=selfweb%>_bh.jsp?id=<%=id%>&page=<%=ShowPage%>"><%=list1.getString("djbh")%></a></td>
<td class='small' ><%=list1.getString("yckname")%></td>
<td class='small' ><%=list1.getString("ckname")%></td>
<td class='small' ><%=list1.getString("name")%></td>
<td class='small' ><%=list1.getString("Fdate").substring(0,10)%></td>
<td class='small' ><%=list1.getString("memo")%></td>
<td class='small'><a href="<%=selfweb%>_bh.jsp?id=<%=id%>&page=<%=ShowPage%>"><div align="center">查看</div></td>
<td class='small'><a href="<%=selfweb%>_Edit.jsp?id=<%=id%>&page=<%=ShowPage%>"><div align="center">修改</div></td>
<td class='small'><a href="<%=selfweb%>_Del.jsp?id=<%=id%>&page=<%=ShowPage%>" onclick="return window.confirm('你確實要刪除【<%=list1.getString("djbh")%>】嗎？');"><div align="center">刪除</div></td>
</tr>
<% }else{
%>
<tr bgcolor=<%=Color%> >
<td class='small' > </td>
<td class='small' > </td>
<td class='small' > </td>
<td class='small' > </td>
<td class='small' > </td>
<td class='small' > </td>
<td class='small' > </td>
<td class='small' > </td>
<td class='small' > </td>
</tr>
<%
}
}
}
%>
</table></td>
</tr>
<tr>
<td class="small" width="23%" >
<div align="left">[<%=ShowPage%>/<%=PageCount%>頁] </div> <div align="left"> [共<%=list1.getRecordCount()%>條記錄 每頁<%=PageSize%>條]</div>
</td>
<td class="small" width="77%" >
<div align="right" >
<a href="<%=selfweb%>.jsp">第一頁 <a>
<% if (ShowPage==1)
out.println("<img border='0' src='../images/1-prev.gif'>");
else {
%>
<a href="<%=selfweb%>.jsp?page=<%=ShowPage-1%>"><img border="0" src="../images/1-prev.gif"> <a>
<% }
if (ShowPage==PageCount)
out.println("<img border='0' src='../images/1-next.gif'>");
else {%>
<a href="<%=selfweb%>.jsp?page=<%=ShowPage+1%>"><img border="0" src="../images/1-next.gif"> <a>
<% } %>
<a href="<%=selfweb%>.jsp?page=<%=PageCount%>">最后一頁 <a>
</div>
</td>
</tr>
</table>
</body></html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -