DMottab.blogspot.com

IMPLEMENTACION BASICA DE STORE PROCEDURE CON Spring JDBC CONFIGURACION DE DATASOURCE: OBTENER EL DATASOURCE DE WEBSHERE jdbc.datasource. WebSphereDataSourceAdapter"> jndi.JndiObjectFactoryBean"> EN LA CLASE : LA INJECTION DEL DATASOURCE private DataSource dataSource; private JdbcTemplate jdbcTemplate; public void setDataSource(DataSource dataSource) { this.dataSource = dataSource; this.jdbcTemplate = new JdbcTemplate(this.dataSource); } METODO GENERICO QUE EJECUTA STORE DE UPDATE,INSERT private void registroArchivo(final List parameters,final String SP){ jdbcTemplate.execute( new CallableStatementCreator(){ public CallableStatement createCallableStatement( Connection con)throws SQLException { CallableStatement cs = con.prepareCall("{call "+SP+"}"); for (int i = 0; i if(parameters.get(i) instanceof Integer){ cs.setInt((i+1), Integer.parseInt(parameters. get(i).toString())); }else if(paramete...