Example usage for org.springframework.jdbc.support.rowset SqlRowSet getString

List of usage examples for org.springframework.jdbc.support.rowset SqlRowSet getString

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.support.rowset.*
  5. SqlRowSet
  6. getString

Introduction

In this page you can find the example usage for org.springframework.jdbc.support.rowset SqlRowSet getString.

Prototype

String getString(String columnLabel) throws InvalidResultSetAccessException;

Source Link

Document

Retrieve the value of the indicated column in the current row as a String.

Usage

From source file:com.ardhi.businessgame.services.BusinessGameService.java

/**
 * Generate the 13-digit unique id based on the current time millis provided by the system
 * (System.currentTimeMillis()) plus 3-digit incremental value.
 * //from  w  ww. ja va  2 s  .c o m
 * @param table The table that'll be used.
 * @return The 13-digit unique id plus 3-digit incremental value.
 */
private String getUniqueIncrementIdNew(String table) {
    String val = "", sqls[];
    int counter;
    long curMillis, millis;
    ArrayList<String> sqlL = new ArrayList<String>();

    SqlRowSet srs = db.getJdbc().queryForRowSet("select [value] from info_values where name='inc_" + table
            + "' union select [value] from info_values where name='last_inc_set_millis'");
    if (srs.next()) {
        counter = Integer.parseInt(srs.getString("value"));
    } else
        return val;

    curMillis = System.currentTimeMillis();

    if (srs.next())
        millis = Long.parseLong(srs.getString("value"));
    else
        return val;

    if (millis < curMillis) {
        millis = curMillis;
        counter = 0;
        sqlL.add("update info_values set [value]='" + millis + "' where name='last_inc_set_millis'");
        sqlL.add("update info_values set [value]='0' where substring(name,1,4)='inc_'");
    }

    if (counter > 99)
        val = "" + counter;
    else if (counter > 9)
        val = "0" + counter;
    else
        val = "00" + counter;
    sqlL.add("update info_values set [value]='" + (counter + 1) + "' where name='inc_" + table + "'");

    sqls = new String[sqlL.size()];
    sqlL.toArray(sqls);
    db.getJdbc().batchUpdate(sqls);

    return millis + val;
}

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String loadPlayerInfo(HttpServletRequest req) {
    String val = "", email, dob, about;
    long rep;/*  w w w .  ja v  a2 s.  c  o m*/
    SqlRowSet srs1 = db.getJdbc()
            .queryForRowSet("select email,dob,about,rep from businessgame.dbo.[user] where name='"
                    + req.getParameter("player") + "'"),
            srs2, srs3;
    if (srs1.next()) {
        email = srs1.getString("email");
        dob = srs1.getString("dob");
        about = srs1.getString("about");
        rep = srs1.getLong("rep");
    } else
        return "0";

    srs1 = db.getJdbc()
            .queryForRowSet("select type from installment where [user]='" + req.getParameter("player") + "'");
    ArrayList<String> installments = new ArrayList<String>(), outputs = new ArrayList<String>();
    ArrayList<ArrayList<Double>> prices = new ArrayList<ArrayList<Double>>();
    ArrayList<Double> tmpPrices;
    while (srs1.next()) {
        if (!installments.contains(srs1.getString("type")))
            installments.add(srs1.getString("type"));
        srs2 = db.getJdbc().queryForRowSet("select output_type from info_sector_output where sector='"
                + srs1.getString("type") + "' and output_type!='Energy'");
        while (srs2.next()) {
            if (!outputs.contains(srs2.getString("output_type"))) {
                tmpPrices = new ArrayList<Double>();
                outputs.add(srs2.getString("output_type"));
                srs3 = db.getJdbc().queryForRowSet("select price from desc_product where product='"
                        + srs2.getString("output_type") + "' order by quality asc");
                //               System.out.println("select price from desc_product where product='"+srs2.getString("output_type")+"' order by quality asc");
                while (srs3.next()) {
                    //                  System.out.println(srs3.getDouble("price"));
                    tmpPrices.add(srs3.getDouble("price"));
                }
                prices.add(tmpPrices);
                tmpPrices = null;
            }
        }
    }

    srs1 = db.getJdbc().queryForRowSet("select quality from info_quality order by quality asc");
    ArrayList<Integer> qualities = new ArrayList<Integer>();
    while (srs1.next()) {
        qualities.add(srs1.getInt("quality"));
    }

    for (int i = 0; i < outputs.size(); i++) {
        for (int j = 0; j < qualities.size(); j++) {
            //            System.out.println(outputs.get(i)+" - "+qualities.get(j)+" at "+prices.get(i).get(j));
        }
    }

    ArrayList<String> data = new ArrayList<String>();
    data.add(email);
    data.add(dob);
    data.add(about);
    data.add(gson.toJson(rep));
    data.add(gson.toJson(installments));
    data.add(gson.toJson(outputs));
    data.add(gson.toJson(qualities));
    data.add(gson.toJson(prices));

    val = gson.toJson(data);

    srs1 = null;
    data = null;
    email = null;
    about = null;
    installments = null;
    outputs = null;
    qualities = null;
    prices = null;
    tmpPrices = null;

    gc();

    return val;
}

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String buyMarketEquipment(HttpServletRequest req) {
    String val = "0", seller, user, userZone, equipmentIdSeller, sqls[];
    double userMoney, sellerMoney, price, storage = 0, size;
    int level;// w ww.ja va2 s .  com
    ArrayList<String> sqlL = new ArrayList<String>();

    //0 = internal error
    //1 = produk dah abis
    //2 = uang ga cukup
    //3 = storage ga ada
    //4 = storage ga cukup

    SqlRowSet srs = db.getJdbc().queryForRowSet(
            "select name,money,[zone] from businessgame.dbo.[user] where name=(select [user] from storage where id='"
                    + req.getParameter("storage") + "')");
    if (srs.next()) {
        user = srs.getString("name");
        userMoney = srs.getDouble("money");
        userZone = srs.getString("zone");
    } else
        return "0";

    srs = db.getJdbc().queryForRowSet(
            "select storage_equipment_id,market_equipment.price,size,name,money from market_equipment,list_equipment,desc_equipment,[user],storage,storage_equipment where market_equipment.id='"
                    + req.getParameter("equipmentId")
                    + "' and storage_equipment.id=list_equipment.id and storage_equipment_id=storage_equipment.id and list_equipment.[desc]=desc_equipment.id and storage_equipment_id=list_equipment.id and storage.id=storage_equipment.storage and [user].name=storage.[user]");
    if (srs.next()) {
        price = srs.getDouble("price");
        size = srs.getDouble("size");
        equipmentIdSeller = srs.getString("storage_equipment_id");
        seller = srs.getString("name");
        sellerMoney = srs.getDouble("money");
    } else
        return "1";

    if (userMoney < price)
        return "2";

    userMoney -= price;

    srs = db.getJdbc()
            .queryForRowSet("select [level] from storage where id='" + req.getParameter("storage") + "'");
    if (srs.next()) {
        level = srs.getInt("level") - 1;
    } else
        return "3";

    srs = db.getJdbc().queryForRowSet(
            "select [value] from info_values where name='storage' union select [value] from info_values where name='storage_inc'");
    if (srs.next()) {
        storage = Double.parseDouble(srs.getString("value"));
    } else
        return "0";

    if (srs.next()) {
        storage += level * Double.parseDouble(srs.getString("value"));
    } else
        return "0";

    srs = db.getJdbc().queryForRowSet("select id,size from storage_product where storage='"
            + req.getParameter("storage")
            + "' union select storage_equipment.id,size from storage_equipment,desc_equipment,list_equipment,storage where storage='"
            + req.getParameter("storage")
            + "' and list_equipment.id=storage_equipment.id and list_equipment.[desc]=desc_equipment.id and storage.id=storage_equipment.storage");
    while (srs.next()) {
        storage -= srs.getDouble("size");
    }

    if (storage < size)
        return "4";

    sqlL.add("update storage_equipment set storage='" + req.getParameter("storage") + "' where id='"
            + equipmentIdSeller + "'");

    sqlL.add("update list_equipment set buy_price='" + price + "' where id='" + equipmentIdSeller + "'");

    sqlL.add("delete from market_equipment where id='" + req.getParameter("equipmentId") + "'");

    sqlL.add("update businessgame.dbo.[user] set money='" + userMoney + "' where name='" + user + "'");

    if (!seller.equals("")) {
        sellerMoney += price;
        sqlL.add("update businessgame.dbo.[user] set money='" + sellerMoney + "' where name='" + seller + "'");
    }

    sqls = new String[sqlL.size()];
    sqlL.toArray(sqls);
    db.getJdbc().batchUpdate(sqls);

    srs = db.getJdbc().queryForRowSet(
            "select market_equipment.id,storage.[user],equipment,market_equipment.price,quality,durability,size,operational,draw from market_equipment,storage_equipment,desc_equipment,list_equipment,storage,info_equipment where market_equipment.[zone]='"
                    + userZone
                    + "' and storage_equipment.id=storage_equipment_id and list_equipment.id=storage_equipment.id and list_equipment.[desc]=desc_equipment.id and storage.id=storage_equipment.storage and equipment=name");
    ArrayList<MarketEquipment> equipments = new ArrayList<MarketEquipment>();
    while (srs.next()) {
        equipments
                .add(new MarketEquipment(srs.getString("id"), srs.getString("user"), srs.getString("equipment"),
                        srs.getDouble("price"), srs.getInt("quality"), srs.getDouble("durability"),
                        srs.getDouble("size"), srs.getDouble("operational"), srs.getString("draw")));
    }

    ArrayList<String> data = new ArrayList<String>();
    data.add(gson.toJson(userMoney));
    data.add(gson.toJson(equipments));

    val = gson.toJson(data);

    sqlL = null;
    equipments = null;
    data = null;
    sqls = null;
    srs = null;
    seller = null;
    user = null;
    userZone = null;
    equipmentIdSeller = null;

    gc();

    return val;
}

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String loadUserData(HttpServletRequest req) {
    String val = "";
    SqlRowSet srs = db.getJdbc()
            .queryForRowSet("select id,sender,message,unread from user_message where recipient='"
                    + req.getParameter("user") + "'");
    ArrayList<String> data = new ArrayList<String>();
    ArrayList<Message> messages = new ArrayList<Message>();
    while (srs.next()) {
        messages.add(new Message(srs.getString("id"), srs.getString("sender"), srs.getString("message"),
                (srs.getBoolean("unread"))));
    }/* ww w.  ja  v a  2 s.com*/

    data.add(gson.toJson(messages));
    val = gson.toJson(data);

    messages = null;
    data = null;

    gc();

    return val;
}

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String payBorrowedMoney(HttpServletRequest req) {
    String val = "", sqls[], idBorrow;
    double money, loan, pay;
    ArrayList<String> sqlL = new ArrayList<String>();

    //0 = internal error
    //1 = uang lebih kecil dari pay

    SqlRowSet srs = db.getJdbc()
            .queryForRowSet("select id,money,borrow from businessgame.dbo.[user],borrow_bank where name='"
                    + req.getParameter("user") + "' and name=[user]");
    if (srs.next()) {
        money = srs.getDouble("money");
        loan = srs.getDouble("borrow");
        idBorrow = srs.getString("id");
    } else/*from www.  ja  v a  2  s .  co  m*/
        return "0";

    pay = Double.parseDouble(req.getParameter("pay"));

    if (money < pay)
        return "1";

    if (pay > loan)
        pay = loan;

    loan -= pay;

    money -= pay;

    sqlL.add("update businessgame.dbo.[user] set money=" + money + " where name='" + req.getParameter("user")
            + "'");
    if (loan > 0)
        sqlL.add("update borrow_bank set borrow=" + loan + " where id='" + idBorrow + "'");
    else
        sqlL.add("delete from borrow_bank where id='" + idBorrow + "'");

    sqls = new String[sqlL.size()];
    sqlL.toArray(sqls);
    db.getJdbc().batchUpdate(sqls);

    val = gson.toJson(money);

    sqlL = null;
    sqls = null;
    srs = null;

    gc();

    return val;
}

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String buyBundleEquipmentEmployee(HttpServletRequest req) {
    String val = "", sqls[], user, idInc;
    int quality, items;
    double total = 0, userMoney;
    ArrayList<String> sqlL = new ArrayList<String>();

    //0=internal error
    //1=uang ga cukup

    SqlRowSet srs1 = db.getJdbc().queryForRowSet("select money,type,[user] from installment,[user] where id='"
            + req.getParameter("installment") + "' and [user]=name"), srs2;
    if (srs1.next()) {
        System.out.println("Tes 1");
        userMoney = srs1.getDouble("money");
        user = srs1.getString("user");
        if (req.getParameter("quality") == null) {
            srs2 = db.getJdbc().queryForRowSet("select quality from info_quality where from_base='1'");
            if (srs2.next())
                quality = srs2.getInt("quality");
            else/*  w  ww.  j  a va2 s.  c  om*/
                return "0";
        } else
            quality = Integer.parseInt(req.getParameter("quality"));

        System.out.println("Tes 2");

        srs2 = db.getJdbc().queryForRowSet(
                "select desc_equipment.id,price,items from desc_equipment,info_sector_equipment where sector='"
                        + srs1.getString("type") + "' and quality='" + quality
                        + "' and equipment=equipment_type");
        while (srs2.next()) {
            items = srs2.getInt("items");
            total += srs2.getDouble("price") * items;
            for (int i = 0; i < items; i++) {
                idInc = getUniqueIncrementIdNew("equipment");
                sqlL.add("insert into list_equipment values('" + KEY_EQUIPMENT + idInc + "','"
                        + srs2.getString("id") + "','100','" + srs2.getDouble("price") + "')");
                sqlL.add("insert into installment_equipment values ('" + KEY_EQUIPMENT + idInc + "','"
                        + req.getParameter("installment") + "')");
            }
        }

        System.out.println("Tes 3");

        srs2 = db.getJdbc().queryForRowSet(
                "select desc_employee.id,price,items from desc_employee,info_sector_employee where sector='"
                        + srs1.getString("type") + "' and quality='" + quality
                        + "' and employee=employee_type");
        while (srs2.next()) {
            items = srs2.getInt("items");
            total += srs2.getDouble("price") * items;
            for (int i = 0; i < items; i++) {
                idInc = getUniqueIncrementIdNew("employee");
                sqlL.add("insert into list_employee values ('" + KEY_EMPLOYEE + idInc + "','"
                        + srs2.getString("id") + "')");
                sqlL.add("insert into installment_employee values ('" + KEY_EMPLOYEE + idInc + "','"
                        + req.getParameter("installment") + "')");
            }
        }

        System.out.println("Tes 4");

        if (userMoney < total)
            return "1";

        userMoney -= total;
        sqlL.add("update businessgame.dbo.[user] set money='" + userMoney + "' where name='" + user + "'");

        sqls = new String[sqlL.size()];
        sqlL.toArray(sqls);
        db.getJdbc().batchUpdate(sqls);

        val = gson.toJson(userMoney);

    } else
        return "0";

    sqlL = null;
    sqls = null;
    srs1 = null;
    srs2 = null;
    user = null;
    idInc = null;

    gc();

    return val;
}

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String cancelRejectContract(HttpServletRequest req) {
    String val = "0";
    SqlRowSet srs1 = db.getJdbc()
            .queryForRowSet("select request_storage,supplier_storage,turn from user_contract where id='"
                    + req.getParameter("id") + "' and accept='1'"),
            srs2, srs3;//from   w  ww.ja  va  2 s .c  om
    if (srs1.next()) {
        srs2 = db.getJdbc().queryForRowSet("select [user],[zone] from storage where id='"
                + srs1.getString("request_storage") + "' union select [user],[zone] from storage where id='"
                + srs1.getString("supplier_storage") + "'");
        if (srs2.next()) {
            if (!srs2.getString("user").equals(req.getParameter("user"))) {
                srs3 = db.getJdbc().queryForRowSet("select rep from businessgame.dbo.[user] where name='"
                        + req.getParameter("user") + "'");
                db.getJdbc()
                        .execute("update businessgame.dbo.[user] set rep='"
                                + (srs3.getLong("rep") - (srs1.getInt("turn") * 5)) + "' where name='"
                                + req.getParameter("user") + "'");
            }
        } else
            return "0";
    }

    db.getJdbc().execute("delete from user_contract where id='" + req.getParameter("id") + "'");
    val = "Ok";

    srs1 = null;
    srs2 = null;
    srs3 = null;

    gc();

    return val;
}

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String loadSectorOwned(HttpServletRequest req) {
    String val = "0";

    SqlRowSet srs = db.getJdbc()
            .queryForRowSet("select sector,cost from user_sector_blueprint,info_sector where [user]='"
                    + req.getParameter("user") + "' and sector=name");
    ArrayList<String> userSectors = new ArrayList<String>();
    ArrayList<Double> sectorCosts = new ArrayList<Double>();
    while (srs.next()) {
        userSectors.add(srs.getString("sector"));
        sectorCosts.add(srs.getDouble("cost"));
    }//from  ww  w  .j  av  a2s. c  o m

    srs = db.getJdbc().queryForRowSet(
            "select cost from info_zone where id=(select [zone] from businessgame.dbo.[user] where name='"
                    + req.getParameter("user") + "')");
    double price;
    if (srs.next()) {
        price = srs.getDouble("cost");
    } else
        return "0";

    ArrayList<String> data = new ArrayList<String>();
    data.add(gson.toJson(userSectors));
    data.add(gson.toJson(sectorCosts));
    data.add(gson.toJson(price));

    val = gson.toJson(data);

    userSectors = null;
    sectorCosts = null;
    data = null;
    srs = null;

    gc();

    return val;
}

From source file:com.ardhi.businessgame.services.BusinessGameService.java

/**
 * Take the user's activity into account. Specifically, record the flow of money to/from
 * specified user. //from   ww w  .  j ava 2s . c o m
 * 
 * @param user The user that take into account.
 * @param type The type of account.
 * @param amount The amount of money that take into account.
 * @param isIncome If it is an income, mark as true, otherwise must be false.
 */
private void accountingFinance(String user, String type, double amount, boolean isIncome) {
    String sqls[], idInc;
    SqlRowSet srs;
    ArrayList<String> sqlL = new ArrayList<String>();
    int factor = isIncome ? 1 : -1;

    srs = db.getJdbc().queryForRowSet(
            "select id,total from user_finance where [user]='" + user + "' and type='" + type + "'");
    if (srs.next()) {
        sqlL.add("update user_finance set total='" + (((srs.getDouble("total") * factor) + amount) * factor)
                + "' where id='" + srs.getString("id") + "'");
    } else {
        idInc = getUniqueIncrementIdNew("user_finance");
        sqlL.add("insert into user_finance values ('" + KEY_USER_FINANCE + idInc + "','" + user + "','" + type
                + "','" + (factor * amount) + "')");
    }

    sqls = new String[sqlL.size()];
    sqlL.toArray(sqls);
    db.getJdbc().batchUpdate(sqls);

    srs = null;
    sqlL = null;
    sqls = null;
    idInc = null;

    gc();
}

