Java:检查oracle字段类型NUMBER(6,4)的值是否等于0

import java.sql.*;

public class OracleNumberCheck {
    public static void main(String[] args) {
        // 数据库连接信息
        String url = "jdbc:oracle:thin:@localhost:1521:xe";
        String username = "your_username";
        String password = "your_password";

        // SQL查询语句
        String sql = "SELECT your_column FROM your_table WHERE your_column = 0";

        try {
            // 连接到Oracle数据库
            Connection connection = DriverManager.getConnection(url, username, password);

            // 执行查询
            Statement statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery(sql);

            // 处理查询结果
            if (resultSet.next()) {
                // 获取字段值
                double value = resultSet.getDouble("your_column");

                // 判断字段值是否等于0
                if (value == 0) {
                    System.out.println("字段值等于0");
                } else {
                    System.out.println("字段值不等于0");
                }
            } else {
                System.out.println("未找到符合条件的数据");
            }

            // 关闭连接
            resultSet.close();
            statement.close();
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}