You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
128 lines
4.6 KiB
128 lines
4.6 KiB
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
|
|
<%@page import="util.Info"%>
|
|
<%@page import="dao.CommDAO"%>
|
|
<%@page import="util.PageManager"%>
|
|
|
|
|
|
|
|
<html>
|
|
<head>
|
|
|
|
<title>新闻通知</title>
|
|
<LINK href="css.css" type=text/css rel=stylesheet>
|
|
|
|
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
|
|
</head>
|
|
<script language="javascript">
|
|
function checkall()
|
|
{
|
|
if(document.form2.plxz.checked==true)
|
|
{
|
|
var code_Values = document.all['pldel'];
|
|
if(code_Values.length){
|
|
for(var i=0;i<code_Values.length;i++)
|
|
{
|
|
code_Values[i].checked = true;
|
|
}
|
|
}else{
|
|
code_Values.checked = true;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
var code_Values = document.all['pldel'];
|
|
if(code_Values.length){
|
|
for(var i=0;i<code_Values.length;i++)
|
|
{
|
|
code_Values[i].checked = false;
|
|
}
|
|
}else{
|
|
code_Values.checked = false;
|
|
}
|
|
}
|
|
}
|
|
</script>
|
|
<%
|
|
String lb=request.getParameter("lb");
|
|
//String lb=new String(request.getParameter("lb").getBytes("8859_1"));
|
|
%>
|
|
<%
|
|
new CommDAO().delete(request,"xinwentongzhi");
|
|
|
|
%>
|
|
<body >
|
|
<p>已有<%=lb%>列表：</p>
|
|
<form name="form1" id="form1" method="get" action="">
|
|
搜索: 标题：<input name="biaoti" type="text" id="biaoti" /> <input name="lb" type="hidden" id="lb" value="<%=lb%>">
|
|
<input type="submit" name="Submit" value="查找" />
|
|
<input type="button" name="Submit2" value="新增" onClick="javascript:location.href='xinwentongzhi_add.jsp?lb=<%=lb%>';" />
|
|
</form>
|
|
|
|
<form name="form2" method="post" action="delall.jsp">
|
|
<table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="00FFFF" style="border-collapse:collapse">
|
|
<tr>
|
|
<td width="30" align="center" bgcolor="CCFFFF">序号</td>
|
|
<td bgcolor='#CCFFFF'>标题</td>
|
|
<td bgcolor='#CCFFFF'>类别</td>
|
|
<td bgcolor='#CCFFFF'>添加人</td>
|
|
<td bgcolor='#CCFFFF'>首页图片</td>
|
|
<td bgcolor='#CCFFFF'>点击率</td>
|
|
<td width="138" align="center" bgcolor="CCFFFF">添加时间</td>
|
|
<td width="60" align="center" bgcolor="CCFFFF">操作</td>
|
|
<td width="50" align="center" bgcolor="CCFFFF"><input name="plxz" type="checkbox" id="plxz" onClick="checkall();" value="1">
|
|
<input name="tablename" type="hidden" id="tablename" value="xinwentongzhi">
|
|
</td>
|
|
</tr>
|
|
<%
|
|
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<HashMap> list = PageManager.getPages(url,10,sql, request );
|
|
int i=0;
|
|
for(HashMap map:list){
|
|
i++;
|
|
%>
|
|
<tr>
|
|
<td width="30" align="center"><%=i %></td>
|
|
<td><%=map.get("biaoti") %></td>
|
|
<td><%=map.get("leibie") %></td>
|
|
<td><%=map.get("tianjiaren") %></td>
|
|
<td><%
|
|
if (map.get("shouyetupian")==null || map.get("shouyetupian").equals("") || map.get("shouyetupian").equals("null"))
|
|
{
|
|
%>
|
|
<%
|
|
}
|
|
else
|
|
{
|
|
%>
|
|
<a href='<%=map.get("shouyetupian") %>' target='_blank'><img src='<%=map.get("shouyetupian") %>' width=88 height=99 border=0 /></a>
|
|
<%
|
|
}
|
|
%>
|
|
</td>
|
|
<td><%=map.get("dianjilv") %></td>
|
|
<td width="138" align="center"><%=map.get("addtime") %></td>
|
|
<td width="60" align="center"><a href="xinwentongzhi_updt.jsp?id=<%=map.get("id")%>">修改</a> <a onClick="return confirm('确定要删除这条记录吗?')" href="xinwentongzhi_list.jsp?scid=<%=map.get("id")%>">删除</a></td>
|
|
<td width="50" align="center"><input name="pldel" type="checkbox" id="pldel" value="<%=map.get("id")%>"></td>
|
|
</tr>
|
|
<%} %>
|
|
</table>
|
|
|
|
<br>
|
|
${page.info }
|
|
<input type="button" name="Submit32" value="打印本页" onClick="javascript:window.print();" style='border:solid 1px #000000; color:#666666'>
|
|
<input type="submit" name="Submit33" value="批量删除" style='border:solid 1px #000000; color:#666666'>
|
|
|
|
</form> </body>
|
|
</html>
|
|
|
|
|
|
|