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"} )

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值