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

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

최수영
조회 수 : 1140
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]
  목록
번호 제목 닉네임 조회 등록일
3629 validExp의 기능에 대해 알고 싶습니다.
기술지원44
 942 2008-03-27
3628 엑셀파일 업로드시 문제
안근식
 1012 2008-03-25
3627 컬럼제한이 있습니까?
김종우
 1000 2008-03-21
3626 컬럼제한이 있습니까?
기술지원40
 1452 2008-03-21
Selected [이미지 첨부]가우스 4.0에서 LuxeCombo와 DataSet을 연동하는 부분에 문제가 있습니다. 첨부 파일
최수영
 1140 2008-03-19
3624 [수정]가우스 4.0에서 LuxeCombo와 DataSet을 연동하는 부분에 문제가 있습니다.
관리자
 1197 2008-03-21
3623 [수정]가우스 4.0에서 LuxeCombo와 DataSet을 연동하는 부분에 문제가 있습니다.
최수영
 945 2008-03-21
3622 [수정]가우스 4.0에서 LuxeCombo와 DataSet을 연동하는 부분에 문제가 있습니다.
기술지원44
 1023 2008-03-24
3621 [수정]문제해결했습니다.
최수영
 994 2008-03-25
3620 jsp/servlet 에서 import 할 경우 해당 클래스를 못 찾네여.ㅠ .ㅠ
이권재
 1001 2008-03-18
3619 jsp/servlet 에서 import 할 경우 해당 클래스를 못 찾네여.ㅠ .ㅠ
기술지원40
 1098 2008-03-20
3618 인터넷 기사를 보고 공지나 그런 내용이 없어 문의 드립니다.
정상헌
 880 2008-03-17
3617 인터넷 기사를 보고 공지나 그런 내용이 없어 문의 드립니다.
기술지원40
 1677 2008-03-17
3616 질문을 왜 지웁니까..ㅡ,.ㅡ[xchar pie]
이정의
 1040 2008-03-17
3615 질문시 상단의 공지글을 읽어 주시기 바랍니다. 질문글은 이동되었습니다.
기술지원44
 972 2008-03-17
3614 50077애러코드 관련 문의
안정효
 1001 2008-03-15
3613 50077애러코드 관련 문의
관리자
 1233 2008-03-17
3612 다음과 같은 인터넷 뉴스를 봤습니다.
전현수
 931 2008-03-13
3611 다음과 같은 인터넷 뉴스를 봤습니다.
관리자
 1126 2008-03-13
3610 가끔가다 이런 에러가 뜹니다.
류정현
 958 2008-03-13
첫 페이지 187 188 189 190 191 192 193 194 195 196 끝 페이지
Tag List
목록 쓰기
XE Login