Home » Enterprise Java » sql » Page 3

sql

JDBC HSQLDB Tutorial

Bipartite Graph

In this tutorial we will review HSQLDB basics. Then we will write a simple Java application to demonstrate how to access and interact with an HSQLDB database using JDBC. 1. JDBC HSQLDB – Introduction HSQLDB stands for Hyper Structured Query Language Database. It’s a relational database management system written in Java. It supports JDBC interface for database access. It offers ...

Read More »

JDBC Driver Types Example

Bipartite Graph

1. Introduction In this example we will review different JDBC Driver Types. We will write a simple Java application to demonstrate how to use JDBC connectivity steps to access an SQLite database. JDBC stands for Java DataBase Connectivity. It was introduced in Java Development Kit (JDK) version 1.1. It’s an application programming interface (API) that allows Java programs to interact ...

Read More »

JDBC Best Practices Tutorial

Bipartite Graph

Hello, in this tutorial we will learn some Java Database Connectivity (JDBC) best practices that Java programmer should follow while writing JDBC code. You can also check our Java Programming Database Tutorial in the following video: Java Programming Database Tutorial – Video JDBC API is used to connect and interact with the relational databases to perform CREATE, READ, UPDATE, DELETE ...

Read More »

JDBC Connection Strings for Popular RDBMS

Bipartite Graph

1. Introduction In Java applications, JDBC (Java DataBase Connectivity) API is used for connecting to relational databases from clients. The API uses Drivers which are nothing but Java library files exposed by different database vendors and Connection Strings/URLs to connect to the databases. Of course, there are other parameters that could be specified like username, password, the database schema to ...

Read More »

javax.sql.RowSetMetaData Example

RowSetMetaData is an object that contains information about the columns in a RowSet object. Some of these column properties are column’s table name, type, count, label, name, size, is nullable, is read only and so on. This interface is an extension of the ResultSetMetaData interface with methods for setting the values in a RowSetMetaData object. The corresponding getter methods are ...

Read More »

javax.sql.rowset.JdbcRowSet Example

This article introduces the JdbcRowSet interface and its basic usage. This class is defined in the javax.sql.rowset package. JdbcRowSet interface extends RowSet (and Rowset extends ResultSet). A Jdbc rowset: It is a connected rowset. It is a wrapper around a ResultSet object; an enhanced ResultSet object. It maintains a connection to its data source, just as a ResultSet object does. ...

Read More »