Class MySQLDatabase

java.lang.Object

net.chen.legacyLand.database.MySQLDatabase

All Implemented Interfaces:

IDatabase

public class MySQLDatabase
extends Object
implements IDatabase

MySQL 数据库实现 使用 HikariCP 连接池

Constructor Summary

Constructors

Constructor	Description
MySQLDatabase(LegacyLand plugin)

Method Summary

Modifier and Type	Method	Description
void	connect()	连接数据库
void	createTables()	创建表结构
void	decrementChunkResource(String world, int chunkX, int chunkZ, double delta)	P2 预留：递减 currentValue。
void	deleteDiplomacyRelation(String nation1, String nation2)
void	deleteFlagWar(String flagWarId)
void	deleteGuaranteeRelation(String guarantorNation, String protectedNation)	删除保卫关系
void	deleteMarket(String marketId)	删除市场数据
void	deleteMarketChest(String chestId)	删除市场箱子数据
void	deleteNationData(String nationName)
void	deleteNationGuarantees(String nationName)	删除国家的所有保卫关系
void	deleteWarData(String warName)
void	disconnect()	断开数据库连接
Connection	getConnection()	获取底层 JDBC 连接（用于扩展模块直接操作，仅 SQL 类型数据库支持）
List<FlagWarData>	loadActiveFlagWars()
List<ChunkResourceData>	loadAllChunkResources()	加载所有已扫描区块（用于全量统计/导出，谨慎在大数据集下调用）。
List<DiplomacyRelation>	loadAllDiplomacyRelations()
Map<String, List<GuaranteeRelation>>	loadAllGuarantees()	加载所有保卫关系
List<Market>	loadAllMarkets()	加载所有市场数据
ChunkResourceData	loadChunkResource(String world, int chunkX, int chunkZ)	加载单个区块的储量数据，未找到返回 null。
List<MarketChest>	loadMarketChests(String marketId)	加载指定市场的所有箱子
GovernmentType	loadNationGovernment(String nationName)
String	loadNationPoliticalSystem(String nationName)	加载国家政治体制 ID
Map<UUID, NationRole>	loadNationRoles(String nationName)
List<String>	loadPlayerAchievements(UUID playerId)
PlayerData	loadPlayerData(UUID playerId, String playerName)
Map<String,Object>	loadSeasonData()
Map<String,Object>	loadSiegeWar(String siegeId)
Map<String,Object>	loadWarData(String warName)
Map<UUID,String>	loadWarParticipants(String warName)
void	removePlayerRole(String nationName, UUID playerId)
void	saveChunkResource(ChunkResourceData data)	保存或更新区块储量数据（upsert）。
void	saveDiplomacyRelation(DiplomacyRelation relation)
void	saveFlagWar(FlagWarData flagWar)
void	saveGuaranteeRelation(GuaranteeRelation relation)	保存保卫关系
void	saveMarket(Market market)	保存市场数据
void	saveMarketChest(MarketChest chest)	保存市场箱子数据
void	saveNationGovernment(String nationName, GovernmentType governmentType)
void	saveNationPoliticalSystem(String nationName, String systemId)	保存国家政治体制（配置驱动）
void	savePlayerAchievement(UUID playerId, String achievementId)
void	savePlayerData(PlayerData data)
void	savePlayerRole(String nationName, UUID playerId, NationRole role)
void	saveSeasonData(String currentSeason, int currentDay, int daysPerSubSeason)
void	saveSiegeWar(Map<String,Object> siegeData)
void	saveWar(War war)
void	saveWarData(String warName, Map<String,Object> warData)
void	saveWarParticipant(String warName, UUID playerId, String role)
void	updateGuaranteeRelation(GuaranteeRelation relation)	更新保卫关系

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface IDatabase

getLogger

Constructor Details

MySQLDatabase

public MySQLDatabase(LegacyLand plugin)

Method Details

connect

public void connect()

Description copied from interface: IDatabase

