Difference between execute() and executeQuery()

[Timothy Sam]

First of all, I'd like to say many thanks to my fellow ranchers! You've all been so nice to me and have been so generous in helping the likes of me. So what's the difference between the execute() and executeQuery() methods? I tried using executeQuery() to create a database and I get an SQLException error (No result set was produced). Here's my code... Could you also help me pinpoint the problem? Thanks!

import java.io.*;
import java.sql.*;
 
public class FAnglesDBTest
{
 
    public static void main(String args[])
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String dsn = "FAnglesDB";
            String url = "jdbc :-o	 dbc:" + dsn;
            Connection con = DriverManager.getConnection(url, "", "");
            con.setAutoCommit(false);
 
            System.out.println("Database connection succeeded");
 
            Statement statement;
            String query;
            ResultSet rs;
 
            query = "CREATE TABLE employee_tbl(emp_num integer)"; 
 
            statement = con.createStatement();
            rs = statement.executeQuery(query);
            
            System.out.println("Execute query succeeded");
 
            statement.close();
            rs.close();
            con.close();
 
        }
        catch(Exception err)
        {
            System.out.println("Error: " + err);
        }
    }
 
}

[Bear Bibeault]

executeQuery(), as its name might suggest, is only used for executing queries. That is, SQL SELECT statements.

What sort of result set would expect from a create table statement?
[ October 16, 2005: Message edited by: Bear Bibeault ]

[Jeanne Boyarsky]

Note that there is an executeUpdate() method to call for creates. It doesn't return a resultset because it doesn't apply for any update call.