📄 bbs_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 bbs_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;
private org.apache.jasper.runtime.TagHandlerPool _jspx_tagPool_c_if_test;
public java.util.List getDependants() {
return _jspx_dependants;
}
public void _jspInit() {
_jspx_tagPool_c_forEach_var_items = org.apache.jasper.runtime.TagHandlerPool.getTagHandlerPool(getServletConfig());
_jspx_tagPool_c_if_test = org.apache.jasper.runtime.TagHandlerPool.getTagHandlerPool(getServletConfig());
}
public void _jspDestroy() {
_jspx_tagPool_c_forEach_var_items.release();
_jspx_tagPool_c_if_test.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("\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("<script type=\"text/javascript\">\r\n");
out.write("function test(){\r\n");
out.write(" var content = document.getElementById(\"talkContent\").value;\r\n");
out.write(" if (content==null||content==\"\")\r\n");
out.write(" {\r\n");
out.write(" alert(\"发布内容为空！\");\r\n");
out.write(" return null;\r\n");
out.write(" }\r\n");
out.write(" document.bbsform.action=\"bbsreleaseservlet\";\r\n");
out.write(" document.bbsform.submit();\r\n");
out.write("}\r\n");
out.write("</script>\r\n");
out.write("<style type=text/css>\r\n");
out.write("body,td,th,table {\r\n");
out.write("color:#666666;\r\n");
out.write("font-size:12px;\r\n");
out.write("font-family:Arial, Helvetica, sans-serif;\r\n");
out.write("line-height:150%;\r\n");
out.write("}\r\n");
out.write("*{\r\n");
out.write("margin:0px;\r\n");
out.write("padding:0px;\r\n");
out.write("}\r\n");
out.write(".bbs_title {\r\n");
out.write("\ttext-indent:2px;\r\n");
out.write("\tfont-size:16px;\r\n");
out.write("\tfont-weight:bold;\r\n");
out.write("\tcolor:#F40000;\r\n");
out.write("\tborder-bottom: 1px solid #0033FF;\r\n");
out.write("}\r\n");
out.write(".bbs_title1 {\r\n");
out.write("color:#000000;\r\n");
out.write("font-weight:bold;\r\n");
out.write("}\r\n");
out.write(".bbs_line1 {\r\n");
out.write("\tborder-bottom: 1px solid #CACACA;\r\n");
out.write("}\r\n");
out.write(".form_width {\r\n");
out.write("font-family:Arial, Helvetica, sans-serif;\r\n");
out.write("font-size:12px;\r\n");
out.write("}\r\n");
out.write("\r\n");
out.write("body {\r\n");
out.write("\tbackground-color: #EFEDEE;\r\n");
out.write("}\r\n");
out.write("a:link {\r\n");
out.write("\tcolor: #666666;\r\n");
out.write("\ttext-decoration: none;\r\n");
out.write("}\r\n");
out.write("a:visited {\r\n");
out.write("\tcolor: #666666;\r\n");
out.write("\ttext-decoration: none;\r\n");
out.write("}\r\n");
out.write("a:hover {\r\n");
out.write("\tcolor: #003399;\r\n");
out.write("\ttext-decoration: none;\r\n");
out.write("}\r\n");
out.write("a:active {\r\n");
out.write("\tcolor: #003399;\r\n");
out.write("\ttext-decoration: none;\r\n");
out.write("}\r\n");
out.write(".inp-L1 {\r\n");
out.write("\tfont-size:12px;\r\n");
out.write("\tcolor:#00659B;\r\n");
out.write("\tline-height:23px;\r\n");
out.write("\twidth:64px;\r\n");
out.write("\theight:21px;\r\n");
out.write("\tborder:0px;\r\n");
out.write("\tbackground:url(images/button-1.gif) no-repeat;\r\n");
out.write("}\r\n");
out.write(".inp-L2 {\r\n");
out.write("\tfont-size:12px;\r\n");
out.write("\tcolor:#003366;\r\n");
out.write("\tline-height:23px;\r\n");
out.write("\twidth:64px;\r\n");
out.write("\theight:21px;\r\n");
out.write("\tborder:0px;\r\n");
out.write("\tbackground:url(images/button-10.gif) no-repeat;\r\n");
out.write("}\r\n");
out.write("\r\n");
out.write("</style>\r\n");
out.write("</head>\r\n");
String sql = "";
int curPage = 0; //当前的页值。
int maxPage=0; //最大的页数。
int maxRowCount = 0; //最大的行数。
int rowsPerPage = 5; //控制分页的行数。
List list = new ArrayList();
List TaxisResult = new ArrayList();
//request.setCharacterEncoding("GBK");
String str = request.getParameter("topicname");
String topicname="";
char a = str.charAt(0);
int v =(int)a;
if((str!=null)&&(v>=19968&&v<=171941))
{
topicname = request.getParameter("topicname");
}else {
topicname=new String(request.getParameter("topicname").getBytes("ISO8859-1"), "GBK");//request.getParameter("topicname");
}
String username=request.getParameter("accounts");
if ((topicname!=null&&!"".equals(topicname))||(username!=null&&!"".equals(username)))
{
//topicname=new String(request.getParameter("topicname").getBytes("ISO8859-1"));
request.getSession(true).setAttribute("topicname", topicname);
request.getSession(true).setAttribute("accounts", username);
try {
sql = "";
JdbcTemplate jt1 = new JdbcTemplate();
DataSource ds1;
sql =
"select topicName,critiquePerson,critiqueTime,critiqueContent from dbo.bbstable "
+"where topicName ='"+topicname+"' order by critiqueTime";
DatabaseConnect dbc1 = new DatabaseConnect();
ds1 = dbc1.DatabaseConnect();
jt1 = new JdbcTemplate(ds1);
list = jt1.queryForList(sql);
//初始化maxRowCount、maxPage
if (list == null) {
list = new ArrayList();
}
List taxisdatalist = new ArrayList(); //排序后的数据集
List backresult = new ArrayList(); //返回页面数据
List backmaxpage = new ArrayList(); //返回页面数据
List backcurpage = new ArrayList(); //返回当前页
if (list == null) list = new ArrayList();
maxRowCount = list.size();
if (maxRowCount % rowsPerPage == 0) {
maxPage = maxRowCount / rowsPerPage;
}
else {
maxPage = maxRowCount / rowsPerPage + 1;
}
//backmaxpage.add(String.valueOf(maxPage));
taxisdatalist=list;
request.getSession(true).setAttribute("maxPage", maxPage);
if (request.getParameter("page") != null) {
curPage = Integer.parseInt(request.getParameter("page"));
}
if (taxisdatalist!=null&&taxisdatalist.size()>0)
{
if ( (curPage == 0 || curPage == 1) ) {
if (taxisdatalist.size()<=rowsPerPage)
{
rowsPerPage=taxisdatalist.size();
}
for (int i = 0; i < rowsPerPage; i++) {
if ((taxisdatalist.size() == 0)) {//taxisdatalist.size() == (i + 1) ||&&taxisdatalist.size()!=1
break;
}
if (taxisdatalist.get(i) != null) {
backresult.add(taxisdatalist.get(i));
}
}
curPage = 1;
backcurpage.add(String.valueOf(curPage));
request.getSession(true).setAttribute("curpage", curPage);
}
if (curPage > 1) {
for (int i = 0; i < rowsPerPage; i++) {
if (taxisdatalist.size()==((curPage-1) * rowsPerPage + i))
break;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -