top.wcpe.wclevel.mapper

接口 WCLevelMapper

public interface WCLevelMapper

方法概要

限定符和类型	方法和说明
void	createTable()
int	existTable(java.lang.String databaseName)
PlayerLevel	getPlayerLevel(java.lang.String name)
void	insertPlayerLevel(PlayerLevel playerLevel)
java.util.List<PlayerLevel>	listPlayerLevel()
void	updatePlayerLevel(PlayerLevel playerLevel)

方法详细资料

existTable

@Select(value="select count(*) from information_schema.TABLES t where t.TABLE_SCHEMA =#{databaseName} and t.TABLE_NAME = \'wclevel_playerdatas\'")
int existTable(java.lang.String databaseName)

createTable

@Update(value="create table `wclevel_playerdatas` (`name` varchar(32) NOT NULL, `exp` int NOT NULL, `level` int NOT NULL, PRIMARY KEY (`name`));")
void createTable()

getPlayerLevel

@Select(value="select name,exp,level from `wclevel_playerdatas` where `name`= #{name};")
PlayerLevel getPlayerLevel(@Param(value="name")
                                                                                                                     java.lang.String name)

listPlayerLevel

@Select(value="select `data` from `wclevel_playerdatas`;")
java.util.List<PlayerLevel> listPlayerLevel()

insertPlayerLevel

@Insert(value="insert INTO `wclevel_playerdatas`(name, exp, level) VALUES (#{name},#{exp},#{level})")
void insertPlayerLevel(PlayerLevel playerLevel)

updatePlayerLevel

@Update(value="update `wclevel_playerdatas` SET exp= #{exp}, level=#{level} WHERE name=#{name};")
void updatePlayerLevel(PlayerLevel playerLevel)