Java 切换按钮
<%String sign=request.getParameter("signid");if(request.getParameter("signid")!=null){sign=request.getParameter("signid");}if(sign==null){%>最新照片|<a href="index.jsp?signid=1">热门照片</a> <%}if(sign!=null){out.println("<a href='index.jsp'>"+"最新照片"+"</a>"+"|热门照片");} %><br/><%String imgPath= Common.getPropertiesValue("LOCAL_HOST")+"/"+ Common.getPropertiesValue("LOCAL_MANAGEROOT")+"/"+Common.getPropertiesValue("LOCAL_NEWS");String mobile = Common.getMobile(request);Object myNickName=request.getSession().getAttribute("myNickName");Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;int count=0;int pagesize=5;int pagenum=1;if(request.getParameter("pn")!=null){pagenum=Integer.parseInt(request.getParameter("pn"));}if(mobile==null&&"".equals(mobile)){out.println("请您正确使用手机操作！");out.println("<br/>");}else{try {conn = DBClassLocal.getConnection();String sql="select count(*) from local_streetshoot where pass=0 order by createtime desc";ps = conn.prepareStatement(sql);rs=ps.executeQuery();while(rs.next()){count=rs.getInt(1);}sql = "select * from (select t.*,rownum rn from (select * from local_streetshoot where pass=0 order by createtime desc)t where rownum<=?)where rn>?";ps = conn.prepareStatement(sql);ps.setInt(1,pagesize*pagenum);ps.setInt(2,pagesize*(pagenum-1));rs=ps.executeQuery();while(rs.next()){out.println("标题："+rs.getString("titlename"));out.println("<br/>");String path=rs.getString("imgurl");//String path2=imgPath+path;out.println("<img src='"+path+"'/>");out.println("<br/>");out.println("描述："+rs.getString("discription"));out.println("<br/>");out.println("<a href='support.jsp?id="+rs.getInt("id")+"'>"+"支持一下"+"</a>"+"("+rs.getInt("hot")+")");out.println("昵称："+"<a href='http://wap.139hz.com/wap/weibo/kongjian/'>"+rs.getString("nickname")+"</a>");out.println("<br/>");}} catch (Exception e) {request.setAttribute("message","服务器错误");request.getRequestDispatcher("message.jsp").forward(request,response);return;} finally {if (rs != null) {rs.close();}if (ps != null) {ps.close();}if (conn != null) {conn.close();}}out.println(Pager.getPagerSimple(count, pagesize, pagenum, "index.jsp"));} %>