Java Yank.execute方法代码示例

import org.knowm.yank.Yank; //导入方法依赖的package包/类
public DbUser getUserData(IUser user){
    if(Karren.conf.getAllowSQLRW()) {
        if(!dbUserCache.containsKey(user.getStringID())) {
            String sql = "INSERT IGNORE User (UserID, TimeLeft) VALUES (?, null)";
            Object[] params = {user.getLongID()};
            Yank.execute(sql, params);
            sql = "SELECT * FROM User WHERE UserID=?";
            Object[] params2 = {user.getLongID()};
            DbUser dbUser = Yank.queryBean(sql, DbUser.class, params2);
            dbUserCache.put(user.getStringID(), dbUser);
            return dbUser;
        } else {
            return dbUserCache.get(user.getStringID());
        }
    }
    return null;
}
 

import org.knowm.yank.Yank; //导入方法依赖的package包/类
public DbGuild getGuild(IGuild guild){
    if(Karren.conf.getAllowSQLRW()){
        if(!dbGuildCache.containsKey(guild.getStringID())) {
            String sql = "INSERT IGNORE Guild (GuildID, GuildOwner, GuildName, CommandPrefix, RollDifficulty, MaxVolume, RandomRange, OverrideChannel) VALUES (?, ?, ?, null, -1, 40, 0, 0)";
            Object[] params = {guild.getStringID(), guild.getOwner().getName(), guild.getName()};
            Yank.execute(sql, params);
            sql = "SELECT * FROM Guild WHERE GuildID=?";
            Object[] params2 = {guild.getStringID()};
            DbGuild dbGuild = Yank.queryBean(sql, DbGuild.class, params2);
            dbGuildCache.put(guild.getStringID(), dbGuild);
            return dbGuild;
        } else {
            return dbGuildCache.get(guild.getStringID());
        }
    }
    return null;
}
 

import org.knowm.yank.Yank; //导入方法依赖的package包/类
public DbWordcount getWordCount(String word){
    if(Karren.conf.getAllowSQLRW()) {
        if(!dbWordcountCache.containsKey(word)) {
            String sql = "INSERT IGNORE WordCounts (WordID, Word, Count, CountStarted) VALUES (null, ?, 1, null)";
            Object[] params = {word};
            Yank.execute(sql, params);
            sql = "SELECT * FROM WordCounts WHERE Word=?";
            DbWordcount dbWordcount = Yank.queryBean(sql, DbWordcount.class, params);
            dbWordcountCache.put(word, dbWordcount);
            return dbWordcount;
        } else {
            return dbWordcountCache.get(word);
        }
    }
    return null;
}
 

import org.knowm.yank.Yank; //导入方法依赖的package包/类
@Override
public ItemsVO doCreateItemsTableIfNot(ItemsVO vo) {
    // boolean tableExists = Yank.queryScalar(SQL_IF_TABLE_EXISTS.replace("#searchTable#",
    // vo.getItemsManageTable().toUpperCase()), String.class, null) == null;
    boolean tableExists = doIfTableExists(vo);
    if (!tableExists) {
        String sql = StringUtilsExt.replaceArrayMerge(SQL_CREATE_ITEMS_TABLE_IF_NOT,
                new String[] { "#itemsManageTable#", "#colname#", "#coltype#" },
                new String[] { vo.getItemsManageTable().toUpperCase(), vo.getColname(), vo.getColtype() });
        logger.debug("JDBC::doCreateItemsTableIfNot tableExists={} therefore sql={}", tableExists, sql);
        Yank.execute(sql, null);
    } else {
        logger.debug("JDBC::doCreateItemsTableIfNot tableExists={}, did not CREATE TABLE", tableExists);
    }
    return vo;
}
 

import org.knowm.yank.Yank; //导入方法依赖的package包/类
/*************
 * ITEM DAOs *
 *************/
@Override
public void doStoreItemValue(Item item, ItemVO vo) {
    vo = storeItemValueProvider(item, vo);
    String sql = StringUtilsExt.replaceArrayMerge(SQL_INSERT_ITEM_VALUE,
            new String[] { "#tableName#", "#dbType#", "#tablePrimaryValue#" },
            new String[] { vo.getTableName(), vo.getDbType(), sqlTypes.get("tablePrimaryValue") });
    Object[] params = new Object[] { vo.getValue() };
    logger.debug("JDBC::doStoreItemValue sql={} value='{}'", sql, vo.getValue());
    Yank.execute(sql, params);
}
 

import org.knowm.yank.Yank; //导入方法依赖的package包/类
public void doStoreItemValue(Item item, ItemVO vo) {
    vo = storeItemValueProvider(item, vo);
    String sql = StringUtilsExt.replaceArrayMerge(SQL_INSERT_ITEM_VALUE,
            new String[] { "#tableName#", "#tablePrimaryValue#" },
            new String[] { vo.getTableName(), sqlTypes.get("tablePrimaryValue") });
    Object[] params = new Object[] { vo.getValue(), vo.getValue() };
    logger.debug("JDBC::doStoreItemValue sql={} value='{}'", sql, vo.getValue());
    Yank.execute(sql, params);
}
 

