String Firstname = request.getParameter("FirstName");
String Lastname= request.getParameter("LastName");
String Username = request.getParameter("username");
String Password= request.getParameter("password");
int Psid= Integer.parseInt(request.getParameter("psid"));
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(connectionURL, "root", "admin@123");
PreparedStatement pst = connection.prepareStatement("update user set FirstName=?,LastName=?,username=?,password=? , psid=? where username ='?'");
pst.setString(1,Firstname);
pst.setString(2,Lastname);
pst.setString(3,Username);
pst.setString(4,Password);
pst.setInt(5,Psid);
int i = pst.executeUpdate();
if(i!=0){
pw.println("record updated");
}
else{
pw.println("failed to update the data");
}
}
this is my
servlet my records are not gettng dynamiclly updated.....it is coming to else part failed to update the data...where am i wrong...