CRUD operations


1. Insert


String insertDate="insert into employee1 values(1,'james',50000.00)";
statement=connection.createStatement();
//step-4: execute your queries/statements
statement.executeUpdate(insertDate);



2. Select


String selectDate="select * from employee1";
statement=connection.createStatement();
//step-4: execute your queries/statements
ResultSet resultSet=statement.executeQuery(selectDate);
ResultSetMetaData metaData=resultSet.getMetaData();
int n=metaData.getColumnCount();
//display columns
for(int i=1;i<=n;i++)
{
System.out.print(metaData.getColumnName(i));
}
System.out.println("\n");
//display rows
while(resultSet.next())
{
System.out.println(resultSet.getInt(1)+"\t"+resultSet.getString(2)+"\t"+resultSet.getInt(3));
}

Note:  
1. ResultSet for display rows
2. ResultSetMetaData for display columns

3. Update


String updateData="";
statement=connection.createStatement();
statement.executeUpdate(updateDate);

4. Delete


String deleteData="";
statement=connection.createStatement();
statement.executeUpdate(deleteData);