java执行mysql,从Java运行mysql命令

hi I have a JAVA project in which I want to display the MySQL databases.

i write this code:

try {

String []command={"mysql -u root -pmanager","show databases"};

Process p= Runtime.getRuntime().exec("mysql -u root -pmanager");

Process p1= Runtime.getRuntime().exec("show databases");

if (p.waitFor()==0){System.out.println("backup done...");}

else{System.out.println("!!!");}

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (InterruptedException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

but it give me this error:

Cannot run program "show": CreateProcess error=2, The system cannot find the file specified

what it should be do?

thanks...

解决方案

Better to pass String object in exec method like:

Runtime.getRuntime().exec( new String [] {"mysql", "-u", "root", "-pmanager", "-e", "show databases"} )