import java.io.;
import javax.servlet.;
import javax.servlet.http.;
import java.util.;
import java.sql.;
import java.awt.;
public class Cadastro extends HttpServlet
{
public void service(ServletRequest request,ServletResponse response)throws ServletException, IOException
{
PrintWriter out=response.getWriter();
String nome=request.getParameter("nome");
String pass=request.getParameter("email");
String name=request.getParameter("psw");
String password=request.getParameter("repete");
int i=0;
try{
Connection cn1 = null; //abrir a base de dados
//PreparedStatement stm1 = null; // para correr no query
PreparedStatement ps= null;
ResultSet rs1 ; //para carregar os dados
Class.forName("com.mysql.jdbc.Driver");
cn1 = DriverManager.getConnection("jdbc:mysql://localhost/sistema?user=root&password=");
//stm = cn1.createStatement();
response.setContentType("text/html");
String sql = "insert into cadastro values (?,?,?,?)"; // where user=? and pass=?"
ps= cn1.prepareStatement(sql);
ps.setString(1, "zotica");
ps.setString(2, "zotica@gmail.com");
ps.setString(3, "zozo");
ps.setString(4, "zozo");
//ps.setString(5, "zozo");
ps.executeUpdate();
///if(rs1.next()){
//out.println("<h1>PASSWORD OR USER IS CORRECET</h1>");
//request.getRequestDispatcher("/up/welcome.jsp").forward(request, response);
HttpServletResponse httpServletResponse = (HttpServletResponse) response;
httpServletResponse.sendRedirect("/up/Welcome.jsp");
//}else{
out.println("<html>");
out.println("<body>");
out.println("<h1>PASSWORD OR USER IS INCORRECET</h1>");
out.println("</body>");
out.println("</html>");
//request.getRequestDispatcher("/up/Index.jsp").forward(request, response);
//}
}catch(Exception ex){
out.println("<h1>ERRO!!!'"+ex+"'</h1>");
}
}
}
o erro : ERRO!!!‘java.sql.SQLException: Column count doesn’t match value count at row 1’
o meu BD tem 5 elementos contando com o id