java获取mysql数据库中的自增id_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 */

}

}

}

}

}