<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="com.biz_nis.cmn.CommonMethod" %> <%@ page import="com.biz_nis.nw_prstus.nw_list.NetworkListDAO" %> <%@ page import="com.biz_nis.nw_prstus.nw_list.NetworkListDTO" %> <%@ page import="org.apache.log4j.Logger" %> <% Logger l_oLogger = Logger.getLogger( "" ); request.setCharacterEncoding("UTF-8"); if("".equals(CommonMethod.nullChk( (String)session.getAttribute("mbr_id") )) && "".equals(CommonMethod.nullChk( (String)session.getAttribute("mbr_pwd") ))) { out.println(""); } //변수 선언부 NetworkListDAO l_oNetworkListDAO = null; NetworkListDTO l_oNetworkListDTO = null; boolean l_bSuccess = false; try { l_oNetworkListDAO = new NetworkListDAO(); l_oNetworkListDTO = new NetworkListDTO(); int p_nCurPage = CommonMethod.intNullChk(request.getParameter("cur_page")); int p_nListSize = CommonMethod.intNullChk(request.getParameter("list_size")); String p_sSlct_flag = CommonMethod.nullChk(request.getParameter("slct_flag")); String p_sSrch_text = CommonMethod.nullChk(request.getParameter("srch_text")); String p_sSrch_fr_dt = CommonMethod.nullChk(request.getParameter("srch_fr_dt")); String p_sSrch_to_dt = CommonMethod.nullChk(request.getParameter("srch_to_dt")); String p_sSlct_idstry = CommonMethod.nullChk(request.getParameter("slct_idstry")); String p_sSlct_entp = CommonMethod.nullChk(request.getParameter("slct_entp")); String p_sSlct_jobcl = CommonMethod.nullChk(request.getParameter("slct_jobcl")); String p_sFlag = CommonMethod.nullChk( request.getParameter("flag") ); String p_sNet_seq = CommonMethod.nullChk(request.getParameter("net_seq")); String p_sNet_mbr_id = CommonMethod.nullChk( request.getParameter("net_mbr_id") ); String p_sNet_idstry = CommonMethod.nullChk( request.getParameter("net_idstry") ); String p_sNet_dstic = CommonMethod.nullChk( request.getParameter("net_dstic") ); int p_nNet_entp_id = CommonMethod.intNullChk( request.getParameter("net_entp_id") ); String p_sNet_user_nm = CommonMethod.nullChk( request.getParameter("net_user_nm") ); String p_sNet_jobcl = CommonMethod.nullChk( request.getParameter("net_jobcl") ); int p_nNet_age = CommonMethod.intNullChk( request.getParameter("net_age") ); String p_sNet_tel01 = CommonMethod.nullChk( request.getParameter("net_tel01") ); String p_sNet_tel02 = CommonMethod.nullChk( request.getParameter("net_tel02") ); String p_sNet_tel03 = CommonMethod.nullChk( request.getParameter("net_tel03") ); String p_sNet_relshp = CommonMethod.nullChk( request.getParameter("net_relshp") ); String p_sNet_resn = CommonMethod.nullChk( request.getParameter("net_resn") ); String p_sNet_rmark = CommonMethod.convertWEBtoDB( CommonMethod.nullChk( request.getParameter("net_rmark") ) ); int p_nNet_a = CommonMethod.intNullChk( request.getParameter("net_a") ); int p_nNet_b = CommonMethod.intNullChk( request.getParameter("net_b") ); int p_nNet_c = CommonMethod.intNullChk( request.getParameter("net_c") ); int p_nNet_d = CommonMethod.intNullChk( request.getParameter("net_d") ); int p_nNet_e = CommonMethod.intNullChk( request.getParameter("net_e") ); int p_nNet_f = CommonMethod.intNullChk( request.getParameter("net_f") ); int p_nNet_g = CommonMethod.intNullChk( request.getParameter("net_g") ); double l_dNet_total = Math.pow(p_nNet_a, 2)+p_nNet_b+p_nNet_c+p_nNet_d+p_nNet_e+p_nNet_f+Math.pow(p_nNet_g, 2); String l_sNet_total = String.valueOf( Math.round(l_dNet_total) ); int l_nNet_total = Integer.parseInt( l_sNet_total ); l_oNetworkListDTO.setNet_seq( p_sNet_seq ); l_oNetworkListDTO.setNet_mbr_id( p_sNet_mbr_id ); l_oNetworkListDTO.setNet_idstry( p_sNet_idstry ); l_oNetworkListDTO.setNet_dstic( p_sNet_dstic ); l_oNetworkListDTO.setNet_entp_id( p_nNet_entp_id ); l_oNetworkListDTO.setNet_user_nm( p_sNet_user_nm ); l_oNetworkListDTO.setNet_jobcl( p_sNet_jobcl ); l_oNetworkListDTO.setNet_age( p_nNet_age ); if (!p_sNet_tel01.equals("") && !p_sNet_tel02.equals("") && !p_sNet_tel03.equals("")) { l_oNetworkListDTO.setNet_tel01( p_sNet_tel01 ); l_oNetworkListDTO.setNet_tel02( p_sNet_tel02 ); l_oNetworkListDTO.setNet_tel03( p_sNet_tel03 ); } else { l_oNetworkListDTO.setNet_tel01( "" ); l_oNetworkListDTO.setNet_tel02( "" ); l_oNetworkListDTO.setNet_tel03( "" ); } l_oNetworkListDTO.setNet_relshp( p_sNet_relshp ); l_oNetworkListDTO.setNet_resn( p_sNet_resn ); l_oNetworkListDTO.setNet_rmark( p_sNet_rmark ); l_oNetworkListDTO.setNet_a( p_nNet_a ); l_oNetworkListDTO.setNet_b( p_nNet_b ); l_oNetworkListDTO.setNet_c( p_nNet_c ); l_oNetworkListDTO.setNet_d( p_nNet_d ); l_oNetworkListDTO.setNet_e( p_nNet_e ); l_oNetworkListDTO.setNet_f( p_nNet_f ); l_oNetworkListDTO.setNet_g( p_nNet_g ); l_oNetworkListDTO.setNet_total( l_nNet_total ); // Insert if (("I").equals(p_sFlag)) { l_bSuccess = l_oNetworkListDAO.insert( l_oNetworkListDTO ); if (l_bSuccess) { %>
<% } else { %>
<% } } // update else if (("U").equals(p_sFlag)) { l_bSuccess = l_oNetworkListDAO.update( l_oNetworkListDTO ); if (l_bSuccess) { %>
<% } else { %>
<% } } // detete else if (("D").equals(p_sFlag)) { l_bSuccess = l_oNetworkListDAO.delete( p_sNet_seq ); if (l_bSuccess) { %>
<% } else { %>
<% } } } catch( Exception e ) { l_oLogger.debug( e.toString() ); } finally {} %>