servlet & JDBC connection

[induz sat]

I have UserRegistration servlet that fetches parameters from register.jsp and add records to RegisteredUser db through JDBC on Tomcat.

what is wrong in the code as when i run the jsp it shows all the elements of HTML form. but when i type in something in TextBox and submit it, Tomcat says "you are not connected to the internet". I can visit yahoo though from the same webbrowser. Also it does not add any records in RegisteredUser table.

try{
				Class.forName(jdbc_driver);
				Connection conn= DriverManager.getConnection(db_URL, db_user, db_pass);
				Statement stmt = conn.createStatement();
				//Statement stmt = conn.createStatement();
				String sql =("INSERT INTO SocialNetwork.REGISTEREDUSER (Name,Password,Age} value (?,?,?)");


				ResultSet rs= stmt.executeQuery(sql);
				
												
				if (rs.next()){
					
					out.println("Welcome" +regdN);
					
				} else {
					
					out.println("<h2>Log in again Or <br>Register<h2>");
					
				}

[Ulf Dittmer]

Impossible to say without seeing the entire code. I notice that you have a curly closing brace in line 6 - is that a typo, or a bug in the program?

[Raj Chila]

Agree with Ulf Dittmer, there could be a lot of reasons why you see that error...but just by looking at your code snippet, Should'nt you be using a Prepared Statement? and if you are not, then the ?'s should be replaced with actual values and the value key word needs to be values.

[induz sat]

curly closing brace in line 6

was a typo. Corrected.

Could you please suggest a working link/example example of PreparedStatement generic class and its methods.

Thanks a lot...I can check a record in the same db in the same project through a Login.jsp and LoginServlet. Do I have to close the jdbc connection for another doPost method to connect??

Thanks again

[Santhosh ayiappan]

All the resources like Statement, Connection should be closed in the finally block.

You have to use the execute or executeUpdate method to perform the insert operation.

executeQuery ExecuteQuery should be used for the Select

[Li Qiangqiang]

"INSERT INTO SocialNetwork.REGISTEREDUSER (Name,Password,Age) values (?,?,?)"

[Rajesh Vassey]

Can you paste the Tomcat server logs. Which can make us know some more insights of error?