jdbc連接mysql數據庫執行insert語句后獲取自增長的主鍵值

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import cn.baokx.db.DatabaseConnection0;
public class Test1 {

    public static void main(String[] args) {

        Connection conn = new DatabaseConnection0().getConnection();

        PreparedStatement pst = null;

        ResultSet rs = null;

        String sql = "INSERT INTO dz(date,time,s,w,deep,level,location)" +

                "VALUES('2014-01-01','05:03:44',25.6,122.4,260,6.2,'俄羅斯')";

        try {

            pst = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);

            pst.executeUpdate();

            rs = pst.getGeneratedKeys();

            if(rs.next()){

                System.out.println(rs.getObject(1));

            }

        } catch (SQLException e) {

            e.printStackTrace();

        } finally{

            try {

                rs.close();

                pst.close();

                conn.close();

            } catch (SQLException e) {

                // TODO Auto-generated catch block

                e.printStackTrace();

            }

        }

    }

}  </pre>