List of usage examples for org.springframework.jdbc.support.rowset SqlRowSet getDouble
double getDouble(String columnLabel) throws InvalidResultSetAccessException;
From source file:org.xeneo.db.recommendation.MarkovRecommendation.java
public void calcRecommendations() throws InvalidResultSetAccessException { List<String> caseTypeList = new ArrayList<String>(); List<RecommendationObject> recObjectList = new ArrayList<RecommendationObject>(); //retrieve the needed fields from the database String sql = "select a.CreationDate, tc.TaskURI, c.CaseTypeURI" + " from Activity as a" + " inner join TaskContext as tc" + " on a.ActivityURI = tc.ActivityURI" + " inner join `Case` as c" + " on tc.CaseURI = c.CaseURI" //+ " where a.CreationDate > '2012-06-13 15:44:42.0'" + " order by a.CreationDate"; System.out.println(sql);// w w w. j ava 2 s. c o m //mapps the returned row of the sql select to a list of DBEntries List<DBEntry> entryList = jdbcTemplate.query(sql, new DBEntryRowMapper()); //Iterate through the list of entries to extract all different CaseTypes //logger.info("extracting CaseTypes ..."); for (DBEntry entry : entryList) { if (!caseTypeList.contains(entry.getCaseTypeUri())) { caseTypeList.add(entry.getCaseTypeUri()); } } //logger.info("extracting recommendations ..."); for (String caseType : caseTypeList) { List<DBEntry> tmpList = new ArrayList<DBEntry>(); System.out.println("---------------------------" + caseType + "---------------------------------"); //seperate each CaseType in a List for (DBEntry entry : entryList) { if (entry.getCaseTypeUri().equals(caseType)) { tmpList.add(entry); } } //create RecommendationObjects for each CaseType for (int i = 0; i < tmpList.size() - 1; i++) { String pre = tmpList.get(i).getTaskUri(); String suc = tmpList.get(i + 1).getTaskUri(); double rel = tmpList.get(i + 1).getCreationDate().getTime() / 10000000000000.0; recObjectList.add(new RecommendationObject(caseType, pre, suc, rel)); //System.out.println(caseType+";"+pre+"; "+suc+"; "+rel); } } //insert RecommendationObjects in database for (RecommendationObject rec : recObjectList) { String caseTypeURI = rec.caseTypeURI; String predecessor = rec.predecessor; String successor = rec.successor; double relevance = rec.relevance; String sql1 = "select * from Recommendation" + " WHERE CaseTypeURI = '" + caseTypeURI + "' AND" + " Predecessor = '" + predecessor + "' AND" + " Successor = '" + successor + "'"; SqlRowSet rs = jdbcTemplate.queryForRowSet(sql1); if (rs.next()) { double oldrelevance = rs.getDouble("Relevance"); double newrelevance = oldrelevance + rec.relevance; String updatesql = "update Recommendation" + " SET Relevance = " + newrelevance + "" + " WHERE CaseTypeURI = '" + caseTypeURI + "' AND" + " Predecessor = '" + predecessor + "' AND" + " Successor = '" + successor + "'"; jdbcTemplate.update(updatesql); //update } else { String insertsql = "insert into Recommendation(CaseTypeURI, Predecessor, Successor, Relevance)" + " values('" + caseTypeURI + "','" + predecessor + "','" + successor + "'," + relevance + ")"; jdbcTemplate.execute(insertsql); //insert } } }
From source file:com.zousu.mongopresser.Presser.java
public void press() { //get a list of all the tables and columns logger.info("Starting MySQL to Mongo Conversion..."); logger.info("Preparing Tables..."); mySQLHandler.initialiseDatabase();//from w w w . ja va 2s .c o m List<Table> tables = mySQLHandler.getTableList(); for (int i = 0; i < tables.size(); i++) { Table table = tables.get(i); List<Column> columns = table.getColumns(); List<DBObject> dboList = new ArrayList<DBObject>(); SqlRowSet rs = mySQLHandler.selectAllFromTable(table.getTableName()); logger.info("Creating objects for " + table.getTableName() + "..."); while (rs.next()) { BasicDBObject dbo = new BasicDBObject(); for (int j = 0; j < columns.size(); j++) { Column col = columns.get(j); String colName = col.getColumnName(); switch (col.getType()) { case Types.INTEGER: case Types.BIGINT: dbo.append(colName, rs.getInt(colName)); break; case Types.DOUBLE: dbo.append(colName, rs.getDouble(colName)); break; case Types.DATE: dbo.append(colName, rs.getDate(colName)); break; default: dbo.append(colName, rs.getString(colName)); break; } } dboList.add(dbo); } //now insert it logger.info("Inserting " + dboList.size() + " mongo rows into " + table.getTableName() + "..."); table.setNumOfRows(dboList.size()); try { mongoHandler.createCollection(table.getTableName(), true); mongoHandler.batchInsert(dboList, table.getTableName()); assert (mongoHandler.getNumObjectsInCollection(table.getTableName()) == dboList.size()); logger.info(table.getTableName() + " DONE!"); } catch (CollectionExistException e) { e.printStackTrace(); } } logger.info(tables.size() + " collections added!"); //now check go get it from mongo and check if the data there is correct logger.info("Checking mongo consistency..."); for (int i = 0; i < tables.size(); i++) { Table table = tables.get(i); assert (mongoHandler.getNumObjectsInCollection(table.getTableName()) == table.getNumOfRows()); logger.info(table.getTableName() + " consistent!"); } logger.info("MySQL to Mongo Conversion Completed!!!!"); }
From source file:com.hygenics.parser.getDAOTemplate.java
/** * Called when needing a count of distincts or other numerical result. * Returns an Integer so only an integer should be used * /*from w w w . java2 s .c o m*/ * @param sql * @param columns * @return */ public double queryForDoubleString(String sql) { SqlRowSet rs = this.jdbcTemplateObject.queryForRowSet(sql); if (rs.next()) { if (rs.getMetaData().getColumnNames().length > 0) { return rs.getDouble(1); } } return 0; }
From source file:com.ardhi.businessgame.services.BusinessGameService.java
public String getSuggestedPrice(HttpServletRequest req) { //Suggested price still based on info_product //Lately, it must use a DSS based, like AHP, or any easier method.. String val = "0"; double price = 0; //Deciding price starts here : System.out.println(req.getParameter("id")); System.out.println(req.getParameter("id").substring(0, 2)); if (req.getParameter("id").substring(0, 2).equals("PR")) { val = "select price from desc_product where id=(select storage_product.[desc] from storage_product where id='" + req.getParameter("id") + "')"; }/*w w w.ja v a 2s. c o m*/ else if (req.getParameter("id").substring(0, 2).equals("EQ")) { val = "select price from desc_equipment where id=(select list_equipment.[desc] from list_equipment where id='" + req.getParameter("id") + "')"; } SqlRowSet srs = db.getJdbc().queryForRowSet(val); if (srs.next()) price = srs.getDouble("price"); else return "0"; //Deciding price ends here. srs = db.getJdbc().queryForRowSet( "select [zone] from user_market_license where [user]='" + req.getParameter("user") + "'"); ArrayList<String> marketZone = new ArrayList<String>(); while (srs.next()) { marketZone.add(srs.getString("zone")); } ArrayList<String> data = new ArrayList<String>(); data.add(gson.toJson(price)); data.add(gson.toJson(marketZone)); val = gson.toJson(data); marketZone = null; data = null; srs = null; gc(); return val; }
From source file:com.ardhi.businessgame.services.BusinessGameService.java
public String getBorrowedMoney(HttpServletRequest req) { String val = ""; double borrow; SqlRowSet srs = db.getJdbc() .queryForRowSet("select borrow from borrow_bank where [user]='" + req.getParameter("user") + "'"); if (srs.next()) borrow = srs.getDouble("borrow"); else//w w w.j a v a2 s. c o m return "1"; val = gson.toJson(borrow); return val; }
From source file:com.ardhi.businessgame.services.BusinessGameService.java
public String calculateFixPrice(HttpServletRequest req) { String val = ""; SqlRowSet srs = db.getJdbc().queryForRowSet( "select durability,buy_price from list_equipment where id='" + req.getParameter("id") + "'"); double price; if (srs.next()) price = ((100 - srs.getDouble("durability")) / 100) * srs.getDouble("buy_price"); else/*from w w w .j a v a2s . co m*/ return "0"; val = gson.toJson(price); return val; }
From source file:com.ardhi.businessgame.services.BusinessGameService.java
public String fixEquipment(HttpServletRequest req) { String val = "", sqls[]; double money, price; //0=internal error //1=uang user kurang SqlRowSet srs1 = db.getJdbc().queryForRowSet( "select money from businessgame.dbo.[user] where name='" + req.getParameter("user") + "'"), srs2; if (srs1.next()) money = srs1.getDouble("money"); else//from www.j a v a2 s .com return "0"; srs1 = db.getJdbc().queryForRowSet( "select durability,buy_price from list_equipment where id='" + req.getParameter("id") + "'"); if (srs1.next()) price = ((100 - srs1.getDouble("durability")) / 100) * srs1.getDouble("buy_price"); else return "0"; if (money < price) return "1"; money -= price; ArrayList<String> sqlL = new ArrayList<String>(); sqlL.add("update businessgame.dbo.[user] set money='" + (money) + "' where name='" + req.getParameter("user") + "'"); sqlL.add("update list_equipment set durability='95.00' where id='" + req.getParameter("id") + "'"); sqls = new String[sqlL.size()]; sqlL.toArray(sqls); db.getJdbc().batchUpdate(sqls); srs1 = db.getJdbc().queryForRowSet( "select storage_equipment.id,equipment,quality,durability,size,operational,draw from storage_equipment,list_equipment,desc_equipment,info_equipment where storage=(select id from storage where [user]='" + req.getParameter("user") + "' and [zone]=(select [zone] from businessgame.dbo.[user] where name='" + req.getParameter("user") + "')) and storage_equipment.id=list_equipment.id and list_equipment.[desc]=desc_equipment.id and name=equipment"); ArrayList<StorageEquipment> storageEquipments = new ArrayList<StorageEquipment>(); while (srs1.next()) { srs2 = db.getJdbc().queryForRowSet( "select market_equipment.id,equipment,market_equipment.price,quality,durability,size,operational,draw from storage_equipment,market_equipment,desc_equipment,list_equipment,info_equipment where storage_equipment_id='" + srs1.getString("id") + "' and storage_equipment.id=storage_equipment_id and list_equipment.id=storage_equipment.id and list_equipment.[desc]=desc_equipment.id and equipment=name"); if (!srs2.next()) { storageEquipments.add(new StorageEquipment(srs1.getString("id"), srs1.getString("equipment"), srs1.getInt("quality"), srs1.getDouble("durability"), srs1.getDouble("size"), srs1.getDouble("operational"), srs1.getString("draw"))); } } ArrayList<String> data = new ArrayList<String>(); data.add(gson.toJson(money)); data.add(gson.toJson(storageEquipments)); val = gson.toJson(data); data = null; storageEquipments = null; srs1 = null; srs2 = null; gc(); return val; }
From source file:com.ardhi.businessgame.services.BusinessGameService.java
public String buySectorBlueprint(HttpServletRequest req) { String val = "", idInc, sqls[]; double money, price, cost; int level, userLevel; ArrayList<String> sqlL = new ArrayList<String>(); //0=internal error //1=uang ga cukup //2=level belum cukup SqlRowSet srs = db.getJdbc().queryForRowSet( "select money,[level] from businessgame.dbo.[user] where name='" + req.getParameter("user") + "'"); if (srs.next()) { money = srs.getDouble("money"); userLevel = srs.getInt("level"); } else/*from w w w .j av a2s.c o m*/ return "0"; srs = db.getJdbc().queryForRowSet("select [value] from info_values where name='sector'"); if (srs.next()) { price = Double.parseDouble(srs.getString("value")); } else return "0"; srs = db.getJdbc() .queryForRowSet("select [level] from info_sector where name='" + req.getParameter("sector") + "'"); if (srs.next()) level = srs.getInt("level"); else return "0"; srs = db.getJdbc().queryForRowSet( "select sector from user_sector_blueprint where [user]='" + req.getParameter("user") + "'"); ArrayList<String> userSectors = new ArrayList<String>(); while (srs.next()) { userSectors.add(srs.getString("sector")); } price *= userSectors.size(); if (money < price) return "1"; if (userLevel < level) return "2"; money -= price; if (userLevel == level) userLevel = level + 1; idInc = getUniqueIncrementIdNew("user_sector_blueprint"); sqlL.add("insert into user_sector_blueprint values ('" + KEY_USER_SECTOR_BLUEPRINT + idInc + "','" + req.getParameter("user") + "','" + req.getParameter("sector") + "')"); sqlL.add("update businessgame.dbo.[user] set money='" + money + "', [level]='" + userLevel + "' where name='" + req.getParameter("user") + "'"); System.out.println("update businessgame.dbo.[user] set money='" + money + "', [level]='" + userLevel + "' where name='" + req.getParameter("user") + "'"); sqls = new String[sqlL.size()]; sqlL.toArray(sqls); db.getJdbc().batchUpdate(sqls); srs = db.getJdbc() .queryForRowSet("select cost from info_sector where name='" + req.getParameter("sector") + "'"); if (srs.next()) { cost = srs.getDouble("cost"); } else return "0"; ArrayList<String> data = new ArrayList<String>(); data.add(gson.toJson(money)); data.add(KEY_USER_SECTOR_BLUEPRINT + idInc); data.add(gson.toJson(cost)); val = gson.toJson(data); sqlL = null; sqls = null; idInc = null; srs = null; gc(); return val; }
From source file:com.ardhi.businessgame.services.BusinessGameService.java
public String advertiseProduct(HttpServletRequest req) { String val = "Ok", zone, idInc, sqls[]; double money, price; ArrayList<String> sqlL = new ArrayList<String>(); SqlRowSet srs = db.getJdbc().queryForRowSet( "select money,[zone] from businessgame.dbo.[user] where name='" + req.getParameter("user") + "'"); if (srs.next()) { zone = srs.getString("zone"); money = srs.getDouble("money"); } else// w ww . j av a 2 s . c o m return "0"; srs = db.getJdbc() .queryForRowSet("select price from desc_advertisement where id='" + req.getParameter("ads") + "'"); if (srs.next()) price = srs.getDouble("price") * Double.parseDouble(req.getParameter("turn")); else return "0"; if (money < price) return "1"; money -= price; sqlL.add("update businessgame.dbo.[user] set money='" + money + "' where name='" + req.getParameter("user") + "'"); // srs = db.getJdbc().queryForRowSet("select total from user_finance where user='"+req.getParameter("user")+"' and type='Advertisement'"); // if(srs.next()){ // sqlL.add("update user_finance set total='"+(((srs.getDouble("total")*-1)+price)*-1)+"' where user='"+req.getParameter("user")+"' and type='Advertisement'"); // } else { // idInc = getUniqueIncrementIdNew("user_finance"); // sqlL.add("insert into user_finance values ('"+KEY_USER_FINANCE+idInc+"','"+req.getParameter("user")+"','Raw Material','"+(-1*price)+"')"); // } accountingFinance(req.getParameter("user"), "Advertisement", price, false); srs = db.getJdbc() .queryForRowSet("select id,turn from product_advertisement where [user]='" + req.getParameter("user") + "' and product='" + req.getParameter("product") + "' and [zone]='" + zone + "' and ads='" + req.getParameter("ads") + "'"); if (srs.next()) sqlL.add("update product_advertisement set turn='" + (srs.getLong("turn") + (Long.parseLong(req.getParameter("turn")))) + "' where id='" + srs.getString("id") + "'"); else { idInc = getUniqueIncrementIdNew("product_advertisement"); sqlL.add("insert into product_advertisement values ('" + KEY_PRODUCT_ADVERTISEMENT + idInc + "','" + req.getParameter("user") + "','" + req.getParameter("product") + "','" + zone + "','" + req.getParameter("ads") + "','" + req.getParameter("turn") + "')"); } sqls = new String[sqlL.size()]; sqlL.toArray(sqls); db.getJdbc().batchUpdate(sqls); val = gson.toJson(money); 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 w w w . ja va 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; }