View difference between Paste ID: 5pK3V1hn and zDvaa5wa
SHOW: | | - or go back to the newest paste.
1
<%
2
String sql="select * from members";
3
String usrnme=(String)session.getAttribute("name");
4
String psswrd=(String)session.getAttribute("pass");
5
sql="select * from members where username='"+usrnme+"' and password='"+psswrd+"'";
6
7
8
  if(request.getMethod().equals("POST"))
9
  {	  
10
        
11
	     String username=request.getParameter("username");
12
	     String password=request.getParameter("password");
13-
	     String password2=request.getParameter("password2");
13+
	   
14
	     if (session.getAttribute("pass").equals(password) && session.getAttribute("name").equals(username))
15
	     {
16-
         db.insertUpdateDelete("update members set password='"+password2+"' where username='"+username+"' and password='"+password+"'");
16+
         db.insertUpdateDelete("delete from members where password='"+password+"' and username='"+username+"'");
17-
         session.setAttribute("pass",password2);
17+
         session.invalidate();
18-
         response.sendRedirect("updateForMember.jsp");
18+
         response.sendRedirect("index.html");
19
	     }
20
	     else
21-
	    	 response.sendRedirect("updateForMember.jsp");
21+
	    	 response.sendRedirect("deleteForMember.jsp");
22
  }
23
%>