baoliaocontent_jsp.java

来自「jsp_javabean+tomcat的web管理系统！」· Java 代码 · 共 541 行 · 第 1/2 页

      out.write("\r\n");
      out.write("          </select></td>\r\n");
      out.write("      </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("        <td bgcolor=\"#FFFDFB\">　长 号 码 \r\n");
      out.write("          <select name=\"longcode\" id=\"longcode\">\r\n");
      out.write("\t\t    <option value=\"\">请选择 ....</option>\r\n");
      out.write("\t\t    ");
try{
		      while(tpcLongCodeRs.next()){
		  
      out.write("\r\n");
      out.write("\t\t    <option ");
if(longcode.equals(tpcLongCodeRs.getString(1))) out.println("selected");
      out.write(" value=\"");
      out.print(tpcLongCodeRs.getString(1));
      out.write('"');
      out.write('>');
      out.print(tpcLongCodeRs.getString(1));
      out.write("</option>\r\n");
      out.write("\t\t    ");
  }
		    }catch(SQLException ex){out.print(ex.getMessage());}
			finally{
			   if(tpcLongCodeRs!=null){
			      tpcLongCodeRs.close();
				  tpcLongCodeRs=null;
			   }
			}
		  
      out.write("\r\n");
      out.write("            </select></td>\r\n");
      out.write("      </tr>\r\n");
      out.write("      <tr>\r\n");
      out.write("        <td bgcolor=\"#FFFDFB\">　手机号码\r\n");
      out.write("          <input name=telphone type=text class=textbox id=\"tic_order\" size=15 value=\"");
      out.print(telphone);
      out.write("\">\r\n");
      out.write("          　　　          </td>\r\n");
      out.write("      </tr>\r\n");
      out.write("      <tr>\r\n");
      out.write("        <td bgcolor=\"#FFFDFB\">　报料名称\r\n");
      out.write("            <select name=blName>\r\n");
      out.write("\t\t    <option value=\"\">请选择 ....</option>\r\n");
      out.write("\t\t    ");
try{
		      while(tpcNameRs.next()){
		  
      out.write("\r\n");
      out.write("\t\t    <option ");
if(blName.equals(tpcNameRs.getString(1))) out.println("selected");
      out.write(" value=\"");
      out.print(tpcNameRs.getString(1));
      out.write('"');
      out.write('>');
      out.print(tpcNameRs.getString(1));
      out.write("</option>\r\n");
      out.write("\t\t    ");
  }
		    }catch(SQLException ex){out.print(ex.getMessage());}
			finally{
			   if(tpcNameRs!=null){
			      tpcNameRs.close();
				  tpcNameRs=null;
			   }
			}
		  
      out.write("\r\n");
      out.write("            </select></td>\r\n");
      out.write("      </tr>\r\n");
      out.write("      <tr>\r\n");
      out.write("        <td align=\"right\" bgcolor=\"#FFFDFB\">　　　\r\n");
      out.write("          <input type=\"submit\" name=\"Submit\" value=\"提交\"> 　 \r\n");
      out.write("          </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("  <tr>\r\n");
      out.write("    <td bgcolor=\"#FFFFFF\">\r\n");
      out.write("\t  <table width=\"100%\"  border=\"0\" cellpadding=\"0\" cellspacing=\"1\" bgcolor=\"#333333\">\r\n");
      out.write("        <tr height=\"16\" align=\"center\" bgcolor=\"#CCCCCC\">\r\n");
      out.write("          ");
 for(int i=1;i<=columns;i++){ 
      out.write("\r\n");
      out.write("\t\t  <td align=\"center\" bgcolor=\"#efefef\"><strong>");
      out.print(rsmd.getColumnName(i));
      out.write("</strong></td>\r\n");
      out.write("\t\t  ");
}
      out.write("\r\n");
      out.write("\t    </tr>\r\n");
      out.write("        ");

   if(pageN.getRowsCount()>0){
	 do{
  
      out.write("\r\n");
      out.write("        <tr bgcolor=\"#FFF4E6\">\r\n");
      out.write("          ");
for(int i=1;i<=columns;i++){ 
      out.write("\r\n");
      out.write("          <td align=\"center\">\r\n");
      out.write("      ");

	    try{

			 if(pageN.getObject(i)==null){
			   out.print("空");
			  }else{
			    out.print(pageN.getObject(i));
			  }

		}catch(SQLException ex){
		   out.println(ex.getMessage());
		}
	  
      out.write("          　</td>\r\n");
      out.write("          ");
}
      out.write("\r\n");
      out.write("\t    </tr>\r\n");
      out.write("        ");

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

	int pageCount=0;
	pageCount=pageN.getPageCount();
  
      out.write("\r\n");
      out.write("        <form name=\"pagiNation\" method=\"post\">\r\n");
      out.write("          <tr>\r\n");
      out.write("            <td colspan=\"");
      out.print(columns);
      out.write("\" align=\"center\" bgcolor=\"#cccccc\"><font color=\"#FF9900\"> 点播次数:");
      out.print(orderCount);
      out.write('　');
      out.write('共');
      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>\r\n");
      out.write("\t\t<input type=\"hidden\" name=\"cntrl\" value=\"");
      out.print(cntrl);
      out.write("\">\r\n");
      out.write("\t\t<input type=\"hidden\" name=\"query_start_date\" value=\"");
      out.print(sDate);
      out.write("\">\r\n");
      out.write("\t\t<input type=\"hidden\" name=\"startHour\" value=\"");
      out.print(sHour);
      out.write("\">\r\n");
      out.write("\t\t<input type=\"hidden\" name=\"startMinute\" value=\"");
      out.print(sMinute);
      out.write("\">\r\n");
      out.write("\t\t<input type=\"hidden\" name=\"query_end_date\" value=\"");
      out.print(eDate);
      out.write("\">\r\n");
      out.write("\t\t<input type=\"hidden\" name=\"endHour\" value=\"");
      out.print(eHour);
      out.write("\">\r\n");
      out.write("\t\t<input type=\"hidden\" name=\"endMinute\" value=\"");
      out.print(eMinute);
      out.write("\">\r\n");
      out.write("\t\t<input type=\"hidden\" name=\"telphone\" value=\"");
      out.print(telphone);
      out.write("\">\r\n");
      out.write("\t\t<input type=\"hidden\" name=\"blName\" value=\"");
      out.print(blName);
      out.write("\">\r\n");
      out.write("\t\t<input type=\"hidden\" name=\"gateway\" value=\"");
      out.print(gateway);
      out.write("\">\r\n");
      out.write("\t\t<input type=\"hidden\" name=\"longcode\" value=\"");
      out.print(longcode);
      out.write("\">\r\n");
      out.write("\t\t</td>\r\n");
      out.write("          </tr>\r\n");
      out.write("        </form>\r\n");
      out.write("      </table></td>\r\n");
      out.write("  </tr>\r\n");
      out.write("</table>\r\n");

 pageN.close();
 try{
    if(rs!=null){
	  rs.close();
	  rs=null;
	}
 }catch(SQLException ex){}

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