글 수 7,449
조회 수 : 1144
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(); }
}
%>
* 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)
|
|
