How to update record in oracle databse

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.awt.Color"%>
<%@page import ="java.sql.*"%>
<%@page import ="java.util.*"%>

<%!
String nam,username,password,address,male,email,cont,nm;
String upnam,upusername,uppassword,upaddress,upmale,upemail,upcont,upnm;
String slt="";
int flag=0 ,a=0,temp=0;
long contact,upcontact;
boolean b=false;
Connection con;
public void jspInit()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","hr");
}
catch(Exception e)
{
System.out.print(e);
}
}

%>
<%
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from login");

%>

<!DOCTYPE html>
 
  <head>
    <title></title>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
    <body bgcolor="#9999">
    <form method="post" action="usersdetail.jsp">  
    <center>
        <table border="1">
          
    <tr><td colspan="8" align="center">  <center><font size="4"><b> Verify User Details !</b></font></center></td></tr>
<%
try
           {
      %>

<tr> <td> <font size="2"> Select User Name </font></td>      
        <td> <font size="2"> Name </font></td>      
         <td align="center"><font size="2"> User name </font></td>
         <td align="center"><font size="2"> Password </font></td>
         <td align="center"> <font size="2"> Address </font></td>
        <td align="center"><font size="2"> Contact No </font></td>
        <td align="center"><font size="2"> Gender </font></td>
            <td align="center"><font size="2"> E-mail id </font></td></tr>
       <tr
           >           
           <td align="center" >     
      
      <%
         out.println("<select id=my name=my>");
      while(rs.next())
         {
          
      nam = rs.getString(1);
  
    
   %>
  
       <option value=<%=nam%> > <%= nam %>  </option>
   
   <%
    
         }
      out.println("</select>");
       
    
    slt = request.getParameter("my");
     
      %>
      
        
      <%
     
     rs= st.executeQuery("select * from login");      
      
           while(rs.next())
           {
               
           nm = rs.getString(1);
      
      
                if(nm.equals(slt))
                {
                        
                        username = rs.getString(2);
                         password = rs.getString(3);
                         address = rs.getString(4);
                           male = rs.getString(6);
                         email = rs.getString(7);
                        cont = rs.getString(5);
                         contact = Long.parseLong(cont);
                        
            %>                                 
         <td align=center>
          <input type=text name=udn value=<%=nm%>>
        </td>

<%
                                
           if (temp==1)
               
           {
           upnam= request.getParameter("udn");
           upusername=request.getParameter("udun");
           uppassword=request.getParameter("udp");
           upaddress=request.getParameter("uda");
           upmale=request.getParameter("udg");
           upemail=request.getParameter("ude");
           upcont=request.getParameter("udc");
           upcontact = Long.parseLong(upcont);
           upnm=request.getParameter("udg");
       
    
// line wrapped by Wendy G
       b=st.execute("update login SET NAME = 'upnam', " +
                    "USERNAME = 'upusername', PASSWORD = 'uppassword',  " +
                    "ADDRESS = 'upaddress', CONTACT= 'upcontact', " +
                    " GENDER = 'upmale', EMAIL= 'upemail' where name = 'nm')"); 
       
          
         }       
    %>

<%--   
        if(slt!=null)
       {
    out.println("You have selected: " +slt);
      }
     --%>
     <%        
         }
      catch(Exception e){ }
      %>  
      </td>
  
           
    </table>

</body>
</html>

1.
This is my jsp code which allow to select users through drop down list and then set respective user information to textbox after click on show button.
And i did any changes in shown text fields and click on update button to save those changes in to database(login table).
But how to update text field details through update button?

2.
Here i also face another problem, while matching user_name in table with selected drop down list option e.g. I keep user name = sudhir pawar and any respected details in login table.
Then i select sudhir pawar from drop down list and click on show button no text fields with its respected details are shown in jsp page.
It work fine if i keep user name = sudhir only not sudhir pawar, so please give me solution for this situation.

you can create table using this query:-

CREATE TABLE "LOGIN"
( "NAME" VARCHAR2(50) NOT NULL ENABLE,
"USERNAME" VARCHAR2(50) NOT NULL ENABLE,
"PASSWORD" VARCHAR2(50) NOT NULL ENABLE,
"ADDRESS" VARCHAR2(200) NOT NULL ENABLE,
"CONTACT" NUMBER NOT NULL ENABLE,
"GENDER" VARCHAR2(10) NOT NULL ENABLE,
"EMAIL" VARCHAR2(50) NOT NULL ENABLE
)
/

Suggestion #1: Move most of this code into a java class.

Java code does not belong on a JSP.
SQL/Database code does not belong on a JSP.

You might consider methods in this java class such as

public List<String> getAllUserNames();
public User getUserBasedOnName(String name)
public void saveUserDetails(User user);

Suggestion#2: Break this JSP up.
This JSP seems to do many things.
- display a list of users to choose
- display the details for one user
- update the details for one user
I would suggest breaking this functionality up into seperate modules so that you can develop and test each independently.

>It work fine if i keep user name = sudhir only not sudhir pawar, so please give me solution for this situation.
Your database table has fields for both "name" and "username"
Currently your code appears to be looking up using the "name" column, rather than "username". That might explain this situation.

Not a JSP question, moved to JDBC. You should not be doing this in a JSP to begin with.

please friends give me solution on this

Ok so the key on your database table is name, the select worked when you choose "sudhir" but not when you use "sudihar pawar", these names are different.

It work fine if i keep user name = sudhir only not sudhir pawar, so please give me solution for this situation.

and to contiue the servlet bullying, but if this is only an example program to test the db end learn about unit tests.

jsp or servlets