source: trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/database/GS3SQLConnectionFactory.java@ 8745

package org.greenstone.gsdl3.gs3build.database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;


public class GS3SQLConnectionFactory
{
    public static Connection getConnection(String database)
    {
    try {
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/"+database+"?user=gsdl3admin"/*&password=greenstone"*/);
        return connection;
    }
    catch (SQLException sqlEx)
        {   System.out.println(sqlEx.toString());
        }
    catch (Exception ex)
        {   System.out.println(ex.toString());
        return null;
        }
    return null;
    }
    
    public static SQLConnection getSQLConnection(String database)
    {
    Connection c = getConnection(database);
    if (c== null) {
        return null;
    }
    return new SQLConnection(c);
    }

    
    public static GS3SQLConnection getGS3SQLConnection(String database)
    {
    Connection c = getConnection(database);
    if (c== null) {
        return null;
    }
    return new GS3SQLConnection(c);
    }

    /* returns a Connection to the server, */
    public static Connection getConnection() 
    {
    return getConnection("test");
    }

    /* returns a Connection to the server, */
    public static SQLConnection getSQLConnection() 
    {
    return getSQLConnection("test");
    }

    public static GS3SQLConnection getGS3SQLConnection()
    { 
    return getGS3SQLConnection("test");
    }

    public static void main(String args[])
    { 
    GS3SQLConnection connection = getGS3SQLConnection();
    connection.initCollection("maya");
    }
}