how to get ms access 2007 auto increment id in java

[muthulk2]

i'm using the access db for this example.i want to get the last record auto increment id

package com.java2novice.jdbc;
*
import java.sql.*;
 
*
public class MyAutoGeneratedKeys {
*
public static void main(String a[]){
********
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:student");
String query = "insert into Student(fname,lname,gender) values (?,?,?)";
*********
pstmt = con.prepareStatement(query,Statement.RETURN_GENERATED_KEYS);
pstmt.setString(1, "John");
pstmt.setString(2, "methev");
pstmt.setInt(3,"Male");
***********
pstmt.executeUpdate();
************
rs = pstmt.getGeneratedKeys();
************
while(rs.next()){
System.out.println("Generated Emp Id: "+rs.getObject(1).toString());
}
*
}  catch (SQLException e) {
**********
} finally{****}
****
*
}
}

[chaarmann]

You can't get the next free autoincrement number (aliaas ID), it's a database issue and has to do with concurrency of requests.
Method 1: let's say you would get the next free number somehow (for example by asking for the current maximum of the id-column, then you add 1 to it) and use this for the new record you want to insert. In the meantime another process could have done the same and already inserted the new entry. Then when you try to insert your entry, you get back an error: ID already used!

So the only way I know is, to insert a record first and then ask the JDBC-interface for the inserted ID. For example for MySQL:

Statement statement = connection.createStatement(Statement.CLOSE_ALL_RESULTS, Statement.RETURN_GENERATED_KEYS);
statement.execute("insert into table ...");
ResultSet generatedKeys = statement.getGeneratedKeys();
generatedKeys.next();
int autoIncrementedId =generatedKeys.getInt(1);

You could insert an entry with default values first and later use "update" with its ID to update it.