insert values to mysql database

Question

aarya 1 Junior Poster

18 Years Ago

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";

%>

<%
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>

java-jsp mysql

4 Contributors
5 Replies
435 Views
4 Years Discussion Span
Latest Post 14 Years Ago Latest Post by gauravleoheart

masijade 1,351 Industrious Poster

18 Years Ago

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

masijade 1,351 Industrious Poster

18 Years Ago

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.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

aarya 1 Junior Poster · Answer 1 · 2006-06-02T23:57:21+00:00

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

Harika.it 0 Newbie Poster · Answer 2 · 2006-10-24T13:39:47+00:00

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>

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.

gauravleoheart -2 Newbie Poster · Answer 3 · 2010-06-16T18:37:15+00:00

it works like this as u want to insert values into the table...

u need to put this where you want your insert code

// at first u need to get your form data into the jsp variables using the getParameter function"

// <table> // this table is for printing data in table which im doing below

<%

try
{
String my_sql_statement = "insert into [tablename] (fieldname1,fieldname2,fieldname3) values ('" + value1 + "','" + value2 "',"' + value3 "')";

Class.foName("com.mysql.jdbc.Driver").newInstance;
Connection con = DriverManager.getConnection;

Statement s1 = con.createStatement();
int value = executeUpdate(my_sql_statement);

//and now if you want to check that you have inserted them properly

String my_sql_statement2 = "select * from [tablename]";

ResultSet rs=s1.executeQuery(my_sql_statement2);

while(rs.next())
{
//now get the values of those jsp table in a string like suppose u have only 1 column //in ur table so it would be like this and column name is username

String my_username = rs.getString("username");
//and if you want to disply it 

%> <tr><td><%= my_username %> </td></tr>

<%
} // end while

} // end try
%>
</table>

<%

catch (Exception e )
{
out.print(e);
}
finally
{
}
%>

minor errors may be there but this will be the logic

Replied to 4 years old thread, with no code tags and bad code. Do not connect to DB from page view, use servlet.