How to open a command prompt and input different commands from a java program

Question

I need to open a command prompt & execute ij.bat, which will take me to another prompt, where I can give command to connect to DB & later different sql statements. I was able to execute ij.bat from the java program like

Process process = Runtime.getRuntime().exec("D:\\ij.bat");

But how to give the furthur set of commands through the java program?

I think you may try `Robot` to do this. To give command on opened command prompt. — Pasupathi Rajamanickam, May 12 '15 at 07:20

score 0 · Answer 1 · edited May 23 '17 at 12:14

0

You can use this exec public Process exec(String command) throws IOException

Also visit This Link

edited May 23 '17 at 12:14

Community

1
1

answered May 12 '15 at 06:58

Pawan

167
12

My Scenario is `cmd> ij.bat` `ij> connect '..\db\mall';` `ij> select * from users;` – user1407668 May 12 '15 at 07:00
Please visit the link in my answer – Pawan May 12 '15 at 07:01
I cheked that. It has the details on how to read the output one command executed – user1407668 May 12 '15 at 07:05

score 0 · Answer 2 · answered May 12 '15 at 17:10

Instead of trying to run ij.bat, and feed it commands to run and parse the output, just have your program use the ij class, and its runScript method: http://db.apache.org/derby/docs/10.11/publishedapi/org/apache/derby/tools/ij.html#runScript-java.sql.Connection-java.io.InputStream-java.lang.String-java.io.OutputStream-java.lang.String-

Then you don't have to spawn a separate process, but can just keep everything in pure Java in your program itself.

How to open a command prompt and input different commands from a java program

2 Answers2

Linked