FileDocCategorySizeDatePackage
AddressBean.javaAPI DocExample3557Sun Mar 03 05:28:40 GMT 2002com.titan.address

AddressBean

public abstract class AddressBean extends Object implements javax.ejb.EntityBean

Fields Summary
Constructors Summary
Methods Summary
public voidejbActivate()

public java.lang.IntegerejbCreateAddress(java.lang.String street, java.lang.String city, java.lang.String state, java.lang.String zip)

		 setStreet(street);
         setCity(city);
         setState(state);
         setZip(zip);
        setId(getNextUniqueKey());
         return null;
    
public voidejbLoad()

public voidejbPassivate()

public voidejbPostCreateAddress(java.lang.String street, java.lang.String city, java.lang.String state, java.lang.String zip)

    
public voidejbRemove()

public voidejbStore()

public abstract java.lang.StringgetCity()

public abstract java.lang.IntegergetId()

private java.lang.IntegergetNextUniqueKey()


        Connection conn = null;
	    Statement stmt = null;
	    ResultSet rs = null;
        Statement stmt2 = null;
	    boolean rowspresent = false;
	    int sequenceID = 0;
	    Integer myId = null;

	    try
	    {

		    InitialContext aContext = new InitialContext();
		    javax.sql.DataSource aDatasource = (javax.sql.DataSource)aContext.lookup("jdbc/TitanUID");
		    conn = aDatasource.getConnection();
		    System.out.println("Obtained a database connection to Cloudscape");

		    stmt = conn.createStatement();
		    StringBuffer aString = new StringBuffer();
		    aString.append("select ").append("\"").append("CurrentValue");
		    aString.append("\"").append(" from ").append("\"").append("SequenceTable");
		    aString.append("\"").append(" where").append("\"").append("SequenceName");
		    aString.append("\"").append("like").append("'Address'");//.append(" for Update");
		    System.out.println(aString);
		    rs = stmt.executeQuery(aString.toString());
	        if (rs != null)
	        {
	            while (rs.next())
	            {
	                sequenceID =rs.getInt(1);
	            }
	        }

		    myId = new Integer(sequenceID);
            System.out.println("ID fetched =="+ myId.intValue());
		    sequenceID++;
            stmt2 = conn.createStatement();
		    StringBuffer aString2 = new StringBuffer("update \"SequenceTable\" set \"CurrentValue\"="+sequenceID+" where \"SequenceName\"='Address'");
		    System.out.println(aString2);
		    stmt2.execute(aString2.toString());
		}
		catch( Exception ex)
		{
		    ex.printStackTrace();
		}
         finally
        {
            try
            {
                stmt.close();
                stmt2.close();
                conn.close();
            }
            catch( Exception ex)
            {
             ex.printStackTrace();
            }
         }
		return myId;
	
public abstract java.lang.StringgetState()

public abstract java.lang.StringgetStreet()

public abstract java.lang.StringgetZip()

public abstract voidsetCity(java.lang.String city)

public voidsetEntityContext(javax.ejb.EntityContext ec)

public abstract voidsetId(java.lang.Integer id)

public abstract voidsetState(java.lang.String state)

public abstract voidsetStreet(java.lang.String street)

public abstract voidsetZip(java.lang.String zip)

public voidunsetEntityContext()