📄 ry_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(); %>
<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="ry_up2.jsp">

<%
  String s_user_id = request.getParameter("s_user_id");
  String s_u_power_id ="";
  String s_jb_id ="";
  String lm_id ="";
  IdSelectBean.setIdName("s_user_id");
  IdSelectBean.setStrTableName("school_user");
  IdSelectBean.setStrId(s_user_id+" and s_user_del=0");
  
 	 try {
	  Connection conn = DBConBean.getConnection();
	  IdSelectBean.setConn(conn);
	  ResultSet result = IdSelectBean.getResultSet();

	//利用while循环将数据表中的记录列出
	while(result.next()) {
    s_jb_id=result.getString("s_jb_id");
    s_u_power_id=result.getString("s_u_power_id");
    String s_user_name=result.getString("s_user_name");
	String s_user_mima=result.getString("s_user_mima");
	lm_id=result.getString("lm_id");

%>
   
  <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="hidden" name="s_user_id" style="width:100px" value="<%=s_user_id%>">
        <input type="text" name="s_user_name" style="width:100px" value="<%=s_user_name%>">
      </td>
    </tr>
    <tr> 
      <td>密　码：</td>
      <td> 
        <input type="text" name="s_user_mima" style="width:100px" value="<%=s_user_mima%>">
      </td>
    </tr>
<%

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

%> 
    <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");
  
 	 try {
	  ResultSet result = IdSelectBean.getResultSet();

	//利用while循环将数据表中的记录列出
	while(result.next()) {

String s_u_power_id_new=result.getString("s_u_power_id");
String s_u_power_bei=result.getString("s_u_power_bei");

if (s_u_power_id_new.equals(s_u_power_id)){
out.println("<option value='"+s_u_power_id_new+"' selected>"+s_u_power_bei+"</option>");}else
{out.println("<option value='"+s_u_power_id_new+"'>"+s_u_power_bei+"</option>");}

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

%>    </select>
	 </td>
    </tr>
    <tr> 
      <td>用户所属项目：</td>
      <td> 
       <select name="s_jb_id" style="width:100px">  <%
  IdSelectBean.setIdName("1");
  IdSelectBean.setStrTableName("school_jibie");
  IdSelectBean.setStrId("1 and s_jb_del=0");
  
 	 try {
	  ResultSet result1 = IdSelectBean.getResultSet();

	//利用while循环将数据表中的记录列出
	while(result1.next()) {

String s_jb_id_new=result1.getString("s_jb_id");
String s_jb_name=result1.getString("s_jb_name");

if (s_jb_id_new.equals(s_jb_id)){
out.println("<option value='"+s_jb_id_new+"' selected>"+s_jb_name+"</option>");}else
{out.println("<option value='"+s_jb_id_new+"'>"+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> <%
  s_jb_id =(String)session.getValue("s_jb_id");
  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()) {

String lm_id_new=result2.getString("lm_id");
String lm_name=result2.getString("lm_name");

if (lm_id_new.equals(lm_id)){
out.println("<option value='"+lm_id_new+"' selected>"+lm_name+"</option>");}else
{out.println("<option value='"+lm_id_new+"'>"+lm_name+"</option>");}
	  }
	 }
	 catch(Exception e) {DBConBean.closeAll();
	   e.printStackTrace();
	 }		
    DBConBean.closeAll();
%> </select>
      </td>
    </tr>
    <tr> 
      <td colspan="2">
        <input type="submit" name="Submit2" value="提交">
        <input type="reset" name="Submit3" value="重置">
      </td>
    </tr>
  </table>
  </form>
</body>
</html>
⌨️ 快捷键说明

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