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
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.
I've never won anything before. Not even a tiny ad: