📄 qf_brow.jsp
字号:
<%@page language="java"%>
<%@page contentType="text/html;charset=8859_1"%>
<%@page import="java.sql.*"%>
<%@page import="DBCon"%>
<%@page import="DateText"%>
<%@page import="CPager"%>
<% CPager CPagerBean=new CPager(12);//数量 %>
<% DBCon DBConBean=new DBCon(); %>
<%@page import="IdSelect"%>
<% IdSelect IdSelectBean=new IdSelect();
String s_jb_id =(String)session.getValue("s_jb_id");
int pagesize=10;
String pages=request.getParameter("pages");
if ((pages==null)||(pages=="")){pages="1";}else{}
int pages_new = Integer.parseInt(pages);
IdSelectBean.setStrTableName("wenzhang");
IdSelectBean.setStrId("wz_qf='1' and wz_del='0' and s_jb_id='"+s_jb_id+"'");
Connection conn = DBConBean.getConnection();
IdSelectBean.setConn(conn);
int count = IdSelectBean.getCount();
int pageline=(count%pagesize)==0?(count/pagesize):(count/pagesize)+1;
if (pages_new<=0){pages_new=1;}else{
if (pages_new>pageline){pages_new=pageline;}else{}}
IdSelectBean.setIdName("lm_del");
IdSelectBean.setStrTableName("lanmu");
IdSelectBean.setStrId("0 and s_jb_id="+s_jb_id+"");
try {
//设置连接，返回结果集
ResultSet result = IdSelectBean.getResultSet();
while(result.next()) {
String num= result.getString("lm_id");
String lm_name= result.getString("lm_name");
session.setAttribute(num,lm_name);
}
result.close(); }
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
}
%>
<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/style.css" type="text/css">
</head>
<script language="javascript">
function subb() {
if(document.form1.pages.value==""){alert("请输入你需要的页号");}else{
document.form1.action="qf_brow.jsp?pages="+document.form1.pages.value+""
form1.submit();
}}
</script>
<body bgcolor="#FFFFFF" text="#000000">
<table width="80%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> 等待签发的文章<br>
<table width="100%" border="1" cellspacing="0" cellpadding="0" align="left" bordercolorlight="#000000" bordercolordark="#ffffff" class="zw" bgcolor="#e1e1e1">
<tr>
<td>文章录入日期</td>
<td>文章题目</td>
<td>最后送签日期</td>
<td>精华推荐</td>
<td>预计发布日期</td>
<td>所属栏目</td>
<td>录入人</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
IdSelectBean.setIdName("wz_qf");
IdSelectBean.setStrTableName("wenzhang");
IdSelectBean.setStrId("'0' and wz_del='0' and s_jb_id='"+s_jb_id+"' order by wz_id desc");
try {
ResultSet result = IdSelectBean.getResultSet();
while(result.next()){
String wz_id=result.getString("wz_id");
String lm_id=result.getString("lm_id");
String zt_id=result.getString("zt_id");
String wz_name=result.getString("wz_name");
String wz_data=DateText.getDateString(result.getString("wz_data"));
String wz_firstdata=DateText.getDateString(result.getString("wz_firstdata"));
String wz_lastdata=DateText.getDateString(result.getString("wz_lastdata"));
String wz_jinghua=result.getString("wz_jinghua");
String wz_power=result.getString("wz_power");
%>
<tr>
<td><%=wz_firstdata%></td>
<td><%=wz_name%></td>
<td><%=wz_lastdata%></td>
<td><%=wz_jinghua%></td>
<td><%=wz_data%></td>
<td><%String lm_name_new=session.getAttribute(lm_id).toString();
out.println(lm_name_new);%></td>
<td><%=wz_power%></td>
<td><a href="../wen/wz_xiang.jsp?id=<%=wz_id%>">浏览</a></td>
<td><a href="qf_false.jsp?wz_id=<%=wz_id%>">送回</a></td>
<td><a href="qf_ture.jsp?wz_id=<%=wz_id%>">签发</a></td>
</tr>
<%
}
result.close();}
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
}
%>
</table>
</td>
</tr> <tr>
<td>
<p>送回文章列表 </p>
<table width="100%" border="1" cellspacing="0" cellpadding="0" align="left" bordercolorlight="#000000" bordercolordark="#ffffff" class="zw" bgcolor="#e1e1e1">
<tr>
<td>文章录入日期</td>
<td>文章题目</td>
<td>最后送签日期</td>
<td>精华推荐</td>
<td>预计发布日期</td>
<td>所属栏目</td>
<td>录入人</td>
<td> </td>
<td> </td>
</tr>
<%
IdSelectBean.setIdName("wz_qf");
IdSelectBean.setStrTableName("wenzhang");
IdSelectBean.setStrId("'2' and wz_del='0' and s_jb_id='"+s_jb_id+"' order by wz_id desc");
try {
ResultSet result1 = IdSelectBean.getResultSet();
while(result1.next()){
String wz_id=result1.getString("wz_id");
String lm_id=result1.getString("lm_id");
String zt_id=result1.getString("zt_id");
String wz_name=result1.getString("wz_name");
String wz_data=DateText.getDateString(result1.getString("wz_data"));
String wz_firstdata=DateText.getDateString(result1.getString("wz_firstdata"));
String wz_lastdata=DateText.getDateString(result1.getString("wz_lastdata"));
String wz_jinghua=result1.getString("wz_jinghua");
String wz_power=result1.getString("wz_power");
%>
<tr>
<td><%=wz_firstdata%></td>
<td><%=wz_name%></td>
<td><%=wz_lastdata%></td>
<td><%=wz_jinghua%></td>
<td><%=wz_data%></td>
<td><%String lm_name_new=session.getAttribute(lm_id).toString();
out.println(lm_name_new);%></td>
<td><%=wz_power%></td>
<td><a href="../wen/wz_xiang.jsp?id=<%=wz_id%>">浏览</a></td>
<td><a href="qf_ture.jsp?wz_id=<%=wz_id%>">签发</a></td>
</tr>
<%
}
result1.close();}
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
}
%>
</table>
</td>
</tr><tr><td>
<p>已经签发的文章</p>
<form name="form1" method="post" action="">
<table width="100%" border="1" cellspacing="0" cellpadding="0" align="left" bordercolorlight="#000000" bordercolordark="#ffffff" class="zw" bgcolor="#e1e1e1">
<tr>
<td>文章录入日期</td>
<td>文章题目</td>
<td>最后送签日期</td>
<td>精华推荐</td>
<td>审核人</td>
<td>预计发布日期</td>
<td>所属栏目</td>
<td>录入人</td>
<td> </td>
<td> </td>
</tr>
<%
IdSelectBean.setIdName("wz_qf");
IdSelectBean.setStrTableName("wenzhang");
IdSelectBean.setStrId("'1' and wz_del='0' and s_jb_id='"+s_jb_id+"' order by wz_id desc");
try {
ResultSet result2 = IdSelectBean.getResultSet();
int i=1;
while(result2.next()){i=i+1;
String wz_id=result2.getString("wz_id");
String lm_id=result2.getString("lm_id");
String zt_id=result2.getString("zt_id");
String wz_name=result2.getString("wz_name");
String wz_data=DateText.getDateString(result2.getString("wz_data"));
String wz_firstdata=DateText.getDateString(result2.getString("wz_firstdata"));
String wz_lastdata=DateText.getDateString(result2.getString("wz_lastdata"));
String wz_jinghua=result2.getString("wz_jinghua");
String wz_power=result2.getString("wz_power");
String wz_bei3=result2.getString("wz_bei3");
if((i>((pages_new-1)*pagesize))&&(i<(pages_new*pagesize+1))){
/*result2
//result2.last();
// out.println(result2.getRow());
//CPagerBean.setItemCount(count);
//CPagerBean.setCurrentPageIndex(1);//yehao
//int j=CPagerBean.getFirstItemIndex();
//int h=CPagerBean.getLastItemIndex();
result2.absolute(2);
for (int i=1;i<4;i++){result2.next();
String wz_id=result2.getString("wz_id");
String lm_id=result2.getString("lm_id");
String zt_id=result2.getString("zt_id");
String wz_name=result2.getString("wz_name");
String wz_data=DateText.getDateString(result2.getString("wz_data"));
String wz_firstdata=DateText.getDateString(result2.getString("wz_firstdata"));
String wz_lastdata=DateText.getDateString(result2.getString("wz_lastdata"));
String wz_jinghua=result2.getString("wz_jinghua");
String wz_power=result2.getString("wz_power");
String wz_bei3=result2.getString("wz_bei3");*/
%>
<tr>
<td><%=wz_firstdata%></td>
<td><%=wz_name%></td>
<td><%=wz_lastdata%></td>
<td><%=wz_jinghua%></td>
<td><%=wz_bei3%></td>
<td><%=wz_data%></td>
<td><%String lm_name_new=session.getAttribute(lm_id).toString();
out.println(lm_name_new);%></td>
<td><%=wz_power%></td>
<td><a href="../wen/wz_xiang.jsp?id=<%=wz_id%>">浏览</a></td>
<td><a href="qf_false.jsp?wz_id=<%=wz_id%>">撤消签发</a></td>
</tr>
<%
}else{} }//}
}
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
}DBConBean.closeAll();
%>
<tr>
<%int j=pages_new-1;int h=pages_new+1;%>
<td colspan="10">共<%=(count%pagesize)==0?(count/pagesize):(count/pagesize)+1%>页 <a href="qf_brow.jsp?pages=<%=j%>">上一页</a> <a href="qf_brow.jsp?pages=<%=h%>">下一页</a> 本页是第<%=pages_new%>页
<input type="text" name="pages" style="width:20px">
<input type="button" name="Submit" value="GO" onclick="subb()">
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -