Pessoal muito estranho…envio 7 parâmetros e da erro no 8º…
Servlet
public class SrvAleraAluno extends HttpServlet {
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String nome, ano, obs, fone, idade, media;
int cod;
cod = Integer.valueOf(request.getParameter("txtCod"));
nome = request.getParameter("txtNome");
idade = request.getParameter("txtIdade");
ano = request.getParameter("txtAno");
obs = request.getParameter("txtObs");
media = request.getParameter("txtMedia");
fone = request.getParameter("txtFone");
Aluno alu;
alu = new Aluno();
alu.setIdAluno(Integer.valueOf(cod));
alu.setNomeAluno(nome);
alu.setIdadeAluno(Integer.valueOf(idade));
alu.setAnoAluno(ano);
alu.setObsAluno(obs);
alu.setMediaAluno(Float.valueOf(media));
alu.setFoneAluno(fone);
boolean result = false;
result = AlunoDAO.update(alu);
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try {
out.println("<html>");
out.println("<head>");
out.println("<title>Resultado da Inclusão</title>");
out.println("</head>");
out.println("<body>");
if (result) {
out.println("<h1>Alterado com Sucesso!</h1>");
} else {
out.println("<h1>Erro ao Alterar Aluno</h1>");
}
out.println("<a href='index.jsp'>VOLTAR</a>");
out.println("</body>");
out.println("</html>");
} finally {
out.close();
}
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}DAO
[code]
public static boolean update(Aluno aluno) {
String sql = “UPDATE aluno SET idaluno=?, nomeAluno = ?, anoAluno = ?, idadeAluno= ?, obsAluno = ?, mediaAluno = ? , foneAluno =? WHERE idAluno = ?”;
try {
PreparedStatement pstm = (PreparedStatement) new Conexao().getConexao().prepareStatement(sql);
pstm.setInt(1, aluno.getIdAluno());
pstm.setString(2, aluno.getNomeAluno());
pstm.setString(3, aluno.getAnoAluno());
pstm.setInt(4, aluno.getIdadeAluno());
pstm.setString(5, aluno.getObsAluno());
pstm.setFloat(6, aluno.getMediaAluno());
pstm.setString(7, aluno.getFoneAluno());
pstm.executeUpdate();
return true;
} catch (Exception e) {
System.out.println("Erro ao atualizar dados de aluno.\n"+e);
return false;
}
}
[/code]
Erro
Erro ao atualizar dados de aluno.
java.sql.SQLException: No value specified for parameter 8