📄 ry_ziliao.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>
function subb() {
if(document.form1.s_user_name.value==""){
alert("请填写要增加的栏目名称！！");
}
else
if(document.form1.s_user_mima.value==""){
alert("请填写要增加的管理员信箱！！");
}else{
document.form1.action="ry_add.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="90%">
    <tr> 
      <td>用户名：</td>
      <td> 
        <input type="text" name="s_user_name" style="width:100px">
      </td>
    </tr>
    <tr> 
      <td>密　码：</td>
      <td> 
        <input type="text" name="s_user_mima" style="width:100px">
      </td>
    </tr>
    <tr> 
      <td>用户权限编号：</td>
      <td>
 <select name="s_u_power_id" style="width:100px"><%
  IdSelectBean.setIdName("1");
  IdSelectBean.setStrTableName("school_user_power");
  IdSelectBean.setStrId("1 and s_u_power_del=0");
  String s_u_power_id =(String)session.getValue("s_u_power_id"); 
  int s_u_power = Integer.parseInt(s_u_power_id);
 	 try {
	  Connection conn = DBConBean.getConnection();
	  IdSelectBean.setConn(conn);
	  ResultSet result = IdSelectBean.getResultSet();
  int j=s_u_power+1;int i;
	//利用while循环将数据表中的记录列出
	for(i=1;i<j;i++) {result.next();
%>
       
		<option value="<%= result.getString("s_u_power_id") %>"><%= result.getString("s_u_power_bei") %></option>
       
<%

	  }
	 }
	 catch(Exception e) {DBConBean.closeAll();
	   e.printStackTrace();
	 }		

%>    </select>   </td>
    </tr>
    <tr> 
      <td>用户所属项目：<%=s_u_power_id%></td>
      <td> 
       <select name="s_jb_id" style="width:100px">  <%
  String s_jb_id =(String)session.getValue("s_jb_id");
  IdSelectBean.setIdName("s_jb_del");
  IdSelectBean.setStrTableName("school_jibie");
  if(s_u_power_id.equals("4")){IdSelectBean.setStrId("0");}else{
  IdSelectBean.setStrId("0 and s_jb_id="+s_jb_id);}
  
 	 try {
	  ResultSet result1 = IdSelectBean.getResultSet();

	//利用while循环将数据表中的记录列出
	while(result1.next()) {
%>
       
          <option value="<%= result1.getString("s_jb_id") %>"><%= result1.getString("s_jb_name") %></option>
        
        <%

	  }
	 }
	 catch(Exception e) {DBConBean.closeAll();
	   e.printStackTrace();
	 }		

%></select>
      </td>
    </tr>
    <tr> 
      <td>用户所属栏目：</td>
      <td> 
       <select name="lm_id" style="width:100px"><option value="1">全部栏目</option> <%
  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 result2 = IdSelectBean.getResultSet();

	//利用while循环将数据表中的记录列出
	while(result2.next()) {
%>
        
          <option value="<%= result2.getString("lm_id") %>"><%= result2.getString("lm_name") %></option>
       
        <%

	  }
	 }
	 catch(Exception e) {DBConBean.closeAll();
	   e.printStackTrace();
	 }		
    DBConBean.closeAll();
%> </select>
      </td>
    </tr>
    <tr> 
      <td colspan="2">
        <input type="button" name="Submit2" value="提交" onclick="subb()">
        <input type="reset" name="Submit3" value="重置">
      </td>
    </tr>
  </table>
  </form>
</body>
</html>
⌨️ 快捷键说明

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