salut , j'essai de modifier les donné d'une table, voila le code:
import java.awt.TextField;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;


public class First_serv2 extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException
{
Connection cnt=null;
Statement st=null,st1=null;
PreparedStatement pst=null;
ResultSet rst=null;



response.setContentType("text/html");
PrintWriter out = response.getWriter();
BufferedReader lineReader = new BufferedReader(new InputStreamReader(System.in));

out.println("<html>");
out.println("<head>");
out.println("<title>Multiplication</title>");
out.println("</head>");
out.println("<body>");

String var;
var=request.getParameter("txt");
out.print(var);



try
{ String url = "jdbc:odbc:db1";
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver).newInstance();
cnt = DriverManager.getConnection(url, "", "");
st=cnt.createStatement();
pst=cnt.prepareStatement("select * from etudiant where num=?");
pst.setString(1,var);
rst=pst.executeQuery() ;

while(rst.next())
{
out.print("<form name=frm3 method='get' action='First_serv2'>");

out.print("numéro etudiant :<input type='text' name='numtxt' value="+rst.getInt(1)+">");
out.print("<br>");
out.print("cne etudiant :<input type=text name='cnetxt' value="+rst.getInt(2)+">");
out.print("<br>");
out.print("nom etudiant :<input type=text name='nomtxt' value="+rst.getString(3)+">");
out.print("<br>");
out.print("prenom etudiant :<input type=text name='prenomtxt' value="+rst.getString(4)+">");



out.print(" <input type='submit' name='btmodif' value='modifier'>");
out.print("</form>");

}
String numtxt;
numtxt=request.getParameter("numtxt");
String cnetxt;
cnetxt=request.getParameter("cnetxt");
String nomtxt;
nomtxt=request.getParameter("nomtxt");
String prenomtxt;
prenomtxt=request.getParameter("prenomtxt");

pst = cnt.prepareStatement("UPDATE etudiant SET cne = ? " + "and nom= ? " + "and prenom= ? " + "WHERE num= ? ");
pst.setString(1,cnetxt);

pst.setString(2,nomtxt);

pst.setString(3,prenomtxt);

pst.setString(4,numtxt);

pst.execute();

cnt.close();





}
catch(Exception e)
{
out.print("Error: " + e);
}


out.print("");
out.print("");
out.print("");
out.println("</body>");
out.println("</html>");
}
}



lorsque je click qur le bouton modifier , rien ne m'arache,et pourtant il ne m'affiche pas un message d'erreur
merci pr votre aide.