通过JDBC向数据库插入数据后如何获取自增字段值

啥话不说，直接上代码。。。。

	public void insert(Order o) {
        try {
            Class.forName("com.mysql.jdbc.Driver");
 
            Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/cart?characterEncoding=UTF-8","root", "admin");
 
            String sql = "insert into order_ values(null,?)";
 
            PreparedStatement ps = ps = c.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
 
            ps.setInt(1, o.getUser().getId());
 
            ps.execute();
            
            ResultSet rs = ps.getGeneratedKeys();
            if (rs.next()) {
                int id = rs.getInt(1);
                o.setId(id);
            }
 
            ps.close();
 
            c.close();
 
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
 
    }