KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > lucane > server > database > PostgresLayer


1 /*
2  * Lucane - a collaborative platform
3  * Copyright (C) 2003 Vincent Fiack <vfiack@mail15.com>
4  *
5  * This library 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 library 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 library; if not, write to the Free Software
17  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
18  */
19 package org.lucane.server.database;
20
21 import java.sql.Connection JavaDoc;
22 import java.sql.SQLException JavaDoc;
23
24 import javax.sql.DataSource JavaDoc;
25
26 class PostgresLayer extends DatabaseAbstractionLayer
27 {
28     private DataSource JavaDoc dataSource;
29     
30     public PostgresLayer(DataSource JavaDoc dataSource)
31     {
32         this.dataSource = dataSource;
33     }
34     
35     public Connection JavaDoc getConnection()
36     throws SQLException JavaDoc
37     {
38         return dataSource.getConnection();
39     }
40     
41     public String JavaDoc resolveType(String JavaDoc type)
42     {
43         if(type.equalsIgnoreCase("SMALLTEXT"))
44             return "VARCHAR(250)";
45         else if(type.equalsIgnoreCase("TEXT"))
46             return "TEXT";
47         else if(type.equalsIgnoreCase("SMALLINT"))
48             return "int2";
49         else if(type.equalsIgnoreCase("INT"))
50             return "int4";
51         else if(type.equalsIgnoreCase("BIGINT"))
52             return "int8";
53         else if(type.equalsIgnoreCase("REAL"))
54             return "float8";
55         else
56             return type;
57     }
58 }
59
Popular Tags