?? 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="關(guān)閉窗口"></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"> 用戶權(quán)限：</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="基層業(yè)務(wù)主管";
if(rs.userAccess.equals(new Integer(4)))
access="基層測繪主管";
if(rs.userAccess.equals(new Integer(6)))
access="海區(qū)業(yè)務(wù)主管";
if(rs.userAccess.equals(new Integer(7)))
access="海區(qū)測繪主管";
if(rs.userAccess.equals(new Integer(9)))
access="海事局主管";
if(rs.userAccess.intValue()==2)
access="維修員";
if(rs.userAccess.intValue()==5)
access="海區(qū)錄入員";
if(rs.userAccess.intValue()==8)
access="基層物資";
if(rs.userAccess.intValue()==10)
access="立項錄入員";
if(rs.userAccess.intValue()==11)
access="航標(biāo)站員工";
%>
<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();
}%>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -