• 고객센터
  • 교육
  • 매뉴얼
  • 데모
  • 제품소개
글 수 7,449

[이미지 첨부]가우스 4.0에서 LuxeCombo와 DataSet을 연동하는 부분에 문제가 있습니다.

최수영
조회 수 : 1146
2008.03.19 (20:34:38)
* 고객시스템명 : ?
* GAUCE 버전 : 4.0
* WAS 종류(WebLogic 등등) : weblogic 8.0
* DB 종류 : mysql 6.0
* 문의 유형(질문/요청/참조) : 질문
* 내용 :


내용을 다시 올립니다.

결과에서 보다시피 원래 목적은 우편번호7자를 텍스트박스에 입력하면 키이벤트를 받아서

데이터셋에 우편번호를 검색하여 나온 데이터들을 LuxeCombo에 넣을려고 했습니다.

그런데 LuxeCombo에 넣을려고 해도 안넣어지더군요.

그래서 사진에 나온 것처럼 LuxeCombo와 Grid를 동시에 이용했습니다.

그런데 밑에 사진을 보면 Grid는 내용이 잘 바인딩됩니다.

문제는 LuxeCombo이지요.

왜 잘안되는지....

그림과 소스자체를 파일에 첨부합니다.


참고로 view부분은 Example01.jsp이며

데이터셋을 생성하는 부분은 SelectZip.jsp입니다.

참고로 오류메시지는 없습니다....



Example01.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
        <head>
                <title>다시한번 </title>
                <link rel = stylesheet href="css/StyleSheet.css" type="text/css">
                <script language="javascript">
                        
                        function KeyEventZipcode(){
                        
                                var f = document.frm;
                                
                                if(f.zipcode.value.length == 7){
                                
                                        onSearch();
                                
                                }
                        
                        }
                        
                        function onSearch(){
                        
                                var f = document.frm;
                        //        alert(f.zipcode.value);
                                zipData.DataID = "SelectZip.jsp?zipcode=" + f.zipcode.value;
                                zipData.Reset();
                        
                        }
                        
                </script>
                
                <script language="javascript" for="zipData" event="OnLoadCompleted(rowcnt)">
                
                //        zipData.NameValue(zipData.RowPosition, "zipcode");
                //        dataCombo.ComboDataID = "zipData";
                
                </script>
                
                <!-- 데이터셋 정의 부분-->
                <object id="zipData" classid="CLSID:2506B38B-0FF7-4249-BA3E-8BC1DC399FBB">
                
                        <param name="SyncLoad" value="false">
                                        
                </object>
                
        </head>
        <body>
                
                <form name="frm">
                
                        <table>
                        <tr>
                        <td>        
                                우편번호 :
                        </td>
                        <td>
                                <input name="zipcode" type="text" maxlength="7" onKeyUp="KeyEventZipcode()"><br/>
                        </td>
                        </tr>
                        <tr>
                        <td>
                                주      소 :
                        </td>
                        <td>
                                <object id="dataCombo" classid="clsid:D8BCC087-4710-427D-B2E4-A4B93B6EA197" width="300" height="40" style="font-size:9pt; visibility:visible">
                                        <param name="ComboDataID"        value="zipData">                                        
                                </object>        
                        </td>
                        </tr>  
                        </table>
                        <object  id="Edit_Zip" classid="clsid:EA8B6EE6-3DD8-4534-B4BB-27148CF0042B" width="760" height="352" style="font-family:; font-size:9pt;">
                                <param name="DataID" value="zipData">
                                <param name="SortView"                        value="left">
                                <param name="Editable"                                value='true'>
                                <param name="BorderStyle"                      value="0">
                                <param name=ColSelect                            value="false">                                                                                        
                                <param name="FillArea"                  value="true">
                                <param name="TitleHeight"           value="35">
                                <Param name="RowHeight"             value="23">
                                <param name="IndWidth"              value="0">
                                <param name="HeadLineColor"         value=#BDE1DF>
                                <param name="LineColor"             value=#BDE1DF>
                                <param name="IndicatorBkColor"      value=#F8F6EA>
                                <param name="IndicatorColBkColor"   value=#EDF9F8>
                                <param name="MultiRowSelect"                 value="true">
                                <param name="DisableNoVScroll"            value="false">
                                <param name="TitleHeight"                 value="18">
                                <Param Name="ViewSummary"                 value="0" >        
                                <param name="HeadBorder"            value="4">
                                <Param Name="UsingOneClick"             value="1">
                                <Param name="SelectionColor"                value="
                                        <SC>Type='FocusCurCol',         BgColor=#F1F7F9, TextColor=#879671</SC>
                                        <SC>Type='FocusCurRow',         BgColor=#F1F7F9, TextColor=#879671</SC>                                                                                        
                                        <SC>Type='EditCol',                 BgColor=#F1F7F9, TextColor=#879671</SC>
                                        <SC>Type='FocusEditCol',         BgColor=#F1F7F9, TextColor=#879671</SC>
                                        <SC>Type='FocusCurCol',         BgColor=#F1F7F9, TextColor=#879671</SC>
                                        <SC>Type='FocusEditRow',         BgColor=#F1F7F9, TextColor=#879671</SC>
                                        <SC>Type='EditRow',                 BgColor=#F1F7F9, TextColor=#879671</SC>
                                        <SC>Type='CurCol',                         BgColor=#F1F7F9, TextColor=#879671</SC>
                                        <SC>Type='FocusSelRow',         BgColor=#F1F7F9, TextColor=#879671</SC>
                                        <SC>Type='SelRow',                         BgColor=#F1F7F9, TextColor=#879671</SC>
                                        <SC>Type='CurRow',              BgColor=#F1F7F9, TextColor=#879671</SC>">
                                <PARAM NAME="Format" VALUE="
                                        <C>ID='SEQ'                Name='번호'                Edit=none         Width=60        align=center,HeadColor=#64764A,HeadBgColor=#E1F4F1,bgcolor=$FFFFFF,textcolor=#000000,SumColor=#64764A, sumbgColor=#EDF9F8, FontStyle=bold, fontexpr={currow=0} </FC>
                                        <G> Name='주 소'
                                        <C>ID='ZIPCODE'                Name='우편번호'                Width=70        align=center  ,HeadColor=#64764A,HeadBgColor=#E1F4F1,bgcolor=$FFFFFF,textcolor=#000000,SumColor=#64764A, sumbgColor=#EDF9F8, FontStyle=bold, fontexpr={currow=0}         </C>
                                        <C>ID='SIDO'                Name='시, 도'                Width=80        align=left  ,HeadColor=#64764A,HeadBgColor=#E1F4F1,bgcolor=$FFFFFF,textcolor=#000000,SumColor=#64764A, sumbgColor=#EDF9F8, FontStyle=bold, fontexpr={currow=0}</C>
                                        <C>ID='GUGUN'                Name='구, 군'                Width=100        align=left  ,HeadColor=#64764A,HeadBgColor=#E1F4F1,bgcolor=$FFFFFF,textcolor=#000000,SumColor=#64764A, sumbgColor=#EDF9F8, FontStyle=bold, fontexpr={currow=0}</C>
                                        <C>ID='DONG'                Name='동'                           Width=300        align=left  ,HeadColor=#64764A,HeadBgColor=#E1F4F1,bgcolor=$FFFFFF,textcolor=#000000,SumColor=#64764A, sumbgColor=#EDF9F8, FontStyle=bold, fontexpr={currow=0}</C>        
                                        <C>ID='BUNJI'                Name='번지'                          Width=100        align=left  ,HeadColor=#64764A,HeadBgColor=#E1F4F1,bgcolor=$FFFFFF,textcolor=#000000,SumColor=#64764A, sumbgColor=#EDF9F8, FontStyle=bold, fontexpr={currow=0}</C>
                                        </G>        
                                        ">
                        </object>
                </form>
        
        </body>
</html>



------------------------------------------------------------------------------------------------------

SelectZip.jsp



