1.11M Members

insert values to mysql database

 
0
 

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>

 
0
 

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

 
0
 

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

 
0
 

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.

 
0
 

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.

 
-1
 

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

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article