본문 바로가기
JSP/Tomcat 6.0 설정

우편번호 톰캣에서 돌려보자

하얀소닉 2012. 5. 21. 00:01

//member.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">
<%
 String myctx = request.getContextPath();//프로젝트 path를 가져옵니다 보통 http://localhost:8080/music_fairy 를 말합니다.

//WebContent/member/member.jsp다 <%=myctx%>/member/member.jsp 이렇게 되는 것입니다.

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">인코딩을 EUC-KR로 했습니다.
<title>회원가입 페이지</title>

</head>

<script type="text/javascript">

function zipCheck(){
  var url="<%=myctx%>/Zip-Check";
  var win=window.open(url,"ZipCheck","width=600, height=300,scrollbars=yes,top=80, left=80");//web.xml로 보냄
 }

</script>

<table> 생략---

 

<tr>
    <td colspan="1">우편번호</td>
    <td colspan="1"><input type="text" name="zip" style="background-color: #E4E6EF" readonly="readonly" maxlength="7"><a href="javascript:zipCheck()">//javascript:zipCheck() function zipCheck(){} 위에서 선언...
    <img alt="우편번호 조회" src="<%=myctx%>/images/zipcheck.png"/>
    </a>
    
    </td>
</tr>

//web.xml

 

<servlet>
     <servlet-name>Zip-Check</servlet-name>
     <servlet-class>member.controller.ZipCheck</servlet-class>
 </servlet>
 <servlet-mapping>
     <servlet-name>Zip-Check</servlet-name>
     <url-pattern>/Zip-Check</url-pattern>
 </servlet-mapping>

 

//servlet //member.controller

//ZipCheck.java

package member.controller;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class ZipCheck extends HttpServlet{

 @Override
 protected void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
  
  //String mode=request.getParameter("mode");
  String path="/member/zipcheck.jsp";
  RequestDispatcher dispatcher=request.getRequestDispatcher(path);
  dispatcher.forward(request, response);
 }
 
}

zipcodesearch.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR"
 pageEncoding="EUC-KR"%>
<%
 String myctx = request.getContextPath();
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>우편번호 검색</title>
<script type="text/javascript">
function searching(){
 if(!zipF.dongInput.value){
  alert('검색할 읍/면/동 이름을 입력하세요');
  zipF.dongInput.focus();
  return;
 }
 zipF.submit();
}
function closing(){
 self.close();
}
</script>
</head>
<body style="background-color: #f1f1f1">
 <div align="center">
  <form name="zipF" method="post" action="<%=myctx%>/Zipcode-Search">
   <table width="585" border="0">
    <tr>
     <td align="left" valign="middle"><img
      src="<%=myctx%>/images/telescope.png" width="30" height="30" />우편번호
      검색</td>
     <td align="right" valign="bottom"><b><font size="2"
       color="#000000">#Multi</font><!-- #999999 -->
     </b>
     </td>
    </tr>
    <tr>
     <td colspan="2" bgcolor="#101010"></td>
    </tr>
    <tr></tr>
   </table>
   <table border="1" width="585">
    <tr>
     <td bgcolor="#101010"><br />
     <br />
     <b><font color="white">읍/면/동 이름</font>
     </b> <input type="text" name="dongInput" id="doch" width="10"
      maxlength="20"> <br />
     <br />
    </tr>
   </table>
   <br />
   <br /> <input type="button" name="searchingBtn" value="검색(Search)"
    onclick="searching()" /> <input type="button" name="closingBtn"
    value="닫기(Close)" onclick="closing()"/> <br />
   <br />
   <table width="585">
    <tr>
     <td colspan="2" bgcolor="#000000"></td>
    </tr>
   </table>
   <br />
   <table width="585">
    <tr>
     <td align="left"><b><font color="red" size="2"> ▷
        검색하고자 하는 읍/면/동 이름을 입력해주십시오.<br /> ▷ 주소 경기 고양시 일산서구 일산1동 이라면 <font
        color='black'>'일산'</font> 또는 <font color='black'>'일산1동'</font>
        이라고 입력하시면 됩니다. </font>
     </b></td>
    </tr>
   </table>
  </form>
 </div>

</body>
</html>

 

web.xml

<servlet>
     <servlet-name>Zipcode-Search</servlet-name>
     <servlet-class>member.controller.ZipCodeSearch</servlet-class>
 </servlet>
 <servlet-mapping>
     <servlet-name>Zipcode-Search</servlet-name>
     <url-pattern>/Zipcode-Search</url-pattern>
 </servlet-mapping>

 

//ZipCodeSearch.java

package member.controller;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import member.domain.ZipCodeDTO;

public class ZipCodeSearch extends HttpServlet {

 @Override
 protected void doPost(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  request.setCharacterEncoding("euc-kr");
  String keyword = request.getParameter("dongInput").trim();
  System.out.println(keyword + "입력한 동이름");

  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rs = null;
  List<ZipCodeDTO> getZipList=new ArrayList();
  try {
   Class.forName("com.mysql.jdbc.Driver");
   conn = DriverManager.getConnection(
     "jdbc:mysql://localhost:3306/mymulti", "root", "manager2");
   String sql = "select zipcode,sido,gugun,dong,bunji from zipcode where dong like ?";
   pstmt = conn.prepareStatement(sql);
   pstmt.setString(1, "%"+keyword+"%");
   rs = pstmt.executeQuery();
   
   while (rs.next()) {

    ZipCodeDTO dto=new ZipCodeDTO();
    dto.setZipcode(rs.getString("zipcode"));
    dto.setSido(rs.getString("sido"));
    dto.setGugun(rs.getString("gugun"));
    dto.setDong(rs.getString("dong"));
    dto.setBunji(rs.getString("bunji"));
    getZipList.add(dto);
    

   }// while
   request.setAttribute("ziplist", getZipList);
   
  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   if (rs != null)
    try {
     rs.close();
    } catch (SQLException e) {
    }
   if (pstmt != null)
    try {
     pstmt.close();
    } catch (SQLException sqle) {
    }
   if (conn != null)
    try {
     conn.close();
    } catch (SQLException sqle) {
    }
  }
  /*
   * select zipcode,sido,gugun,dong,bunji from zipcode where dong like
   * '흑석동';
   */
  String path = "/member/zipcodesearch.jsp";
  RequestDispatcher dispatcher = request.getRequestDispatcher(path);
  dispatcher.forward(request, response);
  return;
 }

}

저작자표시 비영리

'JSP > Tomcat 6.0 설정' 카테고리의 다른 글

context.xml 수정  (1) 2012.06.07
지금까지 회원가입 웹프로그램  (0) 2012.06.07
proj  (0) 2012.05.24
JSP 톰캣-jdk1.6/1.7 연동 (2)  (0) 2012.04.24
JSP 톰캣-jdk1.6/1.7 연동 (1)  (0) 2012.04.24

'JSP/Tomcat 6.0 설정' Related Articles

티스토리툴바