package Database;

import java.sql.*;

public class DatabaseClient {

    public Statement stmt;

    public DatabaseClient(Database db){

        try{

            Class.forName("org.gjt.mm.mysql.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql:///"+db.get_db_name(),db.get_db_user(),db.get_db_password());
            stmt = conn.createStatement();

        }catch(Exception exc){
            System.out.println("Errore JDBC : "+exc.getMessage());
        }

    }

      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;
         }
      }

}