连接数据库

Specified by:

connect in interface IDatabase

disconnect

public void disconnect()

Description copied from interface: IDatabase

断开数据库连接

Specified by:

disconnect in interface IDatabase

getConnection

public Connection getConnection()

Description copied from interface: IDatabase

获取底层 JDBC 连接（用于扩展模块直接操作，仅 SQL 类型数据库支持）

Specified by:

getConnection in interface IDatabase

createTables

public void createTables()

Description copied from interface: IDatabase

创建表结构

Specified by:

createTables in interface IDatabase

saveNationGovernment

public void saveNationGovernment(String nationName,
 GovernmentType governmentType)

Specified by:

saveNationGovernment in interface IDatabase

loadNationGovernment

public GovernmentType loadNationGovernment(String nationName)

Specified by:

loadNationGovernment in interface IDatabase

saveNationPoliticalSystem

public void saveNationPoliticalSystem(String nationName,
 String systemId)

Description copied from interface: IDatabase

保存国家政治体制（配置驱动）

Specified by:

saveNationPoliticalSystem in interface IDatabase

loadNationPoliticalSystem

public String loadNationPoliticalSystem(String nationName)

Description copied from interface: IDatabase

加载国家政治体制 ID

Specified by:

loadNationPoliticalSystem in interface IDatabase

savePlayerRole

public void savePlayerRole(String nationName,
 UUID playerId,
 NationRole role)

Specified by:

savePlayerRole in interface IDatabase

loadNationRoles

public Map<UUID, NationRole> loadNationRoles(String nationName)

Specified by:

loadNationRoles in interface IDatabase

removePlayerRole

public void removePlayerRole(String nationName,
 UUID playerId)

Specified by:

removePlayerRole in interface IDatabase

deleteNationData

public void deleteNationData(String nationName)

Specified by:

deleteNationData in interface IDatabase

saveDiplomacyRelation

public void saveDiplomacyRelation(DiplomacyRelation relation)

Specified by:

saveDiplomacyRelation in interface IDatabase

loadAllDiplomacyRelations

public List<DiplomacyRelation> loadAllDiplomacyRelations()

Specified by:

loadAllDiplomacyRelations in interface IDatabase

deleteDiplomacyRelation

public void deleteDiplomacyRelation(String nation1,
 String nation2)

Specified by:

deleteDiplomacyRelation in interface IDatabase

savePlayerData

public void savePlayerData(PlayerData data)

Specified by:

savePlayerData in interface IDatabase

loadPlayerData

public PlayerData loadPlayerData(UUID playerId,
 String playerName)

Specified by:

loadPlayerData in interface IDatabase

saveWar

public void saveWar(War war)

Specified by:

saveWar in interface IDatabase

saveWarData

public void saveWarData(String warName,
 Map<String,Object> warData)

Specified by:

saveWarData in interface IDatabase

loadWarData

public Map<String,Object> loadWarData(String warName)

Specified by:

loadWarData in interface IDatabase

deleteWarData

public void deleteWarData(String warName)

Specified by:

deleteWarData in interface IDatabase

saveWarParticipant

public void saveWarParticipant(String warName,
 UUID playerId,
 String role)

Specified by:

saveWarParticipant in interface IDatabase

loadWarParticipants

public Map<UUID,String> loadWarParticipants(String warName)

Specified by:

loadWarParticipants in interface IDatabase

saveSiegeWar

public void saveSiegeWar(Map<String,Object> siegeData)

Specified by:

saveSiegeWar in interface IDatabase

loadSiegeWar

public Map<String,Object> loadSiegeWar(String siegeId)

Specified by:

loadSiegeWar in interface IDatabase

savePlayerAchievement

public void savePlayerAchievement(UUID playerId,
 String achievementId)

Specified by:

savePlayerAchievement in interface IDatabase

loadPlayerAchievements

public List<String> loadPlayerAchievements(UUID playerId)

Specified by:

