📄 selectbbs_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import com.bbs.connect.DatabaseConnect;
import org.springframework.jdbc.core.JdbcTemplate;
import javax.sql.DataSource;
public final class selectBbs_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
private static java.util.Vector _jspx_dependants;
private org.apache.jasper.runtime.TagHandlerPool _jspx_tagPool_c_forEach_var_items;
public java.util.List getDependants() {
return _jspx_dependants;
}
public void _jspInit() {
_jspx_tagPool_c_forEach_var_items = org.apache.jasper.runtime.TagHandlerPool.getTagHandlerPool(getServletConfig());
}
public void _jspDestroy() {
_jspx_tagPool_c_forEach_var_items.release();
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=GBK");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("<html>\r\n");
out.write("<head>\r\n");
out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=GBK\">\r\n");
out.write("<title>BBS主题</title>\r\n");
out.write("<meta http-equiv=\"refresh\" content=\"60\">\r\n");
out.write("<script type=\"text/javascript\">\r\n");
out.write("function checkout()\r\n");
out.write("{\r\n");
out.write(" var topname1 = document.getElementById(\"topname\").value;\r\n");
out.write(" if (topname1==null||topname1==\"\")\r\n");
out.write(" {\r\n");
out.write(" alert(\"主题内容为空！\");\r\n");
out.write(" return null;\r\n");
out.write(" }\r\n");
out.write(" document.selectForm.action=\"createtopicservlet.ct\";\r\n");
out.write(" document.selectForm.submit();\r\n");
out.write(" /*\r\n");
out.write(" if (document.getElementById(\"hid2\").value=document.getElementById(\"topname\").value)\r\n");
out.write(" {\r\n");
out.write(" alert(\"涓婚閲嶅悕锛\\uFFFD\");\r\n");
out.write(" }else{\r\n");
out.write(" document.fm2.getElementsByName(\"check\").value = \"1\";\r\n");
out.write(" document.fm2.action=\"createtopicservlet.ct\";\r\n");
out.write(" document.fm2.submit();\r\n");
out.write(" }*/\r\n");
out.write("}\r\n");
out.write("</script>\r\n");
out.write("</head>\r\n");
try{
String sql = "";
sql =
"select TOP 2 a.topicName,count(distinct b.critiquePerson) Number "
+"from topic a left join bbstable b on a.topicname = b.topicname "
+ "group by a.topicName order by Number";
DatabaseConnect dbc = new DatabaseConnect();
DataSource ds = dbc.DatabaseConnect();
JdbcTemplate jt = new JdbcTemplate(ds);
List list = jt.queryForList(sql);
if (list!=null)
{
List pagecontent = new ArrayList();
pagecontent= list;
request.getSession(true).setAttribute("pagecontentUrl",pagecontent);
request.setAttribute("pagecontenturl", pagecontent);
}
}catch(Exception e)
{
e.printStackTrace();
}
out.write("\r\n");
out.write("<body>\r\n");
out.write("<!--getBbsName getBbsAuthor getBbsTime-->\r\n");
out.write("<form name=\"selectForm\" id=\"selectForm\" action=\"bbstopic.ct\" method=\"post\">\r\n");
out.write("<table width=\"50%\" id=\"tb\" border=\"1\">\r\n");
out.write("<tr align=\"center\">\r\n");
out.write("<td>主题名称</td>\r\n");
out.write("<td>参与人数</td>\r\n");
out.write("</tr>\r\n");
out.write("<TBODY>\r\n");
// c:forEach
org.apache.taglibs.standard.tag.rt.core.ForEachTag _jspx_th_c_forEach_0 = (org.apache.taglibs.standard.tag.rt.core.ForEachTag) _jspx_tagPool_c_forEach_var_items.get(org.apache.taglibs.standard.tag.rt.core.ForEachTag.class);
_jspx_th_c_forEach_0.setPageContext(_jspx_page_context);
_jspx_th_c_forEach_0.setParent(null);
_jspx_th_c_forEach_0.setVar("contents");
_jspx_th_c_forEach_0.setItems((java.lang.Object) org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate("${requestScope.pagecontenturl}", java.lang.Object.class, (PageContext)_jspx_page_context, null, false));
int[] _jspx_push_body_count_c_forEach_0 = new int[] { 0 };
try {
int _jspx_eval_c_forEach_0 = _jspx_th_c_forEach_0.doStartTag();
if (_jspx_eval_c_forEach_0 != javax.servlet.jsp.tagext.Tag.SKIP_BODY) {
do {
out.write("\r\n");
out.write("<tr align=\"center\">\r\n");
out.write(" <td>\r\n");
out.write(" <a href=\"#\" onclick=\"javascript:window.open('bbs.jsp?topicname=");
out.write((java.lang.String) org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate("${contents.topicName}", java.lang.String.class, (PageContext)_jspx_page_context, null, false));
out.write("&accounts=");
out.print(request.getParameter("accounts"));
out.write("')\" id=\"\">\r\n");
out.write(" ");
out.write((java.lang.String) org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate("${contents.topicName}", java.lang.String.class, (PageContext)_jspx_page_context, null, false));
out.write("</a></td>\r\n");
out.write(" <td>");
out.write((java.lang.String) org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate("${contents.Number}", java.lang.String.class, (PageContext)_jspx_page_context, null, false));
out.write("</td>\r\n");
out.write("</tr>\r\n");
int evalDoAfterBody = _jspx_th_c_forEach_0.doAfterBody();
if (evalDoAfterBody != javax.servlet.jsp.tagext.BodyTag.EVAL_BODY_AGAIN)
break;
} while (true);
}
if (_jspx_th_c_forEach_0.doEndTag() == javax.servlet.jsp.tagext.Tag.SKIP_PAGE)
return;
} catch (Throwable _jspx_exception) {
while (_jspx_push_body_count_c_forEach_0[0]-- > 0)
out = _jspx_page_context.popBody();
_jspx_th_c_forEach_0.doCatch(_jspx_exception);
} finally {
_jspx_th_c_forEach_0.doFinally();
_jspx_tagPool_c_forEach_var_items.reuse(_jspx_th_c_forEach_0);
}
out.write("\r\n");
out.write("</TBODY>\r\n");
out.write("<tr align=\"center\">\r\n");
out.write(" <td><a href=\"#\" onclick=\"javascript:window.open('topicshow.jsp?accounts=");
out.print(request.getParameter("accounts"));
out.write("')\">更多主题...</a></td>\r\n");
out.write(" <td> </td>\r\n");
out.write("</tr>\r\n");
out.write("\r\n");
out.write("</table>\r\n");
out.write("<!--\r\n");
out.write("<div>\r\n");
out.write(" <span>主题内容：</span><input type=\"text\" size=\"20\" value=\"\" id=\"topname\" name=\"topname\"/>\r\n");
out.write(" <input type=\"button\" name=\"insert\" value=\"新建主题\" id=\"insert\" onclick=\"checkout()\"/><br>\r\n");
out.write("</div>\r\n");
out.write("<input type=\"hidden\" id=\"accounts\" name=\"accounts\" value=\"<=request.getParameter(\"accounts\")>\"/>-->\r\n");
out.write("<!--\r\n");
out.write("<table width=\"200\" border=\"0\" id=\"tb2\">\r\n");
out.write(" <span>涓婚鍚嶇О锛\\uFFFD</span><br>\r\n");
out.write(" <input type=\"text\" size=\"20\" value=\"\" id=\"topname\" name=\"topname\"/><br>\r\n");
out.write(" <input type=\"button\" name=\"insert\" value=\"寤虹珛鏂颁富棰\\uFFFD\" id=\"insert\" onclick=\"checkout()\"/><br>\r\n");
out.write("\r\n");
out.write(" <input type=\"hidden\" id=\"hid1\" name=\"hid1\" value=\"0\"/>\r\n");
out.write(" <input type=\"hidden\" id=\"hid2\" name=\"hid2\" value=\"{sessionScope.topicname1}\"/>\r\n");
out.write(" <input type=\"hidden\" id=\"hid3\" name=\"timehid\" value=\"0\"/>\r\n");
out.write("</table>-->\r\n");
out.write("</form>\r\n");
out.write("</body>\r\n");
out.write("</html>\r\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -