hi , i got stucked with sql-servlet combination... i have worked comfortably with select statements.. i tried one insert statement and i got the problem rs=st.executeQuery("insert into Result (Name,Roll_no) values('"+req.getParameter("name")+"','"+req.getParameter("roll_no")+"');");
this is the actual statement and it inserts values in database also but throws an exception.. java.sql.SQLException: No ResultSet was produced what do i do so that i won't get the exception? also if i just want to check that if some value is there in database or not e.g. user name and poassword, which sql statement should i use? Thanx for ur helping hand... bhupendra
posted 14 years ago
The insert statement does not create a result set, unlike a select statement. I think you may want to use the executeUpdate() methoed rather than the executeQuery() method. executeUpdate() will return an int representing the number of rows affected.