loadPlayerAchievements in interface IDatabase

saveSeasonData

public void saveSeasonData(String currentSeason,
 int currentDay,
 int daysPerSubSeason)

Specified by:

saveSeasonData in interface IDatabase

loadSeasonData

public Map<String,Object> loadSeasonData()

Specified by:

loadSeasonData in interface IDatabase

saveFlagWar

public void saveFlagWar(FlagWarData flagWar)

Specified by:

saveFlagWar in interface IDatabase

loadActiveFlagWars

public List<FlagWarData> loadActiveFlagWars()

Specified by:

loadActiveFlagWars in interface IDatabase

deleteFlagWar

public void deleteFlagWar(String flagWarId)

Specified by:

deleteFlagWar in interface IDatabase

saveMarket

public void saveMarket(Market market)

Description copied from interface: IDatabase

保存市场数据

Specified by:

saveMarket in interface IDatabase

loadAllMarkets

public List<Market> loadAllMarkets()

Description copied from interface: IDatabase

加载所有市场数据

Specified by:

loadAllMarkets in interface IDatabase

deleteMarket

public void deleteMarket(String marketId)

Description copied from interface: IDatabase

删除市场数据

Specified by:

deleteMarket in interface IDatabase

saveMarketChest

public void saveMarketChest(MarketChest chest)

Description copied from interface: IDatabase

保存市场箱子数据

Specified by:

saveMarketChest in interface IDatabase

loadMarketChests

public List<MarketChest> loadMarketChests(String marketId)

Description copied from interface: IDatabase

加载指定市场的所有箱子

Specified by:

loadMarketChests in interface IDatabase

deleteMarketChest

public void deleteMarketChest(String chestId)

Description copied from interface: IDatabase

删除市场箱子数据

Specified by:

deleteMarketChest in interface IDatabase

saveGuaranteeRelation

public void saveGuaranteeRelation(GuaranteeRelation relation)

Description copied from interface: IDatabase

保存保卫关系

Specified by:

saveGuaranteeRelation in interface IDatabase

loadAllGuarantees

public Map<String, List<GuaranteeRelation>> loadAllGuarantees()

Description copied from interface: IDatabase

加载所有保卫关系

Specified by:

loadAllGuarantees in interface IDatabase

updateGuaranteeRelation

public void updateGuaranteeRelation(GuaranteeRelation relation)

Description copied from interface: IDatabase

更新保卫关系

Specified by:

updateGuaranteeRelation in interface IDatabase

deleteGuaranteeRelation

public void deleteGuaranteeRelation(String guarantorNation,
 String protectedNation)

Description copied from interface: IDatabase

删除保卫关系

Specified by:

deleteGuaranteeRelation in interface IDatabase

deleteNationGuarantees

public void deleteNationGuarantees(String nationName)

Description copied from interface: IDatabase

删除国家的所有保卫关系

Specified by:

deleteNationGuarantees in interface IDatabase

saveChunkResource

public void saveChunkResource(ChunkResourceData data)

Description copied from interface: IDatabase

保存或更新区块储量数据（upsert）。

Specified by:

saveChunkResource in interface IDatabase

loadChunkResource

public ChunkResourceData loadChunkResource(String world,
 int chunkX,
 int chunkZ)

Description copied from interface: IDatabase

加载单个区块的储量数据，未找到返回 null。

Specified by:

loadChunkResource in interface IDatabase

loadAllChunkResources

public List<ChunkResourceData> loadAllChunkResources()

Description copied from interface: IDatabase

加载所有已扫描区块（用于全量统计/导出，谨慎在大数据集下调用）。

Specified by:

loadAllChunkResources in interface IDatabase

decrementChunkResource

public void decrementChunkResource(String world,
 int chunkX,
 int chunkZ,
 double delta)

Description copied from interface: IDatabase

P2 预留：递减 currentValue。当前未被调用。

Specified by:

decrementChunkResource in interface IDatabase