From source file:com.ardhi.businessgame.services.BusinessGameService.java

public String detachEquipment(HttpServletRequest req) {
    String val = "0", idStorage, sqls[];
    ArrayList<String> sqlL = new ArrayList<String>();
    SqlRowSet srs;

    //0 = internal error
    //1 = user belum memiliki storage

    srs = db.getJdbc()//from www.j a  va 2s .c o m
            .queryForRowSet("select id from storage where [user]='" + req.getParameter("user")
                    + "' and [zone]=(select [zone] from businessgame.dbo.[user] where name='"
                    + req.getParameter("user") + "')");
    if (srs.next())
        idStorage = srs.getString("id");
    else
        return "1";

    sqlL.add("delete from installment_equipment where id='" + req.getParameter("idEquipment") + "'");

    sqlL.add("insert into storage_equipment values ('" + req.getParameter("idEquipment") + "','" + idStorage
            + "')");

    sqls = new String[sqlL.size()];
    sqlL.toArray(sqls);
    db.getJdbc().batchUpdate(sqls);

    srs = db.getJdbc().queryForRowSet(
            "select installment_equipment.id,equipment,quality,durability,size,operational,draw from installment_equipment,desc_equipment,list_equipment,info_equipment where installment='"
                    + req.getParameter("id")
                    + "' and installment_equipment.id=list_equipment.id and list_equipment.[desc]=desc_equipment.id and name=equipment");
    ArrayList<InstallmentEquipment> equipments = new ArrayList<InstallmentEquipment>();
    while (srs.next()) {
        equipments.add(new InstallmentEquipment(srs.getString("id"), srs.getString("equipment"),
                srs.getInt("quality"), srs.getDouble("durability"), srs.getDouble("size"),
                srs.getDouble("operational"), srs.getString("draw")));
    }

    Installment installment = getSingleUserInstallments(req.getParameter("id"));

    ArrayList<String> data = new ArrayList<String>();
    data.add(gson.toJson(equipments));
    data.add(gson.toJson(installment));

    val = gson.toJson(data);

    equipments = null;
    installment = null;
    data = null;
    sqlL = null;
    sqls = null;
    idStorage = null;
    srs = null;

    gc();

    return val;
}