1 /* Copyright (C) 2004 Finalist IT Group
2 *
3 * This file is part of JAG - the Java J2EE Application Generator
4 *
5 * JAG is free software; you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation; either version 2 of the License, or
8 * (at your option) any later version.
9 * JAG is distributed in the hope that it will be useful,
10 * but WITHOUT ANY WARRANTY; without even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 * GNU General Public License for more details.
13 * You should have received a copy of the GNU General Public License
14 * along with JAG; if not, write to the Free Software
15 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
16 */
17
18 package com.finalist.tools.statementExecutorUtils;
19
20 import java.sql.*;
21 import javax.sql.*;
22 import javax.naming.*;
23
24 import com.finalist.tools.database.StatementExecutor;
25 import com.finalist.tools.database.OracleRowMapper;
26
27 public class QueryHelper extends StatementExecutor {
28
29 /*** Creates a new instance of QueryHelper */
30 public QueryHelper() {
31 super(createConnection(), new OracleRowMapper());
32 }
33
34
35 //get connecion from datasource or else directly
36 private static Connection createConnection() {
37 Connection con = null;
38 try {
39 con = ConnectionManager.connect();
40 }
41 catch (SQLException q) {
42 System.out.println("SQLException ocurred looking up connection from datasource ");
43 }
44 return con;
45 }
46
47
48 public void close() {
49 try {
50 if (this.conn != null && !this.conn.isClosed()) {
51 conn.close();
52 }
53 }
54 catch (SQLException e) {
55 System.out.println("Error closing the connection");
56 System.out.println("Message :" + e.getMessage());
57 }
58 }
59
60 }