java如何通过jdbc得到数据库的自增主键id号？

用mysql试验了下是可以得到id号的，代码片段如下：

package com.mysql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class 插入数据并得到ID {

	public static void main(String[] args) {
		Connection conn = null;
		try {
			String userName = "root";
			String password = "111111";
			String jdbcurl = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8";
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			conn = DriverManager.getConnection(jdbcurl, userName, password);
			String sql = "insert into test(time) values("
					+ System.currentTimeMillis() + ")";
			Statement pstmt = conn.createStatement();
			int count = pstmt.executeUpdate(sql,
					Statement.RETURN_GENERATED_KEYS);
			if (count > 0) {
				ResultSet resultSet = pstmt.getGeneratedKeys();
				if (resultSet.next()) {
					int id = resultSet.getInt(1);
					System.out.println(id);
				}
			}

			pstmt.close();
		} catch (Exception e) {
			System.err.println("Cannot connect to database server,Exception:"
					+ e.getMessage());
		} finally {
			if (conn != null) {
				try {
					conn.close();
					conn = null;
				} catch (Exception e) { /* ignore close errors */
				}
			}
		}
	}

}

感谢 牛老大 分享指点

顶一下