<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%> <%@page import="util.Info"%> <%@page import="dao.CommDAO"%> <%@page import="util.PageManager"%> 新闻通知 <% String lb=request.getParameter("lb"); //String lb=new String(request.getParameter("lb").getBytes("8859_1")); %> <% new CommDAO().delete(request,"xinwentongzhi"); %>

已有<%=lb%>列表:

搜索: 标题:
<% new CommDAO().delete(request,"xinwentongzhi"); String url = "xinwentongzhi_list2.jsp?lb="+lb; String sql = "select * from xinwentongzhi where tianjiaren='"+request.getSession().getAttribute("username")+"' and leibie='"+lb+"'"; if(request.getParameter("biaoti")=="" ||request.getParameter("biaoti")==null ){}else{sql=sql + " and biaoti like '%"+request.getParameter("biaoti").trim()+"%' ";} if(request.getParameter("tianjiaren")=="" ||request.getParameter("tianjiaren")==null ){}else{sql=sql+ " and tianjiaren like '%"+request.getParameter("tianjiaren").trim()+"%' ";} if(request.getParameter("leibie")=="" ||request.getParameter("leibie")==null ){}else{sql=sql+ " and leibie like '%"+request.getParameter("leibie").trim()+"%' ";} sql+=" order by id desc"; //out.print(sql); ArrayList list = PageManager.getPages(url,10,sql, request ); int i=0; for(HashMap map:list){ i++; %> <%} %>
序号 标题 类别 添加人 首页图片 点击率 添加时间 操作
<%=i %> <%=map.get("biaoti") %> <%=map.get("leibie") %> <%=map.get("tianjiaren") %> <% if (map.get("shouyetupian")==null || map.get("shouyetupian").equals("") || map.get("shouyetupian").equals("null")) { %> <% } else { %> <% } %> <%=map.get("dianjilv") %> <%=map.get("addtime") %> ">修改 ">删除 ">

${page.info }