Shigekax ~ DeeZ

//Classe :

package objects;

public class Shigekax {

    private static int _ID;
    private static int _ShigekaxID;
    private static int _NbrFight;

    public Shigekax(int ID, int ShigekaxID, int NbrFight)
    {
        Shigekax._ID = ID;
        Shigekax._ShigekaxID = ShigekaxID;
        Shigekax._NbrFight = NbrFight;
    }

    public static int getID()
    {
        return _ID;
    }

    public int getShigekaxID()
    {
        return _ShigekaxID;
    }

    public int getNbrFight()
    {
        return _NbrFight;
    }

    public void ShigekaxRemove()
    {
     //TODO:
    }
}


//SQLManager :

        public static void REMOVE_SHIGEKAX()
        {
          String baseQuery = "DELETE FROM shigekax WHERE id = ?;";
          try {
            PreparedStatement p = newTransact(baseQuery, othCon);
            p.setInt(1, Shigekax.getID());

            p.execute();
            closePreparedStatement(p);
          } catch (SQLException e) {
            GameServer.addToLog("Game: SQL ERROR: " + e.getMessage());
            GameServer.addToLog("Game: Query: " + baseQuery);
          }
        }

        public static void LOAD_SHIGEKAX()
        {
          try
          {
            ResultSet RS = executeQuery("SELECT * FROM shigekax;", Ancestra.OTHER_DB_NAME);

            while (RS.next())
            {
                new Shigekax(
                RS.getInt("id"),
                RS.getInt("shigekaxid"),
                RS.getInt("nbrfight"));
            }

            closeResultSet(RS);
          }
          catch (SQLException e) {
            RealmServer.addToLog("SQL ERROR: " + e.getMessage());
            e.printStackTrace();
          }
        }

//TODO :

Fight.java : A chaque début? fin de combat on vérifie dans la bdd...
Fight.java : if(getNbrFight() == 0)
        SQLManager.REMOVE_SHIGEKAX();