📄 jcy_jd_view.jsp
字号:
<%@ page contentType="text/html; charset=GBK" errorPage="" %>
<%@ import="com.vstsoft.std.vststd" %>
<%com.vstsoft.std.vststd std=new com.vstsoft.std.vststd();%>
<%@ errorPage="errorPage.jsp" %>
<%@page import="sun.jdbc.rowset.*"%>
<jsp:useBean id="PageList" class="com.vstsoft.std.PageList" scope = "session" />
<jsp:useBean id="jcypurview" class="com.vstsoft.jcypurview" scope = "session" />
<% if (jcypurview.checkLogin() == false)
{
%>
<Script Language=javascript>
alert("用户已断线或未正常登录，请重新登录！")
window.open("../index.htm","_top")
</Script>
<% return;
}
if (jcypurview.purviewVerdict("B0500039") == false)
{
%>
<Script Language=javascript>
alert("您没有操作此页权限！")
window.open("../index.jsp","_top")
</Script>
<% return;
} %>
<%
String nowuserid = jcypurview.getUserid(); //取当前用户编号
String nowusername = jcypurview.getUserName(); //取当前用户名称
String nowuserszqx = jcypurview.getUserSzqx(); //取当前用户所在区县
String nowuserszdw = jcypurview.getUserSzdw(); //取当前用户所在单位
%>
<html>
<head>
<title>公务员管理</title>
<link rel="stylesheet" href="../style.css" type="text/css">
<%
//response.setHeader("Pragma","No-cache");
//response.setHeader("Cache-Control","no-cache");
//response.setDateHeader("Expires",0);
String dm = std.getValue(request,"dm"); //街道代码
String mc = std.getValue(request,"mc"); //街道名称
String jl = "";
String dmm = ""; //街道编号
String key ="";
String sql_select = "";
key = std.getValue(request,"key");
if(key.equals("query"))
{
if(nowuserszqx.equals("001"))
{
sql_select = "select dm,dm,mc from dm_mx where dmm='0002'";
if (!dm.equals(""))
sql_select = sql_select + "and dm like '%"+dm+"%'";
if (!mc.equals(""))
sql_select = sql_select + "and mc like '%"+mc+"%'";
sql_select = sql_select + "order by dm_mx.dm";
}
if(!nowuserszqx.equals("001"))
{
sql_select = "select dm,dm,mc from dm_mx where dmm='0002' and dm like '"+nowuserszqx+"%'";
if (!dm.equals(""))
sql_select = sql_select + "and dm like '%"+dm+"%'";
if (!mc.equals(""))
sql_select = sql_select + "and mc like '%"+mc+"%'";
sql_select = sql_select + "order by dm_mx.dm";
}
PageList.setJndi("jc");
PageList.setPagenum(1);
PageList.setListnum(20);
PageList.setLink("jcy_jd_view.jsp");
//PageList.setTarget("jcy_jd_view.jsp");
PageList.setTarget("mainFrame");
PageList.setSql(sql_select);
}
else{
String pagen = std.getValue(request,"p");
int pagenum = Integer.parseInt(pagen);
PageList.setPagenum(pagenum);
}
CachedRowSet crs = new CachedRowSet();
crs = PageList.getRs();
crs.beforeFirst();
String panduan = "select count(*) from dm_mx where dmm='0002'";
if (!dm.equals(""))
panduan = panduan + "and dm like '%"+dm+"%'";
if (!mc.equals(""))
panduan = panduan + "and mc like '%"+mc+"%'";
sun.jdbc.rowset.CachedRowSet ii = std.getResultBySelect(panduan);
ii.next();
jl = ii.getString(1);
%>
<script language=javascript>
var G_id;
function f_radio(num)
{
G_id = num;
}
function f_modify()
{
if (<%=jl%> == 0)
{
alert("没有记录");
return false;
}
if (G_id == "" || G_id == null)
{
alert("请选择街道信息！");
return false;
}
else
{
window.open("jcy_jd_new_modify.jsp?zt=modify&ID="+G_id,"_self");
}
}
function f_del()
{
if (<%=jl%> == 0)
{
alert("没有记录");
return false;
}
if (G_id == "" || G_id == null)
{
alert("请选择删除的街道信息！");
return false;
}
else
{
form.action = "jcy_jd_submit.jsp?zt=del&ID="+G_id;
form.submit();
}
}
function f_imager(text,ixy)
{
if (ixy == '0')
{
alert(text);
window.open("jcy_jd_select.jsp","_self");
}
else
{
alert(text);
}
}
function f_back()
{
window.open("jcy_jd_select.jsp","_self");
}
</script>
</head>
<body>
<tr>
<td width="252"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="12" height="84" align="left" background="../images/caozuo01.gif"> </td>
<td background="../images/caozuo02.gif" align="center" width="744"><font size="3" color="#FF6600"><b>街道查询</b></font></td>
<td width="15"><img src="../images/caozuo03.gif" width="15" height="84"></td>
</tr>
</table>
<table width="100%" height="177" border="0" cellpadding="0" cellspacing="0" bgcolor="#EEF9FF">
<tr>
<td width="15" height="177" background="../images/caozuo04.gif"><img src="../images/caozuo04.gif" width="15" height="6"></td>
<td width="759" align="center"><br>
<table width="95%" height="119" border="0" align="center">
<tr>
<td width="719" height="115">
<form name="form" method="post" action="" target="jdview">
<br>
<table width="100%" bordercolorlight=#666699 bordercolordark=#ffffff border="1" cellspacing="0" cellpadding="0" align="center">
<tr align='center' bgcolor="#174ca3" height='25'>
<td width='45' height="40"><font color="#FFFFFF"> </font></td>
<td width='209'><font color="#FFFFFF">街道代码</font></td>
<td width="425" colspan="2"><font color="#FFFFFF">街道名称</font></td>
</tr>
<%while (crs.next()){
dm = crs.getString(1);
dmm = crs.getString(2); //街道编号dm
mc = crs.getString(3);
if (dm == null) dm = "001001";
if (dmm == null) dmm = "001001";//街道编号dm
if (mc == null) mc = "";
%>
<tr height='25' align='center'>
<td width="45" height="25"> <font size="-1">
<input type="radio" name="radiobutton" value="<%=dm%>" onClick="f_radio(this.value)">
</font></td>
<td><font color="#105781"><%=dmm%></font></td>
<td colspan="2"><font color="#105781"><%=mc%></font></td>
</tr>
<%}%>
</table>
<br>
<table width="600" border="0" align="center" bordercolorlight=#666699 bordercolordark=#ffffff>
<tr>
<td width="67" height="23"> <div align="right"></div>
<div align="center"></div>
<div align="center"></div>
<div align="center"> </div></td>
<td width="109"> <input type="button" name="Submit52" value="修 改" class="input" onClick = "f_modify()"></td>
<td width="164"> <div align="center">
<input type="button" name="Submit223" value="删 除" class="input" onClick = "f_del()">
</div></td>
<td width="179"> <div align="center">
<input type="button" name="Submit2232" value="返 回" class="input" onClick="f_back()">
</div></td>
<td width="59"> </td>
</tr>
</table>
</form></td>
</tr>
</table>
<table align=center border=0 cellpadding=2 cellspacing=0 width=95% bgcolor="#FFF8CC">
<tbody>
<tr>
<td height=10 width=30> </td>
<td height=10 width=670> <%=PageList.getLink()%></td>
</tr>
</tbody>
</table>
<p> </td>
<td width="14" background="../images/caozuo07.gif"><img src="../images/caozuo07.gif" width="14" height="6"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="21" height="16"><img src="../images/caozuo05.gif" width="21" height="16"></td>
<td width="763" background="../images/caozuo08.gif"><img src="../images/caozuo08.gif" width="6" height="16"></td>
<td width="19"><img src="../images/caozuo09.gif" width="19" height="16"></td>
</tr>
</table>
<br> </td>
</tr>
</table></td>
<td width="59"> </td>
<br>
<td width="381">
<p><br>
</p></td>
<div align="center"></div>
<tr>
<iframe name="jdview" width="1000" height="1000" style="display:none" ></iframe>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -