JDBC Example
This document describes the mechanics of writing a Java program
(typically running on your computer) that interacts with a MySql
database hosted on satoshi.cis.uncw.edu.
- If Java JDK is not installed on your machine, do that first.
- Download the following files to the same folder:
- JDBC Example file - Java source file
- JDBC MySql jar file
- Open
a terminal, navigate to the folder where you stored the files above,
and at the command line, compile the Java source file using the
command: javac JDBC_Example.java
- If you get an error message that javac cannot be found, make sure that the folder containing the javac application (on my laptop this is C:\Program Files\Java\jdk-10.0.1\bin) is included in your PATH.
- Note: To develop using Eclipse or another Java IDE, the JDBC-MySql jar file must be added to the build path for your IDE. Also, the JDBC Example code given here uses a Console class that
may not work properly with Eclipse. In that case, you will need to
replace the use of Console with some other input mechanism.
- If you are not on campus, you must be VPN'ed in to do the next steps. Run the Java program as described below:
- Windows: java -cp .;mysql-connector-java-8.0.21.jar JDBC_Example
- Mac: java -cp .:mysql-connector-java-8.0.21.jar JDBC_Example
- When prompted, enter your MySql user name as both the user name and the database name.
When prompted for your password enter the MySql
password you received in the email earlier this semester. Note: If you have
changed your MySql password since then, it is not your new
password. It is the password you originally received in your email.