import org.knowm.yank.Yank; //导入方法依赖的package包/类
@Override
public ItemsVO doCreateItemsTableIfNot(ItemsVO vo) {
    String sql = StringUtilsExt.replaceArrayMerge(SQL_CREATE_ITEMS_TABLE_IF_NOT,
            new String[] { "#itemsManageTable#", "#colname#", "#coltype#" },
            new String[] { vo.getItemsManageTable(), vo.getColname(), vo.getColtype() });
    logger.debug("JDBC::doCreateItemsTableIfNot sql={}", sql);
    Yank.execute(sql, null);
    return vo;
}
 

import org.knowm.yank.Yank; //导入方法依赖的package包/类
@Override
public ItemsVO doCreateItemsTableIfNot(ItemsVO vo) {
    String sql = StringUtilsExt.replaceArrayMerge(SQL_CREATE_ITEMS_TABLE_IF_NOT,
            new String[] { "#itemsManageTable#", "#colname#", "#coltype#", "#itemsManageTable#" },
            new String[] { vo.getItemsManageTable(), vo.getColname(), vo.getColtype(), vo.getItemsManageTable() });
    logger.debug("JDBC::doCreateItemsTableIfNot sql={}", sql);
    Yank.execute(sql, null);
    return vo;
}
 

import org.knowm.yank.Yank; //导入方法依赖的package包/类
/*************
 * ITEM DAOs *
 *************/
@Override
public void doStoreItemValue(Item item, ItemVO vo) {
    vo = storeItemValueProvider(item, vo);
    String sql = StringUtilsExt.replaceArrayMerge(SQL_INSERT_ITEM_VALUE,
            new String[] { "#tableName#", "#dbType#", "#tableName#", "#tablePrimaryValue#" }, new String[] {
                    vo.getTableName(), vo.getDbType(), vo.getTableName(), sqlTypes.get("tablePrimaryValue") });
    Object[] params = new Object[] { vo.getValue() };
    logger.debug("JDBC::doStoreItemValue sql={} value='{}'", sql, vo.getValue());
    Yank.execute(sql, params);
}
 

import org.knowm.yank.Yank; //导入方法依赖的package包/类
/*************
 * ITEM DAOs *
 *************/
@Override
public void doCreateItemTable(ItemVO vo) {
    String sql = StringUtilsExt.replaceArrayMerge(SQL_CREATE_ITEM_TABLE,
            new String[] { "#tableName#", "#dbType#", "#tablePrimaryKey#" },
            new String[] { vo.getTableName(), vo.getDbType(), sqlTypes.get("tablePrimaryKey") });
    Yank.execute(sql, null);
}
 

import org.knowm.yank.Yank; //导入方法依赖的package包/类
@Override
public void doStoreItemValue(Item item, ItemVO vo) {
    vo = storeItemValueProvider(item, vo);
    String sql = StringUtilsExt.replaceArrayMerge(SQL_INSERT_ITEM_VALUE,
            new String[] { "#tableName#", "#dbType#", "#tablePrimaryValue#" },
            new String[] { vo.getTableName().toUpperCase(), vo.getDbType(), sqlTypes.get("tablePrimaryValue") });
    Object[] params = new Object[] { vo.getValue() };
    logger.debug("JDBC::doStoreItemValue sql={} value='{}'", sql, vo.getValue());
    Yank.execute(sql, params);
}
 

import org.knowm.yank.Yank; //导入方法依赖的package包/类
public void doDeleteItemsEntry(ItemsVO vo) {
    String sql = StringUtilsExt.replaceArrayMerge(SQL_DELETE_ITEMS_ENTRY, new String[] { "#itemname#" },
            new String[] { vo.getItemname() });
    logger.debug("JDBC::doDeleteItemsEntry sql={}", sql);
    Yank.execute(sql, null);
}
 

import org.knowm.yank.Yank; //导入方法依赖的package包/类
/*************
 * ITEM DAOs *
 *************/
public void doUpdateItemTableNames(List<ItemVO> vol) {
    String sql = updateItemTableNamesProvider(vol);
    Yank.execute(sql, null);
}
 

import org.knowm.yank.Yank; //导入方法依赖的package包/类
public void update(){
    String sql = "UPDATE Reminder SET ReminderSent=? WHERE ReminderID=?";
    Yank.execute(sql, new Object[]{reminderSent, reminderID});
}
 

import org.knowm.yank.Yank; //导入方法依赖的package包/类
public void update(){
    if(!notMapped) {
        String sql = "UPDATE GuildUser SET RollTimeout=?, IgnoreCommands=?, RollsSinceLastClear=?, TotalRolls=?, WinningRolls=? WHERE GuildUserID=?";
        Yank.execute(sql, new Object[]{rollTimeout, ignoreCommands, rollsSinceLastClear, totalRolls, winningRolls, guildUserID});
    }
}