String sql1="create table zhjun.pet2(name char(20),age int(10))";
String command="C:/Program Files/MySQL/MySQL Server 5.0/bin/mysql.exe -uroot -pasdf1987 "+sql1;
try {
Process process=rt.exec(command);
} catch (IOException e) {
/ TODO Auto-generated catch block
e.printStackTrace();
}
String command="C:/Program Files/MySQL/MySQL Server 5.0/bin/mysql.exe -uroot -pasdf1987 "+sql1;
try {
Process process=rt.exec(command);
} catch (IOException e) {
/ TODO Auto-generated catch block
e.printStackTrace();
}
String command="\"C:/Program Files/MySQL/MySQL Server 5.0/bin/mysql.exe\" -uroot -pasdf1987 "+sql1; 似乎记得原来碰到过一个问题,就是用java执行外部指令的时候,如果指令路径中有空格,会被解释成两个指令:C:/Program Files/MySQL/MySQL实际上被认为是执行C:/Program指令,参数为:Files/MySQL/MySQL所以要加引号