📄 oa_jobqueryresult.jsp

📁 使用jsp,数据库使用orcale
💻 JSP
字号:
<%@include file="/internet/common.jsp"%>
<SCRIPT language="JavaScript" src="/pageComponent/resources/scripts/checkBox.js"></SCRIPT>
<SCRIPT language="JavaScript" src="/pageComponent/resources/scripts/pagination.js"></SCRIPT>
<SCRIPT language="JavaScript" src="/pageComponent/resources/scripts/dataformcheck.js"></SCRIPT>
<link rel="stylesheet" href="/pageComponent/resources/theme/style.css" type="text/css">
<PG:DataGrid>
<%--自动生成代码，请不要手动修改
<?xml version="1.0" encoding="GB2312" standalone="no"?>
<wizardContent version="1.0">
    <content>
        <iteratorXpath value="list[@type='OA_JOB']" type="String"/>
        <updateAction value="employee.pr.prOA_JOBUpdate.do" type="String"/>
        <oddClass value="pg_result_content" type="String"/>
        <title value="查询结果" type="String"/>
        <insertTarget value="_self" type="String"/>
        <isPage value="true" type="Boolean"/>
        <insertAction value="forward.do?nextPage=/employee/page/OA_JOBInsert.jsp" type="String"/>
        <highLightClass value="onmouseover" type="String"/>
        <updateTarget value="_self" type="String"/>
        <deleteAction value="employee.pr.prOA_JOBDelete.do" type="String"/>
        <deleteTarget value="_top" type="String"/>
        <selectFieldStyle value="checkbox" type="String"/>
        <evenClass value="pg_result_content_" type="String"/>
        <pageAction value="employee.pr.prOA_JOBQuery.do" type="String"/>
        <selectFieldName value="JOB_ID" type="String"/>
        <formName value="form1" type="String"/>
    </content>
    <entity name="OA_JOB" id="entity">
        <field name="JOB_ID" dataType="number" displayName="序号" length="19" precision="3" isKey="true">
            <showType value="show"/>
            <fieldType value="BigDecimal"/>
        </field>
        <field name="EMPLOYEE_ID" displayName="员工编号" length="20">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="EMPLOYEE_NAME" displayName="员工姓名" length="20" isNullable="true">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="DEPARTMENT_ID" displayName="部门编号" length="20">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="JOB_DATE" dataType="date" displayFormat="yyyy-MM-dd" displayName="日期" isNullable="true">
            <showType value="show"/>
            <fieldType value="Date"/>
        </field>
        <field name="JOB_TOPIC" displayName="主题" length="50" isNullable="true">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="JOB_CONTENT" displayName="内容" length="500" isNullable="true">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="JOB_BACK" displayName="反馈" length="100" isNullable="true">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
        <field name="JOB_STATE" displayName="状态" length="20" isNullable="true">
            <showType value="show"/>
            <fieldType value="String"/>
        </field>
    </entity>
</wizardContent>
 --%>
