📄 addnew1.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" import="java.sql.*" %>
<%@ page import="mfkvit.JdbcBean,java.util.*" %>
<jsp:useBean id="login" class="mfkvit.login" scope="session">
</jsp:useBean>
<%
if(session.isNew()){response.sendRedirect("index.jsp");}
String success=login.getSuccess();
if(success==null){success="";}
if(!(success.equals("ok"))){response.sendRedirect("index.jsp");}
%>
<script type="" language="javascript">
function check(val) {
var a = document.all.tags("input");
if (a!=null) {
if (a.length!=null) {
for (i=0; i<a.length; i++) {
if (a(i).type== "checkbox")
a(i).checked=val;
}
}
}
}
function submitdel(){
document.form2.action="/servlet1"
document.form2.submit();
}
function submitcz(){
document.form2.action="addnew1.jsp"
document.form2.submit();
}
</script>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>admin</title>
<link href="c.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 5px;
background-image: url();
margin-bottom: 0px;
background-color: #d6dff7;
}
.style1 {line-height: 20px; color: #000000; text-decoration: none; font-size: 12px;}
-->
</style>
</head>
<body leftmargin="0">
<form name="form2" method="post" action="">
<%! int pageSize =13;//每页显示的记录
int pageCount = 0;//总页数
int showPage =1;//当前显示的页数
%>
<%
request.setCharacterEncoding("gb2312");
String lb1=request.getParameter("lb");
String condition="select * from addnew";
if(lb1!=null && !lb1.equals("全部")){condition="select * from addnew where lb1='"+lb1+"'";}
JdbcBean jdbc = new JdbcBean();
int lastRow = jdbc.execQueryName(condition);
ArrayList a = jdbc.getRS();
pageCount = (lastRow % pageSize == 0) ? (lastRow / pageSize) : (lastRow / pageSize + 1);//固定算法
String go1=request.getParameter("page");
if(go1==null)
{ go1="1";
}
try{
showPage=Integer.parseInt(go1);
}
catch(NumberFormatException e){
showPage=1;
}
if(showPage<=1)//输入的页数小于则显示第一页
{ showPage=1;
}
if(showPage>=pageCount)//输入的页数大于总页数则显示最后一页
{ showPage=pageCount;
}
int posion=(showPage-1)*pageSize;
%>
<table width="638" border="0" align="center" cellspacing="2">
<tr bordercolor="#FFFFFF" bgcolor="#799ae1">
<td height="24" colspan="7"> <span class="fds"><img src="img/pmlogin.gif" width="14" height="15"></span><span class="dfd">新闻信息</span><span class="c">
<select name="lb" id="lb">
<option>企业新闻</option>
<option>行业新闻</option>
</select>
<input style="BORDER-RIGHT: #7AC8EB 1px solid; BORDER-TOP: #7AC8EB 1px solid; FONT-SIZE: 9pt; BORDER-LEFT: #7AC8EB 1px solid; BORDER-BOTTOM: #7AC8EB 1px solid; HEIGHT: 18px; BACKGROUND-COLOR: #E8F6FC" type="submit" name="Submit3" value="查 询" onClick="submitcz();">
</span><span class="ff"> 共<%=pageCount%>页 当前第 <%=showPage%> 页
<%if (showPage>1){%>
<a href="addnew1.jsp?page=1">[第一页]</a> <a href="addnew1.jsp?page=<%=showPage-1%>">[上一页]</a>
<%}else{%>
[第一页] [上一页]
<%}
if (showPage< pageCount) {%>
<a href="addnew1.jsp?page=<%=showPage+1%>">[下一页]</a> <a href="addnew1.jsp?page=<%=pageCount%>">[最后页]</a>
<%}else{%>
[下一页] [最后页]
<%}%>
</span> </td>
</tr>
<tr bordercolor="#FFFFFF" bgcolor="#E0F2FC">
<td width="94">
<div align="center" class="c">新闻类别</div></td>
<td width="187" height="24">
<div align="center" class="c">新闻标题</div></td>
<td width="65">
<div align="center" class="c">内容</div></td>
<td width="82">
<div align="center" class="c">日期</div></td>
<td width="129" colspan="3">
<div align="center"><span class="unnamed1"><font size="2"><a class="unnamed1" style="TEXT-DECORATION:underline;cursor:hand" onClick="check(1)">全选</a>,</font></span><font color="#003366" size="2"><font color="#FF3366"><a class="unnamed1" style="TEXT-DECORATION:underline;cursor:hand" onClick="check(0)">全不选 </a> </font><span class="c">
<input style="BORDER-RIGHT: #7AC8EB 1px solid; BORDER-TOP: #7AC8EB 1px solid; FONT-SIZE: 9pt; BORDER-LEFT: #7AC8EB 1px solid; BORDER-BOTTOM: #7AC8EB 1px solid; HEIGHT: 18px; BACKGROUND-COLOR: #E8F6FC" type="submit" name="Submit32" value="删除"onClick="submitdel();">
</span> </font></div></td>
<tbody>
<%
for(int t=posion;t<posion+pageSize && t<lastRow;t++)
{ HashMap col = (HashMap)a.get(t);
String w=(String)col.get("id");
int d=Integer.parseInt(w);
%> <tr bgcolor="#E8EDF4">
<td bgcolor="#E8EDF4">
<div align="center" class="c"><%=(String)col.get("lb1")%></div></td>
<td height="28" bgcolor="#E8EDF4">
<div align="center" class="c"><%=(String)col.get("bt1")%></div></td>
<td><a href="../new_temple.jsp?id=<%=d%>" target="_blank">
<div align="center"><img src="img/arrow_7.gif" width="52" height="18" border="0" usemap="#Map"></div>
</a> </td>
<td bgcolor="#E8EDF4">
<div align="center" class="unnamed1"><%=(String)col.get("time1")%></div></td>
<td colspan="3">
<div align="center"> <font size="2"> <span class="c">
<input name="sc" type="checkbox" id="sc" value="<%=d%>">
<input type="hidden" name="admin" value="delnew" />
</span></font><span class="c"></span></div></td>
<% }%>
</table><table width="591" align="center">
<tr><td height="44" class="xb"> <div align="right"><span class="c"><strong>共<%=pageCount%>页 当前第 <%=showPage%> 页
<%if (showPage>1){%>
<a href="addnew1.jsp?page=1">[第一页]</a> <a href="addnew1.jsp?page=<%=showPage-1%>">[上一页]</a>
<%}else{%>
[第一页] [上一页]
<%}
if (showPage< pageCount) {%>
<a href="addnew1.jsp?page=<%=showPage+1%>">[下一页]</a> <a href="addnew1.jsp?page=<%=pageCount%>">[最后页]</a>
<%}else{%>
[下一页] [最后页]
<%}%>
</strong></span></div></td></tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -