?? qx_ry_query.jsp
字號:
<%@page contentType="text/html;charset=GBK"%>
<%@ page import = "com.vstsoft.std.*" %>
<%@ page import = "java.sql.*" %>
<%@page import = "sun.jdbc.rowset.*"%>
<jsp:useBean id="jcypurview" class="com.vstsoft.jcypurview" scope = "session" />
<jsp:useBean id="PageList" class="com.vstsoft.std.PageList" scope = "session" />
<%vststd std = new vststd();%>
<% if (jcypurview.checkLogin() == false)
{
%>
<Script Language=javascript>
alert("用戶已斷線或未正常登錄，請重新登錄!")
window.open("../index.htm","_top")
</Script>
<% return;}
if (jcypurview.purviewVerdict("B0500006") == false)
{
%>
<Script Language=javascript>
alert("您沒有操作此頁權限!")
window.open("../index.jsp","_top")
</Script>
<% return; } %>
<%
String key = std.getValue(request, "key");
String lsql = "";
String squery = std.getValue(request,"query");
lsql = "select userid,usercode,username,(select mc from DM_MX where dmm = '0001' and dm = jcy_ry.QX),(select dwmc from jcy_dw where dwdm = jcy_ry.dwdm),(select zbmc from jcy_zb where zbdm = jcy_ry.ZBDM), lrrq from jcy_ry where RYZT = '03' and (usercode like '%"+ squery +"%' or username like '%"+ squery +"%') order by lrrq desc";
if (key.equals("query")){
PageList.setJndi("jc");
PageList.setPagenum(1);
PageList.setListnum(10);
PageList.setLink("qx_ry_view.jsp");
PageList.setTarget("tabFrame");
PageList.setSql(lsql);
}else{
String pagen = std.getValue(request,"p");
int pagenum = Integer.parseInt(pagen);
PageList.setPagenum(pagenum);
}
sun.jdbc.rowset.CachedRowSet ryview = new CachedRowSet();
ryview = PageList.getRs();
ryview.beforeFirst();
String suserid = "";
String susercode = "";
String susername = "";
String sqxmc = "";
String sdwmc = "";
String szbmc = "";
%>
<html>
<head>
<title>公務員權限管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<link rel="stylesheet" href="../style.css" type="text/css">
<script>
//function f_err(err,jcid,spd){
// alert(err);
// if (spd == "okdel"){
// location.reload();
// parent.leftFrame.location.reload();
// }
//}
</script>
</head>
<body background="../images/qx_4.gif" text="#000000" leftmargin="0" topmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td width="1"> </td>
<td width="759" align="center">
<form name="form1" method="post" action="">
<div id="submit">
<p><font color="#FF3300" size="3"><strong><br>
<br>
<br>
<br>
人 員 查 詢 結 果</strong></font></p>
<table align=center bordercolordark=#ffffff bordercolorlight=#666699 cellpadding=0 cellspacing=1 width=96% >
<tr align="center" bgcolor="#EEF9FF">
<td width="15%" height="22" bgcolor=#174ca3><font color="#FFFFFF">用戶名</font></td>
<td width="15%" bgcolor=#174ca3><font color="#FFFFFF">真實姓名</font></td>
<td width="15%" bgcolor=#174ca3><font color="#FFFFFF">所在區縣</font></td>
<td width="30%" bgcolor=#174ca3><font color="#FFFFFF">所在單位</font></td>
<td width="20%" bgcolor=#174ca3><font color="#FFFFFF">所在組別</font></td>
</tr>
<%while (ryview.next()){
suserid = ryview.getString(1);
susercode = ryview.getString(2);
susername = ryview.getString(3);
sqxmc = ryview.getString(4);
sdwmc = ryview.getString(5);
szbmc = ryview.getString(6);
suserid = (suserid != null)?suserid:"";
susercode = (susercode != null)?susercode:"";
susername = (susername != null)?susername:"";
sqxmc = (sqxmc != null)?sqxmc:"";
szbmc = (szbmc != null)?szbmc:"";
sdwmc = (sdwmc != null)?sdwmc:"";
%>
<tr align="center" bgcolor="#FFFFFF">
<td height="22"><a href='qx_tab.jsp?ID=<%=suserid%>' target='tabFrame'><font color="#990000" size="-1"><%=susercode%></font></a></td>
<td height="22"><font color="#105781" size="-1"><%=susername%></font></td>
<td height="22"><font color="#105781" size="-1"><%=sqxmc%></font></td>
<td height="22"><font color="#105781" size="-1"><%=sdwmc%></font></td>
<td height="22"><font color="#105781" size="-1"><%=szbmc%></font></td>
<%}%>
</table>
<table width="96%" height="42" border="0" cellspacing="0">
<tr>
<td width="672" height="40" align="center">
<div align="left"><%=PageList.getLink()%><br>
</div></td>
<td width="82" align="center"><div align="right">
</div></td>
</tr>
</table>
<div align="right"> </div>
</div>
</form>
</td>
<td width="10"> </td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -