•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the JSP section within the Web Development category of DaniWeb, a massive community of 374,449 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,734 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our JSP advertiser: Lunarpages JSP Web Hosting
Views: 12666 | Replies: 4
 |
•
•
Join Date: Sep 2005
Posts: 139
Reputation: 
Rep Power: 3
Solved Threads: 0
Junior Poster
hi
i am trying to insert into mysql databse using jsp.but i am getting the error as
^
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>
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>
•
•
Join Date: Feb 2006
Posts: 1,356
Reputation:
Rep Power: 8
Solved Threads: 113
executeUpdate returns an int indicating the number of rows affected
by the query. It does not return a ResultSet.
by the query. It does not return a ResultSet.
Java Programmer and Sun Systems Administrator
----------------------------------------------
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
----------------------------------------------
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
•
•
Join Date: Sep 2005
Posts: 139
Reputation:
Rep Power: 3
Solved Threads: 0
Junior Poster
•
•
•
•
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
•
•
Join Date: Feb 2006
Posts: 1,356
Reputation:
Rep Power: 8
Solved Threads: 113
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.
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.
Java Programmer and Sun Systems Administrator
----------------------------------------------
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
----------------------------------------------
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
•
•
Join Date: Oct 2006
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by aarya 
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.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb JSP Marketplace
Linear Mode
- How insert image into mysql database and retrieve (PHP)
- Why does it insert NULL values into MySQL DB??? (ASP.NET)
- how deposit a picture to MYSQL database (PHP)
- dynamically generated textboxes & radio buttons php, insert into db (PHP)
Other Threads in the JSP Forum
- Previous Thread: Problem with update data to database
- Next Thread: Find JSP Model II tutorials
