Share on Google+Share on Google+

Deleting a Row from SQL Table Using EJB

deleting row sql table

Deleting a Row from SQL Table Using EJB


In the given example of Enterprise Java Bean, we are going to delete a row from the SQL Table. Find out the steps given below that describes how to delete a particular row from the database table using EJB. The steps involved in this process are as :-

1)Create an interface named :-This is the Remote Interface for the Bean. Here we have used  @Remote annotation to declare the class as a Remote Interface. The use of annotation here is that through it we can create a java source file which contain the bean implementation logic.

String getStatus(); String getAddress(); String getUpdate();:-
These are the method which is to be defined in the Bean and is called in the client application.

package bean;

import javax.ejb.Remote;
import java.util.*;

public interface AccountStatusRemote {

  String getStatus();

  String getAddress();
  String getUpdate();

2)Create a Bean named is the session bean we have created. By session bean we mean the bean which act as an agents to the client. it is generally used in controlling the business process and filling the gaps between the data of the entity beans. Here

is the session type.

@RolesAllowed(value = {"USERS"}):-This is also the annotation which means that only users in the security role USERS can access the  method declared in the Bean . is the client application through which we can access the methods which are defined in the bean.

@EJB:-This is the annotation that configure the EJB values for a field or a method. Normally this annotation is a Resource annotation where it is known that the resultant is an EJB interface.

private static AccountStatusRemote accountStatusBean:-By this we have created an instance of the interface AccountStatusRemote . 

package bean;

import java.sql.*;
import java.util.*;
import javax.ejb.Stateless;

public class AccountStatusBean implements AccountStatusRemote {

  private String name = "";
  private String address = "sec-3,D-16/116,Rohini";
  private String Update;

@RolesAllowed(value = {"USERS"})
public String getStatus() {
  return "Name of the company is: " + name;

  public String getAddress() {
  return "Address of the company is: " + address;

  @SuppressWarnings(value = "unchecked")

  public String getUpdate() {
 Connection con = null;
  String url = "jdbc:mysql://";
  String dbName = "komal";
  String driver = "com.mysql.jdbc.Driver";
  String updateString=null;
  String userName = "root";
  String password = "root";
 try {
  con = DriverManager.getConnection(url + dbName, 
  userName, password
  Statement st = con.createStatement()
  updateString="delete from employees where  First_Name='A'";
 catch (Exception e) {
 return updateString ;

Output of the program

Name of the company is:
Address of the company is: sec-3,D-16/116,Rohini
Data updated successfully : See sql table to verify
delete from employees where First_Name='A'

Download Source code



Posted on: April 18, 2011 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Share this Tutorial Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Discuss: Deleting a Row from SQL Table Using EJB  

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image