Populating a SQL Database in preparation for Java (Apache Derby) смотреть онлайн

Java Playlist: https://www.youtube.com/watch?v=-rSf4t9TsNE&list=PLg3AZRFBfHLW3fiJpYFR61j1ElcybfjE_&ab_channel=NealHoltschulte

Next video in this sequence: https://youtu.be/kvsrn3NHfO4

Previous video in this sequence: https://youtu.be/b4Zo5XWR6zE

In this video I will show how to populate a SQL database using Derby and then I will give a walkthrough of some basic SQL commands.

It is assumed that you have ALREADY installed Derby. If not, see my previous video, linked here: https://youtu.be/b4Zo5XWR6zE

STEPS:
Open a new command prompt.

Check that your System Variables are set by typing in echo then the name of the variable you want to check bracketed by percentage signs. This is what I typed in and saw when my path variables were correctly set up:

echo %JAVA_HOME%
C:\Program Files\Java\jdk-20

echo %DERBY_HOME%
C:\Program Files\Java\jdk-20\db

echo %CLASSPATH%
C:\PROGRA~1\Java\jdk-20\db\lib\derbyshared.jar;C:\PROGRA~1\Java\jdk-20\db\lib\derby.jar;C:\PROGRA~1\Java\jdk-20\db\lib\derbytools.jar;C:\PROGRA~1\Java\jdk-20\db/lib/derbyoptionaltools.jar;


If any of your System Variables are not correctly set up then you may need to either set them in Environment Variables and/or run setEmbeddedCP.bat which is found inside your Derby bin folder. Mine is located here: "C:\Program Files\Java\jdk-20\db\bin\setEmbeddedCP.bat"


Note that I will be using examples based on this textbook:
Java How to Program, Late Objects Version, Eleventh Edition, Paul Deitel & Harvey Deitel, Pearson, 2018, ISBN-13: 978-0-13-479140-1, ISBN-10: 0-13-479140-1
https://www.amazon.com/Java-Program-Late-Objects-11th/dp/0134791401

In this video in particular I will be using books.sql. This SQL file and other Java files I'm using can be download here:
https://drive.google.com/drive/folders/1rhEigUOYejmqwdwb684DwoPScEvtak0c?usp=sharing


Next, connect to the Derby command prompt by typing the following command into your command prompt (INCLUDING the quotation marks) and hitting enter:
"%JAVA_HOME%\db\bin\ij"

Then type or copy in this command and hit enter to connect to, and create, a database named "books". You can name your database something else if you want. Note that this will also set up the database to use username "deitel" and password "deitel":
connect 'jdbc:derby:books;create=true;user=deitel;password=deitel';

(Note that if you've already created your books database then you connect without using create=true; so your connect command would just be this: connect 'jdbc:derby:books;user=deitel;password=deitel'; )

Run the following command to execute all the sql in books.sql. This will populate your database with tables and data:
run 'books.sql';

A bunch of SQL commands will scroll down the screen. At this point you can type in your own queries or updates. Put this one in to verify that you can access the correct data:
SELECT * FROM authors;

That's it. You're done.

Exit the Derby command prompt using these commands (note that the semicolons are needed):
disconnect; exit;

In the video, I then discuss the contents of books.sql. If you're interested in learning even more about SQL, there is a great tutorial on w3schools that is beginner friendly: https://www.w3schools.com/sql/