KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > xquark > extractor > sql > DatabaseManager


1 /*
2  * This file belongs to the XQuark distribution.
3  * Copyright (C) 2003 Universite de Versailles Saint-Quentin.
4  *
5  * This program is free software; you can redistribute it and/or
6  * modify it under the terms of the GNU Lesser General Public
7  * License as published by the Free Software Foundation; either
8  * version 2.1 of the License, or (at your option) any later version.
9  *
10  * This program is distributed in the hope that it will be useful,
11  * but WITHOUT ANY WARRANTY; without even the implied warranty of
12  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
13  * Lesser General Public License for more details.
14  *
15  * You should have received a copy of the GNU Lesser General Public
16  * License along with this program; if not, write to the Free Software
17  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307.
18  * You can also get it at http://www.gnu.org/licenses/lgpl.html
19  *
20  * For more information on this software, see http://www.xquark.org.
21  */
22
23 package org.xquark.extractor.sql;
24
25
26 import java.sql.*;
27 import java.util.Locale JavaDoc;
28
29 public class DatabaseManager {
30
31     private static final String JavaDoc RCSRevision = "$Revision: 1.4 $";
32     private static final String JavaDoc RCSName = "$Name: $";
33
34
35     private Connection _connection = null;
36     private Statement _statement = null;
37     private static Locale JavaDoc _locale = new Locale JavaDoc ( "fr" , "fra");
38 // private DatabaseMetadata _databaseMetadata ;
39
40     public DatabaseManager()
41     {
42     }
43
44     public void connectToDatabase (String JavaDoc driver,String JavaDoc url,String JavaDoc user,String JavaDoc password)
45         throws SQLException , ClassNotFoundException JavaDoc
46     {
47         if (_connection != null) disconnectFromDatabase();
48         Class.forName(driver);
49         _connection = DriverManager.getConnection(url,user,password ) ;
50         _statement = _connection.createStatement();
51     }
52
53     public Connection getConnection ( )
54     {
55         return _connection ;
56     }
57
58     public Statement getStatement ( )
59     {
60         return _statement ;
61     }
62
63     public static Locale JavaDoc getLocale ()
64     {
65         return _locale ;
66     }
67
68     public String JavaDoc getTemporaryTableName ()
69     {
70         return "SqlWrapper" + System.currentTimeMillis() ;
71     }
72
73     public void disconnectFromDatabase () throws SQLException
74     {
75         _statement.close();
76         _connection.close();
77         _statement = null;
78         _connection = null;
79         //Trace.message ( this,"disconnectFromDatabase", "DataBase disconnected" ) ;
80 }
81
82
83 }
84
Popular Tags