jsp아이디찾기 중인데 오류좀 봐주세요
조회수 1590회
뷰쪽.jsp
<form action="find-controller.jsp" method="post">
<input type="text" size="20" name="userName" placeholder="이름을 입력해주세//요" required>
<br class="clear">
<p>전화번호:</p>
<input type="text" size="20" name="userNumber" placeholder=" - 를 제외한 번호 전체를 입력해주세요." required>
<br class="clear">
<p>이메일:</p>
<input type="text" size="20" name="userEmail" placeholder=" 이메일을입력해주세요." required>
<br class="clear">
</div>
<input type="submit" value="FIND ID" class="findid">
</form>
컨트롤러.jsp
<%@page import="com.jsp.web.member.model.MemberDAO"%>
<%@page import="com.jsp.web.member.model.MemberVO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<% request.setCharacterEncoding("utf-8"); %>
<jsp:useBean id="members" class="com.jsp.web.member.model.MemberVO" />
<jsp:setProperty name="members" property="*" />
<%
String name = request.getParameter("userName");
String email = request.getParameter("userEmail");
MemberDAO dao = MemberDAO.getInstance();
String user_id = dao.findId(members);
%>
<%if(user_id == null){ %>
<script type="text/javascript">
alert("존재하지 않은 계정입니다");
history.go(-1);
</script>
<%}else{%>
<script type="text/javascript">
alert("찾으시는 계정은 <%=user_id%>입니다.");
location.href="login1.jsp";
</script>
<%}%>
DB쪽
@Override
public String findId(MemberVO member) throws Exception {
String user_id = null;
String sql = "SELECT user_id FROM izone_member WHERE user_name=? and user_email=?";
try {
conn = ds.getConnection();
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, member.getUserName());
pstmt.setString(2, member.getUserEmail());
System.out.println("이름 읽어오기:"+ member.getUserName());
System.out.println("asd: " +member.getUserEmail());
rs = pstmt.executeQuery();
if(rs.next()){
user_id = rs.getString("user_id");
}
} catch (Exception e) {
e.printStackTrace();
}finally {
conn.close();
pstmt.close();
rs.close();
}
return user_id;
}
이름이랑 이메일만 가지고 아이디찾기 만들고있는데 계속 존재하지않는 아이디라고만 뜨는데 어디서 잘못되었는지 확인부탁드립니다.ㅜㅠㅜ
-
(•́ ✖ •̀)
알 수 없는 사용자
댓글 입력