jdbc主键回填

jdbc主键回填

public static int commonInsert(String sql, Object... args) {

        Connection connection = DBUtils.getConnection();

        PreparedStatement prst = null;
        try {
            prst = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
            if (args != null && args.length > 0) {
                for (int i = 0; i < args.length; i++) {
                    prst.setObject(i + 1, args[i]);
                }
            }
            prst.executeUpdate();
            ResultSet generatedKeys = prst.getGeneratedKeys();
            if (generatedKeys.next()){
                return generatedKeys.getInt(1);//获取主键
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtils.close(connection, prst);
        }
        return 0;
    }