Boa Noite galera…
seguinte estou com dificuldades em usar o update…
segue o codigo completo
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Update extends HttpServlet{
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws IOException, ServletException
{
res.setContentType("text/html");
java.io.PrintWriter out = res.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>Cadastro De Itens</title>");
out.println("</head>");
out.println("<body>");
out.println("<form method=POST action=>");
out.println("<table width=600 border=0 align=center>");
out.println("<tr>");
out.println("<td>");
out.println("</td>");
out.println("<td>");
out.println("<font face=Verdana>");
out.println("<b>Cadastro de Itens</b></font>");
out.println("<br>");
out.println("<br>");
out.println("<br>");
out.println("</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>");
out.println("<font face=Verdana>Usuarios: ");
out.println("</td>");
out.println("<td>");
Conector con = new Conector();
con.conectar();
String sql2 = "select * from usuarios ORDER BY nome";
ResultSet rr = con.executarConsulta(sql2);
try{
rr.first();
out.println("<select name=usuarios style=\"background-color: #CCCCCC\">");
while(!rr.isAfterLast()){
String valor = rr.getString("nome");
out.println("<option value="+rr.getString("id")+"> "+valor+" </option>");
rr.next();
}
out.println("</select>");
} catch (Exception e)
{out.println(e);
}
out.println("</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>");
out.println("</td>");
out.println("<td>");
out.println("<br>");
out.println("<input type=submit value=Cadastrar name=B1> ");
out.println("<input type=reset value=Limpar name=B2>");
out.println("</td>");
out.println("</tr>");
out.println("</form>");
out.println("</body>");
out.println("</html>");
out.close();
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws IOException, ServletException{
res.setContentType("text/html");
java.io.PrintWriter out = res.getWriter();
//criando variaveis para receber o valor
String usuarios = req.getParameter("usuarios");
Conector con = new Conector();
con.conectar();
String sql = "select * from usuarios where id = '"+usuarios+"'";
ResultSet r = con.executarConsulta(sql);
try{
r.first();
while(!r.isAfterLast()){
out.println("<input type=text name=mostra value="+r.getString("nome")+"> <br>");
out.println("<input type=text name=mostra2 value="+r.getString("telefone")+" ><br>");
out.println("<input type=text name=mostra3 value="+r.getString("email")+"><br>");
r.next();
}
}catch (Exception e){
out.println(e);
}
String mostra = req.getParameter("mostra");
String mostra2 = req.getParameter("mostra2");
String mostra3 = req.getParameter("mostra3");
try{
Conector cone = new Conector();
cone.conectar();
String Atualiza = "UPDATE usuarios set nome="+mostra+", telefone="+mostra2+", email="+mostra3+" WHERE id="+usuarios+" " ;
cone.executarConsulta(Atualiza);
out.println(Atualiza);
}catch (Exception e){
out.println(e);
}
}
}
agora onde imagino que possa estar o problema
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws IOException, ServletException{
res.setContentType("text/html");
java.io.PrintWriter out = res.getWriter();
//criando variaveis para receber o valor
String usuarios = req.getParameter("usuarios");
Conector con = new Conector();
con.conectar();
String sql = "select * from usuarios where id = '"+usuarios+"'";
ResultSet r = con.executarConsulta(sql);
try{
r.first();
while(!r.isAfterLast()){
out.println("<input type=text name=mostra value="+r.getString("nome")+"> <br>");
out.println("<input type=text name=mostra2 value="+r.getString("telefone")+" ><br>");
out.println("<input type=text name=mostra3 value="+r.getString("email")+"><br>");
r.next();
}
}catch (Exception e){
out.println(e);
}
String mostra = req.getParameter("mostra");
String mostra2 = req.getParameter("mostra2");
String mostra3 = req.getParameter("mostra3");
try{
Conector cone = new Conector();
cone.conectar();
String Atualiza = "UPDATE usuarios set nome="+mostra+", telefone="+mostra2+", email="+mostra3+" WHERE id="+usuarios+" " ;
cone.executarConsulta(Atualiza);
out.println(Atualiza);
}catch (Exception e){
out.println(e);
}
}
bom pessoal o problema e o seguinte …
criei 3 variaveis para pegar o valor q a consulta vai retornar nos campos…
so q na hora do sql os campos retornam todos NULL…
oq pode ser???
desde ja grato
[]s
