📄 ck_brow.jsp

📁 新闻发布系统本系统可以完成功能： 1 支持多个网站 2 添加栏目
💻 JSP
字号:
<%@page language="java"%>
<%@page contentType="text/html;charset=8859_1"%>
<%@page import="java.sql.*"%>
<%@page import="DBCon"%>
<%@page import="DateText"%>
<% DBCon DBConBean=new DBCon(); %>
<%@page import="IdSelect"%>
<% IdSelect IdSelectBean=new IdSelect(); %>
<html>
<head>
<title>无标题文档</title>
<link rel="stylesheet" href="../css/style.css" type="text/css">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<%
  String lm_id = request.getParameter("lm_id");
  
  String zt_id = request.getParameter("zt_id");
  
  String first_data = request.getParameter("first_data");
  
  out.println(first_data);
  
  if(first_data.equals("")){first_data="2099-12-31";}else{}
  
  out.println(first_data);

  String last_data = request.getParameter("last_data");

  if(last_data.equals("")){last_data="1979-9-16";}else{}
  
  String key_words = request.getParameter("key_words");
  
  if(key_words.equals("")){key_words="";}else{}

  String pubman = request.getParameter("pubman");

  if(pubman.equals("")){pubman="";}else{}
  
  String checkman = request.getParameter("checkman");

  if(checkman.equals("")){checkman="";}else{}
  
  String s_jb_id =(String)session.getValue("s_jb_id");
  
  String s_user_lm_id =(String)session.getValue("s_user_lm_id");

%>
<table width="80%" 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>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <%
  IdSelectBean.setIdName("s_jb_id");
  IdSelectBean.setStrTableName("wenzhang_view");
  if(zt_id.equals("")){IdSelectBean.setStrId("'"+s_jb_id+"' and lm_id='"+lm_id+"' and s_user_name like '%"+pubman+"%' and wz_bei3 like '%"+checkman+"%' and wz_key like '%"+key_words+"%'");}else{if(lm_id.equals("")){IdSelectBean.setStrId("'"+s_jb_id+"' and zt_id='"+zt_id+"' and s_user_name like '%"+pubman+"%' and wz_bei3 like '%"+checkman+"%' and wz_key like '%"+key_words+"%' and wz_firstdata <='"+first_data+"' and wz_lastdata >='"+last_data+"'");}else{IdSelectBean.setStrId("'"+s_jb_id+"' and lm_id='"+lm_id+"' and zt_id='"+zt_id+"' and s_user_name like '%"+pubman+"%' and wz_bei3 like '%"+checkman+"%' and wz_key like '%"+key_words+"%' and wz_firstdata <='"+first_data+"' and wz_lastdata >='"+last_data+"'");}}
 	 try {
	  Connection conn = DBConBean.getConnection();
	  IdSelectBean.setConn(conn);
	  ResultSet result = IdSelectBean.getResultSet();
	  while(result.next()){
	  String wz_id=result.getString("wz_id");
	 lm_id=result.getString("lm_id");
	  zt_id=result.getString("zt_id");
	  String wz_name=result.getString("wz_name");
	  String wz_data=DateText.getDateString(result.getString("wz_data"));
	  String wz_jinghua=result.getString("wz_jinghua");
	  String wz_power=result.getString("wz_power");
	  String wz_lastdata=DateText.getDateString(result.getString("wz_lastdata"));
	  String wz_firstdata=DateText.getDateString(result.getString("wz_firstdata"));
	 
%>
    <tr> 
      <td><%=wz_firstdata%></td>
      <td><%=wz_name%></td>
      <td><%=wz_lastdata%></td>
      <td><%=wz_jinghua%></td>
      <td><%=wz_data%></td>
      <td><%=wz_power%></td>
      <td><a href="../wen/wz_up.jsp?id=<%=wz_id%>">修改</a></td>
      <td><a href="../wen/wz_xiang.jsp?id=<%=wz_id%>">详细</a></td>
    </tr>
<%
	  }
	 }
	 catch(Exception e) {DBConBean.closeAll();
	   e.printStackTrace();
	 }DBConBean.closeAll();		
%>
  </table>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -