JDBC

In this article we will learn about ResultSetMetaData interface and its use in JDBC programs.     This article is a part of our core java tutorial for beginners. Some of the methods available in ResultSetMetaData interface are given below: Method Description public int getColumnCount() throws SQLException Returns the number of columns in the result set […]

In this article we will learn how to delete data from a table using JDBC and MYSQL.   This article is a part of our core java tutorial for beginners.   In this example, we will try to delete the record of student with id 5. The Java code for deleting a record in a MYSQL […]

In this article we will learn how to update data in a table using JDBC and MYSQL.   This article is a part of our core java tutorial for beginners.   The Java code for updating a record in a MYSQL table using JDBC is given below: import java.sql.*; public class UpdateData { static final String […]

In this example, we will use MYSQL DBMS which contains a database named sampledb and a table named students.   The credentials for connecting to the database requires username and password as root and 123456 respectively.   The data in the students table is given below:   This article is a part of our core java […]

The basic implementation steps involved in developing a JDBC application are: Load and register the driver Establish a Connection between Java application and database Create a Statement object Execute the query on the database Process the result using ResultSet Close the connection   This article is a part of our core java tutorial for beginners.   […]