Connecttodbms.java

Go to the documentation of this file.

package p2pserver;

import java.sql.*;

public class Connecttodbms{

public Connecttodbms(){super();}

public static Connection connect(boolean speak, String dbms, String user, String pswd)
{
    try
    {
        Class.forName("com.mysql.jdbc.Driver");
        Connection db = DriverManager.getConnection("jdbc:mysql://localhost/"+dbms,user,pswd);
        pswd = "";
        return db;
    }
    catch(Exception x)
    {
        if(speak) p2putility.Util.logServer("Errore di connessione.\n"+x);
        return null;
    }
}

public static boolean disconnect(boolean speak, Connection db)
{
    try
    {
        db.close();
        return true;
    }
    catch(Exception x)
    {
        if(speak) p2putility.Util.logServer("Errore nella chiusura della connessione.\n"+x);
        return false;
    }
}

public static Statement createStat(boolean speak, Connection db)
{
    try
    {
        return db.createStatement();
    }
    catch(Exception x)
    {
        if(speak) p2putility.Util.logServer("Errore nella creazione dello statement.\n"+x);
        return null;
    }
}

public static boolean closeStat(boolean speak, Statement s)
{
    try
    {
        s.close();
        return true;
    }
    catch(Exception x)
    {
        if(speak) p2putility.Util.logServer("Errore nella chiusura dello Statement.\n"+x);
        return false;
    }
}

public static ResultSet yesRSetQuery(boolean speak, Statement s, String query)
{
    try
    {
        return s.executeQuery(query);
    }
    catch(Exception x)
    {
        if(speak) p2putility.Util.logServer("Errore in esecuzione query.\n"+x);
        return null;
    }
}

public static boolean noRSetQuery(boolean speak, Statement s, String query)
{
    try
    {
        return !s.execute(query);
    }
    catch(Exception x)
    {
        if(speak) p2putility.Util.logServer("Errore in esecuzione query.\n"+x);
        return false;
    }
}

public static boolean closeRSet(boolean speak, ResultSet r)
{
    try
    {
        r.close();
        return true;
    }
    catch(Exception x)
    {
        if(speak) p2putility.Util.logServer("Errore nella chiusura del ResultSet.\n"+x);
        return false;
    }
}

    
}