I need to export an NVARCHAR from JAVA in excel

1

I am using the sql server database in which I am using a cursor.

I need to read this NVARCHAR from java so I can export it in excel from java.

Take into consideration: that these columns of my Excel will be added more in the future.

export format:

script table:

CREATE TABLE TB_INGRESO(
    PERIODO varchar(20) NOT NULL,
    UE varchar(20) NOT NULL,
    SEDE varchar(20) NOT NULL,
    AREA varchar(20) NOT NULL,
    PRODUCTO varchar(50) NOT NULL,
    FECHA date NOT NULL,
    PRECIO decimal(19, 6) NULL,
    CANTIDAD decimal(19, 6) NULL
    )
    GO

    ALTER TABLE TB_INGRESO
    ADD CONSTRAINT PK_TB_MSTINGRESOS PRIMARY KEY(PERIODO,UE,SEDE,AREA,PRODUCTO,FECHA)

    GO

Stored Procedure:

java method:

Result of my view (the values of month and year I am putting them hard in my bean)

I would be recommended another way to get this report in excel

    
asked by Raúl Eduardo Chávez Espinoza 09.03.2018 в 20:43
source

0 answers