KickJava   Java API By Example, From Geeks To Geeks.

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


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
27 class MySQLLayer extends DatabaseAbstractionLayer
28 {
29     private DataSource JavaDoc dataSource;
30     
31     public MySQLLayer(DataSource JavaDoc dataSource)
32     {
33         this.dataSource = dataSource;
34     }
35     
36     public Connection JavaDoc getConnection()
37     throws SQLException JavaDoc
38     {
39         return dataSource.getConnection();
40     }
41     
42     public String JavaDoc resolveType(String JavaDoc type)
43     {
44         if(type.equalsIgnoreCase("SMALLTEXT"))
45             return "VARCHAR(250)";
46         else if(type.equalsIgnoreCase("TEXT"))
47             return "MEDIUMTEXT";
48         else if(type.equalsIgnoreCase("SMALLINT"))
49             return "SMALLINT";
50         else if(type.equalsIgnoreCase("INT"))
51             return "INT";
52         else if(type.equalsIgnoreCase("BIGINT"))
53             return "BIGINT";
54         else if(type.equalsIgnoreCase("REAL"))
55             return "DOUBLE";
56         else
57             return type;
58     }
59 }
60
Popular Tags