newquestions_jsp.java

来自「jsp_javabean+tomcat的web管理系统！」· Java 代码 · 共 300 行

JAVA
300 行
字号 
package org.apache.jsp.megabusi.xlmt;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import msrv.Pagination;;

public final class newQuestions_jsp extends org.apache.jasper.runtime.HttpJspBase
    implements org.apache.jasper.runtime.JspSourceDependent {

  private static java.util.Vector _jspx_dependants;

  static {
    _jspx_dependants = new java.util.Vector(1);
    _jspx_dependants.add("/megabusi/xlmt/../../verifys.inc");
  }

  public java.util.List getDependants() {
    return _jspx_dependants;
  }

  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=gb2312");
      pageContext = _jspxFactory.getPageContext(this, request, response,
      			"", 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');
      out.write('\n');
      out.write('\r');
      out.write('\n');
      msrv.PurviewVerify pv = null;
      synchronized (_jspx_page_context) {
        pv = (msrv.PurviewVerify) _jspx_page_context.getAttribute("pv", PageContext.PAGE_SCOPE);
        if (pv == null){
          pv = new msrv.PurviewVerify();
          _jspx_page_context.setAttribute("pv", pv, PageContext.PAGE_SCOPE);
        }
      }
      out.write('\r');
      out.write('\n');

 String msrvUserID="",projectID="",contextPath="",relativelyURI="",relativelyFile="";
 if(session.getAttribute("msrvUserID")==null||session.getAttribute("msrvUserID").equals(""))
  {
     out.print("<script>alert('非法进入');window.location='main.jsp';window.parent.carnoc.location='left.jsp'</script>");
	 return;
  }else{
    msrvUserID=(String)session.getAttribute("msrvUserID");
	contextPath=request.getContextPath();
	relativelyURI=request.getRequestURI();
   	relativelyFile=relativelyURI.substring(contextPath.length()+1,relativelyURI.length());    	
  }
 pv.init(Integer.parseInt(msrvUserID),relativelyFile);
 if(!pv.getViewPurview()){
	out.print("<script>alert('你不具有此项权限，请与管理员联系！');</script>");
	return;	
 }

      out.write('\r');
      out.write('\n');
      msrv.NDBConn conn = null;
      synchronized (_jspx_page_context) {
        conn = (msrv.NDBConn) _jspx_page_context.getAttribute("conn", PageContext.PAGE_SCOPE);
        if (conn == null){
          conn = new msrv.NDBConn();
          _jspx_page_context.setAttribute("conn", conn, PageContext.PAGE_SCOPE);
        }
      }
      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=gb2312\">\r\n");
      out.write("<title>无标题文档</title>\r\n");
      out.write("<style type=\"text/css\">\r\n");
      out.write("<!--\r\n");
      out.write("body {\r\n");
      out.write("\tmargin-left: 0px;\r\n");
      out.write("\tmargin-top: 0px;\r\n");
      out.write("\tmargin-right: 0px;\r\n");
      out.write("\tmargin-bottom: 0px;\r\n");
      out.write("}\r\n");
      out.write(".style1 {color: #FFFFFF}\r\n");
      out.write("-->\r\n");
      out.write("</style>\r\n");
      out.write("<script language=\"javascript\" src=\"../../common/script.js\"></script>\r\n");
      out.write("<link href=\"../../css/all.css\" rel=\"stylesheet\" type=\"text/css\">\r\n");
      out.write("</head>\r\n");
      out.write("\r\n");
      out.write("<body>\r\n");

   String sql="";
   ResultSet rs=null;
   sql="select tk_question_id,tk_question,isnull(tk_type,''),isnull(tk_subtype,''),isnull(tk_xinzuo_type,'') from megajoysms.dbo.tk_question order by tk_type,tk_subType";
   try{
      rs=conn.executeQuery(sql);
   }catch(SQLException ex){out.println(ex.getMessage());}
   Pagination pageN=null;  //分页
   int pageNum=1,rows=0,pageSize=0;   //页码及行码,页尺寸
   try{
		pageN=new Pagination(rs);
	  }catch(Exception ex){out.println(ex.getMessage());}
	  if(request.getParameter("pageSize")!=null){  //设置页面尺寸
		 pageSize=Integer.parseInt(request.getParameter("pageSize"));
	  }else pageSize=20;
	  pageN.setPageSize(pageSize);
	  if(request.getParameter("pageNum")!=null){ //设置页码
	   pageNum=Integer.parseInt(request.getParameter("pageNum"));
	   if(pageNum<=0) pageNum=1;
	  }
	pageN.gotoPage(pageNum);

      out.write("\r\n");
      out.write("<table width=\"100%\" height=\"100%\"  border=\"0\" cellpadding=\"0\" cellspacing=\"1\" bgcolor=\"#808080\">\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td height=\"23\">　<span class=\"style1\">后台管理--心灵密探--题库</span></td>\r\n");
      out.write("  </tr>\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td align=\"center\" valign=\"top\" bgcolor=\"#FFFFFF\"><br>      <table width=\"98%\"  border=\"0\" cellpadding=\"0\" cellspacing=\"1\" bgcolor=\"#CCCCCC\">\r\n");
      out.write("      <tr bgcolor=\"#F2F2F2\">\r\n");
      out.write("        <td height=\"20\" colspan=\"6\">\r\n");
      out.write("          <table width=\"100%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
      out.write("            <tr>\r\n");
      out.write("              <td>&nbsp;【心灵密探】题库</td>\r\n");
      out.write("              <td align=\"right\">&nbsp;</td>\r\n");
      out.write("            </tr>\r\n");
      out.write("          </table></td>\r\n");
      out.write("      </tr>\r\n");
      out.write("      <tr align=\"center\">\r\n");
      out.write("        <td width=\"7%\" height=\"17\" bgcolor=\"#FFFFFF\"> 流水号</td>\r\n");
      out.write("        <td width=\"65%\" bgcolor=\"#FFFFFF\">题目</td>\r\n");
      out.write("        <td width=\"4%\" bgcolor=\"#FFFFFF\">分类</td>\r\n");
      out.write("        <td width=\"6%\" bgcolor=\"#FFFFFF\">子分类</td>\r\n");
      out.write("        <td width=\"9%\" bgcolor=\"#FFFFFF\">星座参数</td>\r\n");
      out.write("        <td width=\"9%\" align=\"right\" bgcolor=\"#FFFFFF\"><a href=\"addNewQuestion.jsp\">添加</a>&nbsp;</td>\r\n");
      out.write("      </tr>\r\n");
      out.write("\t  ");

	 if(pageN.getRowsCount()>0){
	   do{
	  
      out.write("\r\n");
      out.write("      <tr>\r\n");
      out.write("        <td height=\"26\" align=\"center\" bgcolor=\"#FFFFFF\">");
      out.print(pageN.getString(1));
      out.write("</td>\r\n");
      out.write("        <td bgcolor=\"#FFFFFF\">");
      out.print(pageN.getString(2));
      out.write("</td>\r\n");
      out.write("        <td align=\"center\" bgcolor=\"#FFFFFF\">");
      out.print(pageN.getString(3));
      out.write("</td>\r\n");
      out.write("        <td align=\"center\" bgcolor=\"#FFFFFF\">");
      out.print(pageN.getString(4));
      out.write("</td>\r\n");
      out.write("        <td align=\"center\" bgcolor=\"#FFFFFF\">");
      out.print(pageN.getString(5));
      out.write("</td>\r\n");
      out.write("        <td align=\"right\" bgcolor=\"#FFFFFF\">");
if(pv.getEditPurview()){
      out.write("<a href=\"editNewQuestion.jsp?qid=");
      out.print(pageN.getString(1));
      out.write("&pageSize=");
      out.print(pageSize);
      out.write("&pageNum=");
      out.print(pageNum);
      out.write("\">修改</a>\r\n");
      out.write("          ");
}
      out.write(" \r\n");
      out.write("\t\t");
if(pv.getDeletePurview()){
      out.write("<a href=\"javascript:deleteConfirm('dealNewQuestion.jsp?cntrl=delete&qid=");
      out.print(pageN.getString(1));
      out.write("')\">删除</a>");
}
      out.write("&nbsp;</td>\r\n");
      out.write("      </tr>\r\n");
      out.write("\t  ");

	      rows++;
        }while(pageN.next()&&rows<pageSize);
      }
	  
      out.write("\r\n");
      out.write("\t  ");

		int pageCount=0;
		pageCount=pageN.getPageCount();
      
      out.write("\r\n");
      out.write("\t  <form name=\"pagiNation\" action=\"questions.jsp\" method=\"post\">\r\n");
      out.write("      <tr align=\"center\" bgcolor=\"F2F2F2\">\r\n");
      out.write("        <td height=\"22\" colspan=\"6\"><font color=\"#FF9900\">共");
      out.print(pageN.getRowsCount());
      out.write("条记录&nbsp;<a href=\"javascript:gotoPage(1);\">首页</a> <a href=\"javascript:gotoPage(");
      out.print(pageN.getCurPage()-1);
      out.write(");\">上一页</a> <a href=\"javascript:gotoPage(");
      out.print(pageN.getCurPage()+1);
      out.write(");\">下一页</a> <a href=\"javascript:gotoPage(");
      out.print(pageCount);
      out.write(");\">末页</a> 页码：");
      out.print(pageN.getCurPage());
      out.write('/');
      out.print(pageCount);
      out.write("页</font>&nbsp;指定：\r\n");
      out.write("          <select size=\"1\" onchange=\"javascript:document.pagiNation.submit()\" name=\"pageNum\">\r\n");
      out.write("            ");
for(int i=1;i<=pageCount;i++){
      out.write("\r\n");
      out.write("            <option ");

								    if(pageNum==i) out.println("selected");
								  
      out.write(" value=\"");
      out.print(i);
      out.write('"');
      out.write('>');
      out.print(i);
      out.write("</option>\r\n");
      out.write("            ");
}
      out.write("\r\n");
      out.write("          </select>\r\n");
      out.write("页每页显示\r\n");
      out.write("<select size=\"1\" onchange=\"javascript:document.pagiNation.submit()\" name=\"pageSize\">\r\n");
      out.write("  ");

								   int pages=10;
								   while(pages<=100){
								 
      out.write("\r\n");
      out.write("  <option\r\n");
      out.write("\t\t\t\t\t\t\t\t  ");
if(pages==pageSize) out.print("selected");
      out.write(" \r\n");
      out.write("\t\t\t\t\t\t\t\t   value=\"");
      out.print(pages);
      out.write('"');
      out.write('>');
      out.print(pages);
      out.write("</option>\r\n");
      out.write("  ");

								     if(pages<50) pages=pages+10;
									 else pages=pages+50;
								   }
								  
      out.write("\r\n");
      out.write("  <option value=\"");
      out.print(pageN.getRowsCount());
      out.write("\">全部</option>\r\n");
      out.write("</select></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("\t </form>\r\n");
      out.write("    </table>  \r\n");
      out.write("    <br></td>\r\n");
      out.write("  </tr>\r\n");
      out.write("</table>\r\n");

 pageN.close();
 conn.close();

      out.write("\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);
    }
  }
}

newquestions_jsp.java - 源码说明

本页面展示了「jsp_javabean+tomcat的web管理系统！」中的 newquestions_jsp.java 源码文件，采用 Java 编程语言编写，共 300 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与JSP相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?