ai está
import java.sql.;
import java.io.;
public class Fundos {
ResultSet rs;
Conexao conex = new Conexao();
public boolean alteraRendimentos(String xdata1, String xdata2, String xdata3, String xdata4, String xcota1, String xcota2, String xcota3, String xcota4, String xpatrimonio1, String xpatrimonio2, String xpatrimonio3, String xpatrimonio4, String xdia1, String xdia2, String xdia3, String xdia4, String xmes1, String xmes2, String xmes3, String xmes4, String xano1, String xano2, String xano3, String xano4, String x121, String x122, String x123, String x124, String x241, String x242, String x243, String x244, String xibova, String xibovm, String xcdia, String xcdim, String xusa, String xusm) throws ClassNotFoundException, SQLException{
return conex.executaUpdate(“update fundos_rendimentos set data1 = to_date(’” + xdata1 + “’, ‘DD/MM/YY’), data2 = to_date(’” + xdata2 + “’, ‘DD/MM/YY’), data3 = to_date(’” + xdata3 + “’, ‘DD/MM/YY’), data4 = to_date(’” + xdata4 + “’, ‘DD/MM/YY’), cota1=’” + xcota1 + “’, cota2=’” + xcota2 + “’, cota3=’” + xcota3 + “’, cota4=’” + xcota4 + “’, patrimonio1 =’” + xpatrimonio1 + “’, patrimonio2=’” + xpatrimonio2 + “’, patrimonio3=’” + xpatrimonio3 + “’, patrimonio4=’” + xpatrimonio4 + “’, dia1=’” + xdia1 + “’, dia2=’” + xdia2 + “’, dia3=’” + xdia3 + “’, dia4=’” + xdia4 + “’, mes1=’” + xmes1 + “’, mes2=’” + xmes2 + “’, mes3=’” + xmes3 + “’, mes4=’” + xmes4 + “’, ano1=’” + xano1 + “’, ano2=’” + xano2 + “’, ano3=’” + xano3 + “’, ano4=’” + xano4 + “’, meses121=’” + x121 + “’, meses122=’” + x122 + “’, meses123=’” + x123 + “’, meses124=’” + x124 + “’, meses241=’” + x241 + “’, meses242=’” + x242 + “’, meses243=’” + x243 + “’, meses244=’” + x244 + “’, ibovm=’” + xibovm + “’, ibova=’” + xibova + “’, cdim=’” + xcdim + “’, cdia=’” + xcdia + “’, usm=’” + xusm + “’, usa=’” + xusa + “’”);
}
public ResultSet buscaRendimentos() throws ClassNotFoundException, SQLException{
return conex.executaSQL("select to_char(data1, 'DD/MM/YY') as data1, to_char(data2, 'DD/MM/YY') as data2, to_char(data3, 'DD/MM/YY') as data3, to_char(data4, 'DD/MM/YY') as data4, * from fundos_rendimentos");
}
o código está exataqmente assim