package project_aps.apps;

/**
 * Created by ph_rp on 28/09/2016.
 */
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import android.util.Log;

public class sqlController {

    public String driver;
    public String url;
    public String user;
    public String password;

    //-- CRIANDO CONEXOES
    public static Connection conn;
    public static Statement stmt;
    public static ResultSet rs;

    public  sqlController() {
        driver   = "com.mysql.jdbc.Driver";
        url      = "jdbc:mysql://192.168.0.22:3306/appsocial";
        user     = "apps";
        password = "001200";
    }

    public boolean Conecta() throws Exception
    {
        try {
            Class.forName(driver).newInstance ();
            Log.w("BLOQUEIO","TUDO OK COM CLASS.FORNAME");
        } catch (Exception e) {
            Log.w("BLOQUEIO","NAO FUNCIONOU O CLASS.FORNAME");
        }

        try {
            conn = DriverManager.getConnection(url,user,password);
            Log.w("BLOQUEIO","TUDO OK COM O DRIVER.MANAGER");
        } catch (Exception e) {
            Log.w("BLOQUEIO",e.getMessage());
        }

        try {
            stmt = conn.createStatement();
            Log.w("BLOQUEIO","TUDO OK COM O CREATESTATEMENT");
        } catch (Exception e) {
            Log.w("BLOQUEIO","NAO FUNCIONOU O CREATESTATEMENT");
        }


        return true;
    }
}