Hi I want to build a command line utility tool in Java for DB Transactions on Linux. My requirement is when we run the java program it should show command prompt. From there User can enter any sql statement and get the restuls. Java Program should log all these transactions. Please let me know by using Java can we connect to DB and provide DB prompt for DB transactions? Replies are highly appreciated. Thanks in Advance:crazy:
yes, there are 2 ways proper way been to use the necessary API of the db or the classes that come with java to run and access the DB [like mysql and oracle] other way it to directly run the necessary console (for ex if mysql is installed in the server you can run the commanline of mysql and run any command through it) this way is easier because you can directly output the output given by the commandline itself