📄 zt_up.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();
String zt_id = request.getParameter("zt_id");
String s_jb_id =(String)session.getValue("s_jb_id"); %>
<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>
function popInsertImage()
{
  window.open("into.jsp","wnd_pop",
          "toolbar=0,status=0,resizable=1,width=780,height=550,top=0,left=0");
  return;
}
</script>
<script language="javascript">
function subb() {
if(document.form1.zt_name.value==""){
alert("请填写要增加的栏目名称！！");
}
else
if(document.form1.zt_info.value==""){
alert("请填写要增加的管理员信箱！！");
}else{
document.form1.action="zt_up2.jsp";
form1.submit();
}
}
</script>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="">
  <table border="1" cellspacing="0" cellpadding="0" align="left"  bordercolorlight="#000000" bordercolordark="#ffffff" class="zw" bgcolor="#e1e1e1" width="75%">
  <%
  	  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="";
   IdSelectBean.setIdName("zt_id");
   IdSelectBean.setStrTableName("zhuanti");
   IdSelectBean.setStrId(zt_id+" and zt_del=0 and s_jb_id="+s_jb_id+"");
  
 	 try {
	  Connection conn = DBConBean.getConnection();
	  IdSelectBean.setConn(conn);
	  ResultSet result1 = IdSelectBean.getResultSet();
	  //利用while循环将数据表中的记录列出
	  while(result1.next()) {
	  lm_id=result1.getString("lm_id");
	  zt_name=result1.getString("zt_name");
	  zt_info=result1.getString("zt_info");
	  zt_data=result1.getString("zt_data");
	  zt_moban_id=result1.getString("zt_moban_id");
	  zt_pic=result1.getString("zt_pic");
	  zt_jinghua=result1.getString("zt_jinghua");
	  zt_power=result1.getString("zt_power");
	  %>    <tr> 
      <td>&nbsp;</td>
      <td>专题名称：</td>
      <td> 
        <input type="text" name="zt_name" value="<%=zt_name%>">
      </td>
      <td>&nbsp;</td>
    </tr>
    <tr> 
      <td>&nbsp;</td>
      <td>专题所属栏目：</td>
      <td> 
        
 <%	  }
	result1.close(); }
	 catch(Exception e) {DBConBean.closeAll();
	   e.printStackTrace();
	 }	
%>     <select name="lm_id" style="width:140px">    <% 
   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_id)){
out.println("<option value='"+lm_id_new+"' selected>"+lm_name_new+"</option>");}else
{out.println("<option value='"+lm_id_new+"'>"+lm_name_new+"</option>");}
}
	 }
	 catch(Exception e) {DBConBean.closeAll();
	   e.printStackTrace();
	 }
%>
        </select>
      </td>
      <td>&nbsp;</td>
    </tr>
    <tr> 
      <td>&nbsp;</td>
      <td>专题模板：</td>
      <td> 
<select name="zt_moban_id" style="width:140px">
<% 
   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(zt_moban_id)){
out.println("<option value='"+jm_id_new+"' selected>"+jm_bei+"</option>");}else
{out.println("<option value='"+jm_id_new+"'>"+jm_bei+"</option>");}
}
	 }
	 catch(Exception e) {DBConBean.closeAll();
	   e.printStackTrace();
	 }	DBConBean.closeAll();	
%> </select>
        <input type="hidden" name="zt_data" value="<%=zt_data%>">
		<input type="hidden" name="zt_id" value="<%=zt_id%>">
      </td>
      <td>&nbsp;</td>
    </tr>
    <tr> 
      <td>&nbsp;</td>
      <td>专题图片地址：</td>
      <td> 
        <textarea name="zt_pic"><%=zt_pic%></textarea>
        <a href="javascript:popInsertImage()">选图片地址</a></td>
      <td>&nbsp;</td>
    </tr>
    <tr> 
      <td>&nbsp;</td>
      <td>专题精华推荐：</td>
      <td>  <% if (zt_jinghua.equals("1"))
		 {out.println("<input type='radio' name='zt_jinghua' value='1' checked>精华推荐<input type='radio' name='zt_jinghua' value='0'>普通专题");
		 }else
			 {out.println("<input type='radio' name='zt_jinghua' value='1'>精华推荐<input type='radio' name='zt_jinghua' value='0' checked>普通专题");}%>
      </td>
      <td>&nbsp;</td>
    </tr>
    <tr> 
      <td>&nbsp;</td>
      <td colspan="2">专题简介：</td>
      <td>&nbsp;</td>
    </tr>
    <tr> 
      <td>&nbsp;</td>
      <td colspan="2"> 
        <textarea name="zt_info" style="width:300px"><%=zt_info%></textarea>
      </td>
      <td>&nbsp;</td>
    </tr>
    <tr> 
      <td>&nbsp;</td>
      <td colspan="2">
        <input type="button" name="Submit" value="提交" onclick="subb()">
         <input type="button" name="Submit" value="返回" onclick="window.history.back()">
		<input type="reset" name="Submit2" value="重置">
      </td>
      <td>&nbsp;</td>
    </tr>
  </table>
</form>
</body>
</html>
⌨️ 快捷键说明

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