package test5;
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class test2{
public File parentFile;
public test2(File parentFile) {
this.parentFile = parentFile;
readDataBase(parentFile.list());
}
private void readDataBase(String[] list){//这个函数里读数据库的方式可能跟你的不一样,自己看着改改
for(String oldName:list) {
Connection conn =null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/111yao?useUnicode=true&characterEncoding=UTF-8","root","caojian");//DSN是数据源名字
Statement st = conn.createStatement();
ResultSet rs=st.executeQuery("select * from dst_product where image='"+oldName+"'");
System.out.println(conn+"------");
while (rs.next())
{
String newName = rs.getString("image");
rename(oldName,"$$$"+newName);
}
}
catch (Exception e) {
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
private void rename(String oldName, String newName) {
try {
File source = new File(parentFile.toString()+"\\"+oldName);
File target = new File(source.getParent()+"\\"+newName);
boolean res = source.renameTo(target);
Thread.currentThread().sleep(200);
System.out.println(source.toString());
System.out.println(target.toString());
System.out.println(res);
}
catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String [] args) {
String path = "F:\\图片\\javaIOTest";//这里把path改成文件夹的路径
File file = new File(path);
new test2(file);
}
}
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class test2{
public File parentFile;
public test2(File parentFile) {
this.parentFile = parentFile;
readDataBase(parentFile.list());
}
private void readDataBase(String[] list){//这个函数里读数据库的方式可能跟你的不一样,自己看着改改
for(String oldName:list) {
Connection conn =null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/111yao?useUnicode=true&characterEncoding=UTF-8","root","caojian");//DSN是数据源名字
Statement st = conn.createStatement();
ResultSet rs=st.executeQuery("select * from dst_product where image='"+oldName+"'");
System.out.println(conn+"------");
while (rs.next())
{
String newName = rs.getString("image");
rename(oldName,"$$$"+newName);
}
}
catch (Exception e) {
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
private void rename(String oldName, String newName) {
try {
File source = new File(parentFile.toString()+"\\"+oldName);
File target = new File(source.getParent()+"\\"+newName);
boolean res = source.renameTo(target);
Thread.currentThread().sleep(200);
System.out.println(source.toString());
System.out.println(target.toString());
System.out.println(res);
}
catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String [] args) {
String path = "F:\\图片\\javaIOTest";//这里把path改成文件夹的路径
File file = new File(path);
new test2(file);
}
}