ResultSet issue with adding record

[Joseph Smithern]

I am trying to compile the below JDBC class file but it gives me error message about the ResultSet class:

UserDatabase.java:25: incompatible types
found   : java.sql.ResultSet
required: int
        int status = stmt.executeQuery(query);
                                      ^
1 error

Here is my java file that has a method (addRecord) that will be called by a Servlet:

import java.io.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
 
public class UserDatabase
{
    
 
 public static int addRecord(String lastname, String firstname) throws SQLException
{  
    try
{
       Class.forName("org.gjt.mm.mysql.Driver");
        String dbURL = "jdbc:mysql://localhost/dbconn";
        String username = "root";
        String password = "sandiego";
        Connection connection = DriverManager.getConnection(dbURL, username, password);
    String query = "Insert into User (lastname,firstname) " +
"values ('" + lastname + "', " + 
"'" + firstname + "')";
Statement stmt = connection.createStatement();
        int status = stmt.executeQuery(query);
    stmt.close();
return status;
}
        catch(SQLException e)
{
            System.out.println("Cant open DB");
}
     }
}

[ September 24, 2006: Message edited by: Joseph Smithern ]

[Ian Singe]

I think what you want to use is executeUpdate - which is used for INSERTS, etc, and returns a int showing the row count

See here
[ September 24, 2006: Message edited by: Ian Singe ]

[Ian Singe]

Also, it's better practise to use prepared statement, rather than just statement, as it's 'safer' (not to mention easier) - you use it like so :

    
PreparedStatement pstmt = con.prepareStatement("UPDATE EMPLOYEES
                                     SET SALARY = ? WHERE ID = ?");
   pstmt.setBigDecimal(1, 153833.00)
   pstmt.setInt(2, 110592)

[Joseph Smithern]

Thanks,

I appreciate your answer and now I learned that executeUpdate method always returns an int data type.

[Rajesh Agarwal]

Also remember the following

boolean execute(String)
int executeUpdate(String)
ResultSet executeQuery(String)