persistence.xml

<persistence>
   <persistence-unit name="IntroEJB3">
      <jta-data-source>java:/Oussema_OracleDS</jta-data-source>
      <properties>
         <property name="hibernate.hbm2ddl.auto" value="update"/>
      </properties>
   </persistence-unit>
</persistence>

userRemote Remote Interface

package customized.bean;

//import java.util.List;
import javax.ejb.Remote;

@Remote
public interface userRemote {
   public void addUser(u_ser ub);
   public boolean FindUserByUserName(String usrname);   
   public boolean FindUserByPassword(String passwd);
   public boolean FindUserByEmail(String email);   
   public Integer getUserID(String usrname);
   public u_ser GetUser(String usr_name,String usr_pass);
 
}

userBean Stateless Session Bean

package customized.bean;

import java.util.List;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

@Stateless
public class userBean implements userRemote {

   @PersistenceContext
   EntityManager em;

   public void addUser(u_ser usr) {
      em.persist(usr);
   }
  
   public boolean FindUserByUserName(String usrname) { // should return single record -- By Oussema
       List<u_ser> lst_usrs = em.createQuery("select u from u_ser u where u.user_name=\'"+usrname+"\'").getResultList();
       if(lst_usrs.isEmpty())
       {
           return false;
       }else
       {
           return true;
       }
    }
  
  
   public u_ser GetUser(String usr_name,String usr_pass){
       digest d=new digest();
       d.string=usr_pass;
       List<u_ser> lst_usrs = em.createQuery("select u from u_ser u where u.user_name=\'"+usr_name+"\' and user_pass=\'"+d.getDigest_SHA1()+"\'").getResultList();
       u_ser u = lst_usrs.get(0);
       return u;
        
   }
  
  
  
  

  
   public boolean FindUserByPassword(String usr_pass) { // should return single record -- By Oussema
       digest d=new digest();
       d.string=usr_pass;
       List<u_ser> lst_usrs = em.createQuery("select u from u_ser u where u.user_pass=\'"+d.getDigest_SHA1()+"\'").getResultList();
       if(lst_usrs.isEmpty())
       {
           return false;
       }else
       {
           return true;
       }
    }

  
   public boolean FindUserByEmail(String email){  // should return single record -- By Oussema
       List<u_ser> lst_usrs = em.createQuery("select u from u_ser u where u.email=\'"+email+"\'").getResultList();
       if(lst_usrs.isEmpty())
       {
           return false;
       }else
       {
           return true;
       }
       }
  
   public Integer getUserID(String usrname){
       List<u_ser> l_usrs=em.createQuery("select u from u_ser u where u.user_name=\'"+usrname+"\'").getResultList();
       u_ser u=l_usrs.get(0);
       return u.getUser_id();
   } 
}

u_ser Entity Bean

package customized.bean;

import java.io.Serializable;
import javax.persistence.Entity;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.GeneratedValue;
import javax.persistence.SequenceGenerator;


@Entity
public class u_ser implements Serializable {
   
    @Id
   
    @SequenceGenerator(name="mySeq", sequenceName="seq_u_ser",initialValue=1,allocationSize=1)
    @GeneratedValue(strategy=GenerationType.SEQUENCE,generator="mySeq")
   
    public Integer user_id;
    public String user_name;
    public String first_name;
    public String last_name;
    public String user_pass;
    public String address;
    public String email;
    public String cellular_phone;
    public String other_phone;
   
   
    public u_ser(){
    super();
    }
   
    public u_ser(Integer usrID){
    super();
        this.user_id=usrID;
        }
   
    public u_ser(Integer usrID,String usrName,String first_name,String last_name,String usrPass,String usrAddress,String usrEmail,String cell_phone,String othr_phone){
        super();
        this.user_id=usrID;
        this.user_name=usrName;
        this.first_name=first_name;
        this.last_name=last_name;
        digest d=new digest();
        d.string=usrPass;
        this.user_pass = d.getDigest_SHA1();
        //this.user_pass=usrPass;
        this.address=usrAddress;
        this.email=usrEmail;
        this.cellular_phone=cell_phone;
        this.other_phone=othr_phone;
    }

    public Integer getUser_id() {
        return user_id;
    }

    public void setUser_id(int userId) {
        user_id = userId;
    }

    public String getUser_name() {
        return user_name;
    }

    public void setUser_name(String userName) {
        user_name = userName;
    }

    public String getFirst_name() {
        return first_name;
    }

    public void setFirst_name(String firstName) {
        first_name = firstName;
    }