OK!
This is the source code:
Servlet[CODEpackage dbConnect;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class ServletLogin extends HttpServlet {
//Statement stm;
//ResultSet rs = null;
PreparedStatement update =null;
Connection con = null;
String DbUserName = "eloi";
String DbPassword = "trocar";
public void init() throws ServletException {
}
public void doGet(HttpServletRequest request , HttpServletResponse response)
throws IOException, ServletException{
doPost( request, response );
}
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws IOException, ServletException {
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://ANDROMEDA:1433",DbUserName, DbPassword);
PreparedStatement update = con.prepareStatement("insert into WIZUSUARIOS (UID, PWD, Nome)"
+ "values(? ,? ,? )");
}
catch(Exception sqle ){
System.out.println("Error message at" +sqle);
//System.out.println("Error message at" + cne);
}
try{
update.setString(1,request.getParameter("userId"));
update.setString(2,request.getParameter("password"));
update.setString(3,request.getParameter("name"));
update.executeUpdate();
update.close();
con.close();
}
catch(SQLException e){
e.printStackTrace();
System.out.println(e.getMessage());
System.out.println("Error at" + e);
}
}
public void destroy() {
super.destroy();
try {
if(update != null)
update.close();
}
catch(SQLException e){
System.out.println("Error at" + e);
}
try{
if(con != null)
con.close();
}
catch (SQLException sqle) {
//throw new ServletException( "SQL error trying to do this or that: " + sqle);
System.out.println("Error at" + sqle);
}
}
}
[/CODE]
the web form is:
and the eror messsage is
Its funny because before it didnt come this message just a blank page??
Ranch Hand Scavenger Hunt
. This isnt a job for a newbie but kind enjoying the challenge.
Number Posts (51/100)
First Post