<?xml version="1.0" encoding="UTF-8" ?>
<jsp:root
	xmlns:jsp="http://java.sun.com/JSP/Page"
	xmlns:og="hybs-taglib.tld" 
	version="2.0">
<jsp:directive.page language="java" contentType="text/xml; charset=UTF-8" />

<og:head headType="xml" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "GF7000"
	title	= "郵便番号検索"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>

<!-- DB検索 SQL文記述 debug="true" でSQL文を確認できます。-->
<og:value command="SQL" >
		select substr(JISCODE,1,2) AS PREF_CODE,CITY_KANJI,TOWN_KANJI,BLOCK_KANJI,JIGYO_KANJI
		from GF42
		where POSTCODE like '{@POSTCODE}%'
		and   rownum = 1
</og:value>

<og:value command="SQL" >
		select count(*) as CNT
		from GF42
		where POSTCODE like '{@POSTCODE}%'
</og:value>

<og:text>
<zip>
  <pref>{@PREF_CODE}</pref>
  <city>{@CITY_KANJI}</city>
  <town>{@TOWN_KANJI}</town>
  <block>{@BLOCK_KANJI}</block>
  <jigyo>{@JIGYO_KANJI}</jigyo>
  <count>{@CNT}</count>
</zip>
</og:text>

</jsp:root>
