insert values to mysql database

•

What is DaniWeb IT Discussion Community?

You're currently browsing the JSP section within the Web Development category of DaniWeb, a massive community of 391,616 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,679 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.

Join our community!

Please support our JSP advertiser: Lunarpages JSP Web Hosting

Thread Tools Display Modes

Views: 13077 | Replies: 4

Previous Post in Thread

Next Post in Thread

•

Join Date: Sep 2005

Posts: 139

Reputation: aarya is an unknown quantity at this point

Rep Power: 3

Solved Threads: 0

aarya

Offline

Junior Poster

insert values to mysql database

May 31st, 2006

hi

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

Help with Code Tags

(Toggle Plain Text)

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>