📄 lm_xiang.jsp

📁 新闻发布系统本系统可以完成功能： 1 支持多个网站 2 添加栏目
💻 JSP
字号:
<%@page language="java"%>
<%@page contentType="text/html;charset=8859_1"%>
<%@page import="java.sql.*"%>
<%@page import="DBCon"%>
<% 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>
<script language="javascript">
function subb() {
if(document.form1.lm_name.value==""){
alert("请填写要增加的栏目名称！！");
}
else
if(document.form1.lm_admin_mail.value==""){
alert("请填写要增加的管理员信箱！！");
}else{
document.form1.action="lm_up2.jsp"
form1.submit();
}
}
</script>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="">
  <table width="75%" border="1" cellspacing="0" cellpadding="0" align="left"  bordercolorlight="#000000" bordercolordark="#ffffff" class="zw" bgcolor="#e1e1e1">
<% 
  String s_jb_id =(String)session.getValue("s_jb_id");
  String lm_id = request.getParameter("lm_id");
  String lm_type="";String lm_moban_id="";String lm_tx="";
  String lm_win="";String lm_vist_power="";String lm_info="";
  IdSelectBean.setIdName("lm_id");
  IdSelectBean.setStrTableName("lanmu");
  IdSelectBean.setStrId(lm_id+" and lm_del=0");
  
 	 try {
	  Connection conn = DBConBean.getConnection();
	  IdSelectBean.setConn(conn);
	  ResultSet result = IdSelectBean.getResultSet();
	  //利用while循环将数据表中的记录列出
	  while(result.next()) {
	  String lm_name= result.getString("lm_name");
	  lm_type=result.getString("lm_type");
	  lm_info=result.getString("lm_info");
	  lm_tx=result.getString("lm_tx");
	  String lm_line=result.getString("lm_line");
	  lm_win=result.getString("lm_win");
	  String lm_admin_mail=result.getString("lm_admin_mail");
	  lm_moban_id=result.getString("lm_moban_id");
	  String lm_xh=result.getString("lm_xh");
	  lm_vist_power=result.getString("lm_vist_power");	  
%>
    <tr> 
      <td rowspan="12" height="240">&nbsp;</td>
      <td height="30">栏目名称：</td>
      <td height="30"> 
        <%=lm_name%><input type="hidden" name="lm_id" style="width:140px" value="<%=lm_id%>">
      </td>
      <td rowspan="12" height="240">&nbsp;</td>
    </tr>
    <tr> 
      <td height="30">每页显示文章数：</td>
      <td height="30"> 
        <%=lm_line%>
      </td>
    </tr>
    <tr> 
      <td height="30">管理员信箱：</td>
      <td height="30"> 
       <%=lm_admin_mail%>
      </td>
    </tr>
    <tr> 
      <td height="30">栏目排列序号</td>
      <td height="30"> 
        <%=lm_xh%>
      </td>
    </tr>
    <tr> 
      <td height="30">栏目级别：</td>
      <td height="30"> 
   <% IdSelectBean.setIdName("1");
   IdSelectBean.setStrTableName("lanmu");
   IdSelectBean.setStrId("1 and lm_del=0 and lm_type=0  and s_jb_id="+s_jb_id+"");
  
 	 try {
	  ResultSet result1 = IdSelectBean.getResultSet();
	  //利用while循环将数据表中的记录列出
	  while(result1.next()) {
	  String lm_id_new=result1.getString("lm_id");
	  String lm_name_new=result1.getString("lm_name");
   if (lm_id_new.equals(lm_type)){
out.println(lm_name_new);}else
{}
	  }
	 }
	 catch(Exception e) {DBConBean.closeAll();
	   e.printStackTrace();
	 }		
%>
       
      </td>
    </tr>
    <tr> 
      <td height="30">栏目的模板名称：</td>
      <td height="30"> 
        
  <% 
   IdSelectBean.setIdName("jm_del");
   IdSelectBean.setStrTableName("jiemian");
   IdSelectBean.setStrId("0 and s_jb_id="+s_jb_id+"");
  
 	 try {

	  ResultSet result1 = IdSelectBean.getResultSet();
	  //利用while循环将数据表中的记录列出
	  while(result1.next()) {
	  String jm_id_new=result1.getString("jm_id");
	  String jm_bei=result1.getString("jm_bei");
	  if (jm_id_new.equals(lm_moban_id)){out.println(jm_bei);}else{}
     }
	 }
	 catch(Exception e) {DBConBean.closeAll();
	   e.printStackTrace();
	 }%>   
      </td>
    </tr>
    <tr> 
      <td height="30">栏目间隔符号：</td>
      <td height="30"> 
        <%=lm_tx%>
      </td>
    </tr>
    <tr> 
      <td height="30">窗口打开方式：</td>
      <td height="30"> 
        
		<% if (lm_win.equals("_blank")){
out.println("新窗口");}else
{out.println("本窗口");}
%>   
         
      </td>
    </tr>
    <tr> 
      <td height="30">栏目的访问权限： </td>
      <td height="30"> 
        
		<% if (lm_vist_power.equals("1")){
out.println("公众");}else
{out.println("用户");}
%>   
         
      </td>
    </tr>
    <tr> 
      <td height="30" colspan="2">栏目简介：</td>
    </tr>
    <tr> 
      <td height="30" colspan="2"> 
        &nbsp;<%=lm_info%>
      </td>
    </tr>
    <tr> 
      <td height="30" colspan="2"> 
        <input type="button" name="Submit3" value="返回" onclick="window.history.back()">
	</td>
    </tr>
<%
	  }
	 }
	 catch(Exception e) {DBConBean.closeAll();
	   e.printStackTrace();
	 }	DBConBean.closeAll();	
%>
  </table>
  </form>
</body>
</html>
⌨️ 快捷键说明

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