Learn how to get details of columns in an SQL query with JDBC.
An earlier article covered the basics of JDBC (Java DataBase Connectivity) and how to perform SQL queries on a MySQL database. Frequently, it is useful to obtain more information about the columns in a query. These include: the number of columns, column names and types, etc. Maybe you want to build a GUI table showing the results of a query, which requires the names of the columns and more. This article will show you how to retrive the information using JDBC.
Continue reading “JDBC – More About Columns in an SQL Query”
A simple tutorial showing the basics of using JDBC database API.
“A man’s true character comes out when he’s drunk.”
― Charlie Chaplin
JDBC stands for Java DataBase Connectivity and is the standard API (application programming interface) java provides for working with databases. JDBC, as a standard, is built into the java platform. To connect with and use a database, you need an additional component called a jdbc driver, which is specific to the type of database you are working with, such as MySQL, SQL Server, etc. In other words, the JDBC API consists of a small number of classes and a bunch of interfaces, the implementation provided by the actual database vendor. This is illustrated by the figure below.
Continue reading “JDBC MySQL Tutorial”
Implement a Pivot Table in Java using Java 8 Streams and Collections.
“Money may not buy happiness, but I’d rather cry in a Jaguar than on a bus.”
― Françoise Sagan
Today let us see how we can implement a pivot table using java 8 streams. Raw data by itself does not deliver much insight to humans. We need some kind of data aggregation to discern patterns in raw data. A pivot table is one such instrument. Other more visual methods of aggregation include graphs and charts.
Continue reading “Java – Pivot Table using Streams”
Sorting a large CSV file by loading it into SQLite. Much faster and easier to process.
“When you’re at the end of your rope, tie a knot and hold on.”
― Theodore Roosevelt
We are trying to sort a large CSV file. The file contains a couple of million rows – not large by “big-data” standards, but large enough to face problems working with it.
Continue reading “Sort Large CSV File using SQLite”
Large CSV files present a challenge when need arises to sort. Learn how to do that using a database.
“All of life is a constant education.”
― Eleanor Roosevelt, The Wisdom of Eleanor Roosevelt
Let us explore some ways of sorting large data sets.
By large, I don’t mean typical “big-data” sizes – which might consist of billions of rows. Such data sets fall into the realm of “big data” which we are not exploring today. Instead I am talking of sorting a rather large CSV file – maybe a couple of million rows.
Continue reading “Sorting a Large CSV File”
Load XML into MySQL by using Java DOM Parser.
“Never memorize something that you can look up.”
― Albert Einstein
XML provides the ability to represent hierarchical structure with its parent-child relationships. This enables applications to store structured data in XML for export. Importing this XML data into a database is a bit involved as we shall see in this article. You need to write code to manage the database connection. In addition you need parse the XML and isolate the data that needs to be imported.
Continue reading “Load XML into Mysql Using Java”