KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > openejb > test > beans > DatabaseBean


1 /**
2  * Redistribution and use of this software and associated documentation
3  * ("Software"), with or without modification, are permitted provided
4  * that the following conditions are met:
5  *
6  * 1. Redistributions of source code must retain copyright
7  * statements and notices. Redistributions must also contain a
8  * copy of this document.
9  *
10  * 2. Redistributions in binary form must reproduce the
11  * above copyright notice, this list of conditions and the
12  * following disclaimer in the documentation and/or other
13  * materials provided with the distribution.
14  *
15  * 3. The name "Exolab" must not be used to endorse or promote
16  * products derived from this Software without prior written
17  * permission of Exoffice Technologies. For written permission,
18  * please contact info@exolab.org.
19  *
20  * 4. Products derived from this Software may not be called "Exolab"
21  * nor may "Exolab" appear in their names without prior written
22  * permission of Exoffice Technologies. Exolab is a registered
23  * trademark of Exoffice Technologies.
24  *
25  * 5. Due credit should be given to the Exolab Project
26  * (http://www.exolab.org/).
27  *
28  * THIS SOFTWARE IS PROVIDED BY EXOFFICE TECHNOLOGIES AND CONTRIBUTORS
29  * ``AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT
30  * NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
31  * FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL
32  * EXOFFICE TECHNOLOGIES OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
33  * INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
34  * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
35  * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
36  * HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT,
37  * STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
38  * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED
39  * OF THE POSSIBILITY OF SUCH DAMAGE.
40  *
41  * Copyright 1999 (C) Exoffice Technologies Inc. All Rights Reserved.
42  *
43  * $Id: DatabaseBean.java 1096 2004-03-26 21:41:16Z dblevins $
44  */

45 package org.openejb.test.beans;
46
47 import java.sql.Connection JavaDoc;
48 import java.sql.PreparedStatement JavaDoc;
49 import java.sql.ResultSet JavaDoc;
50 import java.sql.Statement JavaDoc;
51
52 import javax.ejb.EJBException JavaDoc;
53 import javax.ejb.SessionContext JavaDoc;
54 import javax.naming.InitialContext JavaDoc;
55 import javax.sql.DataSource JavaDoc;
56
57 public class DatabaseBean implements javax.ejb.SessionBean JavaDoc {
58     
59     public SessionContext JavaDoc context;
60     public InitialContext JavaDoc jndiContext;
61     
62     public void ejbCreate( ) throws javax.ejb.CreateException JavaDoc{
63         try{
64             jndiContext = new InitialContext JavaDoc();
65         } catch (Exception JavaDoc e){
66             throw new EJBException JavaDoc(e.getMessage());
67         }
68     }
69     
70     public void executeQuery(String JavaDoc statement) throws java.sql.SQLException JavaDoc{
71         try{
72
73         DataSource JavaDoc ds = (DataSource JavaDoc)jndiContext.lookup("java:comp/env/database");
74         Connection JavaDoc con = ds.getConnection();
75
76         PreparedStatement JavaDoc stmt = con.prepareStatement(statement);
77         ResultSet JavaDoc rs = stmt.executeQuery();
78         
79         con.close();
80         } catch (Exception JavaDoc e){
81             throw new EJBException JavaDoc("Cannot execute the statement: "+statement+ e.getMessage());
82         }
83     }
84     
85     public boolean execute(String JavaDoc statement) throws java.sql.SQLException JavaDoc{
86         boolean retval;
87         Connection JavaDoc con = null;
88         try{
89
90         DataSource JavaDoc ds = (DataSource JavaDoc)jndiContext.lookup("java:comp/env/database");
91         con = ds.getConnection();
92
93         Statement JavaDoc stmt = con.createStatement();
94         retval = stmt.execute(statement);
95         
96         } catch (javax.naming.NamingException JavaDoc e){
97 // } catch (Exception e){
98
// e.printStackTrace();
99
//throw new RemoteException("Cannot execute the statement: "+statement, e);
100
throw new EJBException JavaDoc("Cannot lookup the Database bean."+e.getMessage());
101         } finally {
102             if(con!=null) {
103                 con.close();
104             }
105         }
106         return retval;
107     }
108     
109     public void ejbPassivate( ){
110         // never called
111
}
112     public void ejbActivate(){
113         // never called
114
}
115     public void ejbRemove(){
116     }
117     
118     public void setSessionContext(javax.ejb.SessionContext JavaDoc cntx){
119         context = cntx;
120     }
121 }
122    
Popular Tags