How to update a data in database from jsp

Hi

I have some user details in MySQL,iam trying to update the data from jsp page but its showing unable to connect to database but the same code if i gave some name in code it is updating, but i need to update data at run time i will give first_name in run time by useing that remaing data wants to update in mysql

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.*" %> 
<%@ page import="java.io.*" %> 
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Inserting Data in MySql</title>
</head>
<BODY bgcolor="#ffffcc">
<FORM action="up.jsp" method="get">
<H1><CENTER> <B>ADD USER'S DETAILS</B></CENTER></H1>

<p align="right">
 ${username}
 </p>
<TABLE style="background-color: #ECE5B6;" WIDTH="30%" >
                    <tr>
                        <td> First Name : </td><td> <input name="fname" size=15 type="text" /> </td> 
                    </tr>
                    <tr>
                        <td> Last Name : </td><td> <input name="lname" size=15 type="text" /> </td> 
                    </tr>
                    <tr>
                        <td> Email-id : </td><td> <input name="Email_id" size=15 type="text" /> </td> 
                    </tr>
                    <tr>
                        <td> Phone number : </td><td> <input name="Phone" size=15 type="text" /> </td> 
                    </tr>
                    <tr>
                        <td> Username  : </td><td> <input name="Username" size=15 type="text" /> </td> 
                    </tr>
                    <tr>
                        <td> Password  : </td><td> <input name="Password" size=15 type="password" /> </td> 
                    </tr>
                    </tr>
                  <td width="50%"><INPUT TYPE="submit" VALUE="submit"></td>
          </tr>
                </table>
                <%
   String fname = request.getParameter("fname");
   String lname = request.getParameter("lname");
   String Email_id = request.getParameter("Email_id");
   String Phone = request.getParameter("Phone");
   String Username = request.getParameter("Username");
   String Password = request.getParameter("Password");
   String connectionURL = "jdbc:mysql://localhost:3306/usermaster";
   Connection connection = null;
   PreparedStatement pstatement = null;
   Class.forName("com.mysql.jdbc.Driver").newInstance();
   int updateQuery = 0;
   if(fname!=null && lname!=null && Email_id!=null && Phone!=null && Username!=null && Password!=null){
	   if(fname!="" && lname!="" && Email_id!="" && Phone!="" && Username!="" && Password!=""){
		   try{
			   connection = DriverManager.getConnection(connectionURL, "root", "root");
			   String queryString = "update empdetails set Last_Name=? where First_name= ?";
			   pstatement = connection.prepareStatement(queryString);
	              pstatement.setString(2, lname);
	              updateQuery = pstatement.executeUpdate();
	              if (updateQuery != 0) { %>
                  <br>
                  <TABLE style="background-color: #E3E4FA;" 
                  WIDTH="30%" border="1">
                     <tr><th>Data is updated successfully 
                   in database.</th></tr>
                  </table>
                  <%
              }
            } 
            catch (Exception ex) {
            out.println("Unable to connect to database.");
   
               }
            finally {
                // close all the connections.
                pstatement.close();
                connection.close();
            }
          }
        }
%>
</FORM>
</body> 
</html>

if i gave code like this it is updateing

it is updating arun data but i need to give the name also in run time.

please guide me,

Thanks in advance

few Things I can suggest after looking into your code ...

1. pstatement.setString(2, lname); you have just set lname only even in your query you should pass fname also.
2. try to use normal sql update ,i doubt you can pass dynamic value in where clause in PL/SQL (I guess). try to update data without using where clause ,if you get success
it means you can't pass dynamic value for where clause.

hope my finding help you :)

Don't use java code inside jsp. It's a very old practice. JSP is just the view.

Yes it is old practice to write java code in the JSP

But if you still want to update data .Write the updation block(java code) in separate method in the Java class and then call it from the JSP.

you have to just pass the parameters in the method and rest of work you can do the method , I mean if you have only parameter then pass other one as empty and in the java method you can actually create the query having one where condition.

say
method( param1,param2){

SQL="......"

if(param1 !=""){

SQL =SQL+"fname=" +param1;
}

if(param2 !=""){

SQL =SQL+"lname=" +param1;
}

}

Something like above pseudocode..