public void update(String[] columns,Object[] columnValues,String[] conditions,Object[] conditionValues) throws DataAccessException {
  if (columns.length != columnValues.length || conditions.length != conditionValues.length) {
    logger.error("DatabaseWriter update columns and values mismatch");
    return;
  }
  Object[] values=Arrays.copyOf(columnValues,columnValues.length + conditionValues.length);
  System.arraycopy(conditionValues,0,values,columnValues.length,conditionValues.length);
  final String sql=PreparedStatementUtil.prepareUpdateTemplateWithColumn(tableName,columns,conditions);
  execute(sql,values);
}

public void update ( String [ ] columns , Object [ ] columnValues , String [ ] conditions , Object [ ] conditionValues ) throws DataAccessException { if ( columns . length != columnValues . length || conditions . length != conditionValues . length ) { logger . error ( "DatabaseWriter update columns and values mismatch" ) ; return ; } Object [ ] values = Arrays . copyOf ( columnValues , columnValues . length + conditionValues . length ) ; System . arraycopy ( conditionValues , 0 , values , columnValues . length , conditionValues . length ) ; final String sql = PreparedStatementUtil . prepareUpdateTemplateWithColumn ( tableName , columns , conditions ) ; execute ( sql , values ) ; }
use jdbc template preparedstatement to update row in database by setting columns with conditions
