📄 zg.jsp
字号:
<td colspan="3"><div align="left"><span class="style6"><%=rs2.getString("JJLY")%></span></div></td>
</tr>
</table>
<%}%>
<div align="center">
<%bh=rs.getString("BH");
int shgx=0;
String newcondition3="select * from SHGX where BH="+"'"+bh+"'";
conn.setcondition(newcondition3);
ResultSet rs3=conn.getrs();
while(rs3.next())
{shgx++;}
if(shgx==0){out.print("无社会关系记录！");}
else
{out.print(rs.getString("XM"));out.print("的社会关系表：");}
conn.setcondition(newcondition3);
rs3=conn.getrs();
while(rs3.next())
{
%>
</div>
<table width="900" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#FF99CC">
<!--DWLayoutTable-->
<tr>
<td width="106" height="20" valign="top"bgcolor="#FF99CC" class="style9">关系人姓名:</td>
<td width="109" valign="top"><div align="left"><%=rs3.getString("GXXM")%></div></td>
<td width="109" valign="top"bgcolor="#FF99CC" class="style9">二人关系:</td>
<td width="109" valign="top"><div align="left"><%=rs3.getString("YBRGX")%></span></div></td>
<td width="104" valign="top"bgcolor="#FF99CC" class="style9">政治面目:</td>
<td width="112" valign="top"><div align="left"><span class="style6"><%=rs3.getString("ZZMM")%></span></div></td>
<td width="112" valign="top"bgcolor="#FF99CC"><span class="style9">职务工种:</span></td>
<td width="112" valign="top"><div align="left"><span class="style6"><%=rs3.getString("ZWGZ")%></span></div></td>
</tr>
<tr>
<td height="20" valign="top" bgcolor="#FF99CC"><span class="style9">工作单位:</span></td>
<td colspan="7" valign="top"><div align="left"><span class="style6"><%=rs3.getString("GZDW")%></span></div></td>
</tr>
<tr>
<td height="20" valign="top" bgcolor="#FF99CC"><span class="style9">备注：</span></td>
<td colspan="7" valign="top"><div align="left"><span class="style6"><%=rs3.getString("BZ")%></span></div></td>
</tr>
</table>
<%}%>
<div align="center">
<%bh=rs.getString("BH");
int grjl=0;
String newcondition4="select * from GRJL where BH="+"'"+bh+"'";
conn.setcondition(newcondition4);
ResultSet rs4=conn.getrs();
while(rs4.next())
{grjl++;}
if(grjl==0){out.print("无个人简历记录！");}
else
{out.print(rs.getString("XM"));out.print("的个人简历：");}
conn.setcondition(newcondition4);
rs4=conn.getrs();
while(rs4.next())
{
%>
</div>
<table width="900" border="1" align="center" cellspacing="1" bordercolor="#FF99CC">
<!--DWLayoutTable-->
<tr>
<td width="105" height="22" valign="top" bgcolor="#FF99CC"><span class="style9">前工作单位:</span></td>
<td colspan="3" valign="top" class="style6"><div align="left"><%=rs4.getString("GZDW")%></div></td>
</tr>
<tr>
<td height="22" valign="top" bgcolor="#FF99CC" class="style9">起止年月:</td>
<td width="334" valign="top" class="style6"><div align="left"><%=rs4.getString("QZNY")%></div></td>
<td width="102" valign="top" bgcolor="#FF99CC" class="style9">证明人:</td>
<td width="338" valign="top" class="style6"><div align="left"><%=rs4.getString("ZMR")%></div></td>
</tr>
</table>
<%}%>
<%}%>
<% String condition_gz="select * from bzgz where bh='"+page_bh+"'";
conn.setcondition(condition_gz);
ResultSet rs1=conn.getrs();
rs1.next();
rs1.last();
int all_gz=rs1.getRow();
if(all_gz==1)
{ rs1.first();
%>
<table width="900" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#FF99CC">
<!--DWLayoutTable-->
<tr>
<td height="30" colspan="12" align="center" valign="middle"bgcolor="#FF99CC">
<div align="center" class="style2"><%=rs1.getString("XM")%>工资明细表</div></td>
</tr>
<tr>
<td width="75" bgcolor="#FF99CC"><div align="left">超时:</div></td>
<td width="75"><div align="center"><%=rs1.getString("CS")%></div></td>
<td width="75" bgcolor="#FF99CC"><div align="left">超价:</div></td>
<td width="75"><div align="center"><%=rs1.getString("CJ")%></div></td>
<td width="75" bgcolor="#FF99CC"><div align="left">超资:</div></td>
<td width="75"><div align="center"><%=rs1.getString("CZ")%></div></td>
<td width="75" bgcolor="#FF99CC"><div align="left">加天:</div></td>
<td width="75"><div align="center"><%=rs1.getString("JT")%></div></td>
<td width="75" bgcolor="#FF99CC"><div align="left">日工资:</div></td>
<td width="75"><p align="center"><%=rs1.getString("RGZ")%></p> </td>
<td width="75" bgcolor="#FF99CC"><div align="left">加资:</div></td>
<td width="62"><div align="center"><%=rs1.getString("JZ")%></div></td>
</tr>
<tr>
<td bgcolor="#FF99CC"><div align="left">粮副地工:</div></td>
<td><div align="center"><%=rs1.getString("LFDG")%></div></td>
<td bgcolor="#FF99CC"><div align="left">粮贴:</div></td>
<td><div align="center"><%=rs1.getString("LT")%></div></td>
<td bgcolor="#FF99CC"><div align="left">副贴:</div></td>
<td><div align="center"><%=rs1.getString("FT")%></div></td>
<td bgcolor="#FF99CC"><div align="left">单位贴:</div></td>
<td><div align="center"><%=rs1.getString("DWT")%></div></td>
<td bgcolor="#FF99CC"><div align="left">中夜班:</div></td>
<td><div align="center"><%=rs1.getString("ZYB")%></div></td>
<td bgcolor="#FF99CC"><div align="cleft">岗位薪:</div></td>
<td><div align="center"><%=rs1.getString("GWX")%></div></td>
</tr>
<tr>
<td bgcolor="#FF99CC"><div align="left">保健:</div></td>
<td><div align="center"><%=rs1.getString("BJ")%></div></td>
<td bgcolor="#FF99CC"><div align="left">保险:</div></td>
<td><div align="center"><%=rs1.getString("BX")%></div></td>
<td bgcolor="#FF99CC"><div align="left">药补:</div></td>
<td><div align="center"><%=rs1.getString("YB")%></div></td>
<td bgcolor="#FF99CC"><div align="left">卫生:</div></td>
<td><div align="center"><%=rs1.getString("WS")%></div></td>
<td bgcolor="#FF99CC"><div align="left">书报:</div></td>
<td><div align="center"><%=rs1.getString("SB")%></div></td>
<td bgcolor="#FF99CC"><div align="left">交通:</div></td>
<td><div align="center"><%=rs1.getString("JIAOTONG")%></div></td>
</tr>
<tr>
<td bgcolor="#FF99CC"><div align="left">房贴:</div></td>
<td><div align="center"><%=rs1.getString("FANGTIE")%></div></td>
<td bgcolor="#FF99CC"><div align="left">煤贴:</div></td>
<td><div align="center"><%=rs1.getString("MT")%></div></td>
<td bgcolor="#FF99CC"><div align="left">政府贴:</div></td>
<td><div align="center"><%=rs1.getString("ZFT")%></div></td>
<td bgcolor="#FF99CC"><div align="left">工资贴:</div></td>
<td align="center"><%=rs1.getString("GZBT")%></td>
<td bgcolor="#FF99CC"><div align="left">业务:</div></td>
<td><div align="center"><%=rs1.getString("YW")%></div></td>
<td bgcolor="#FF99CC"><div align="left">浮资:</div></td>
<td><div align="center"><%=rs1.getString("FZ")%></div></td>
</tr>
<tr>
<td bgcolor="#FF99CC"><div align="left">事天:</div></td>
<td><div align="center"><%=rs1.getString("ST")%></div></td>
<td bgcolor="#FF99CC"><div align="left">病天:</div></td>
<td><div align="center"><%=rs1.getString("BT")%></div></td>
<td bgcolor="#FF99CC"><div align="left">扣缺勤:</div></td>
<td><div align="center"><%=rs1.getString("KQQ")%></div></td>
<td bgcolor="#FF99CC"><div align="left">扣病假:</div></td>
<td><div align="center"><%=rs1.getString("KBJ")%></div></td>
<td bgcolor="#FF99CC"><div align="left">房租:</div></td>
<td><div align="center"><%=rs1.getString("KFZ")%></div></td>
<td bgcolor="#FF99CC"><div align="left">会费:</div></td>
<td><div align="center"><%=rs1.getString("KHF")%></div></td>
</tr>
<tr>
<td bgcolor="#FF99CC"><div align="left">违纪:</div></td>
<td><div align="center"><%=rs1.getString("WJ")%></div></td>
<td bgcolor="#FF99CC"><div align="leftr">扣公积金:</div></td>
<td><div align="center"><%=rs1.getString("KGJJ")%></div></td>
<td bgcolor="#FF99CC"><div align="leftr">其他:</div></td>
<td><div align="center"><%=rs1.getString("QT")%></div></td>
<td bgcolor="#FF99CC"> <div align="left">合计:</div></td>
<td><div align="center"><%%></div></td>
<td bgcolor="#FF99CC"><div align="left">应领工资:</div></td>
<td><div align="center"><%%></div></td>
<td bgcolor="#FF99CC"><div align="left">实领工资:</div></td>
<td><div align="center"><%%></div></td>
</tr>
</table>
<%}%>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -