DeleteBean


1   /*
2     * JBoss, Home of Professional Open Source
3     * Copyright 2005, JBoss Inc., and individual contributors as indicated
4     * by the @authors tag. See the copyright.txt in the distribution for a
5     * full listing of individual contributors.
6     *
7     * This is free software; you can redistribute it and/or modify it
8     * under the terms of the GNU Lesser General Public License as
9     * published by the Free Software Foundation; either version 2.1 of
10    * the License, or (at your option) any later version.
11    *
12    * This software is distributed in the hope that it will be useful,
13    * but WITHOUT ANY WARRANTY; without even the implied warranty of
14    * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
15    * Lesser General Public License for more details.
16    *
17    * You should have received a copy of the GNU Lesser General Public
18    * License along with this software; if not, write to the Free
19    * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
20    * 02110-1301 USA, or see the FSF site: http://www.fsf.org.
21    */
22  package org.jboss.ejb3.test.regression.ejbthree290;
23  
24  import java.sql.Connection  ;
25  import java.sql.PreparedStatement  ;
26  import javax.ejb.Stateless  ;
27  import javax.ejb.TransactionAttribute  ;
28  import javax.ejb.TransactionAttributeType  ;
29  import javax.annotation.Resource;
30  import javax.sql.DataSource  ;
31  
32  /**
33   * Comment
34   *
35   * @author <a HREF="mailto:bill@jboss.org">Bill Burke</a>
36   * @version $Revision: 37459 $
37   */
38  @Stateless  
39  public class DeleteBean implements DeleteLocal
40  {
41     @Resource(mappedName="java:/DefaultDS") DataSource   ds;
42  
43     @TransactionAttribute  (TransactionAttributeType.REQUIRES_NEW)
44     public void removeEntity(int id) throws Exception  
45     {
46        Connection   conn = ds.getConnection();
47        PreparedStatement   ps  = conn.prepareStatement("delete from MYENTITY_TABLE where id=?");
48        ps.setInt(1, id);
49        ps.executeUpdate();
50        ps.close();
51        conn.close();
52     }
53  }
54
A to Z: JavaDoc & Examples Daily Java News & Articles Open Source Projects Open Source Codes Free Computer Books Remove Frame
Popular Tags