By doing exactly what ypu are doing, but storing the result of the executeUpdate in an int rather than a ResultSet. You can then check that the integer is not 0 if you want to make sure that something was inserted. After you have made this change, try your program again. If nothing is being inserted, you will at least, probably get a better error message than the one you are getting now. This error message is being thrown during compileation. Up to this point, nothing has been executed.
This is Harika. Now i got the same task to do. Would u now help me about this. I have to write a jsp file which reads the values from html file having textfields and those has to b inserted in to database mysql through the driver com.mysql.jdbc.Drive. Would you show me jsp file regarding to this.
it works like this as u want to insert values into the table...
u need to put this where you want your insert code
// at first u need to get your form data into the jsp variables using the getParameter function"
// <table> // this table is for printing data in table which im doing below
String my_sql_statement = "insert into [tablename] (fieldname1,fieldname2,fieldname3) values ('" + value1 + "','" + value2 "',"' + value3 "')";
Connection con = DriverManager.getConnection;
Statement s1 = con.createStatement();
int value = executeUpdate(my_sql_statement);
//and now if you want to check that you have inserted them properly
String my_sql_statement2 = "select * from [tablename]";
//now get the values of those jsp table in a string like suppose u have only 1 column //in ur table so it would be like this and column name is username
String my_username = rs.getString("username");
//and if you want to disply it
%> <tr><td><%= my_username %> </td></tr>
} // end while
} // end try
catch (Exception e )
minor errors may be there but this will be the logic