right_0002ejsp_jsp.java

电子商务系统 系统主要分为前台和后台。前台包括产品的展示及会员购物等模块

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;
import java.sql.*;
import com.wgh.DB.connDB;

public class right_0002ejsp_jsp extends HttpJspBase {


  private static java.util.Vector _jspx_includes;

  public java.util.List getIncludes() {
    return _jspx_includes;
  }

  public void _jspService(HttpServletRequest request, HttpServletResponse response)
        throws java.io.IOException, ServletException {

    JspFactory _jspxFactory = null;
    javax.servlet.jsp.PageContext pageContext = null;
    HttpSession session = null;
    ServletContext application = null;
    ServletConfig config = null;
    JspWriter out = null;
    Object page = this;
    JspWriter _jspx_out = null;


    try {
      _jspxFactory = JspFactory.getDefaultFactory();
      response.setContentType("text/html; charset=gb2312");
      pageContext = _jspxFactory.getPageContext(this, request, response,
      			"", true, 8192, true);
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write("\r\n");
      out.write("\r\n");

connDB conn=new connDB();
ResultSet rs_superType=conn.executeQuery("select ID,superType from V_Type group by ID,superType order by superType desc");


      out.write("\r\n");
      out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n");
      out.write("<table width=\"100%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n            ");
      out.write("<tr>\r\n              ");
      out.write("<td>");
      out.write("<img src=\"images/shop_20.gif\" width=\"201\" height=\"80\">");
      out.write("</td>\r\n            ");
      out.write("</tr>\r\n            ");
      out.write("<tr>\r\n              ");
      out.write("<td height=\"90\" valign=\"top\">");
      out.write("<table width=\"100%\" height=\"40\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n             ");

			int ID_superType=0;
			String superType="";
			int m=1;
			while(rs_superType.next()){
			  ID_superType=rs_superType.getInt(1);
			  superType=rs_superType.getString(2);
				String sql="select * from V_Type where ID="+ID_superType;
				ResultSet rs_subType=conn.executeQuery(sql);
				String subType="";
				int subID=0;
				//获取记录总数
				rs_subType.last();
				int subType_RC=rs_subType.getRow();
				rs_subType.first();
			 
      out.write("\r\n            ");
      out.write("<tr>\r\n\t\t\t");
      out.write("<td>\r\n\t\t\t\t\t");

					if(subType_RC<=0){
					
      out.write("\r\n\t\t\t\t\t&nbsp;&nbsp;&nbsp;&nbsp;");
      out.write("<img src=\"images/jian_null.gif\" width=\"38\" height=\"16\" border=\"0\">\r\n\t\t\t\t\t");
      out.print(superType);
      out.write("\r\n\t\t\t\t\t");

					}else{
					
      out.write("\r\n\t\t\t\t\t&nbsp;&nbsp;&nbsp;&nbsp;");
      out.write("<a href=\"Javascript:ShowTR(img");
      out.print(m);
      out.write(",OpenRep");
      out.print(m);
      out.write(")\">");
      out.write("<img src=\"images/jia.gif\" border=\"0\" alt=\"展开\" id=\"img");
      out.print(m);
      out.write("\">");
      out.write("</a>\r\n\t\t\t\t\t");
      out.write("<a href=\"Javascript:ShowTR(img");
      out.print(m);
      out.write(",OpenRep");
      out.print(m);
      out.write(")\">");
      out.print(superType);
      out.write("</a>\r\n\t\t\t\t\t");

					}
					
      out.write("\r\n                ");
      out.write("</td>\r\n\t\t\t\t");
if (subType_RC>0){
      out.write("\r\n\t\t\t  ");
      out.write("<tr id=\"OpenRep");
      out.print(m);
      out.write("\" style=\"display:none;\">\r\n\t\t\t   ");
      out.write("<td colspan=\"6\">\r\n\t\t\t\t");
do{
				subType=rs_subType.getString(3);
				subID=rs_subType.getInt(4);
				
      out.write("\r\n\t\t\t     ");
      out.write("<table width=\"100%\"  border=\"0\" cellspacing=\"-2\" cellpadding=\"-2\">\r\n                   ");
      out.write("<tr>\r\n                      ");
      out.write("<td height=\"25\" align=\"center\">");
      out.write("<table width=\"90%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n                  ");
      out.write("<tr onMouseOver=\"this.style.background='#EEEEEE'\" onMouseOut=\"this.style.background=''\">\r\n                    ");
      out.write("<td width=\"15%\">&nbsp;");
      out.write("</td>\r\n                    ");
      out.write("<td width=\"10%\" align=\"center\">");
      out.write("<img src=\"images/folder.gif\" width=\"16\" height=\"16\" border=\"0\"> ");
      out.write("</td>\r\n                    ");
      out.write("<td width=\"75%\">");
      out.write("<a href=\"type.jsp?Type=");
      out.print(subID);
      out.write("\">");
      out.print(subType);
      out.write("</a>");
      out.write("</td>\r\n                  ");
      out.write("</tr>\r\n              ");
      out.write("</table>");
      out.write("</td>\r\n                   ");
      out.write("</tr>\r\n                 ");
      out.write("</table>\r\n\t\t\t\t ");
	m++;  //注意，该条语句一定不能少
				}while(rs_subType.next());
				
      out.write("\r\n\t\t\t   ");
      out.write("</td>\r\n\t\t\t   ");
}
      out.write("\r\n\t\t\t  ");
      out.write("</tr>\r\n");
      out.write("<script language=\"javascript\">\r\nShowTR(img1,OpenRep1)  //设置第1个结点为展开状态\r\nfunction ShowTR(objImg,objTr){\r\n\tif(objTr.style.display == \"\"){\r\n\t\tobjTr.style.display = \"none\";\r\n\t\tobjImg.src = \"images/jia.gif\";\r\n\t\tobjImg.alt = \"展开\";\r\n\t}else{\r\n\t\tobjTr.style.display = \"\";\r\n\t\tobjImg.src = \"images/jian.gif\";\r\n\t\tobjImg.alt = \"折叠\";\r\n\t}\r\n}\r\n");
      out.write("</script>\r\n");
			}
      out.write("\r\n              ");
      out.write("</table>");
      out.write("</td>\r\n            ");
      out.write("</tr>\r\n            ");
      out.write("<tr>\r\n              ");
      out.write("<td height=\"30\" valign=\"bottom\">");
      out.write("<img src=\"images/shop_31.gif\" width=\"201\" height=\"30\">");
      out.write("</td>\r\n            ");
      out.write("</tr>\r\n          ");
      out.write("</table>\r\n            ");
      out.write("<table width=\"100%\" height=\"119\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n              ");
      out.write("<tr>\r\n                ");
      out.write("<td height=\"70\" align=\"center\">");
      out.write("<img src=\"images/ggzs.gif\" width=\"150\" height=\"60\">");
      out.write("</td>\r\n              ");
      out.write("</tr>\r\n              ");
      out.write("<tr>\r\n                ");
      out.write("<td height=\"70\" align=\"center\">");
      out.write("<img src=\"images/ggzs.gif\" width=\"150\" height=\"60\">");
      out.write("</td>\r\n              ");
      out.write("</tr>\r\n              ");
      out.write("<tr>\r\n                ");
      out.write("<td height=\"70\" align=\"center\">");
      out.write("<img src=\"images/ggzs.gif\" width=\"150\" height=\"60\">");
      out.write("</td>\r\n              ");
      out.write("</tr>\r\n            ");
      out.write("</table>");
    } catch (Throwable t) {
      out = _jspx_out;
      if (out != null && out.getBufferSize() != 0)
        out.clearBuffer();
      if (pageContext != null) pageContext.handlePageException(t);
    } finally {
      if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
    }
  }
}