<form action="employee.pr.prOA_JOBQuery.do" name="form1" method="POST">
 <pagecom:hiddenData property="PageCond"/> 
		<pagecom:hiddenData property="OA_JOB"/>

	<TABLE width="80%" border="0" align="center" cellPadding="0" cellSpacing="0" class="pg_result">
		<TR>
			<TD class="pg_result_title" colspan="10">查询结果
			</TD>
		</TR>

		<TR class="pg_result_head">
		  <TD align="left">&nbsp;<logic:notEqual property="list[@type='OA_JOB']/@rowNum" value="0">
				<html:checkbox name="chkAll" onclick="checkAll('checkall')"/>
			   </logic:notEqual>选择</TD><TD>序号</TD><TD>员工编号</TD><TD>员工姓名</TD><TD>部门编号</TD><TD>日期</TD><TD>主题</TD><TD>内容</TD><TD>反馈</TD><TD>状态</TD>		    	
		</TR>		            
		<logic:iterate id="ResultSet" property="list[@type='OA_JOB']">       
		
		<TR class="<pagecom:trclass oddClass='pg_result_content' evenClass='pg_result_content_'/>" onmouseover='this.className="onmouseover"' onmouseout='this.className="<pagecom:trclass oddClass="pg_result_content" evenClass="pg_result_content_" mapping="oddClass|oddClass,evenClass|evenClass"/>"'>
		
			<TD>
			<logic:present id="ResultSet" property="OA_JOB/JOB_ID">
			&nbsp;<html:checkbox styleId="checkall" name="list[@name='update']/OA_JOB/JOB_ID" id="ResultSet" property="OA_JOB/JOB_ID"  indexed="true" />
			</logic:present>
			</TD>						
				
			<TD>
			<bean:write id="ResultSet" property="OA_JOB/JOB_ID"/>
			</TD>
			
			<TD>
			<bean:write id="ResultSet" property="OA_JOB/EMPLOYEE_ID"/>
			</TD>
			
			<TD>
			<bean:write id="ResultSet" property="OA_JOB/EMPLOYEE_NAME"/>
			</TD>
			
			<TD>
			<bean:write id="ResultSet" property="OA_JOB/DEPARTMENT_ID"/>
			</TD>
			
			<TD>
			<bean:write id="ResultSet" property="OA_JOB/JOB_DATE" formatType="yyyy-MM-dd" formatClass="com.primeton.eos.webtag.bean.BeanWriteDateFormatImpl"/>
			</TD>
			
			<TD>
			<bean:write id="ResultSet" property="OA_JOB/JOB_TOPIC"/>
			</TD>
			
			<TD>
			<bean:write id="ResultSet" property="OA_JOB/JOB_CONTENT"/>
			</TD>
			
			<TD>
			<bean:write id="ResultSet" property="OA_JOB/JOB_BACK"/>
			</TD>
			
			<TD>
			<bean:write id="ResultSet" property="OA_JOB/JOB_STATE"/>
			</TD>
													
		</TR>
		</logic:iterate>

		<TR>
			<TD colspan="10">
			<table width="100%"><tr class="pg_result_bottom">
		
			<td align="left">
				<div>						
		 

		<logic:notEqual property="list[@type='OA_JOB']/@rowNum" value="0">
		 <input type="button" value="查看详情" onclick="javascript:prepareUpdateRow(document.form1, 'employee.pr.prOA_JOBUpdate.do', 'checkall','_self')">  
		 <input type="button" value="删除" onclick="javascript:deleteRows(document.form1, 'employee.pr.prOA_JOBDelete.do', 'checkall','_top')">  
		 【<a href="employee.pr.prEmployee.do">返回</a>】
		</logic:notEqual>
</div>
			</td>
<logic:notEqual property="list[@type='OA_JOB']/@rowNum" value="0">
			<td align="right">
		<div>
	<SCRIPT LANGUAGE="JavaScript">
	<!--						
		var myPage = new page();
		myPage.init("form1", "employee.pr.prOA_JOBQuery.do", "PageCond/begin", "PageCond/length", "PageCond/count");
		var currCount = <bean:write property="list[@type='OA_JOB']/@rowNum"/>;
		var htmltext = "";
		if (!myPage.noCount){
			htmltext += myPage.current + "页/"+myPage.total+"页";
			htmltext += " 共"+myPage.count + "条";
		}
		if(myPage.current>1){
			htmltext += "<input type=\"button\" value=\"首页\" onclick=\"myPage.firstPage()\">";
			htmltext += "<input type=\"button\" value=\"上页\" onclick=\"myPage.previousPage()\">";
		}
		else
		{
			htmltext += "<input type=\"button\" value=\"首页\" disabled>";
			htmltext += "<input type=\"button\" value=\"上页\" disabled>";
		}
		if (!myPage.noCount){
			if (myPage.current<myPage.total ) {
				htmltext += "<input type=\"button\" value=\"下页\" onclick=\"myPage.nextPage()\">";
				htmltext += "<input type=\"button\" value=\"尾页\" onclick=\"myPage.lastPage()\"> ";
			}
			else
			{
				htmltext += "<input type=\"button\" value=\"下页\" disabled>";
				htmltext += "<input type=\"button\" value=\"尾页\" disabled> ";
			}
		}else{
			if (myPage.length<=currCount){
				htmltext += "<input type=\"button\" value=\"下页\" onclick=\"myPage.nextPage()\"> ";
			}
			else
			{
				htmltext += "<input type=\"button\" value=\"下页\" disabled> ";
			}
		}
		htmltext += "<input type='text' name='pageno' size=2 value='"+myPage.current+"' eos_datatype='number' eos_caption='页码' onBlur='checkInput(this)'>";
		htmltext += "<input type='button' onclick=myPage.goPage('pageno'); value='go' name='gopage'> ";
		document.write( htmltext );
	//-->
	</SCRIPT>
</div>
			</td>
</logic:notEqual>
			</tr></table>
			</TD>
		</TR>
</TABLE>
</FORM>
</PG:DataGrid>
⌨️ 快捷键说明

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