自定义table标签和数据展现控件(源码)

package com.doit8.tag; import java.io.IOException; import java.util.List; import javax.servlet.ServletRequest; import javax.servlet.jsp.JspException; import javax.servlet.jsp.JspWriter; import javax.servlet.jsp.PageContext; import javax.servlet.jsp.tagext.JspFragment; import javax.servlet.jsp.tagext.SimpleTagSupport; import com.doit8.tag.util.IQuery; public class TableTag extends SimpleTagSupport{ private String name=""; //控件名 private String width=""; //宽度 private String action=""; //动作处理页面 private boolean showStatusBar=false; //是否显示状态栏 private boolean showTitle=false; //是否显示表头 private List items; //数据项 private int rowId=0; //记录ID private int pageRowCount=10; //每页显示的记录数 private IQuery query; //查询接口 private String sql=""; //查询语句 private boolean isCustomTitle=false; //是否自定义表头 public void doTag() throws JspException, IOException { PageContext pageContext=(PageContext)this.getJspContext(); ServletRequest request=pageContext.getRequest(); JspWriter out=getJspContext().getOut(); JspFragment body=getJspBody(); /*如果有查询语句则执行查询语句自动实现后台翻页如果没有查询语句有数据项则用数据项填充数据表*/ if(!"".equals(sql)) { int pageCount=0; //页数 int page=0; //当前页 String sortby=""; //排序条件 String isOrderStr="true"; if(request.getParameter(name+"_page")!=null) { page=Integer.parseInt(request.getParameter(name+"_page").toString()); } if(request.getParameter(name+"_sortby")!=null) { sortby=request.getParameter(name+"_sortby").toString(); boolean isOrder=true; if(request.getParameter(name+"_order").toString().equals("true")) { isOrder=true; isOrderStr="true"; } else { isOrder=false; isOrderStr="false"; } if(!"".equals(sortby)) { //判断是否有ORDER BY子句 if(sql.toUpperCase().indexOf("ORDER")>0&&sql.toUpperCase().indexOf("BY")>0) { if(isOrder) { sql+=","+sortby; } else { sql+=","+sortby+" DESC"; } } else { if(isOrder) { sql+=" ORDER BY "+sortby; } else { sql+=" ORDER BY "+sortby +" DESC"; } } } } /*根据查询语句取后台翻页的数据项*/ items=query.getListByPage(sql, page, pageRowCount); /* int rowCount=query.getRowCount(); //取总记录数 if(rowCount%pageRowCount==0) { pageCount=rowCount/pageRowCount-1; } else { pageCount=rowCount/pageRowCount; } int showPage=page+1;*/ /*组织数据表HTML输出*/ out.println("<form name=\""+name+"_table_Form\" action=\""+action+"\" method=\"POST\">"); out.println("<div>"); out.println("<table name=\""+name+"\" width=\""+width+"\" border=1 class=\"Content\">"); body.invoke(null); out.println("</table>"); out.println("</div>"); if(showStatusBar) { int rowCount=query.getRowCount(); //取总记录数 if(rowCount%pageRowCount==0) { pageCount=rowCount/pageRowCount-1; } else { pageCount=rowCount/pageRowCount; } int totalPageCount=pageCount+1; int showPageCount=10; //显示页数 int splitPageCount=showPageCount/2; //分割页 int showPagei=0; if(pageCount<=showPageCount) { showPageCount=pageCount+1; } int showPage=page+1; int nextPage=page+1>pageCount?pageCount:page+1; int lastPage=pageCount; int previewPage=page-1<0?0:page-1; out.println("<table width=\"100%\">"); out.println("<tr><td align=\"right\"> "); out.println(showPage+"/"+totalPageCount); out.println("<input type=\"hidden\" id=\""+name+"_page\" name=\""+name+"_page\" value="+page+">"); out.println("<input type=\"hidden\" id=\""+name+"_sortby\" name=\""+name+"_sortby\" value="+sortby+">"); out.println("<input type=\"hidden\" id=\""+name+"_order\" name=\""+name+"_order\" value="+isOrderStr+">"); out.println("<a href=javascript:"+name+"_gotopage(0);>"); out.println("<font title=\"first page\" face=webdings color=#888888>9</font></a>"); out.println("<a href=javascript:"+name+"_gotopage("+previewPage+");>"); out.println("<font title=\"preview page\" face=webdings color=#888888>7</font>"); out.println("</a>"); //计算页数 for(int i=1;i<=showPageCount;i++) { if(pageCount<=showPageCount||page<splitPageCount) { showPagei=i; } else { if(page<=pageCount-showPageCount) { showPagei=i+page-splitPageCount; } else { showPagei=i+(pageCount-showPageCount+1); } } if(showPage==showPagei) { out.println("<font color=red>"+showPagei+"</font>"); } else { int goPage=showPagei-1; out.println("<a href=javascript:"+name+"_gotopage("+goPage+")>"+showPagei+"</a>"); } } out.println("<a href=javascript:"+name+"_gotopage("+nextPage+")>"); out.println("<font title=\"next page\" color=#888888 face=webdings>8</font>"); out.println("</a>"); out.println("<a href=javascript:"+name+"_gotopage("+lastPage+")>"); out.println("<font title=\"last page\" color=#888888 face=webdings>:</font>"); out.println("</a>"); out.println("</td></tr>"); out.println("</table>"); } out.println(createGoPageScript()); out.println(createSortScript()); out.println("</form>"); } else { out.println("<table name=\""+name+"\" width=\""+width+"\" border=1 class=\"Content\">"); body.invoke(null); out.println("</table>"); } } /** * 创建翻页js脚本 * @return */ private String createGoPageScript() { StringBuffer strScript=new StringBuffer(); strScript.append("<script>"); strScript.append("function "+name+"_gotopage(page)"); strScript.append("{"); strScript.append("document.getElementById(\""+name+"_page\").value=page;"); strScript.append("document."+name+"_table_Form.submit();"); strScript.append("}"); strScript.append("</script>"); return strScript.toString(); } /** * 创建排序js脚本 * @return */ private String createSortScript() { StringBuffer strScript=new StringBuffer(); strScript.append("<script>"); strScript.append("function "+name+"_sort(sortCodition)"); strScript.append("{"); strScript.append("if(document.getElementById(\""+name+"_order\").value=='true')"); strScript.append("{document.getElementById(\""+name+"_order\").value='false'}"); strScript.append("else"); strScript.append("{document.getElementById(\""+name+"_order\").value='true'}"); strScript.append("document.getElementById(\""+name+"_sortby\").value=sortCodition;"); strScript.append("document."+name+"_table_Form.submit();"); strScript.append("}"); strScript.append("</script>"); return strScript.toString(); } public void setItems(List items) { this.items = items; } public void setName(String name) { this.name = name; } public void setWidth(String width) { this.width = width; } public void setShowStatusBar(boolean showStatusBar) { this.showStatusBar = showStatusBar; } public void setPageRowCount(int pageRowCount) { this.pageRowCount = pageRowCount; } public void setQuery(IQuery query) { this.query = query; } public void setSql(String sql) { this.sql = sql; } public void setAction(String action) { this.action = action; } public void setShowTitle(boolean showTitle) { this.showTitle = showTitle; }