Java SQL ResultSet BigDecimal Read getBigDecimal(ResultSet res, String name)

Description

Returns the values of the specified column as a BigDecimal.

License

MIT License

Parameter

Parameter	Description
res	a result set.
name	a name of the column.

Exception

Parameter	Description
SQLException	if an error occurs.

Return

the value of the column.

Declaration

public static BigDecimal getBigDecimal(ResultSet res, String name) throws SQLException 

Method Source Code

//package com.java2s;
/*/*from  ww w . jav  a2 s.co  m*/
 * Copyright (c) 2015-2016 QuartzDesk.com.
 * Licensed under the MIT license (https://opensource.org/licenses/MIT).
 */

import java.math.BigDecimal;

import java.sql.ResultSet;
import java.sql.SQLException;

public class Main {
    /**
     * Returns the values of the specified column as a BigDecimal. If the column
     * value is null, this method returns null.
     *
     * @param res  a result set.
     * @param name a name of the column.
     * @return the value of the column.
     * @throws SQLException if an error occurs.
     */
    public static BigDecimal getBigDecimal(ResultSet res, String name) throws SQLException {
        BigDecimal v = res.getBigDecimal(name);
        return res.wasNull() ? null : v;
    }
}

Related

1. getBigDecimal(ResultSet rs, String columnLabel)
2. getBigDecimalArray(final ResultSet resultSet, final int index)
3. getBigDecimalNotZero(ResultSet rs, String columnLabel)