displaytag.java

swnglu数据库连接统struts和hinernate

package addressbook.tags;

import hibernatemodel.TAddressbook;
import hibernatemodel.TAddressbookDAO;

import java.util.List;

import javax.servlet.http.HttpSession;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspTagException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.TagSupport;

import model.AddressBookBean;
import model.Constants;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

public final class displayTag extends TagSupport {

	private Log log =
        LogFactory.getLog(this.getClass().getName());


public int doEndTag() throws JspException
{
	JspWriter out = pageContext.getOut();
        HttpSession session = pageContext.getSession();
        TAddressbookDAO myabdao= new TAddressbookDAO();
	try
	{

		String strSql=(String)session.getAttribute(Constants.STRSELECT);
		//利用struts桥连接
		//Vector addressBookBeans=AddressBookBean.search(strSql);//
		//利用hibernate连接
		List addressBookBeans=myabdao.select(strSql);//
		session.setAttribute("abbs", addressBookBeans);
                out.println("<table border=\"2\" cellspacing=\"0\" cellpadding=\"0\">");
                out.println("<tr>");
                out.println("<th>delete</th>");
                out.println("<th>update</th>");
                out.println("<th BGCOLOR=\"#008594\"><b>Name</b></th>");
                out.println("<th BGCOLOR=\"#005540\"><b>Phone<b></th>");
                out.println("<th BGCOLOR=\"#04545f\"><b>Address</b></th>");
                out.println("<th BGCOLOR=\"#04545f\"><b>Email</b></th>");
                out.println("<th ><b>Province</b></th>");
                out.println("</tr>");

                for(int i=0;i<addressBookBeans.size();i++)
                {
                	//利用hibernate连接
                        TAddressbook bean=(TAddressbook)addressBookBeans.get(i);
                      //利用struts桥连接
                        //AddressBookBean bean=(AddressBookBean)addressBookBeans.elementAt(i);//
                        out.println("<tr> ");
                        out.println("<td><a href=\"delete.do?id="+i+"\">delete</a></td>");
                        out.println("<td><a href=\"form/update.jsp?id="+i+"\">update</a></td>");
                        out.println("<td >"+ bean.getName() + "</td>");
                        out.println("<td >"  +bean.getPhone() + "</td>");
                        out.println("<td >"+bean.getAddress()+"</td>");
                        out.println("<td>"+bean.getEmail()+"</td>");
                        out.println("<td>"+bean.getProvince()+"</td>");
                        out.println("</tr> ");
                }

                out.println("</table>");


  }catch (Exception ex)
	{
	  throw new JspTagException("IOException:" + ex.toString());
	}
 	return super.doEndTag();
}
}