操纵大量的1000多张图像

SETLOCAL

SET "oldroot=X:originalpath"
SET "newroot=Y:newrootfolder"
SET "sqlscript=Z:pathtoscript.sql"

FOR %%F IN (%oldroot%*.jpg) DO CALL :process "%%F"

ENDLOCAL
GOTO :EOF

:process
SET filename=%~nx1
SET userid=%filename:~0,5%

IF NOT EXIST "%newroot%%userid%" MKDIR "%newroot%%userid%"
COPY %1 "%newroot%%userid%"

>>%sqlscript% ECHO update users set user_img = '%userid%%filename%' where user_id = %userid%

require 'fileutils'
root="C:\root"
o = File.open("sql.txt","w")
Dir["*.jpg"].each do| jpg|
    dirname = jpg.scan(/^(d+)/)[0].first # get the nbumber
    Dir.mkdir(dirname) if not Dir.exists?(dirname) #make directory
    FileUtils.copy( jpg , root + "\"+dirname) #copy / move
    o.write( "update users set user_img = #{dirname}/#{jpg} where user_id = #{dirname}n" ); #create sql
end
o.close

root