package Database;

import java.sql.*;

public class Database {
        
        public Statement stmt;

    public Database(String db_name,String db_user,String db_password){

      try
        {

           Class.forName("org.gjt.mm.mysql.Driver");
           Connection conn = DriverManager.getConnection("jdbc:mysql:///"+db_name,db_user,db_password);
           System.out.println("->" + "Connessione con Database " + db_name + " effettuata!");
           stmt = conn.createStatement();
           setdata(db_name,db_user,db_password);
           
        }catch(Exception exc){

            System.out.println("Errore JDBC : "+exc.getMessage());
            System.exit(0);

        }

    }

    String db_name;
    String db_user;
    String db_password;

    public void setdata(String db_name,String db_user,String db_password){
        this.db_name = db_name;
        this.db_user = db_user;
        this.db_password = db_password;
    }
    public String get_db_name(){
        return db_name;
    }
    public String get_db_user(){
        return db_user;
    }
    public String get_db_password(){
        return db_password;
    }



      public void Update(String query){
         try{
             stmt.executeUpdate(query);
         }catch(Exception sqlex){
          sqlex.printStackTrace();
         }
      }
      
      public ResultSet Query(String query){
         try{

          return stmt.executeQuery(query);

         }catch(Exception sqlex){
          sqlex.printStackTrace();
          return null;
         }
      }



}