@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"); } }
public boolean getResult() { Connection conn = null; Statement stmt = null; ResultSet rs = null; boolean flag = false; try { conn = pool.getConnection(); String strQuery = "select * from usertable where Email = '" + param.getEmail() + "'"; stmt = conn.createStatement(); rs = stmt.executeQuery(strQuery); if (rs.next()) { System.out.println("Alreay Exist"); flag = false; return flag; } System.out.println("AAA"); // DB에 삽입할 쿼리문 생성 strQuery = "insert into usertable (UserName,Email,PassWord) " + "VALUES('" + param.getUserName() + "', '" + param.getEmail() + "', '" + param.getPassWord() + "')"; // System.out.println(strQuery); stmt = conn.createStatement(); stmt.executeUpdate(strQuery); flag = true; } catch (Exception ex) { System.out.println("Exception" + ex); } finally { pool.freeConnection(conn); } return flag; }