upload_jsp.java

应用泛型以及反射编写的单表操作框架

      out.write("\t\t<th bgcolor=\"#D2D3D9\">编号</th>\r\n");
      out.write("\t\t<th bgcolor=\"#D2D3D9\">扩展名</th>\r\n");
      out.write("\t\t<th bgcolor=\"#D2D3D9\">文件地址</th>\r\n");
      out.write("\t\t<th bgcolor=\"#D2D3D9\">缩略图地址</th>\r\n");
      out.write("\t\t<th bgcolor=\"#D2D3D9\">大小</th>\r\n");
      out.write("\t\t<th bgcolor=\"#D2D3D9\">上传时间</th>\r\n");
      out.write("\t\t<th bgcolor=\"#D2D3D9\">上传人IP</th>\r\n");
      out.write("\t\t<th bgcolor=\"#D2D3D9\">操作</th>\r\n");
      out.write("\t</tr>\r\n");

		   //根据总行数计算总页数
		   if(sum%ipage==0)
		   {
              allpage=sum/ipage;
		   }else{
		      allpage=sum/ipage+1;
		   }
            //判断参数pages是否为空
			if(request.getParameter("jumppages")==null){
			  pages=1;
			}
			else{
              pages=Integer.parseInt(request.getParameter("jumppages"));
			}
            //判断当前页
			if(pages>allpage || pages==0){
			   cpage=1;
			}else{
			   cpage=pages;
			}
			spage=cpage*ipage;//判断要查询的总行数
           int n=0,m=0;
        try
		{

		   con=DataBaseConnection.getConnection();
           Statement stmt=con.createStatement();

           String sql2="select top "+spage+" * from up_imges";
		   ResultSet rs2=stmt.executeQuery(sql2);

		   while(rs2.next())
		   {
			   if(n>(cpage-1)*ipage-1)
			  {
				   m++;
			      int id=rs2.getInt(1);
			      String wid_name=rs2.getString(2);
			      String path=rs2.getString(3);
			      String min_path=rs2.getString(4);
			      int size=rs2.getInt(5);
		          String time=rs2.getString(6);
				  String ip=rs2.getString(7);

      out.write("\r\n");
      out.write("    <tr align=center  style=\"font-size:14px\" height=25> \r\n");
      out.write("      <td>\r\n");
      out.write("\t  ");
      out.print(m);
      out.write("\r\n");
      out.write("\t  </td>\r\n");
      out.write("      <td>\r\n");
      out.write("\t  ");
if(wid_name==""){
      out.write("\r\n");
      out.write("\t  &nbsp;\r\n");
      out.write("\t  ");
}else{
      out.write("\r\n");
      out.write("\t  ");
      out.print(wid_name);
      out.write("\r\n");
      out.write("\t  ");
}
      out.write("\r\n");
      out.write("\t  </td>\r\n");
      out.write("      <td>\r\n");
      out.write("\t  ");
if(path==""){
      out.write("\r\n");
      out.write("\t  &nbsp;\r\n");
      out.write("\t  ");
}else{
      out.write("\r\n");
      out.write("\t  <a href=\"http://localhost:8080/ch2/");
      out.print(path);
      out.write("\" target=\"_blank\">");
      out.print(path);
      out.write("</a>\r\n");
      out.write("\t  ");
}
      out.write("\r\n");
      out.write("\t  </td>\r\n");
      out.write("      <td>\r\n");
      out.write("\t  ");
if(min_path==""){
      out.write("\r\n");
      out.write("\t  &nbsp;\r\n");
      out.write("\t  ");
}else{
      out.write("\r\n");
      out.write("\t  <a href=\"http://localhost:8080/ch2/");
      out.print(min_path);
      out.write("\" target=\"_blank\">");
      out.print(min_path);
      out.write("</a>\r\n");
      out.write("\t  ");
}
      out.write("\r\n");
      out.write("\t  </td>\r\n");
      out.write("      <td>\r\n");
      out.write("\t  ");
if(String.valueOf(size)==""){
      out.write("\r\n");
      out.write("\t  &nbsp;\r\n");
      out.write("\t  ");
}else{
      out.write("\r\n");
      out.write("\t  ");
      out.print(size);
      out.write("\r\n");
      out.write("\t  ");
}
      out.write("\r\n");
      out.write("\t  </td>\r\n");
      out.write("      <td>\r\n");
      out.write("\t  ");
if(time==""){
      out.write("\r\n");
      out.write("\t  &nbsp;\r\n");
      out.write("\t  ");
}else{
      out.write("\r\n");
      out.write("\t  ");
      out.print(time);
      out.write("\r\n");
      out.write("\t  ");
}
      out.write("\r\n");
      out.write("\t  </td>\r\n");
      out.write("\t  <td>\r\n");
      out.write("\t  ");
if(ip==""){
      out.write("\r\n");
      out.write("\t  &nbsp;\r\n");
      out.write("\t  ");
}else{
      out.write("\r\n");
      out.write("\t  ");
      out.print(ip);
      out.write("\r\n");
      out.write("\t  ");
}
      out.write("\r\n");
      out.write("\t  </td>\r\n");
      out.write("\t  <td><a href=\"delimg.jsp?id=");
      out.print(id);
      out.write("&name=");
      out.print(path);
      out.write("&min_name=");
      out.print(min_path);
      out.write("\" onclick=\"return del();\">删除</a></td>\r\n");
      out.write("    </tr>\r\n");
 
			   }
	       n++;
	  }	  
	}
	catch(Exception e)
	{
		   e.printStackTrace();
	}

      out.write("\r\n");
      out.write("  </table>\r\n");
if(allpage!=1 && sum!=0)
	{

      out.write("\r\n");
      out.write("<div align=center>\r\n");
      out.write("<form name=\"PageForm\" action=\"upload.jsp\" method=\"get\">\r\n");
      out.write("每页");
      out.print(ipage);
      out.write("行\r\n");
      out.write(" 共");
      out.print(sum);
      out.write("行\r\n");
      out.write(" 第");
      out.print(cpage);
      out.write("页\r\n");
      out.write(" 共");
      out.print(allpage);
      out.write("页\r\n");
      out.write("　　　\r\n");
if(cpage==1){ out.print(" 首页 上一页");   }else{  
      out.write("   \r\n");
      out.write("<A HREF=\"upload.jsp?jumppages=");
      out.print(1);
      out.write("\">首页</A>\r\n");
      out.write("<A HREF=\"upload.jsp?jumppages=");
      out.print(cpage-1);
      out.write("\">上一页</A>\r\n");
}
      out.write('\r');
      out.write('\n');
if(cpage==allpage){ out.print("下一页 尾页");   }else{  
      out.write("   \r\n");
      out.write("<A HREF=\"upload.jsp?jumppages=");
      out.print(cpage+1);
      out.write("\">下一页</A>\r\n");
      out.write("<A HREF=\"upload.jsp?jumppages=");
      out.print(allpage);
      out.write("\">尾页</A>\r\n");

	}
}
}

      out.write("\r\n");
      out.write("\r\n");
      out.write("</form>\r\n");
      out.write("</div>\r\n");
      out.write("<BR><BR>\r\n");
      out.write("</body>\r\n");
      out.write("</html>");
    } 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);
    }
  }
}