registerejb.java

《J2EE专业项目实例开发》源代码

import java.sql.*;
import javax.sql.*;
import java.util.*;
import javax.ejb.*;
import javax.naming.*;
import java.rmi.*;

public class RegisterEjb implements EntityBean
{
private String requestId;
private String userName;
private String firstName;
private String middleName;
private String lastName;
private String dateOfBirth;   
private String email;
private String addressLine1;
private String addressLine2;
private String city;
private String state;
private String creditCard;
private String creditCardType;
private String password;
private String secretQuestion;
private String secretAnswer;
Connection con;
int id=0;
public RegisterEjb(){}

public void  setRequestId(String req)
 	{
  		requestId=req;
 	}

public void setUserName(String user)
  	{
 		userName=user;
  	}  
public void  setFirstName(String first) 
	{
   		firstName=first;
  	} 
public void  setMiddleName(String middle) 
  	{
   		middleName=middle;
  	} 
public void  setLastName(String last) 
 	{
   		 lastName=last;  
 	}	
public void  setDateOfBirth(String date) 
 	{
  		dateOfBirth=date;
 	}
public void  setEmail(String em) 
 	{
   		email=em;

         }
public void  setAddressLine1(String address1) 
 {
  addressLine1=address1;
 }
public void  setAddressLine2(String address2)
 {
  addressLine2=address2;
 }
public void setCity(String cit)
 {
  city= cit;
 }
public void  setState(String sta) 
 {
  state= sta;
 }
public void setCreditCard(String credit)
 {
creditCard=credit;

 }
public void setCreditCardType(String creditType) 
 {
creditCardType=creditType;
 }

public void setPassword(String pass) 
 	{
   		password=pass;
 	}	
public void setSecretQuestion(String secretQ) 
 	{
  		secretQuestion=secretQ;
 	}

public void setSecretAnswer(String secretA) 
 	{
  		secretAnswer=secretA;
 	}



public String getRequestId()
 	{
  		return requestId;
 	}

public String getUserName()
  	{
    		return userName;
  	}  
public String getFirstName() 
  	{
    		return firstName;
  	} 
public String getMiddleName() 
  	{
    		return middleName;
  	} 
public String getLastName() 
 	{
   		return lastName;  
 	}
public String getDateOfBirth() 
 	{
   		return dateOfBirth;
 	}
public String getEmail() 
 	{
   		return email;
 	}
public String getAddressLine1() 
 	{
  		return addressLine1;
 	}
public String getAddressLine2()
 	{
 		 return addressLine2;
 	}
public String getCity()
 	{
  		return city;
 	}
public String getState() 
 	{
  		return state;
 	}
public String getCreditCard()
 	{
  		return creditCard;
 	}
public String getCreditCardType() 
 	{
  		return creditCardType;
 	}


public String ejbFindByPrimaryKey(String id) throws FinderException{
   
return new String(new Integer(id).toString());
}


public String ejbCreate(String userName,String firstName,String middleName,String lastName, String  dateOfBirth,String email,String addressLine1,String addressLine2,String city, String state,String  creditCard,String creditCardType,String password,String secretQuestion,String secretAnswer)throws  CreateException {
try{
	getConnection();

	Statement st= con.createStatement();
System.out.println("Afterget1"+st);
ResultSet rst=st.executeQuery("Select max(request_id) from User_Info");
while(rst.next()){
   			id=rst.getInt(1);

 		}
	
System.out.println("Inside setEntityContext");
    }catch(Exception e){
	System.out.println("In setEntityContext() :"+e);
     }

this.userName=userName;
this.firstName=firstName;
this.middleName=middleName;
this.lastName=lastName;
this.dateOfBirth=dateOfBirth;
this.email=email;
this.addressLine1=addressLine1;
this.addressLine2=addressLine2;
this.city= city;
this.state= state;
this.creditCard=creditCard;
this.creditCardType=creditCardType;
this.password=password;
this.secretQuestion=secretQuestion;
this.secretAnswer=secretAnswer;

try
  {
   insertDetails(userName, firstName, middleName,lastName, dateOfBirth, email, addressLine1,addressLine2,city,state,
 creditCard,creditCardType,password,secretQuestion,
 secretAnswer);
   }
catch(Exception ex) 
  {
   System.out.println("Exception in inserting details in database"+ex);
  } 
try
  {
   closeConnection();
  }
catch(Exception ex) 
  {
   System.out.println("Exception in closing Connection"+ex);
  } 
return (new Integer(id).toString());
}


private void getConnection() throws NamingException,SQLException
 {
  InitialContext inc=new InitialContext();
  DataSource datsrc=(DataSource)inc.lookup("java:comp/env/jdbc/RegisterDataSource");

  con=datsrc.getConnection();

 }

private void insertDetails(String userName,String firstName,String middleName,String lastName,String dateOfBirth,String email, String addressLine1,String addressLine2,String city,String state,String creditCard,String creditCardType,String password,
String secretQuestion,String secretAnswer)throws SQLException
{

try
{
Statement st= con.createStatement();
		ResultSet rst=st.executeQuery("Select max(request_id) from User_Info");
		while(rst.next()){
   			id=rst.getInt(1);

 		}
	     }catch(Exception e){
		System.out.println("Exception in Activate"+e);
     	       }
id++;

 String role="user";
 String insert1="Insert into User_Info values(?,?,?,?,?,?,?,?,?,?,?,?,?)";
 String insert2="Insert into Login_Info values (?,?,?,?,?)";
 PreparedStatement stat1=con.prepareStatement(insert1);
 PreparedStatement stat2=con.prepareStatement(insert2);

 stat1.setInt(1,id);

 stat1.setString(2,userName);

 stat1.setString(3,firstName);

 stat1.setString(4,middleName);

 stat1.setString(5,lastName);

 stat1.setString(6,dateOfBirth);

 stat1.setString(7,email);

 stat1.setString(8,addressLine1);

 stat1.setString(9,addressLine2);

 stat1.setString(10,city);

 stat1.setString(11,state);

 stat1.setString(12,creditCard);

 stat1.setString(13,creditCardType);

 stat2.setString(1,userName);

 stat2.setString(2,password);

 stat2.setString(3,secretQuestion);

 stat2.setString(4,secretAnswer);

stat2.setString(5,role);

 stat1.executeUpdate();
 stat1.close();

 stat2.executeUpdate();
 stat2.close();
 
}



private void closeConnection() throws SQLException
 {
   con.close();
 }

public String ejbPostCreate(String userName,String firstName,String middleName,String lastName, String dateOfBirth,String email,String addressLine1,String addressLine2,String city, String state,String creditCard,String creditCardType,String password,String secretQuestion,String secretAnswerr){return new Integer(id).toString();}


public void ejbActivate(){
	try{
		getConnection();
		Statement st= con.createStatement();
		ResultSet rst=st.executeQuery("Select max(request_id) from User_Info");
		while(rst.next()){
   			id=rst.getInt(1);

 		}
	     }catch(Exception e){
		System.out.println("In Activate() :"+e);
     	       }
}

public void ejbLoad(){}

public void ejbPassivate(){
try{
	closeConnection();
   }catch(Exception e){
	System.out.println("In setEntityContext() :"+e);
     }

}
public void ejbRemove(){}

public void ejbStore(){}

public void setEntityContext(EntityContext ctx){
try{
		getConnection();
		

 		}
	    catch(Exception e){
		System.out.println("In Activate() :"+e);
     	       }


}

public void unsetEntityContext(){
try{
	closeConnection();
 }catch(SQLException e){
    
  }
}

}