JDBC

The ResultSetMetaData interface in JDBC can be used to gather meta data about the result set. The meta data can include information like number of columns in a result set, type of a column, name of a column, table name, etc.   Some of the methods available in ResultSetMetaData interface are given below: Method Description […]

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 table using JDBC is given below: import java.sql.*; public class DeleteData { static final String DB_URL = "jdbc:mysql://localhost/sampledb"; static final String USER = "root"; static final String PASS = "123456"; […]

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 DB_URL = "jdbc:mysql://localhost/sampledb"; static final String USER = "root"; static final String PASS = "123456"; static final String QUERY = "UPDATE students SET mobile=7788665544 where id=5"; public static void main(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:   For working with MYSQL DBMS and the databases in it, […]

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   Before loading and registering the driver you need to import java.sql package […]