Select records using Prepared Statement

To select records using Prepared Statement in java we use

“A ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is

Read More →

Select records using Statement in Java

To select records using Statement in java we use

“A ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is positione

Read More →

Delete record using Statement in Java

We saw how to Create a table and Insert Data using Statement in Java. Now lets delete some of the data from the table using Statement. Delete record SQL Below is the query that can be fired directl

Read More →

Update record using Statement in Java

We saw how to Create a table and Insert Data using Statement in Java. Now lets update the data into that is already present in the table using Statement. Update record SQL Below is the query that c

Read More →

Insert record using Statement in Java

We saw how to Create Table using Statement in Java. Now lets insert data into this table using Statement. Insert record SQL Below is the query that can be fired directly on database to insert recor

Read More →

Create Table using Statement in Java

Statements in JDBC are used to execute SQL statements that do not require dynamic parameters passed to the query. Lets see how to create create table using statement in java. Please note : We will

Read More →

Connect to MySQL using JDBC

In this post we will see the sample code to connect to MySQL using JDBC drivers in java. For connecting to MySQL database we will need the following 1. Connection URL The format is [crayon-61eb1277

Read More →