left_jsp.java

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

package org.apache.jsp;

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 left_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,
      			null, true, 8192, true);
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write("\r\n");
      out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n");
      out.write("\r\n");

connDB conn=new connDB();
ResultSet rs_bbs=conn.executeQuery("select top 5 * from tb_bbs order by INTime desc");
ResultSet rs_sort=conn.executeQuery("select GoodsID,GoodsName, sum(number) as sumNum from V_order_detail group by GoodsName,GoodsID order by sumNum desc");

      out.write("\r\n");
      out.write("<table width=\"100%\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n      ");
      out.write("<tr>\r\n        ");
      out.write("<td height=\"83\" align=\"center\">");
      out.write("<img src=\"images/shop_11.gif\" width=\"182\" height=\"83\">");
      out.write("</td>\r\n      ");
      out.write("</tr>\r\n      ");
      out.write("<tr>\r\n        ");
      out.write("<td height=\"98\" align=\"center\" background=\"images/shop_17.gif\">\t\t  ");
      out.write("<form name=\"form1\" method=\"post\" action=\"Login_U.jsp\">\r\n\t\t  ");
      out.write("<table width=\"100%\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n            ");
      out.write("<tr>\r\n              ");
      out.write("<td width=\"10%\">&nbsp;");
      out.write("</td>\r\n              ");
      out.write("<td width=\"90%\" valign=\"top\" background=\"Images/index_09.gif\">");
      out.write("<table width=\"100%\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                ");
      out.write("<tr>\r\n                  ");
      out.write("<td width=\"94%\" height=\"24\">会员名\r\n                    ");
      out.write("<input name=\"username\" type=\"text\" class=\"txt_grey\" id=\"username\" size=\"16\">");
      out.write("</td>\r\n                  ");
      out.write("<td width=\"6%\">&nbsp;");
      out.write("</td>\r\n                ");
      out.write("</tr>\r\n                ");
      out.write("<tr>\r\n                  ");
      out.write("<td height=\"24\">密&nbsp;&nbsp;码\r\n                    ");
      out.write("<input name=\"PWD\" type=\"password\" class=\"txt_grey\" id=\"PWD\" size=\"16\" onKeydown=\"if(event.keyCode==13) form1.submit();\">");
      out.write("</td>\r\n                  ");
      out.write("<td>&nbsp;");
      out.write("</td>\r\n                ");
      out.write("</tr>\r\n                ");
      out.write("<tr>\r\n                  ");
      out.write("<td height=\"31\">\r\n                    ");
      out.write("<input name=\"Button\" type=\"button\" class=\"btn_grey\" value=\"注册\" onClick=\"window.location.href='register.jsp'\">\r\n                    &nbsp;\r\n                    ");
      out.write("<input name=\"Submit2\" type=\"button\" class=\"btn_grey\" value=\"登录\" onClick=\"checkU(form1)\">                    ");
      out.write("<input name=\"Submit3\" type=\"reset\" class=\"btn_grey\" value=\"重置\">");
      out.write("</td>\r\n                  ");
      out.write("<td>&nbsp;");
      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  ");
      out.write("</form>");
      out.write("</td>\r\n      ");
      out.write("</tr>\r\n    ");
      out.write("</table>\r\n      ");
      out.write("<table width=\"100%\" height=\"155\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n        ");
      out.write("<tr>\r\n          ");
      out.write("<td>");
      out.write("<img src=\"images/shop_22.gif\" width=\"182\" height=\"58\">");
      out.write("</td>\r\n        ");
      out.write("</tr>\r\n        ");
      out.write("<tr>\r\n          ");
      out.write("<td height=\"97\" align=\"center\" valign=\"top\" class=\"tableBorder_l\">");
      out.write("<table width=\"88%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n            ");

			int ID_bbs=0;
			String title="";
			while(rs_bbs.next()){
			  ID_bbs=rs_bbs.getInt(1);
			  title=rs_bbs.getString(2);

      out.write("\r\n\t\t\t");
      out.write("<tr>\r\n              ");
      out.write("<td height=\"24\" class=\"tableBorder_T_dashed\">");
      out.write("<a href=\"bbs_detail.jsp?ID=");
      out.print(ID_bbs);
      out.write("\">");
      out.print(title);
      out.write("</a>");
      out.write("</td>\r\n            ");
      out.write("</tr>\r\n");
			}
      out.write("\r\n          ");
      out.write("</table>");
      out.write("</td>\r\n        ");
      out.write("</tr>\r\n      ");
      out.write("</table>\r\n      ");
      out.write("<table width=\"100%\" height=\"151\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n        ");
      out.write("<tr>\r\n          ");
      out.write("<td height=\"40\" background=\"images/shop_33.gif\">&nbsp;");
      out.write("</td>\r\n        ");
      out.write("</tr>\r\n        ");
      out.write("<tr>\r\n          ");
      out.write("<td align=\"center\" valign=\"top\" class=\"tableBorder_lb\">");
      out.write("<table width=\"88%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n            ");

			int ID_sort=0;
			String goodsname="";
			while(rs_sort.next()){
			  ID_sort=rs_sort.getInt(1);
			  goodsname=rs_sort.getString(2);

      out.write("\r\n\t\t\t");
      out.write("<tr>\r\n              ");
      out.write("<td height=\"20\" class=\"tableBorder_B_dashed\">");
      out.write("<a href=\"goods_detail.jsp?ID=");
      out.print(ID_sort);
      out.write("\">");
      out.print(goodsname);
      out.write("</a>");
      out.write("</td>\r\n            ");
      out.write("</tr>\r\n");
}
      out.write("\r\n          ");
      out.write("</table>\r\n            ");
      out.write("<table width=\"100%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n              ");
      out.write("<tr>\r\n                ");
      out.write("<td>&nbsp;");
      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");
    } 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);
    }
  }
}