?? 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%\"> ");
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%\"> ");
out.write("</td>\r\n ");
out.write("</tr>\r\n ");
out.write("<tr>\r\n ");
out.write("<td height=\"24\">密 碼\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> ");
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 \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> ");
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\"> ");
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> ");
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);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -