getdbdatatag.java

基于struts开发的网上书店系统。希望对大家有帮助。JSP JavaBean Struts

package jspTagLib;

import javax.servlet.jsp.JspTagException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.TagSupport;

import book.SeeDataBean;

public class GetDBDataTag extends TagSupport {
    //这是一个自定义的标签，主要用于处理书目列表的显示
    //为了照顾通用性，各种需求都用属性送进来

     //当前页吗
     private int pageno; 
     
     //每页行数
     private int pagesize; 

     //排序目标
     private String targetsort; 
     
     //选择跳转目标
     private String targetselect; 

     //查询条件
     private String query; 
     
     //排序条件
     private String sort; 

     /*
	    下面是属性的get和set方法.注意其方法的命名规则
     */
    public void setPageno(String pageno)
	{
   	this.pageno = Integer.parseInt(pageno);
   } 
   public String getPageno()
   {
   	return new Integer(this.pageno).toString();
   }
   
	public void setPagesize(String pagesize)
	{
   	this.pagesize = Integer.parseInt(pagesize);
   } 
   public String getPagesize()
   {
   	return new Integer(this.pagesize).toString();
   }    

	public void setSort(String sort)
	{
   	this.sort =sort;
   } 
   public String getSort()
   {
   	return this.sort;
   }    


	public void setTargetsort(String targetsort)
	{
   	this.targetsort =targetsort;
   } 
   public String getTargetsort()
   {
   	return this.targetsort;
   }
   
   public void setTargetselect(String targetselect)
	{
   	this.targetselect =targetselect;
   } 
   public String getTargetselect()
   {
   	return this.targetselect;
   }    
   

	public void setQuery(String query)
	{
   	this.query =query;
   } 
   public String getQuery()
   {
   	return this.query;
   }    

  
 public GetDBDataTag()throws ClassNotFoundException
 {
     
 }     
 
 public int doStartTag() throws JspTagException 
 {
    return EVAL_BODY_INCLUDE;
 }    
	

 public int doEndTag()throws JspTagException
{
   try
   {
     			
     SeeDataBean obj=new SeeDataBean();
     			
     String mw[]=obj.selectpage(pageno,pagesize,query,sort);
     			
     String[][] array=obj.selectrow("select * from booktable where "+mw[1]+" Order By "+sort);
     		    		      			
     JspWriter out = pageContext.getOut();
     			
     //需要把页码总数提供给页面，使它可以做进一步处理

     pageContext.setAttribute("pagemax",mw[0]);
            
     out.write("<table border='1'  bgcolor=#fffaf0>");
     out.write("<tr bgcolor=#ffe4b5>");
     out.write("<td width='80' height='20'><a href='"+targetsort+"?Sort=num'>编号</a></td>");
     out.write("<td width='200' height='20'><a href='"+targetsort+"?Sort=title'>书名</a></td>");
     out.write("<td width='180' height='20'><a href='"+targetsort+"?Sort=bookconcern'>出版社</a></td>");
     out.write("<td width='100' height='20'><a href='"+targetsort+"?Sort=price'>单价</a></td>");
     out.write("</tr>");

     for (int i=0;i<array.length;i++)
     {
       out.write("<tr>");
       out.write("<td width='80' height='20'>"+array[i][1]+"</td>");
       out.write("<td width='200' height='20'><a href='"+targetselect+"?Pa="+array[i][0]+"'>"+array[i][2]+"</a></td>");;
       out.write("<td width='180' height='20'>"+array[i][3]+"</td>");
       out.write("<td width='100' height='20'>"+array[i][4]+"</td>");
       out.write("</tr>");
     }
	out.write("</table>");       
	
     }
     catch(Exception e)
     {
	 throw new JspTagException("数据库模块调用错误!"); 
     }
 	  return EVAL_PAGE;
  }
}