result set not retrieved

Ranch Hand

Posts: 133

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

this code is written so that it will issue a insert statement and insert the username & password to the mysql database but it
didn't do that .i have checked everything is fine till the line 32 ,but after that some problem is occuring .

package shoppee  ;

import java.sql.* ;
import java.io.* ;
import javax.servlet.* ;
import javax.servlet.http.* ;
import java.sql.ResultSet ;
import java.lang.String ;

public class regme extends HttpServlet {
public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String drivername = "com.mysql.jdbc.Driver";
String urlname = "jdbc:mysql:tusharonline";
String username1 = "root";
String password1 = "adminadmin";
String username = request.getParameter("username");
String password = request.getParameter("password");
String id = request.getParameter("rows");
writedatabase(drivername,urlname,username1,password1,username,password,out);
}

public static void writedatabase(String drivername,String urlname,String username1,String password1,String username,String password,PrintWriter out){
 ResultSet rs3=null; int rows=0;
 String address=null;
 Connection con=null;
 String query1 = "insert into registered (username,password) values('" ;
 String query2 = username ;
 String query3 = password ;
String query=query1+query2+"','"+query3+"');";
out.println("final query"+query+"<BR>");
try{ Class.forName(drivername) ;
      con = DriverManager.getConnection("jdbc:mysql://localhost:3306/tusharonline?" + "user=root&password=adminadmin");
     Statement stmt = con.createStatement();
     rs3=stmt.executeQuery(query);
     ResultSetMetaData rs3MetaData = rs3.getMetaData();
     int columnCount = rs3MetaData.getColumnCount(); 
    
while(rs3.next())
{for(int i=1; i <= columnCount; i++) {out.println(rs3.getString(i));rows=rows+1;} }
}
catch(ClassNotFoundException cnfe){
System.out.println("error occured CNFE :"+cnfe);
}
catch(SQLException sqle){
System.out.println("error occured SQLE :");
sqle.printStackTrace();
}
catch(Exception ex){
System.out.println("Exception here"+ex);
}
out.println("sucessfully registered");
out.println("rows"+rows);
}
}

the stack trace i get at tomcat window is :

java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
        at com.mysql.jdbc.StatementImpl.checkForDml(StatementImpl.java:424)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1365)
        at shoppee.regme.writedatabase(regme.java:42)
        at shoppee.regme.doGet(regme.java:26)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServlet.java:404)
        at org.apache.catalina.servlets.InvokerServlet.doGet(InvokerServlet.java:136)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
        at java.lang.Thread.run(Thread.java:619)

please help me out .