zt_brow.jsp

来自「新闻发布系统 本系统可以完成功能: 1 支持多个网站 2 添加栏目」· JSP 代码 · 共 81 行

JSP
81
字号
<%@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>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/style.css" type="text/css">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="">
<%
  String s_jb_id =(String)session.getValue("s_jb_id");
  IdSelectBean.setIdName("zt_del");
  IdSelectBean.setStrTableName("zhuanti");
  IdSelectBean.setStrId("0 and s_jb_id="+s_jb_id+"");
  
 	 try {
	  Connection conn = DBConBean.getConnection();
	  IdSelectBean.setConn(conn);
	  ResultSet result = IdSelectBean.getResultSet();
	  
%>  <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 colspan="3"><a href="zt_ziliao.jsp">增加新专题</a></td>
    </tr>
  <%    String zt_id="";
		String lm_id="";
		String zt_name="";
		String zt_info="";
		String zt_data="";
		String zt_moban_id="";
		String zt_pic="";
		String zt_jinghua="";
		String zt_power="";
	//利用while循环将数据表中的记录列出
	while(result.next()) {
		zt_id= result.getString("zt_id");
		lm_id= result.getString("lm_id");
		zt_name=result.getString("zt_name");
		zt_info=result.getString("zt_info");
		zt_data=DateText.getDateString(result.getString("zt_data"));
		zt_moban_id=result.getString("zt_moban_id");
		zt_pic=result.getString("zt_pic");
		zt_jinghua=result.getString("zt_jinghua");
		zt_power=result.getString("zt_power");
   %><tr> 
      <td><%=zt_id%></td>
      <td><%=zt_name%></td>
      <td><%if(zt_jinghua.equals("1")){out.println("☆精华专题☆");}else{out.println("普 通 专 题");}%></td>
      <td><%=zt_power%></td>
      <td><%=zt_data%></td>
      <td><a href="zt_up.jsp?zt_id=<%=zt_id%>">修改</a></td>
      <td><a href="zt_del.jsp?zt_id=<%=zt_id%>" onClick="return confirm('您确定删除吗?')">删除</a></td>
      <td><a href="zt_xiang.jsp?zt_id=<%=zt_id%>">详细</a></td>
    </tr>
<%

	  }
	 }
	 catch(Exception e) {DBConBean.closeAll();
	   e.printStackTrace();
	 }		
DBConBean.closeAll();
%>
  </table>
</form>
</body>
</html>

⌨️ 快捷键说明

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