public static ArrayList<Object> updateMerchantStatus(String id, String stat) { Mysql mysqlObj = new Mysql(); ArrayList arrList = null; ArrayList arrList1 = null; try { String selsql = "SELECT * " + " FROM mid_client_pg " + " WHERE pg_id = " + id; arrList1 = mysqlObj.resultSetToArrayList(selsql); if (arrList1 != null) { String updtmcp = "UPDATE mid_client_pg " + " SET is_active = ? " + " WHERE pg_id = ? "; PreparedStatement pstmt = mysqlObj.queryUpdate(updtmcp); pstmt.setString(1, stat); pstmt.setString(2, id); pstmt.executeUpdate(); // issue invalid query pstmt.close(); } } catch (Exception ex) { // err } return arrList; }
public static ArrayList<Object> clientLists() { Mysql mysqlObj = new Mysql(); ArrayList<Object> arrList = null; try { String sql = "SELECT * FROM `client_master`"; arrList = mysqlObj.resultSetToArrayList(sql); } catch (SQLException ex) { // err Log.logger.warning("Currency List Exception " + ex.toString()); } return arrList; }
public void addOnlinePlayer(Player player) { ResultSet playerDB = mysql.executeQuery( "SELECT * FROM SpleexStats WHERE playerName = '" + player.getDisplayName() + "'"); if (!mysql.isEmpty(playerDB)) { mysql.next(playerDB); } else { mysql.executeUpdate( "INSERT INTO SpleexStats (playerName, wins, deaths, blocksDestroyed) VALUES('" + player.getDisplayName() + "', 0, 0, 0)"); } onlinePlayer.put(player, new OnlinePlayer(player)); player.teleport(WORLD_SPAWN); }
public void increaseStatValue(Player player, String statName, int value) { mysql.executeUpdate( "UPDATE SpleexStats SET " + statName + " = " + statName + " + " + value + " WHERE playerName = '" + player.getDisplayName() + "'"); }