javaFx

There are so many people online who have provided a solution to getting the number of rows from an SQLite database table using Java. Some of them work some don’t, this article is going to illustrate the most efficient way to get the number of rows from a table of an SQLite database using Java…

Being the fifth tutorial of Java Database Series, am going to show you how to delete data from SQLite Database using Java. There are many reasons you would want to delete data from SQLite Database using java, for example, you can give your users functionality to delete their account. Understanding the DELETE Syntax of an…

This is the fourth article of the java database tutorial series. The full list of all article under this series can be found at the bottom of this article. This article is going to demonstrate how to update data into an SQLite database using Java. Learning how to update data into SQLite Database is very…

From the previous article, I showed you how to Insert data into the SQLite database. This being the 3rd article of Java Database Series, I will teach you how to fetch data from SQLite database using Java. Understanding how to fetch data from the SQLite database is very vita especially when presenting that data to…

In the previous tutorial, we learned how to connect any Java Application to the SQLite Database. We also learned the best way to manage SQLite databases on the computer for Java Application. SQLite is very much popular and it’s one of the most used database engines on the globe. For example, the android phonebook is…

Basically, where should you save your Java Databases in the project files? Should you save them in the project directory or some arbitrary location within your computer? I have decided to write an article to demonstrate a step-by-step guide on where you should save your databases for any java project on any IDE. Why Does…