executeUpdate("")) ???

[darine darine]

All
I'm trying to insert data to an empty table and so when i execute just one statement(st.executeUpdate("")) i do not get anything entered,so i had to use a second statement with the first one in order to get the data from the first statement entered to the first row.
please let me know what is the ideal solutions.
here is the code.
thanks.
===================

import java.sql.*;
import java.net.*;
import java.util.*;
import java.io.*;
public class DBase
{
public static void main(String r[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:csc193","","");
Statement st=con.createStatement();

st.executeUpdate("INSERT INTO personel_table " +
    "VALUES ('Carol', 'Satr', 1234,'canada')");
//st.executeUpdate("INSERT INTO personel_table " +
//    "VALUES ('Tom', 'Tom', 1234,'canada')");
st.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
e.printStackTrace();
}

}
}

[ Edited by Dave to format code and fix ]
[ March 12, 2002: Message edited by: David O'Meara ]

[David O'Meara]

I'm sorry but I couldn't understand the problem you were having.
If the problem is that you are trying to insert some data and it is not getting written to the DB, try this thread
Dave