Java JDBC Tutorial – Inserting Date and Time

In this blog post, I'll show you how to insert a date and time value into the database. The date and time is collectively known as a timestamp. JDBC has builtin support for saving and reading timestamps. This support is provided by java.sql.Timestamp. Let's assume we have this database table schema below. Make note of the timestamp column called checkout_time. [...]

By |2015-01-06T17:49:14-05:00January 6, 2015|How-To, Java, JDBC, MySQL|Comments Off on Java JDBC Tutorial – Inserting Date and Time

Morning Java Practice Exercise

Here's a morning Java practice exercise (see below). Please read over it and see if you can solve it.  You can download the solution here: customervisit.zip.  Enjoy!

By |2015-01-02T13:35:36-05:00January 2, 2015|How-To, Java|Comments Off on Morning Java Practice Exercise

Java JDBC Tutorial – Part 12.x: Creating Runnable JAR file with Eclipse

In this blog post, I'll show you how to create an runnable JAR file. This will use the code from video 12.10. A runnable JAR file allows you to have a single JAR file that includes all Java class files and supporting libraries. In our case, this includes the JAR files for the MySQL JDBC driver (client api code only) [...]

By |2014-11-28T13:53:05-05:00November 28, 2014|How-To, Java, JDBC, MySQL, Swing|Comments Off on Java JDBC Tutorial – Part 12.x: Creating Runnable JAR file with Eclipse

Java JDBC Tutorial – Part 12.11: Connect Java Swing GUI to a MySQL Database – Date of Birth

Hi All, Things have being going good with the JDBC Swing GUI video series. I had a YouTube subscriber ask if I could expand on this example and show how to handle dates. So, in this post, we'll add support for read/write the date of birth for an employee. Overview of the Steps Add new database field for Date of [...]

By |2014-11-05T12:37:10-05:00November 5, 2014|How-To, Java, JDBC, MySQL, Swing|12 Comments

Java JDBC Tutorial – Part 12.9: Connect Java Swing GUI to a MySQL Database

In this video we will learn how to connect a Java GUI to a MySQL database. We will link database tables to keep track of an employee’s audit history. Please SUBSCRIBE to my YouTube channel. About the Program This program allows a user to add and update employees. Each action on the employee is tracked in the audit_history table. This [...]

By |2014-10-29T08:41:43-04:00October 29, 2014|How-To, Java, JDBC, MySQL, Swing|Comments Off on Java JDBC Tutorial – Part 12.9: Connect Java Swing GUI to a MySQL Database
Go to Top