@Override
public Object processCommand(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
String dong = req.getParameter("dong");
Vector v = new Vector();
Connection con = null;
PreparedStatement stmt = null;
ResultSet rs = null;
DBConnectionMgr pool = null;
try {
pool = DBConnectionMgr.getInstance();
con = pool.getConnection();
String sql = "select * from tblzip where dong like'%" + dong + "%'";
stmt = con.prepareStatement(sql);
rs = stmt.executeQuery();
while (rs.next()) {
ZipDto zip = new ZipDto();
zip.setZipcode(rs.getString("zipcode"));
zip.setSido(rs.getString("sido"));
zip.setDong(rs.getString("dong"));
zip.setGugun(rs.getString("gugun"));
zip.setBunji(rs.getString("bunji"));
v.add(zip);
}
} catch (Exception err) {
System.out.println("zipCommand : " + err);
} finally {
pool.freeConnection(con, stmt, rs);
}
req.setAttribute("zip", v);
return "/exam3/zipSearch.jsp";
}
public sign_upMgr() {
try {
pool = DBConnectionMgr.getInstance();
} catch (Exception e) {
System.out.println("Error : Exception");
}
}