<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<%@ page import="com.gauce.*, com.gauce.io.*, com.gauce.db.*"%>
<%

        ServiceLoader loader = null;
        GauceService service = null;
        GauceRequest gauceReq = null;
        GauceResponse gauceRes = null;
        
        GauceDataSet dSet = null;
        GauceDBConnection conn = null;        
        GauceStatement stmt = null;
        
        try{
                
                loader = new ServiceLoader(request, response);
                service = loader.newService();
                gauceReq = service.getGauceRequest();
            gauceRes = service.getGauceResponse();
            
            String zipcode = gauceReq.getParameter("zipcode");
            zipcode = new String(zipcode.getBytes("euc-kr"), "8859_1");
            
            dSet = new GauceDataSet();
            gauceRes.enableFirstRow(dSet);
            conn = service.getDBConnection("mysql");
                
            dSet.addDataColumn(new GauceDataColumn("zipcode", GauceDataColumn.TB_STRING, 7));
            dSet.addDataColumn(new GauceDataColumn("sido", GauceDataColumn.TB_STRING, 4));
                dSet.addDataColumn(new GauceDataColumn("gugun", GauceDataColumn.TB_STRING, 15));
                dSet.addDataColumn(new GauceDataColumn("dong", GauceDataColumn.TB_STRING, 52));
                dSet.addDataColumn(new GauceDataColumn("bunji", GauceDataColumn.TB_STRING, 17));
                dSet.addDataColumn(new GauceDataColumn("seq", GauceDataColumn.TB_STRING, 5));
                
                String sql = "select zipcode, sido, gugun, dong, bunji, seq from zipcode where zipcode='" + zipcode + "'";
                
                stmt = conn.getGauceStatement(sql);
            stmt.executeQuery(dSet);
            dSet.flush();            
            gauceRes.commit();
            gauceRes.close();
            
        }catch(Exception e){
                
                gauceRes.writeException("Native","9999", e.getMessage());  
            gauceRes.commit();
        
            gauceRes.close();  
        
            System.out.println("[listSrvMgrData.jsp][Error] Message Check : " + e.getMessage());
            e.printStackTrace();
                
        }finally{
                
                try {
                    
                if(stmt != null){        stmt.close();        }
                       if(conn != null){   conn.close();        }
            
               }catch(Exception e) {        e.printStackTrace();        }
                
        }

%>


이 게시물을...
http://member.shift.co.kr/index.php?document_srl=234724 (*.227.22.57)
댓글 [0]
  목록
번호 제목 닉네임 조회 등록일
7449 호환성 보기 설정 이후에도 메뉴 깨짐 현상
kiarakim
 8810 2017-02-15
7448 Shift DEMO 사이트 에서 IE11 다운됨
정성호
 9035 2017-02-10
7447 엑셀 업로드 속도 문의
jokerrain
 9066 2016-12-15
7446 차트 질문 첨부 파일
신현철
 8987 2016-10-04
7445 java.io.IOException/java.lang.NullPointerException 발생
윤재국
 9800 2016-07-13
7444 호환성 보기
kiarakim
 8596 2016-07-11
7443 가우스 그리드에 문자입력시 한글/영문 우선순위 변경
hthink
 8568 2016-04-21
7442 레포트 DFooter영역 이미지 태그
FKSS
 9131 2016-04-20
7441 좌/우측으로 데이터 이동
헐랭이
 7718 2016-04-15
7440 가우스 리포트를 PDF로 저장 가능한가요?
안순주
 9961 2016-04-12
7439 중간소계 필드 제외 문의
김은영2
 7612 2016-04-08
7438 가우스 그리드 범위지정 선택 가능여부 문의 [1]
hthink
 9845 2016-03-29
7437 그리드에 이미지표현 첨부 파일 [1]
홍혜련
 8931 2016-03-23
7436 Internet Explorer의 작동이 중지되었습니다. 첨부 파일 [1]
김태성2
 8613 2016-03-18
7435 특정 index (row) 삭제 [1]
c1138
 8879 2016-03-17
7434 was교체시 업그레이드 재설치 문의 [1]
박서영
 7763 2016-03-15
7433 파일 업로드 문의(핸들이 잘못 되었습니다)
임종훈
 8682 2016-03-15
7432 개발서버 라이센스 갱신 문의 [1]
정민75
 9805 2016-03-07
7431 문의합니다 첨부 파일 [1]
c1138
 9118 2016-03-07
7430 EnterpriseMode 적용이 되지 않습니다. 첨부 파일 [1]
동긔나긔
 10288 2016-03-03
첫 페이지 1 2 3 4 5 6 7 8 9 10 끝 페이지
Tag List
목록 쓰기
XE Login