2349 |
|
가우스 ServiceLoader 연결 시 에러.
|
|
김인영 |
1721 |
2006-10-30 |
|
2348 |
|
가우스 ServiceLoader 연결 시 에러.
|
|
관리자 |
1157 |
2006-10-30 |
|
2347 |
|
가우스 ServiceLoader 연결 시 에러.
|
|
관리자 |
1383 |
2006-10-30 |
안녕하세요? 본 에러는 여러 가지 원인이 있을수있습니다. 예로들어 컴포넌트를 MAX와 Newpacket을 혼합하여 사용하는 경우등 서비스쪽 오류가 아는 화면 쪽 소스를 살펴 보셔야 합니다. 전화를 주셔서 원격 지원으로 해결 하시는게 좋을것 같습니다. ^^ 그럼 수고하세요. >게시판을 이용해 주셔서 감사합니다. >다음양식에 맞게 입력해주세요. > >* 고객시스템명 : (주)한국 사이버테크 >* GAUCE 버전 : 3.0 >* WAS 종류(WebLogic 등등) : Tomcat >* DB 종류 : Oracle >* 문의 유형(질문/요청/참조) : 질문 >* 내용 : >가우스 3.0에서 AMX 컴포넌트를 써서 서비스로더를 연결하면 익스플로러 에러가 뜨면서 >브라우저가 종료됩니다. >다음은 소스코드입니다. > >test.html====================================================================== ><%@ page contentType="text/html;charset=KSC5601" %> ><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN"> ><html> > <head> > <title>Untitled</title> > <meta http-equiv="content-type" content="text/html; charset=ks_c_5601"> > <meta name="generator" content="pld "> > > <style type="text/css"> > body { font-family :굴림체;font-size: 9pt } > </style> > <SCRIPT language="JavaScript" src="../../embedControl.js"></SCRIPT> ></head> ><body> ><P> ><br> ><b>** sample ** </b> ><br> ><br><!--DataSet Component--> ><comment id="__NSID__"> ><OBJECT id=tbds_1 classid=clsid:2506B38B-0FF7-4249-BA3E-8BC1DC399FBB><PARAM NAME="DataID" VALUE="test.jsp"></OBJECT> ></object></comment><SCRIPT>__WS__(__NSID__);</SCRIPT> ></P> > ></body> ></html> > > >test.jsp======================================================================= > ><%@ page import="java.io.*,java.util.*,java.text.*,com.gauce.*,com.gauce.io.*,com.gauce.log.*,com.gauce.common.*, kct.guestbook.GuestBookManager, kct.guestbook.GuestBook,java.text.SimpleDateFormat" contentType="text/html;charset=euc-kr" %><%@ page import="java.sql.*, java.io.*, kct.DBUtil" %><%@ page errorPage = "/error.jsp" %><% > > ServiceLoader loader = new ServiceLoader(request, response); > >%> > >디버깅을 위해 최소한의 코드만 남긴 것이고 >test.html을 브라우저에서 호출하면 익스플로러 에러가 뜨고 (이 에러 화면덤프는 파일로 첨부합니다.) >에러 디버그를 클릭하면 visual C++에서 다음과 같은 코드가 뜹니다. > >==>NTDLL !7c948fea() >NTDLL! 7c93104b() >MXDATASET! 046d495f() >MXDATASET! 046d491b() >MXDATASET! 046bf2c7() >MXDATASET! 046addc3() >MSHTML! 7e6072ea() >MSHTML! 7e3f9b92() >MSHTML! 7e3f8be8() >MSHTML! 7e3f91a7() >MSHTML! 7e46ddee() > >
|
2346 |
|
<FC>속성으로 특정그리드의 왼쪽 몇개 컬럼을 고정시켰는데요...
|
|
정현주 |
1199 |
2006-10-27 |
|
2345 |
|
<FC>속성으로 특정그리드의 왼쪽 몇개 컬럼을 고정시켰는데요...
|
|
조성현 |
1281 |
2006-10-27 |
|
2344 |
|
여러개의 DataSet을 DB에 저장하려고 합니다.
|
|
정성철 |
1686 |
2006-10-27 |
|
2343 |
|
여러개의 DataSet을 DB에 저장하려고 합니다.
|
|
조성현 |
1910 |
2006-10-27 |
|
2342 |
|
XChart에서 Tool Tip사용시 오류문제
|
|
황영재 |
1770 |
2006-10-27 |
|
2341 |
|
XChart에서 Tool Tip사용시 오류문제
|
|
조성현 |
1268 |
2006-10-27 |
|
2340 |
|
[질문] Grid 에서 addRow했을때 상태값을 알수 있는 방법이 있을까요?
|
|
최원 |
1222 |
2006-10-27 |
|
2339 |
|
[질문] Grid 에서 addRow했을때 상태값을 알수 있는 방법이 있을까요?
|
|
조성현 |
1880 |
2006-10-27 |
|
2338 |
|
HttpGauceRequest 에러가 발생합니다.
|
|
배준상 |
1213 |
2006-10-27 |
* 고객시스템명 : * GAUCE 버전 : 4.0 * WAS 종류(WebLogic 등등) : JEUS * DB 종류 : Oracle 10g * 문의 유형(질문/요청/참조) : 질문 * 내용 : 업무상 가우스를 처음 사용하는 가우스 초보입니다. 가우스로 화면을 구성하고 조회를 하는데 아래와 같은 에러가 발생합니다. 어떤 에러이며 원인이 무엇인지요? 원론적인 답변이라도 부탁합니다. ****************************** 에러 메시지 *********************************************************** 2006-10-26 15:55:56.941 ComponentHandler - invoke : java.lang.reflect.InvocationTargetException java.lang.Exception: com/gauce/http/HttpGauceRequest at com.nds.camt.components.ComponentHandler.runMethod(ComponentHandler.java:196) at com.nds.camt.components.ComponentHandler.doing(ComponentHandler.java:120) at camt.com.controller.CamtServlet.processing(CamtServlet.java:222) at camt.com.controller.CamtServlet.service(CamtServlet.java:131) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at jeus.servlet.engine.ServletWrapper.executeServlet(ServletWrapper.java:320) at jeus.servlet.filter.FilterChainImpl.doFilter(FilterChainImpl.java:71) at com.gauce.filter.GauceFilter.doFilter(Unknown Source) at jeus.servlet.filter.FilterWrapper.doFilter(FilterWrapper.java:32) at jeus.servlet.filter.FilterChainImpl.doFilter(FilterChainImpl.java:60) at jeus.servlet.engine.ServletWrapper.processFilter(ServletWrapper.java:203) at jeus.servlet.engine.ServletWrapper.execute(ServletWrapper.java:174) at jeus.servlet.engine.WebtobRequestProcessor.run(WebtobRequestProcessor.java:194) 2006-10-26 15:55:56.941 CamtServlet - service():com/gauce/http/HttpGauceRequest ****************************** 원 소스 *************************************************************** package maagp.adm.land.entry; import java.util.*; import javax.ejb.*; import com.gauce.*; import com.gauce.http.*; import com.gauce.io.*; import com.gauce.log.*; import com.nds.camt.components.*; import com.nds.camt.util.CamtUtil; import common.util.RecordVO; import common.util.GauceUtil; import common.util.GauceVO; import com.nds.camt.util.Crypto; public class AdmLandDelegate extends AbstractDelegate { private EJBHome remoteHome; private EJBLocalHome localHome; public void setEJBLocalHome(EJBLocalHome localHome) { this.localHome = localHome; } public void setEJBRemoteHome(EJBHome remoteHome) { this.remoteHome = remoteHome; } public AdmLandDelegate() { } Crypto cp = new Crypto(); public void getPrdrQuery(GauceVO gaucevo) throws Exception{ GauceInputStream gis = null; GauceOutputStream gos = null; try { gis = ((HttpGauceRequest) req).getGauceInputStream(); gos = ((HttpGauceResponse) res).getGauceOutputStream(); //입력 GauceDataSet 읽기 GauceDataSet condDataSet01 = gis.read("input01"); //입력 GauceDataSet이 null이면 예외처리 if (condDataSet01 == null) throw new Exception("GauceDataTable is null."); //입력조건 GauceDataSet객체를 GauceUtil이용하여 RecordVO객체로 변환처리한다. GauceDataRow[] rows = condDataSet01.getDataRows(); RecordVO cond = GauceUtil.createRecordByDataRow(condDataSet01, rows[0]); //해당 조건에 맞는 결과값을 세션빈에서 읽어온다. AdmLandEntryEjbHome home = ( AdmLandEntryEjbHome ) remoteHome; AdmLandEntryEjb remote = home.create(); Collection records = remote.getPrdrQuery(cond); //출력 데이터셋 읽기 GauceDataSet gridDataSet02 = gis.read("output01"); gos.fragment(gridDataSet02); //출력 데이터셋 컬럼 정의 gridDataSet02.addDataColumn(new GauceDataColumn("prdr_cd" , GauceDataColumn.TB_STRING , 7)); gridDataSet02.addDataColumn(new GauceDataColumn("prdr_nm" , GauceDataColumn.TB_STRING , 20)); gridDataSet02.addDataColumn(new GauceDataColumn("mkr_espr_nm" , GauceDataColumn.TB_STRING , 20)); gridDataSet02.addDataColumn(new GauceDataColumn("rrn" , GauceDataColumn.TB_STRING , 50)); gridDataSet02.addDataColumn(new GauceDataColumn("zip_cd" , GauceDataColumn.TB_STRING , 6)); gridDataSet02.addDataColumn(new GauceDataColumn("basc_addr" , GauceDataColumn.TB_STRING , 100)); gridDataSet02.addDataColumn(new GauceDataColumn("dtld_addr" , GauceDataColumn.TB_STRING , 100)); gridDataSet02.addDataColumn(new GauceDataColumn("tel_no" , GauceDataColumn.TB_STRING , 20)); gridDataSet02.addDataColumn(new GauceDataColumn("mbp_no" , GauceDataColumn.TB_STRING , 20)); gridDataSet02.addDataColumn(new GauceDataColumn("fax_no" , GauceDataColumn.TB_STRING , 20)); gridDataSet02.addDataColumn(new GauceDataColumn("email" , GauceDataColumn.TB_STRING , 50)); gridDataSet02.addDataColumn(new GauceDataColumn("hmpg" , GauceDataColumn.TB_STRING , 100)); gridDataSet02.addDataColumn(new GauceDataColumn("otsd_user_id", GauceDataColumn.TB_STRING , 10)); gridDataSet02.addDataColumn(new GauceDataColumn("wthd_yn" , GauceDataColumn.TB_STRING , 1)); gridDataSet02.addDataColumn(new GauceDataColumn("regr_id" , GauceDataColumn.TB_STRING , 10)); gridDataSet02.addDataColumn(new GauceDataColumn("reg_tm" , GauceDataColumn.TB_STRING , 20)); gridDataSet02.addDataColumn(new GauceDataColumn("updr_id" , GauceDataColumn.TB_STRING , 10)); gridDataSet02.addDataColumn(new GauceDataColumn("upd_tm" , GauceDataColumn.TB_STRING , 20)); Iterator it = records.iterator(); while(it.hasNext()){ //세션빈에서 읽어온 결과값을 출력데이터셋에 설정 RecordVO record = (RecordVO)it.next(); GauceDataRow row = GauceUtil.createDataRowByRecord(gridDataSet02, record); // row.setString(3,cp.decrypt((String)row.getString(3))); //GauceDataRow row = dSet.newDataRow(); /* row.addColumnValue(record.getString("prdr_cd" )); row.addColumnValue(record.getString("prdr_nm" )); row.addColumnValue(record.getString("mkr_espr_nm" )); row.addColumnValue(cp.decrypt((String)record.getString("rrn"))); row.addColumnValue(record.getString("zip_cd" )); row.addColumnValue(record.getString("basc_addr" )); row.addColumnValue(record.getString("dtld_addr" )); row.addColumnValue(record.getString("tel_no" )); row.addColumnValue(record.getString("mbp_no" )); row.addColumnValue(record.getString("fax_no" )); row.addColumnValue(record.getString("email" )); row.addColumnValue(record.getString("hmpg" )); row.addColumnValue(record.getString("otsd_user_id" )); row.addColumnValue(record.getString("wthd_yn" )); row.addColumnValue(record.getString("regr_id" )); row.addColumnValue(record.getString("reg_tm" )); row.addColumnValue(record.getString("updr_id" )); row.addColumnValue(record.getString("upd_tm" )); */ gridDataSet02.addDataRow(row); } gos.write(gridDataSet02); gos.close(); } catch (Exception e) { throw new Exception(e.toString()); } } public void getLandQuery(GauceVO gaucevo) throws Exception{ GauceInputStream gis = null; GauceOutputStream gos = null; try { gis = ((HttpGauceRequest) req).getGauceInputStream(); gos = ((HttpGauceResponse) res).getGauceOutputStream(); //입력 데이터셋 읽기 GauceDataSet condDataSet01 = gis.read("input01"); if (condDataSet01 == null) throw new Exception("GauceDataTable is null."); GauceDataRow[] rows = condDataSet01.getDataRows(); RecordVO cond = GauceUtil.createRecordByDataRow(condDataSet01, rows[0]); //Record cond = new Record(); //cond.set("mmat_nm", (rows[0].getString(condDataSet01.indexOfColumn("mmat_nm")))); //해당 조건에 맞는 결과값을 세션빈에서 읽어온다. AdmLandEntryEjbHome home = ( AdmLandEntryEjbHome ) remoteHome; AdmLandEntryEjb remote = home.create(); Collection records = remote.getLandQuery(cond); //출력 데이터셋 읽기 GauceDataSet gridDataSet02 = gis.read("output01"); gos.fragment(gridDataSet02); //출력 데이터셋 컬럼 정의 gridDataSet02.addDataColumn(new GauceDataColumn("prdr_cd" , GauceDataColumn.TB_STRING , 7)); gridDataSet02.addDataColumn(new GauceDataColumn("land_seq" , GauceDataColumn.TB_STRING , 20)); gridDataSet02.addDataColumn(new GauceDataColumn("soil_prpt_cd" , GauceDataColumn.TB_STRING , 2)); gridDataSet02.addDataColumn(new GauceDataColumn("land_nm" , GauceDataColumn.TB_STRING , 50)); gridDataSet02.addDataColumn(new GauceDataColumn("lnum" , GauceDataColumn.TB_STRING , 100)); gridDataSet02.addDataColumn(new GauceDataColumn("squr" , GauceDataColumn.TB_DECIMAL , 20)); gridDataSet02.addDataColumn(new GauceDataColumn("mkp_yy" , GauceDataColumn.TB_STRING , 4)); gridDataSet02.addDataColumn(new GauceDataColumn("duse_yy" , GauceDataColumn.TB_STRING , 4)); gridDataSet02.addDataColumn(new GauceDataColumn("rmk" , GauceDataColumn.TB_STRING , 1000)); gridDataSet02.addDataColumn(new GauceDataColumn("regr_id" , GauceDataColumn.TB_STRING , 10)); gridDataSet02.addDataColumn(new GauceDataColumn("reg_tm" , GauceDataColumn.TB_STRING , 20)); gridDataSet02.addDataColumn(new GauceDataColumn("updr_id" , GauceDataColumn.TB_STRING , 10)); gridDataSet02.addDataColumn(new GauceDataColumn("upd_tm" , GauceDataColumn.TB_STRING , 20)); Iterator it = records.iterator(); while(it.hasNext()){ //세션빈에서 읽어온 결과값을 출력데이터셋에 설정 RecordVO record = (RecordVO)it.next(); GauceDataRow row = GauceUtil.createDataRowByRecord(gridDataSet02, record); gridDataSet02.addDataRow(row); } gos.write(gridDataSet02); gos.close(); } catch (Exception e) { throw new Exception(e.toString()); } } public void LandModify(GauceVO gaucevo) throws Exception{ GauceInputStream gis = null; GauceOutputStream gos = null; try { gis = ((HttpGauceRequest) req).getGauceInputStream(); gos = ((HttpGauceResponse) res).getGauceOutputStream(); //입력 데이터셋 읽기 GauceDataSet inputDataSet02 = gis.read("input02"); if (inputDataSet02 == null) throw new Exception("GauceDataTable is null."); ArrayList records = new ArrayList(); GauceDataRow[] rows = inputDataSet02.getDataRows(); for(int i=0; i<rows.length; i++){ RecordVO record = GauceUtil.createRecordByDataRow(inputDataSet02, rows[i]); records.add(record); } AdmLandEntryEjbHome home = (AdmLandEntryEjbHome) remoteHome; AdmLandEntryEjb remote = home.create(); remote.LandModify(records); gos.close(); } catch (Exception e) { throw new Exception(e.toString()); } } }
|
2337 |
|
HttpGauceRequest 에러가 발생합니다.
|
|
관리자 |
2346 |
2006-10-30 |
안녕하세요? 먼저 첨부된 소스를 실행하여 아무런 오류 없이 실행 되는지 여부를 확인해 주시길 바랍니다. 테스트 방법은 WAS에 첨부된 파일을 올려 놓고 http://localhost:포트/gauce_test.jsp?X-UIClient=G40 이라고 입력햇을때 아무런 오류 없이 실행된다면 이상이 없는 것 입니다. 이 경우 가우스 관련 문제가 아니라 해당 어플리케이션 문제입니다. 전체적인 소스를 점검해 보셔야 합니다. 그럼 수고하세요. >* 고객시스템명 : >* GAUCE 버전 : 4.0 >* WAS 종류(WebLogic 등등) : JEUS >* DB 종류 : Oracle 10g >* 문의 유형(질문/요청/참조) : 질문 >* 내용 : > >업무상 가우스를 처음 사용하는 가우스 초보입니다. > >가우스로 화면을 구성하고 조회를 하는데 아래와 같은 에러가 발생합니다. > >어떤 에러이며 원인이 무엇인지요? 원론적인 답변이라도 부탁합니다. > > >****************************** 에러 메시지 *********************************************************** > >2006-10-26 15:55:56.941 ComponentHandler - invoke : java.lang.reflect.InvocationTargetException >java.lang.Exception: com/gauce/http/HttpGauceRequest > at com.nds.camt.components.ComponentHandler.runMethod(ComponentHandler.java:196) > at com.nds.camt.components.ComponentHandler.doing(ComponentHandler.java:120) > at camt.com.controller.CamtServlet.processing(CamtServlet.java:222) > at camt.com.controller.CamtServlet.service(CamtServlet.java:131) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) > at jeus.servlet.engine.ServletWrapper.executeServlet(ServletWrapper.java:320) > at jeus.servlet.filter.FilterChainImpl.doFilter(FilterChainImpl.java:71) > at com.gauce.filter.GauceFilter.doFilter(Unknown Source) > at jeus.servlet.filter.FilterWrapper.doFilter(FilterWrapper.java:32) > at jeus.servlet.filter.FilterChainImpl.doFilter(FilterChainImpl.java:60) > at jeus.servlet.engine.ServletWrapper.processFilter(ServletWrapper.java:203) > at jeus.servlet.engine.ServletWrapper.execute(ServletWrapper.java:174) > at jeus.servlet.engine.WebtobRequestProcessor.run(WebtobRequestProcessor.java:194) >2006-10-26 15:55:56.941 CamtServlet - service():com/gauce/http/HttpGauceRequest > > > >****************************** 원 소스 *************************************************************** > >package maagp.adm.land.entry; > >import java.util.*; >import javax.ejb.*; >import com.gauce.*; >import com.gauce.http.*; >import com.gauce.io.*; >import com.gauce.log.*; >import com.nds.camt.components.*; >import com.nds.camt.util.CamtUtil; > >import common.util.RecordVO; >import common.util.GauceUtil; >import common.util.GauceVO; > >import com.nds.camt.util.Crypto; > > >public class AdmLandDelegate extends AbstractDelegate { > private EJBHome remoteHome; > private EJBLocalHome localHome; > > public void setEJBLocalHome(EJBLocalHome localHome) { > this.localHome = localHome; > } > > public void setEJBRemoteHome(EJBHome remoteHome) { > this.remoteHome = remoteHome; > } > public AdmLandDelegate() { > } > > Crypto cp = new Crypto(); > > public void getPrdrQuery(GauceVO gaucevo) throws Exception{ > GauceInputStream gis = null; > GauceOutputStream gos = null; > > try { > gis = ((HttpGauceRequest) req).getGauceInputStream(); > gos = ((HttpGauceResponse) res).getGauceOutputStream(); > > //입력 GauceDataSet 읽기 > GauceDataSet condDataSet01 = gis.read("input01"); > > //입력 GauceDataSet이 null이면 예외처리 > if (condDataSet01 == null) throw new Exception("GauceDataTable is null."); > > //입력조건 GauceDataSet객체를 GauceUtil이용하여 RecordVO객체로 변환처리한다. > GauceDataRow[] rows = condDataSet01.getDataRows(); > > RecordVO cond = GauceUtil.createRecordByDataRow(condDataSet01, rows[0]); > > //해당 조건에 맞는 결과값을 세션빈에서 읽어온다. > AdmLandEntryEjbHome home = ( AdmLandEntryEjbHome ) remoteHome; > AdmLandEntryEjb remote = home.create(); > Collection records = remote.getPrdrQuery(cond); > //출력 데이터셋 읽기 > GauceDataSet gridDataSet02 = gis.read("output01"); > gos.fragment(gridDataSet02); > > > //출력 데이터셋 컬럼 정의 > > gridDataSet02.addDataColumn(new GauceDataColumn("prdr_cd" , GauceDataColumn.TB_STRING , 7)); > gridDataSet02.addDataColumn(new GauceDataColumn("prdr_nm" , GauceDataColumn.TB_STRING , 20)); > gridDataSet02.addDataColumn(new GauceDataColumn("mkr_espr_nm" , GauceDataColumn.TB_STRING , 20)); > gridDataSet02.addDataColumn(new GauceDataColumn("rrn" , GauceDataColumn.TB_STRING , 50)); > gridDataSet02.addDataColumn(new GauceDataColumn("zip_cd" , GauceDataColumn.TB_STRING , 6)); > gridDataSet02.addDataColumn(new GauceDataColumn("basc_addr" , GauceDataColumn.TB_STRING , 100)); > gridDataSet02.addDataColumn(new GauceDataColumn("dtld_addr" , GauceDataColumn.TB_STRING , 100)); > gridDataSet02.addDataColumn(new GauceDataColumn("tel_no" , GauceDataColumn.TB_STRING , 20)); > gridDataSet02.addDataColumn(new GauceDataColumn("mbp_no" , GauceDataColumn.TB_STRING , 20)); > gridDataSet02.addDataColumn(new GauceDataColumn("fax_no" , GauceDataColumn.TB_STRING , 20)); > gridDataSet02.addDataColumn(new GauceDataColumn("email" , GauceDataColumn.TB_STRING , 50)); > gridDataSet02.addDataColumn(new GauceDataColumn("hmpg" , GauceDataColumn.TB_STRING , 100)); > gridDataSet02.addDataColumn(new GauceDataColumn("otsd_user_id", GauceDataColumn.TB_STRING , 10)); > gridDataSet02.addDataColumn(new GauceDataColumn("wthd_yn" , GauceDataColumn.TB_STRING , 1)); > gridDataSet02.addDataColumn(new GauceDataColumn("regr_id" , GauceDataColumn.TB_STRING , 10)); > gridDataSet02.addDataColumn(new GauceDataColumn("reg_tm" , GauceDataColumn.TB_STRING , 20)); > gridDataSet02.addDataColumn(new GauceDataColumn("updr_id" , GauceDataColumn.TB_STRING , 10)); > gridDataSet02.addDataColumn(new GauceDataColumn("upd_tm" , GauceDataColumn.TB_STRING , 20)); > > > Iterator it = records.iterator(); > > while(it.hasNext()){ > //세션빈에서 읽어온 결과값을 출력데이터셋에 설정 > RecordVO record = (RecordVO)it.next(); > GauceDataRow row = GauceUtil.createDataRowByRecord(gridDataSet02, record); > >// row.setString(3,cp.decrypt((String)row.getString(3))); > > //GauceDataRow row = dSet.newDataRow(); >/* > row.addColumnValue(record.getString("prdr_cd" )); > row.addColumnValue(record.getString("prdr_nm" )); > row.addColumnValue(record.getString("mkr_espr_nm" )); > row.addColumnValue(cp.decrypt((String)record.getString("rrn"))); > row.addColumnValue(record.getString("zip_cd" )); > row.addColumnValue(record.getString("basc_addr" )); > row.addColumnValue(record.getString("dtld_addr" )); > row.addColumnValue(record.getString("tel_no" )); > row.addColumnValue(record.getString("mbp_no" )); > row.addColumnValue(record.getString("fax_no" )); > row.addColumnValue(record.getString("email" )); > row.addColumnValue(record.getString("hmpg" )); > row.addColumnValue(record.getString("otsd_user_id" )); > row.addColumnValue(record.getString("wthd_yn" )); > row.addColumnValue(record.getString("regr_id" )); > row.addColumnValue(record.getString("reg_tm" )); > row.addColumnValue(record.getString("updr_id" )); > row.addColumnValue(record.getString("upd_tm" )); >*/ > > gridDataSet02.addDataRow(row); > } > > gos.write(gridDataSet02); > gos.close(); > } catch (Exception e) { > throw new Exception(e.toString()); > } > } > > public void getLandQuery(GauceVO gaucevo) throws Exception{ > GauceInputStream gis = null; > GauceOutputStream gos = null; > > try { > gis = ((HttpGauceRequest) req).getGauceInputStream(); > gos = ((HttpGauceResponse) res).getGauceOutputStream(); > > //입력 데이터셋 읽기 > GauceDataSet condDataSet01 = gis.read("input01"); > > if (condDataSet01 == null) throw new Exception("GauceDataTable is null."); > > GauceDataRow[] rows = condDataSet01.getDataRows(); > > RecordVO cond = GauceUtil.createRecordByDataRow(condDataSet01, rows[0]); > //Record cond = new Record(); > //cond.set("mmat_nm", (rows[0].getString(condDataSet01.indexOfColumn("mmat_nm")))); > > //해당 조건에 맞는 결과값을 세션빈에서 읽어온다. > AdmLandEntryEjbHome home = ( AdmLandEntryEjbHome ) remoteHome; > AdmLandEntryEjb remote = home.create(); > Collection records = remote.getLandQuery(cond); > //출력 데이터셋 읽기 > GauceDataSet gridDataSet02 = gis.read("output01"); > gos.fragment(gridDataSet02); > > //출력 데이터셋 컬럼 정의 > gridDataSet02.addDataColumn(new GauceDataColumn("prdr_cd" , GauceDataColumn.TB_STRING , 7)); > gridDataSet02.addDataColumn(new GauceDataColumn("land_seq" , GauceDataColumn.TB_STRING , 20)); > gridDataSet02.addDataColumn(new GauceDataColumn("soil_prpt_cd" , GauceDataColumn.TB_STRING , 2)); > gridDataSet02.addDataColumn(new GauceDataColumn("land_nm" , GauceDataColumn.TB_STRING , 50)); > gridDataSet02.addDataColumn(new GauceDataColumn("lnum" , GauceDataColumn.TB_STRING , 100)); > gridDataSet02.addDataColumn(new GauceDataColumn("squr" , GauceDataColumn.TB_DECIMAL , 20)); > gridDataSet02.addDataColumn(new GauceDataColumn("mkp_yy" , GauceDataColumn.TB_STRING , 4)); > gridDataSet02.addDataColumn(new GauceDataColumn("duse_yy" , GauceDataColumn.TB_STRING , 4)); > gridDataSet02.addDataColumn(new GauceDataColumn("rmk" , GauceDataColumn.TB_STRING , 1000)); > gridDataSet02.addDataColumn(new GauceDataColumn("regr_id" , GauceDataColumn.TB_STRING , 10)); > gridDataSet02.addDataColumn(new GauceDataColumn("reg_tm" , GauceDataColumn.TB_STRING , 20)); > gridDataSet02.addDataColumn(new GauceDataColumn("updr_id" , GauceDataColumn.TB_STRING , 10)); > gridDataSet02.addDataColumn(new GauceDataColumn("upd_tm" , GauceDataColumn.TB_STRING , 20)); > > Iterator it = records.iterator(); > > while(it.hasNext()){ > //세션빈에서 읽어온 결과값을 출력데이터셋에 설정 > RecordVO record = (RecordVO)it.next(); > GauceDataRow row = GauceUtil.createDataRowByRecord(gridDataSet02, record); > > > > gridDataSet02.addDataRow(row); > } > gos.write(gridDataSet02); > gos.close(); > } catch (Exception e) { > throw new Exception(e.toString()); > } > } > > > public void LandModify(GauceVO gaucevo) throws Exception{ > GauceInputStream gis = null; > GauceOutputStream gos = null; > > try { > gis = ((HttpGauceRequest) req).getGauceInputStream(); > gos = ((HttpGauceResponse) res).getGauceOutputStream(); > > //입력 데이터셋 읽기 > GauceDataSet inputDataSet02 = gis.read("input02"); > > if (inputDataSet02 == null) throw new Exception("GauceDataTable is null."); > > ArrayList records = new ArrayList(); > GauceDataRow[] rows = inputDataSet02.getDataRows(); > for(int i=0; i<rows.length; i++){ > RecordVO record = GauceUtil.createRecordByDataRow(inputDataSet02, rows[i]); > > records.add(record); > } > > AdmLandEntryEjbHome home = (AdmLandEntryEjbHome) remoteHome; > AdmLandEntryEjb remote = home.create(); > remote.LandModify(records); > gos.close(); > } catch (Exception e) { > throw new Exception(e.toString()); > } > } >} >
|
2336 |
|
Excel 업로드 관련
|
|
이신호 |
1172 |
2006-10-26 |
|
2335 |
|
Excel 업로드 관련
|
|
관리자 |
1482 |
2006-10-30 |
|
2334 |
|
combo box의 기능중.. html의 selected 와 관련된 질문입니다.
|
|
정성철 |
1598 |
2006-10-26 |
|
2333 |
|
combo box의 기능중.. html의 selected 와 관련된 질문입니다.
|
|
조성현 |
1304 |
2006-10-27 |
|
2332 |
|
2315번 Excel2DataSet에 관련된 답변에 대하여.. 다시 질문드립니다.
|
|
정성철 |
1265 |
2006-10-26 |
|
2331 |
|
1.소계낼때.. 2.그리드 color 문제
|
|
송주미 |
1332 |
2006-10-26 |
|
2330 |
|
1.소계낼때.. 2.그리드 color 문제
|
|
관리자 |
1490 |
2006-10-30 |
|