Niall,

Simple Answer, your program is not correct!

Dieter

I hope this will get you going ... you've got a way to go...

First, you can execute a statement like this:

  stmt.executeUpdate("INSERT INTO Login VALUES ( 'foo', 'bar' )");

These are static statements, in that the values are hard coded at
the time the Java source was compiled.

If you need to provide Dynamic values (that is, value that are not
known until the program is run) then you need to use Dynamic
statements.

The statement will now look like this:

  "INSERT INTO Login VALUES (?, ?)"

and you will need to use a Prepared Statement, rather than a statement:

  PreparedStatement pstmt = con.prepareStatement("INSERT INTO Login VALUES ( ?, ? )");

then bind the variable values using the pstmt.setXXX methods, like
this:

  pstmt.setString(1, stringVariableName);
  pstmt.setString(2, secondStringVariableName);

etc. There are different pstmt.setXXX methods for each data type. The
first parameter is the index of the place holder (?) in the statement
text, indexed from 1.

See the Javadoc for java.sql.PreparedStatement, which shows all of this.

This is what I have going now, its just geting stuck on the executeUpdate
and not updateing atall, would it be due to not having access on this pc,
I didn't think that would be issue since Im able to read and print to
screen the contence of the DB.

PreparedStatement pstmt = con.prepareStatement("INSERT    INTO Login
VALUES ( ?, ? )");   
   
pstmt.setString(1, Server_GUI.log);
pstmt.setString(2, Server_GUI.pass);
   
pstmt.executeUpdate("INSERT INTO Login VALUES ( '?', '?' )");

Thanks Again.