๐งฉjoin_view.jsp(์ฃผ์ ์ถ๊ฐ)
<p>
์ฐํธ๋ฒํธ <input name="zipcode" type="text" id="sample6_postcode" placeholder="์ฐํธ๋ฒํธ">
<input type="button" onclick="sample6_execDaumPostcode()" value="์ฐํธ๋ฒํธ ์ฐพ๊ธฐ"><br>
</p>
<p>
์ฃผ์ <input type="text" id="sample6_address" placeholder="์ฃผ์" name="addr"><br>
</p>
<p>
์์ธ์ฃผ์ <input type="text" id="sample6_detailAddress" placeholder="์์ธ์ฃผ์" name="addrdetail">
</p>
<p>
์ฐธ๊ณ ํญ๋ชฉ <input type="text" id="sample6_extraAddress" placeholder="์ฐธ๊ณ ํญ๋ชฉ" name="addretc">
</p>
๐งฉjoin_view.jsp
function sample6_execDaumPostcode() {
new daum.Postcode({
oncomplete: function(data) {
var addr = '';
var extraAddr = '';
if (data.userSelectedType === 'R') {
addr = data.roadAddress;
} else {
addr = data.jibunAddress;
}
if(data.userSelectedType === 'R'){
if(data.bname !== '' && /[๋|๋ก|๊ฐ]$/g.test(data.bname)){
extraAddr += data.bname;
}
if(data.buildingName !== '' && data.apartment === 'Y'){
extraAddr += (extraAddr !== '' ? ', ' + data.buildingName : data.buildingName);
}
if(extraAddr !== ''){
extraAddr = ' (' + extraAddr + ')';
}
document.getElementById("sample6_extraAddress").value = extraAddr;
} else {
document.getElementById("sample6_extraAddress").value = '';
}
document.getElementById('sample6_postcode').value = data.zonecode;
document.getElementById("sample6_address").value = addr;
document.getElementById("sample6_detailAddress").focus();
}
}).open();
๐งฉDB
SELECT * FROM TBL_USER tu ;
ALTER TABLE TBL_USER ADD (
zipcode varchar2(100),
addr varchar2(300),
addrdetail varchar2(1000),
addrdetc varchar2(500)
);
๐งฉUserBean.java(์ฃผ์ ์ถ๊ฐ)
public class UserBean {
,,,,
private String zipcode;
private String addr;
private String addrdetail;
private String addretc;
,,,,
public String getZipcode() {
return zipcode;
}
public void setZipcode(String zipcode) {
this.zipcode = zipcode;
}
public String getAddr() {
return addr;
}
public void setAddr(String addr) {
this.addr = addr;
}
public String getAddrdetail() {
return addrdetail;
}
public void setAddrdetail(String addrdetail) {
this.addrdetail = addrdetail;
}
public String getAddretc() {
return addretc;
}
public void setAddretc(String addretc) {
this.addretc = addretc;
}
}
๐งฉuser.xml(์ฃผ์ ์ถ๊ฐ)
<mapper namespace="User">
<select id="checkId" parameterType="string" resultType="_int">
SELECT count(*) FROM TBL_USER tu WHERE USERID = #{userid}
</select>
<insert id="join" parameterType="com.koreait.web.beans.UserBean">
INSERT INTO TBL_USER
VALUES(#{userid}, #{userpw}, #{username}, #{usergender}, #{userphone},
#{zipcode},#{addr},#{addrdetail},#{addretc} )
</insert>
<select id="login" parameterType="hashmap" resultType="com.koreait.web.beans.UserBean">
SELECT * FROM TBL_USER tu WHERE USERID = #{userid} AND userpw = #{userpw}
</select>
</mapper>
๐งฉ๊ฒฐ๊ณผ