Simple JDBC Demo: Using the Command-Line

This is a simple JDBC example that shows you how to run a program from command-line. A Java IDE is not required.

In general, when you are using JDBC from command-line, you have to make sure you have the JDBC driver in your classpath. For example, if i downloaded the MySQL JDBC driver to c:\foobar\mysql-connector-java-5.1.29-bin.jar.  Then you can set the classpath with the following command in the MS-DOS window

set classpath=.;c:\foobar\mysql-connector-java-5.1.29-bin.jar

Then from there you can compile and run your program.

Below, I provide step-by-step instructions on how to run a simple JDBC demo from command-line.

 

Step 0. Download the files and extract to a directory on your computer

– Download simple-jdbc,zip

Step 1.  Create table and load sample data

The first thing you have to do is create the database table and load sample data.

Using your MySQL tool, execute the SQL file: data.sql

This script does the following
– Creates a database schema: demo
– Creates a table: employees
– Inserts three rows of sample data

Step 2: Review Driver.java and the database connection information

– The program attempts to connect to the demo database running on localhost
— jdbc:mysql://localhost:3306/demo
You may need to adjust this for your local environment

– The program make use of databse user id “student” and password “student”
You may need to adjust this for your local environment

Step 3.  Compile the program

In a command-line window, type:

cd <your-download-directory>/simple-jdbc
javac Driver.java

Step 4.  Run the program

Type: run.bat
— (If you are using Linux: run.sh is available)

The batch file will set the classpath for the MySQL driver and then execute the program.

Step 5:  Confirm the results

The program will display the following output

Doe, John
Public, Mary
Queue, Susan

Did you like my blog post?

Signup now and receive an email when I publish new luv2code content.

I agree to have my personal information transfered to AWeber ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Leave a Reply