📄 ry_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>

<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%>">
        <%=s_user_name%>
      </td>
    </tr>
    <tr> 
      <td>密　码：</td>
      <td> 
        <%=s_user_mima%>
      </td>
    </tr>
<%

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

%> 
    <tr> 
      <td>用户权限编号：</td>
      <td>
<%
  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(s_u_power_bei);}else
{}

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

%>
	 </td>
    </tr>
    <tr> 
      <td>用户所属项目：</td>
      <td> 
<%
  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(s_jb_name);}else
{}
	  }
	 }
	 catch(Exception e) {DBConBean.closeAll();
	   e.printStackTrace();
	 }		

%>
          
      </td>
    </tr>
    <tr> 
      <td>用户所属栏目：</td>
      <td> 
<%
  IdSelectBean.setIdName("1");
  IdSelectBean.setStrTableName("lanmu");
  IdSelectBean.setStrId("1");
  
 	 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(lm_name);}else
{}
	  }
	 }
	 catch(Exception e) {DBConBean.closeAll();
	   e.printStackTrace();
	 }		
    DBConBean.closeAll();
%>
      </td>
    </tr>
    <tr> 
      <td colspan="2"> <input type="button" name="Submit3" value="返回" onclick="window.history.back()">
      </td>
    </tr>
  </table>
  </form>
</body>
</html>
⌨️ 快捷键说明

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