bigint java 对应数据类型_学习Java的第015天

Java中的bigint对应的数据类型是BigInteger。它是一个不可变的任意精度整数，可以处理比long类型更大的整数。BigInteger可以进行加、减、乘、除和取模等基本数学运算，同时也支持位运算和比较运算。可以使用BigInteger的构造函数将字符串或整数转换为BigInteger类型，也可以使用toString()方法将BigInteger类型转换为字符串类型。需要注意的是，由于BigInteger是不可变类型，每个操作都会返回一个新的BigInteger对象。

相关问题

create table web_sales ( ws_sold_time_sk bigint, ws_ship_date_sk bigint, ws_item_sk bigint, ws_bill_customer_sk bigint, ws_bill_cdemo_sk bigint, ws_bill_hdemo_sk bigint, ws_bill_addr_sk bigint, ws_ship_customer_sk bigint, ws_ship_cdemo_sk bigint, ws_ship_hdemo_sk bigint, ws_ship_addr_sk bigint, ws_web_page_sk bigint, ws_web_site_sk bigint, ws_ship_mode_sk bigint, ws_warehouse_sk bigint, ws_promo_sk bigint, ws_order_number bigint, ws_quantity int, ws_wholesale_cost decimal(7,2), ws_list_price decimal(7,2), ws_sales_price decimal(7,2), ws_ext_discount_amt decimal(7,2), ws_ext_sales_price decimal(7,2), ws_ext_wholesale_cost decimal(7,2), ws_ext_list_price decimal(7,2), ws_ext_tax decimal(7,2), ws_coupon_amt decimal(7,2), ws_ext_ship_cost decimal(7,2), ws_net_paid decimal(7,2), ws_net_paid_inc_tax decimal(7,2), ws_net_paid_inc_ship decimal(7,2), ws_net_paid_inc_ship_tax decimal(7,2), ws_net_profit decimal(7,2), ws_sold_date_sk bigint ) using ${FILE} partitioned by (ws_sold_date_sk)]

这段代码的问题在于最后一个字符是一个多余的"]"，应该将其删除。正确的代码如下：

create table web_sales (
    ws_sold_time_sk           bigint, 
    ws_ship_date_sk           bigint, 
    ws_item_sk                bigint, 
    ws_bill_customer_sk       bigint, 
    ws_bill_cdemo_sk          bigint, 
    ws_bill_hdemo_sk          bigint, 
    ws_bill_addr_sk           bigint, 
    ws_ship_customer_sk       bigint, 
    ws_ship_cdemo_sk          bigint, 
    ws_ship_hdemo_sk          bigint, 
    ws_ship_addr_sk           bigint, 
    ws_web_page_sk            bigint, 
    ws_web_site_sk            bigint, 
    ws_ship_mode_sk           bigint, 
    ws_warehouse_sk           bigint, 
    ws_promo_sk               bigint, 
    ws_order_number           bigint, 
    ws_quantity               int, 
    ws_wholesale_cost         decimal(7,2), 
    ws_list_price             decimal(7,2), 
    ws_sales_price            decimal(7,2), 
    ws_ext_discount_amt       decimal(7,2), 
    ws_ext_sales_price        decimal(7,2), 
    ws_ext_wholesale_cost     decimal(7,2), 
    ws_ext_list_price         decimal(7,2), 
    ws_ext_tax                decimal(7,2), 
    ws_coupon_amt             decimal(7,2), 
    ws_ext_ship_cost          decimal(7,2), 
    ws_net_paid               decimal(7,2), 
    ws_net_paid_inc_tax       decimal(7,2), 
    ws_net_paid_inc_ship      decimal(7,2), 
    ws_net_paid_inc_ship_tax  decimal(7,2), 
    ws_net_profit             decimal(7,2), 
    ws_sold_date_sk           bigint
) using ${FILE} partitioned by (ws_sold_date_sk)

bigint对应java

在Java中，bigint对应的是BigInteger类。BigInteger类是Java提供的用于处理任意长度整数的类。它可以进行大整数的加、减、乘、除等常见运算，并且支持比较、取余、取模、幂等操作。你可以使用BigInteger类表示任意范围的整数，而不会受到原始数据类型的限制。以下是一个示例代码：

import java.math.BigInteger;

public class BigIntExample {
    public static void main(String[] args) {
        BigInteger num1 = new BigInteger("12345678901234567890");
        BigInteger num2 = new BigInteger("98765432109876543210");

        BigInteger sum = num1.add(num2);
        BigInteger difference = num1.subtract(num2);
        BigInteger product = num1.multiply(num2);
        BigInteger quotient = num1.divide(num2);

        System.out.println("Sum: " + sum);
        System.out.println("Difference: " + difference);
        System.out.println("Product: " + product);
        System.out.println("Quotient: " + quotient);
    }
}

在上面的示例中，我们使用BigInteger类创建了两个大整数num1和num2，并进行了加、减、乘、除等运算。最后，我们将结果打印输出。请注意，在使用BigInteger进行运算时，需要使用BigInteger类提供的方法，而不能直接使用运算符。