DaniWeb IT Discussion Community - insert values to mysql database

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)

- JSP (http://www.daniweb.com/forums/forum24.html)

- - insert values to mysql database (http://www.daniweb.com/forums/thread46775.html)

insert values to mysql database

hi

i am trying to insert into mysql databse using jsp.but i am getting the error as

An error occured between lines: 38 and 47 in the jsp file: /jsp/havyaka/register.jsp



Generated servlet error:

C:\tomcat\work\localhost\examples\jsp\havyaka\register$jsp.java:102: Incompatible type for declaration. Can't convert int to java.sql.ResultSet.

                ResultSet rs = statement.executeUpdate("insert into havyak(usercode,password,email,name,phone,add1,add2,add3,add4,country) values('" + usercode + "','" + password + "','" + email + "','" + name + "','" + phone + "','" + add1 + "','" + add2 + "','" + add3 + "','" + add4 + "','" + country + "')");

^

my code is

<%
String usercode=request.getParameter("usercode");
session.setAttribute( "theuser", usercode );

String password =request.getParameter("password");
session.setAttribute( "thepass", password );

String email=request.getParameter("email");
session.setAttribute( "theemail", email );

String name=request.getParameter("name");
session.setAttribute( "thename", name );

String phone=request.getParameter("phone");
session.setAttribute( "thephone", phone );

String add1=request.getParameter("address1");

String add2=request.getParameter("address2");
String add3=request.getParameter("address3");
String add4=request.getParameter("address4");
String country=request.getParameter("country");

%>

<%@ page import="java.sql.*" %>
<%
String connectionURL = "jdbc:mysql://localhost/login?user=user ;password=pass";

%>

<html><body>

<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection = DriverManager.getConnection(connectionURL, "", "");
Statement statement = connection.createStatement();
ResultSet rs = statement.executeUpdate("insert into havyak(usercode,password,email,name,phone,add1,add2,add3,add4,country) values('" + usercode + "','" + password + "','" +

email + "','" + name + "','" + phone + "','" + add1 + "','" + add2 + "','" + add3 + "','" + add4 + "','" + country + "')");

%>
submitted
</body></html>

Re: insert values to mysql database

executeUpdate returns an int indicating the number of rows affected
by the query. It does not return a ResultSet.

Re: insert values to mysql database

Quote:

Originally Posted by masijade

executeUpdate returns an int indicating the number of rows affected
by the query. It does not return a ResultSet.

yes with that warning i guessed then how i ahve to insert into the database

Re: insert values to mysql database

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.

Re: insert values to mysql database

Quote:

Originally Posted by aarya (Post 220835)

hi

i am trying to insert into mysql databse using jsp.but i am getting the error as

An error occured between lines: 38 and 47 in the jsp file: /jsp/havyaka/register.jsp



Generated servlet error:

C:\tomcat\work\localhost\examples\jsp\havyaka\register$jsp.java:102: Incompatible type for declaration. Can't convert int to java.sql.ResultSet.

                ResultSet rs = statement.executeUpdate("insert into havyak(usercode,password,email,name,phone,add1,add2,add3,add4,country) values('" + usercode + "','" + password + "','" + email + "','" + name + "','" + phone + "','" + add1 + "','" + add2 + "','" + add3 + "','" + add4 + "','" + country + "')");

hi

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.

Thank you.