?? supplyadmin.java
字號:
package com.logistic.taglib;
import com.logistic.data.DataConnect;
import com.logistic.business.SupplyManager;
import com.logistic.model.SupplyInfo;
import java.util.Vector;
import javax.servlet.jsp.tagext.TagSupport;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.http.HttpServletRequest;
import java.sql.ResultSet;
import java.sql.Statement;
public class SupplyAdmin extends TagSupport {
private static final long serialVersionUID = 7766184319541530720L;
DataConnect dc=new DataConnect();
Statement stat=null;
ResultSet rs=null;
public int doEndTag() throws JspException{
JspWriter out=pageContext.getOut();
HttpServletRequest request=(HttpServletRequest)pageContext.getRequest();
String str=(String)request.getQueryString();
int page;
if(str==null||str.equals("")){
page=1;
}else{
String[] aa=str.split("=");
page=Integer.parseInt(aa[1]);
}
try{
String sqls=new String("select * from supplytable order by SupplyId ASC");
int count=dc.selectdata(sqls);
int totalpages=0;
if(count%5==0){
totalpages=count/5;
}else{
totalpages=count/5+1;
}
int currentpage=1;
if(page==-4){
currentpage=totalpages;
}else if(page==-3){
currentpage=currentpage+1;
}else if(page==-2){
if(currentpage==1){
currentpage=1;
}else{
currentpage=currentpage-1;
}
}else{
currentpage=1;
}
SupplyManager gm=new SupplyManager();
Vector items=gm.SupplySearch(sqls, page);
//輸出供應(yīng)商信息列表的表頭
out.println("<table width=\"648\" height=\"23\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
out.println("<tr>");
out.println("<td align=\"center\" class=\"style14\">供應(yīng)商信息列表</td>");
out.println("</tr>");
out.println("</table>");
//輸出所有供應(yīng)商信息內(nèi)容
int span=5,j=0;//span標識每頁顯示10條信息，j是一個計數(shù)器
String path=request.getContextPath();
for(int i=0;i<items.size();i++){
SupplyInfo supplyinfo=(SupplyInfo)items.elementAt(i);
//輸出供應(yīng)商編號和編輯刪除鏈接
out.println("<table width=\"648\" height=\"23\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\" bgcolor=\"#FF9966\">");
out.println("<tr>");
out.println("<td width=\"321\" align=\"left\" bgcolor=\"#FF9999\" class=\"code\">"+supplyinfo.getSupplyid()+"</td>");
out.println("<td width=\"139\" align=\"center\" bgcolor=\"#FF9999\">【編輯】/【刪除】</td>");
out.println("<td width=\"174\" align=\"center\" bgcolor=\"#FF9999\"><a href=\""+path+"/viewpage/datamodify/supplymodify.jsp?sid="+supplyinfo.getSupplyid()+"\"><img src=\""+path+"/image/edit.gif\" border=\"0\"></a> " +
"<a href=\"adminsupply.jsp?supplyid="+supplyinfo.getSupplyid()+"\" onClick=\"{if(confirm('此操作將刪除當前記錄!刪除后將不能恢復(fù),您確定執(zhí)行的操作嗎?')){return true;}return false;}\"><img src=\""+path+"/image/delete.gif\" border=\"0\"></a></td>");
out.println("</tr>");
out.println("</table>");
//輸出供應(yīng)商名稱
out.println("<table width=\"648\" height=\"155\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
out.println("<tr>");
out.println("<td width=\"103\" height=\"25\" align=\"right\" valign=\"middle\" class=\"code\">供應(yīng)商名稱:</td>");
out.println("<td width=\"214\" height=\"25\" align=\"left\">"+supplyinfo.getSupplyname()+"</td>");
//輸出供應(yīng)商負責人
out.println("<td width=\"140\" align=\"right\" class=\"code\">供應(yīng)商負責人:</td>");
out.println("<td width=\"173\" align=\"left\">"+supplyinfo.getSupplycharge()+"</td>");
out.println("</tr>");
//輸出供應(yīng)商地址
out.println("<tr>");
out.println("<td height=\"25\" align=\"right\" class=\"code\">供應(yīng)商地址:</td>");
out.println("<td colspan=\"3\" align=\"left\">"+supplyinfo.getSupplyaddress()+"</td>");
out.println("</tr>");
//輸出供應(yīng)商固定電話
out.println("<tr>");
out.println("<td height=\"27\" align=\"right\" class=\"code\">供應(yīng)商固定電話:</td>");
out.println("<td align=\"left\">"+supplyinfo.getSupplyphone()+"</td>");
//輸出供應(yīng)商移動電話
out.println("<td align=\"right\" class=\"code\">供應(yīng)商移動電話:</td>");
out.println("<td align=\"left\">"+supplyinfo.getSupplymobile()+"</td>");
out.println("</tr>");
//輸出供應(yīng)商傳真
out.println("<tr>");
out.println("<td height=\"26\" align=\"right\" class=\"code\">供應(yīng)商傳真:</td>");
out.println("<td align=\"left\">"+supplyinfo.getSupplyfax()+"</td>");
//輸出供應(yīng)商郵件
out.println("<td align=\"right\" class=\"code\">供應(yīng)商郵件:</td>");
out.println("<td>"+supplyinfo.getSupplyemail()+"</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td height=\"25\" align=\"right\" class=\"code\">供應(yīng)商網(wǎng)址:</td>");
out.println("<td colspan=\"2\" align=\"left\">"+supplyinfo.getSupplyhttp()+"</td>");
out.println("<td> </td>");
out.println("</tr>");
out.println("<tr align=\"center\">");
out.println("<td height=\"25\" colspan=\"4\" bgcolor=\"#CCCCCC\"> </td>");
out.println("</tr>");
out.println("</table>");
j++;
if(j==span)break;
}
out.println("<table width=\"648\" height=\"23\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
out.println("<tr>");
out.println("<td width=\"165\" align=\"left\" height=\"23\">頁次:"+currentpage+"/"+totalpages+"頁 每頁5條信息"+count+"</td>");
out.println("<td width=\"357\" align=\"center\"> <a href=\"adminsupply.jsp?arg1=-1\"><img src=\""+path+"/image/begin.jpg\" border=\"0\"></a> " +
"<a href=\"adminsupply.jsp?arg2=-2\"><img src=\""+path+"/image/1-prev.gif\" border=\"0\"></a> " +
"<a href=\"adminsupply.jsp?arg3=-3\"><img src=\""+path+"/image/1-next.gif\" border=\"0\"></a> " +
"<a href=\"adminsupply.jsp?arg4=-4\"><img src=\""+path+"/image/end.jpg\" border=\"0\"></a></td>");
out.println("</tr>");
out.println("</table>");
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
return SKIP_BODY;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -