📄 userdetails.jsp
字号:
<%@ page language="java" contentType="text/html; charset=GBK" import="imis.*,java.util.*,java.sql.*"%>
<%
request.setCharacterEncoding("GBK");
session=request.getSession();
String user=(String)session.getAttribute("user");
if(user==null){
response.sendRedirect("../../login.html");
}
else{
String userid=request.getParameter("userid");
String name="wmj"; String pass="197555"; String processname = "";
String url=new String(); url="jdbc:sybase:Tds:172.16.0.1:4000/imis";
Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
String sql1 = "select * from user1 where user_id=?" ;
Connection con=DriverManager.getConnection(url,name,pass);
PreparedStatement ps1=con.prepareStatement(sql1);
ps1.setString(1,userid);
ResultSet rs = null;
ResultSet rs1=null;
try{
rs = ps1.executeQuery();
}
catch(Exception e){
System.out.println("在显示用户详细页面的时候出错");
}
String sql2 = "select * from officeunit where unitid = ?";
ps1 = con.preparedStatement(sql2);
ps1.setInt(1,rs.unitid.intValue());
try{
rs1 = ps1.executeQuery();
}
catch(Exception ee){
System.out.println("显示用户详细页面的时候，查询用户单位名称出错");
}%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>MSA Office</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb_2312-80">
<META content="Microsoft FrontPage 4.0" name=GENERATOR>
<link rel="stylesheet" href="../../css/msa.css" type="text/css">
<script language="JavaScript" src="../../public/js/user_menu.js"></script>
<SCRIPT>
window.onload=init
</SCRIPT>
</HEAD>
<BODY class="bg" topMargin=20 leftmargin="0" marginwidth="0" marginheight="0">
<DIV align=center>
<form name="form1" method="post" action="list.html">
<TABLE class=outter cellSpacing=0 cellPadding=0 width=600 border=0>
<TR>
<TD><IMG height=4 src="../../MacOS/lefttop.gif" width=6></TD>
<TD background=../../MacOS/top.gif colSpan=3><IMG height=4
src="../../MacOS/top.gif" width=1></TD>
<TD><IMG height=4 src="../../MacOS/righttop.gif"></TD>
</TR>
<TR>
<TD vAlign=top background=../../MacOS/lwing.gif rowSpan=3><IMG height=18
src="../../MacOS/left.gif" width=6></TD>
<TD vAlign=top background=../../MacOS/titlebg.gif width="16">
<DIV><a href="../../index.html"><img src="../../MacOS/logo.gif" width="16" height="16" border="0" alt="返回MSA_Office首页"></a></DIV>
</TD>
<TD vAlign=top noWrap align=center width="100%"
background=../../MacOS/titlebg.gif><SPAN
style="BACKGROUND-COLOR: #cecece"><FONT class=strong> MSA - OFFICE </font></SPAN></TD>
<TD><a href="javascript:self.close()"><IMG height=18 src="../../MacOS/right_b2.gif" width=18 border="0" alt="关闭窗口"></a></TD>
<TD vAlign=top background=../../MacOS/rwing.gif rowSpan=3><IMG height=18
src="../../MacOS/right.gif" width=7></TD>
</TR>
<TR>
<TD background=../../MacOS/hr.gif colSpan=3><IMG height=2
src="../../MacOS/hr.gif" width=1></TD>
</TR>
<TR>
<TD colSpan=3 align="center"><br>
<table width="600" border="1" cellspacing="1" bordercolor="#666666">
<tr bgcolor="#fafafa">
<td height="121">
<table class=title width="600" border="0" cellspacing="1" cellpadding="2">
<tr>
<td colspan="2" height="15" bgcolor="#666666"><font class=strongw>用户信息管理</font></td>
</tr>
<tr>
<td colspan="2" bgcolor="#fafafa"> 用户详细信息</td>
</tr>
<tr bgcolor="#e0e0e0">
<td width="125" bgcolor="#e0e0e0"> <font class="strong" > 用户ID：</font>
</td>
<td width="469" bgcolor="#e0e0e0"><%=rs.userId%></td>
</tr>
<tr bgcolor="#fafafa">
<td> <font class="strong" > 用户名称：</font> </td>
<td><%=rs.userName%></td>
</tr>
<tr bgcolor="#e0e0e0">
<td><font class="strong"> 用户权限：</font></td>
<%
String access="";
if(rs.userAccess.equals(new Integer(0))||rs.userAccess.equals(new Integer(1)))
access="用户管理员";
if(rs.userAccess.equals(new Integer(3)))
access="基层业务主管";
if(rs.userAccess.equals(new Integer(4)))
access="基层测绘主管";
if(rs.userAccess.equals(new Integer(6)))
access="海区业务主管";
if(rs.userAccess.equals(new Integer(7)))
access="海区测绘主管";
if(rs.userAccess.equals(new Integer(9)))
access="海事局主管";
if(rs.userAccess.intValue()==2)
access="维修员";
if(rs.userAccess.intValue()==5)
access="海区录入员";
if(rs.userAccess.intValue()==8)
access="基层物资";
if(rs.userAccess.intValue()==10)
access="立项录入员";
if(rs.userAccess.intValue()==11)
access="航标站员工";
%>
<td><%=access%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td> <font class="strong"> 用户单位： </font> </td>
<td><%=rs1.processname%></td>
</tr>
<tr align="center" bgcolor="#fafafa">
<td colspan="2" height="30">
<input type="button" name="Submit22" value=" 修 改 " class="file" onClick="location='usermodify.jsp?userid=<%=rs.userId%>'">
<input type="button" name="Submit22" value=" 删 除 " class="file" onClick="location='userdelete.jsp?userid=<%=rs.userId%>'">
<input type="button" name="Submit25" value=" 返 回 " class="file" onClick="history.back()">
</td>
</tr>
</table></td>
</tr>
</table>
<p><img src="../../images/msalogo.gif" width="272" height="50">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="3"><img src="a.gif" width="1" height="1"></td>
</tr>
<tr>
<td background="../../MacOS/hr.gif"><img src="../../MacOS/hr.gif" width="1" height="2"></td>
</tr>
<tr>
<td height="3"><img src="a.gif" width="1" height="1"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <div align="right"><a href="../../help.html" target="blank" style="cursor:help" title="使用帮助"><img src="../../MacOS/help.gif" width="16" height="16" border="0">HELP</a></div></td>
</tr>
</table></TD>
</TR>
<TR>
<TD height="7"><IMG height=7 src="../../MacOS/leftbottom.gif" width=6></TD>
<TD background=../../MacOS/bottom.gif colSpan=3><IMG height=7
src="../../MacOS/bottom.gif" width=1></TD>
<TD><IMG height=7 src="../../MacOS/rightbottom.gif"
width=7></TD>
</TR>
</TABLE> <BR> </form></DIV></BODY></HTML>
<% rs.close();
rs1.close();
ps1.close();
con.close();
}%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -