⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 jcy_ry_view.jsp

📁 一个较好的公务员管理系统软件源代码
💻 JSP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*,com.vstsoft.std.*" %>
<%@ page import="javax.naming.*"%>
<%@ page import="javax.sql.DataSource"%>
<jsp:useBean id="jcypurview" class="com.vstsoft.jcypurview" scope = "session" />
<%
  String currusercode = jcypurview.getUsercode(); //取当前用户usercode
  String curruserid = jcypurview.getUserid();     //取当前用户编号
  String currusername = jcypurview.getUserName(); //取当前用户名称
  String curruserszqx = jcypurview.getUserSzqx(); //取当前用户所在区县 
  String curruserszdw = jcypurview.getUserSzdw(); //取当前用户所在单位

//检测用户是否登录
if (jcypurview.checkLogin() == false)
   {
%>   
	<Script Language=javascript>
		alert("用户已断线或未正常登录，请重新登录！")
		window.open("../index.htm","_top")
	</Script>
<%  
    return;}
%>
<%
  //检测用户是否有操作权限 
  if (!(jcypurview.purviewVerdict("B0500001") || jcypurview.purviewVerdict("B0500002") || jcypurview.purviewVerdict("B0500003") || jcypurview.purviewVerdict("B0500009") || jcypurview.purviewVerdict("B0500010") || jcypurview.purviewVerdict("B0500035") || jcypurview.purviewVerdict("B0500036") || jcypurview.purviewVerdict("B0500037") || jcypurview.purviewVerdict("B0500038") || jcypurview.purviewVerdict("B0500043")))
  {
%>
	<Script Language=javascript>
		alert("您没有操作此页权限！")
		window.open("../index.jsp","_top")
	</Script>
<%	return;
   }
%> 
<html>
<head>
<%vststd std = new vststd();%>
<title>公务员详细信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<script language="JavaScript1.2" src="new.js"></script>
<link rel="stylesheet" href="../style.css" type="text/css">
<%
	String uid = request.getParameter("uid");
	String sdwdm = std.getValue(request, "sdwdm");
	String szbdm = std.getValue(request, "szbdm");
	String sql_view = null;

	if (sdwdm.equals("")){
	sql_view = "select ry.username, ry.sfzh, dp_sys.F_Get_mc_by_dm('0004',ry.xb), ry.usercode, DP_SYS.TO_CHN_DATE(ry.csrq,'YMD'), dp_sys.F_Get_mc_by_dm('0006',ry.mz), dp_sys.F_Get_mc_by_dm('5005',ry.whcd), ry.sxzy, dp_sys.F_Get_mc_by_dm('5004',ry.zzmm), dp_sys.F_Get_mc_by_dm('0001',ry.qx), dp_sys.F_Get_mc_by_dm('0002',ry.jddm), dp_sys.F_Get_mc_by_dm('5007',ry.sfjd), '' dwmc , '' zbmc,  dp_sys.F_Get_mc_by_dm('5003',ry.ssbz), dp_sys.F_Get_mc_by_dm('5006',ry.zjlb), dp_sys.F_Get_mc_by_dm('5002',ry.zw), ry.xphm, ry.zjhm, ry.fzjg, ry.gzbm, DP_SYS.TO_CHN_DATE(ry.gzqr,'YMD'), DP_SYS.TO_CHN_DATE(ry.gzzr,'YMD'), DP_SYS.TO_CHN_DATE(ry.zxrq,'YMD'), dp_sys.F_Get_mc_by_dm('5008',ry.zxyy), ry.ryzt, ry.qx, to_char(ry.gzzr, 'yyyymmdd') from jcy_ry ry where userid = '"+uid+"'";
	}
	else if (szbdm.equals("")){
	sql_view = "select ry.username, ry.sfzh, dp_sys.F_Get_mc_by_dm('0004',ry.xb), ry.usercode, DP_SYS.TO_CHN_DATE(ry.csrq,'YMD'), dp_sys.F_Get_mc_by_dm('0006',ry.mz), dp_sys.F_Get_mc_by_dm('5005',ry.whcd), ry.sxzy, dp_sys.F_Get_mc_by_dm('5004',ry.zzmm), dp_sys.F_Get_mc_by_dm('0001',ry.qx), dp_sys.F_Get_mc_by_dm('0002',ry.jddm), dp_sys.F_Get_mc_by_dm('5007',ry.sfjd), dw.dwmc, '',  dp_sys.F_Get_mc_by_dm('5003',ry.ssbz), dp_sys.F_Get_mc_by_dm('5006',ry.zjlb), dp_sys.F_Get_mc_by_dm('5002',ry.zw), ry.xphm, ry.zjhm, ry.fzjg, ry.gzbm, DP_SYS.TO_CHN_DATE(ry.gzqr,'YMD'), DP_SYS.TO_CHN_DATE(ry.gzzr,'YMD'), DP_SYS.TO_CHN_DATE(ry.zxrq,'YMD'), dp_sys.F_Get_mc_by_dm('5008',ry.zxyy), ry.ryzt, ry.qx, to_char(ry.gzzr, 'yyyymmdd') from jcy_ry ry, jcy_dw dw where userid = '"+uid+"' and ry.dwdm = dw.dwdm";
	}
	else{
	sql_view = "select ry.username, ry.sfzh, dp_sys.F_Get_mc_by_dm('0004',ry.xb), ry.usercode, DP_SYS.TO_CHN_DATE(ry.csrq,'YMD'), dp_sys.F_Get_mc_by_dm('0006',ry.mz), dp_sys.F_Get_mc_by_dm('5005',ry.whcd), ry.sxzy, dp_sys.F_Get_mc_by_dm('5004',ry.zzmm), dp_sys.F_Get_mc_by_dm('0001',ry.qx), dp_sys.F_Get_mc_by_dm('0002',ry.jddm), dp_sys.F_Get_mc_by_dm('5007',ry.sfjd), dw.dwmc, zb.zbmc,  dp_sys.F_Get_mc_by_dm('5003',ry.ssbz), dp_sys.F_Get_mc_by_dm('5006',ry.zjlb), dp_sys.F_Get_mc_by_dm('5002',ry.zw), ry.xphm, ry.zjhm, ry.fzjg, ry.gzbm, DP_SYS.TO_CHN_DATE(ry.gzqr,'YMD'), DP_SYS.TO_CHN_DATE(ry.gzzr,'YMD'), DP_SYS.TO_CHN_DATE(ry.zxrq,'YMD'), dp_sys.F_Get_mc_by_dm('5008',ry.zxyy), ry.ryzt, ry.qx, to_char(ry.gzzr, 'yyyymmdd') from jcy_ry ry, jcy_dw dw, jcy_zb zb where userid = '"+uid+"' and ry.dwdm = dw.dwdm and ry.zbdm = zb.zbdm";
	}

	sun.jdbc.rowset.CachedRowSet crs = std.getResultBySelect(sql_view);
	crs.next();
	String username = crs.getString(1);
	String sfzh = crs.getString(2);
	String xb   = crs.getString(3);
	String usercode = crs.getString(4);
	String csrq = crs.getString(5);
	String year = csrq.substring(0,4);
	String month= csrq.substring(5,7);
	String day  = csrq.substring(8);
	
	String mz   = crs.getString(6);
	String whcd = crs.getString(7);
	String sxzy = crs.getString(8);
	String zzmm = crs.getString(9);
	String qx   = crs.getString(10);
	String jd   = crs.getString(11);
	String sfjx = crs.getString(12);
	String gzdw = crs.getString(13);
	String sszb = crs.getString(14);
	String ssbz = crs.getString(15);
	String zjlb = crs.getString(16);
	String zw   = crs.getString(17);
	String xphm = crs.getString(18);
	String zjhm = crs.getString(19);
	String fzjg = crs.getString(20);
	String gzbm = crs.getString(21);
	String gzqr = crs.getString(22);
	String gzzr = crs.getString(23);
	String zxrq = crs.getString(24);
	String zxyy = crs.getString(25);
	String ryzt = crs.getString(26);
	String qxdm = crs.getString(27);

	String yxrq = crs.getString(28);

	username = (username != null)?username:"";
	sfzh = (sfzh != null)?sfzh:"";
	xb   = (xb != null)?xb:"";
	usercode = (usercode != null)?usercode:"";
	csrq = (csrq != null)?csrq:"";
	mz   = (mz != null)?mz:"";
	whcd = (whcd != null)?whcd:"";
	sxzy = (sxzy != null)?sxzy:"";
	zzmm = (zzmm != null)?zzmm:"";
	qx   = (!qx.equals(""))?qx:"市处";
	jd   = (jd != null)?jd:"";
	sfjx = (sfjx != null)?sfjx:"";
	gzdw = (gzdw != null)?gzdw:"";
	sszb = (sszb != null)?sszb:"";
	ssbz = (ssbz != null)?ssbz:"";
	zjlb = (zjlb != null)?zjlb:"";
	zw   = (zw != null)?zw:"";
	xphm = (xphm != null)?xphm:"";
	zjhm = (zjhm != null)?zjhm:"";
	fzjg = (fzjg != null)?fzjg:"";
	gzbm = (gzbm != null)?gzbm:"";
	gzqr = (gzqr != null)?gzqr:"";
	gzzr = (gzzr != null)?gzzr:"";
	zxrq = (zxrq != null)?zxrq:"";
	zxyy = (zxyy != null)?zxyy:"";

%>
</head>

<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td align="center"> <br>
      <table width="800" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="14" align="left" background="../images/caozuo01.gif">&nbsp;</td>
          <td background=".././images/caozuo02.gif" align="center" width="771"><b><font color="#FF6600" size="3">公务员详细信息</font></b>
		  </td>
          <td width="15"><img src=".././images/caozuo03.gif" width="15" height="84"></td>
        </tr>
      </table>
      <table width="800" border="0" cellspacing="0" cellpadding="0" bgcolor="#EEF9FF">
        <tr> 
          <td width="15" background=".././images/caozuo04.gif"><img src=".././images/caozuo04.gif" width="15" height="6"></td>
          <td align="center"> 
			<form name="form1" method="post" action="" target="submitx">
            <table width="750" cellspacing="1" cellpadding="0" bgcolor="#000099">
              <tr> 
                <td> 
			  <table align=center bordercolordark=#ffffff bordercolorlight=#666699 
cellpadding=0 cellspacing=1 width=100% bgcolor="#000099">
                      <tr align="center" bgcolor="#EEF9FF">
12

⌨️ 快捷键说明

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