JSP
<?xml version='1.0' ?>
< import="java.util.Date"%>
<%@ page contentType="text/html; charset=euc-kr" %>
<% request.setCharacterEncoding("ksc5601"); %>
<%@ page import="java.text.*,
java.lang.*,
java.util.*,
java.sql.*,
java.math.*,
frw.common.lib.*,
frw.common.dto.*,
com.common.lib.jrlib.*"
%>
<%@ include file="/session.jsp"%>
<%@ include file="/select_common.jsp"%>
<%@ taglib uri="/WEB-INF/hrms.tld" prefix="hrm" %>
<jsp:useBean id="frwDac_commonCommand" class="frw.command.FrwDac_commonCommand" scope="page" />
<%
/***********************************************************
* 프로그램의 기본내용을 입력합니다.
************************************************************
* JSP Name : hrm0107_l_x01.jsp
* Description : 조회 리스트를 만들기 위한 JSP
* Author :
* Create Date : 2011.10.00
* History : 2011.10.00 Initial create by ***********************************************************/
DateFormat format = new SimpleDateFormat("yyyyMMdd");
String org_id = request.getParameter("org_id")== null ? "":request.getParameter("org_id");
String org_nm = request.getParameter("org_nm")== null ? "":request.getParameter("org_nm");
String emp_id = request.getParameter("search_id")== null ? "":request.getParameter("search_id");
String emp_nm = request.getParameter("search_nm")== null ? "":request.getParameter("search_nm");
String search_ym = request.getParameter("search_ym");
String start_search = jrTools.removeFmt(search_ym).substring(0,6) + "01";
String end_search = jrTools.removeFmt(search_ym).substring(0,6) + "31";
/*
System.out.println ("----------------- hrms/hrm/web/hrm0107_l_x01.jsp ----------------");
System.out.println (" org_id :" + org_id);
System.out.println (" org_nm :" + org_nm);
System.out.println (" emp_id :" + emp_id);
System.out.println (" emp_nm :" + emp_nm);
System.out.println (" search_ym:" + search_ym);
*/
try {
gdto = setDtoAssign("HRM_SC", "907");
gv = setArgAssign(gv, "S", org_id+"%", 0, 0, null, null, 1);
gv = setArgAssign(gv, "S", org_nm+"%", 0, 0, null, null, 2);
gv = setArgAssign(gv, "S", emp_id+"%", 0, 0, null, null, 3);
gv = setArgAssign(gv, "S", emp_nm+"%", 0, 0, null, null, 4);
gv = setArgAssign(gv, "S", start_search, 0, 0, null, null, 5);
gv = setArgAssign(gv, "S", end_search, 0, 0, null, null, 6);
RowSet rset = frwDac_commonCommand.readableDAC(gdto, gv, true);
%>
<SHEET>
<DATA TOTAL="<%=rset.size()%>">
<%
if (rset == null || rset.size()==0) {
%>
<NONEDATA>
해당 데이터가 없습니다.
</NONEDATA>
<%
}
else {
while(rset.next()) {
%>
<TR MERGE="FALSE">
<TD></TD>
<TD></TD>
<TD></TD>
<TD><%=rset.getString("cal_ymd")%></TD>
<TD><%=rset.getString("emp_id") %></TD>
<TD><%=rset.getString("emp_nm") %></TD>
<TD><%=rset.getString("check_yn")%></TD>
<TD><%=rset.getString("note")%></TD>
</TR>
<%
}
}
%>
</DATA>
</SHEET>
<%
gv.clear();
}
catch(Exception e) {
%>
<ERROR>
<MESSAGE>조회중 오류가 발생했습니다.</MESSAGE>
</ERROR>
<%
e.printStackTrace();
}
%>
< import="java.util.Date"%>
<%@ page contentType="text/html; charset=euc-kr" %>
<% request.setCharacterEncoding("ksc5601"); %>
<%@ page import="java.text.*,
java.lang.*,
java.util.*,
java.sql.*,
java.math.*,
frw.common.lib.*,
frw.common.dto.*,
com.common.lib.jrlib.*"
%>
<%@ include file="/session.jsp"%>
<%@ include file="/select_common.jsp"%>
<%@ taglib uri="/WEB-INF/hrms.tld" prefix="hrm" %>
<jsp:useBean id="frwDac_commonCommand" class="frw.command.FrwDac_commonCommand" scope="page" />
<%
/***********************************************************
* 프로그램의 기본내용을 입력합니다.
************************************************************
* JSP Name : hrm0107_l_x01.jsp
* Description : 조회 리스트를 만들기 위한 JSP
* Author :
* Create Date : 2011.10.00
* History : 2011.10.00 Initial create by ***********************************************************/
DateFormat format = new SimpleDateFormat("yyyyMMdd");
String org_id = request.getParameter("org_id")== null ? "":request.getParameter("org_id");
String org_nm = request.getParameter("org_nm")== null ? "":request.getParameter("org_nm");
String emp_id = request.getParameter("search_id")== null ? "":request.getParameter("search_id");
String emp_nm = request.getParameter("search_nm")== null ? "":request.getParameter("search_nm");
String search_ym = request.getParameter("search_ym");
String start_search = jrTools.removeFmt(search_ym).substring(0,6) + "01";
String end_search = jrTools.removeFmt(search_ym).substring(0,6) + "31";
/*
System.out.println ("----------------- hrms/hrm/web/hrm0107_l_x01.jsp ----------------");
System.out.println (" org_id :" + org_id);
System.out.println (" org_nm :" + org_nm);
System.out.println (" emp_id :" + emp_id);
System.out.println (" emp_nm :" + emp_nm);
System.out.println (" search_ym:" + search_ym);
*/
try {
gdto = setDtoAssign("HRM_SC", "907");
gv = setArgAssign(gv, "S", org_id+"%", 0, 0, null, null, 1);
gv = setArgAssign(gv, "S", org_nm+"%", 0, 0, null, null, 2);
gv = setArgAssign(gv, "S", emp_id+"%", 0, 0, null, null, 3);
gv = setArgAssign(gv, "S", emp_nm+"%", 0, 0, null, null, 4);
gv = setArgAssign(gv, "S", start_search, 0, 0, null, null, 5);
gv = setArgAssign(gv, "S", end_search, 0, 0, null, null, 6);
RowSet rset = frwDac_commonCommand.readableDAC(gdto, gv, true);
%>
<SHEET>
<DATA TOTAL="<%=rset.size()%>">
<%
if (rset == null || rset.size()==0) {
%>
<NONEDATA>
해당 데이터가 없습니다.
</NONEDATA>
<%
}
else {
while(rset.next()) {
%>
<TR MERGE="FALSE">
<TD></TD>
<TD></TD>
<TD></TD>
<TD><%=rset.getString("cal_ymd")%></TD>
<TD><%=rset.getString("emp_id") %></TD>
<TD><%=rset.getString("emp_nm") %></TD>
<TD><%=rset.getString("check_yn")%></TD>
<TD><%=rset.getString("note")%></TD>
</TR>
<%
}
}
%>
</DATA>
</SHEET>
<%
gv.clear();
}
catch(Exception e) {
%>
<ERROR>
<MESSAGE>조회중 오류가 발생했습니다.</MESSAGE>
</ERROR>
<%
e.printStackTrace();
}
%>
댓글
댓글 쓰기
질문이나 의견은 요기에 남겨주세요 ^^,,