search

NRankedDev / JavaMyAdmin

Java SQL Tool
2 stars 0 forks source link

renameDatabase #54

Closed Normynator closed 9 years ago

Normynator commented 9 years ago

public void renameDatabase(String newName) throws SQLException { connect.createStatement().executeUpdate("CREATE DATABASE " + newName); for(Table lst : getTable()){ System.out.println(lst.getName()); connect.createStatement().executeUpdate("RENAME TABLE " + dbname + "." + lst.getName()+ " TO " + newName + "." + lst.getName()); } connect.createStatement().executeUpdate("DROP DATABASE " + dbname); dbname = newName; }

Normynator commented 9 years ago

Wird ein Reload benötigt, da die neue Datenbank nicht angezeigt wird.