Dear Sir/Madam
I am trying to delete the one user data in the Oracle SQL server database by using servlet program (Tomcat server).
The given data is true then the user data to be delete from the database table.
Assume in Database table have 25 users details are there.
I am given 6th (some n th row)user details true values even though while loop is not terminate, it checking until the end of table and always given else black statement. So what is my mistake in while loop explain and please give the solution to me.
My programe is:
import java.lang.*; import java.io.*; import java.sql.*; import java.util.*; import javax.servlet.*; import javax.servlet.http.*; public class JdbcUpdateServlet extends HttpServlet { String name,pas,cde; String un,up,co; boolean flag=false; public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException { try { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); response.setContentType("text/html"); un=request.getParameter("uname"); up=request.getParameter("pwd"); co=request.getParameter("code"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection c=DriverManager.getConnection("jdbc:odbc:hari","raman","raman"); Statement s=c.createStatement(); s.executeQuery("select *from jduser"); ResultSet rs=s.getResultSet(); while(rs.next()) { name=rs.getString(1); pas=rs.getString(2); cde=rs.getString(3); if(un.equals(name)&&up.equals(pas)&&co.equals(cde)) { flag=true; s.executeUpdate("delete from jduser where code='"+un+"'"); break; } } if(flag==true) out.println(name+" User Data deleted successfully"); else out.println("Sorry "+un+" user data is Not Available"); s.close(); c.close(); out.close(); } catch(IOException e) { System.out.println(e.getMessage()); } catch(SQLException e) { System.out.println(e.getMessage()); } catch(ClassNotFoundException e) { System.out.println(e.getMessage()); } } }
In that link solution is not sufficient to my problem.
I want in while loop when if condition is true then only remove one user data and terminate the while loop.
Before it check the values one by one in the table if match then remove.
Same problem with full details (HTML Page, Database table, Servlet Program) see this link
Try this All the best
deletetest.jsp
< input type=checkbox name="check" value="<%=rsselqry.getString(2)%<" < < input type="submit" value="Delete" < **del.jsp** d =request.getParameterValues("check"); if(d !=null) { for(int i=0;i<d.length;i++) { k=(String)d[i]; out.println(k); } } stmtselqry.executeUpdate("delete from mail where name='"+k+"'");