Examples of com.iCo6.util.org.apache.commons.dbutils.BasicRowProcessor$CaseInsensitiveHashMap

Package com.iCo6.util.org.apache.commons.dbutils

Examples of com.iCo6.util.org.apache.commons.dbutils.BasicRowProcessor$CaseInsensitiveHashMap

com.iCo6.util.org.apache.commons.dbutils.QueryRunner
A Map that converts all keys to lowercase Strings for case insensitive lookups. This is needed for the toMap() implementation because databases don't consistenly handle the casing of column names.
The keys are stored as they are given [BUG #DBUTILS-34], so we maintain an internal mapping from lowercase keys to the real keys in order to achieve the case insensitive lookup.
Note: This implementation does not allow null for key, whereas {@link HashMap} does, because of the code:
```
 key.toString().toLowerCase() 
```

                    if(!Database.tableExists(Constants.Nodes.DatabaseTable.toString())) {
                        String SQL = Common.resourceToString("SQL/Core/Create-Table-" + Database.getType().toString().toLowerCase() + ".sql");
                        SQL = String.format(SQL, Constants.Nodes.DatabaseTable.getValue());


                        try {
                            QueryRunner run = new QueryRunner();
                            Connection c = iConomy.Database.getConnection();


                            try{
                                run.update(c, SQL);
                            } catch (SQLException ex) {
                                System.out.println("[iConomy] Error creating database: " + ex);
                            } finally {
                                DbUtils.close(c);
                            }

View Full Code Here

                } catch (SQLException ex) {
                    System.out.println(ex);
                    return;
                }


                QueryRunner run = new QueryRunner();


                try {
                    try{
                        run.query(old, "SELECT * FROM " + table, new ResultSetHandler(){
                            public Object handle(ResultSet rs) throws SQLException {
                                Account current = null;
                                Boolean next = rs.next();


                                if(next)

View Full Code Here


            return true;
        }


        try {
            QueryRunner run = new QueryRunner();
            Connection c = iConomy.Database.getConnection();


            try{
                String t = Constants.Nodes.DatabaseTable.toString();
                Integer amount = run.update(c, "INSERT INTO " + t + "(username, balance, status) values (?, ?, ?)", name.toLowerCase(), balance, status);


                if(amount > 0)
                    created = true;
            } catch (SQLException ex) {
                System.out.println("[iConomy] Error issueing SQL query: " + ex);

View Full Code Here


            return false;
        }


        try {
            QueryRunner run = new QueryRunner();
            Connection c = iConomy.Database.getConnection();


            try{
                String t = Constants.Nodes.DatabaseTable.toString();
                Integer amount = run.update(c, "DELETE FROM " + t + " WHERE username=?", name.toLowerCase());


                if(amount > 0)
                    removed = true;
            } catch (SQLException ex) {
                System.out.println("[iConomy] Error issueing SQL query: " + ex);

View Full Code Here


            return database.hasIndex(name);
        }


        try {
            QueryRunner run = new QueryRunner();
            Connection c = iConomy.Database.getConnection();


            try {
                String t = Constants.Nodes.DatabaseTable.toString();
                exists = run.query(c, "SELECT id FROM " + t + " WHERE username=?", returnBoolean, name.toLowerCase());
            } catch (SQLException ex) {
                System.out.println("[iConomy] Error issueing SQL query: " + ex);
            } finally {
                DbUtils.close(c);
            }

View Full Code Here


            return balance;
        }


        try {
            QueryRunner run = new QueryRunner();
            Connection c = iConomy.Database.getConnection();


            try{
                String t = Constants.Nodes.DatabaseTable.toString();
                balance = run.query(c, "SELECT balance FROM " + t + " WHERE username=?", returnBalance, name.toLowerCase());
            } catch (SQLException ex) {
                System.out.println("[iConomy] Error issueing SQL query: " + ex);
            } finally {
                DbUtils.close(c);
            }

View Full Code Here


            return;
        }


        try {
            QueryRunner run = new QueryRunner();
            Connection c = iConomy.Database.getConnection();


            try{
                String t = Constants.Nodes.DatabaseTable.toString();
                int update = run.update(c, "UPDATE " + t + " SET balance=? WHERE username=?", balance, name.toLowerCase());
            } catch (SQLException ex) {
                System.out.println("[iConomy] Error issueing SQL query: " + ex);
            } finally {
                DbUtils.close(c);
            }

View Full Code Here


        if(!useInventoryDB() && !useMiniDB() && !useOrbDB())
            Thrun.init(new Runnable() {
                public void run() {
                    try {
                        QueryRunner run = new QueryRunner();
                        Connection c = iConomy.Database.getConnection();


                        try{
                            run.batch(c, query, parameters);
                        } catch (SQLException ex) {
                            System.out.println("[iConomy] Error with batching: " + ex);
                        } finally {
                            DbUtils.close(c);
                        }

View Full Code Here

        }


        Thrun.init(new Runnable() {
            public void run() {
                try {
                    QueryRunner run = new QueryRunner();
                    Connection c = iConomy.Database.getConnection();


                    try {
                        String t = Constants.Nodes.DatabaseTable.toString();
                        Integer amount = run.update(c, "DELETE FROM " + t + " WHERE balance=?", Constants.Nodes.Balance.getDouble());
                    } catch (SQLException ex) {
                        System.out.println("[iConomy] Error issueing SQL query: " + ex);
                    } finally {
                        DbUtils.close(c);
                    }

View Full Code Here

        }


        Thrun.init(new Runnable() {
            public void run() {
                try {
                    QueryRunner run = new QueryRunner();
                    Connection c = iConomy.Database.getConnection();


                    try {
                        String t = Constants.Nodes.DatabaseTable.toString();
                        Integer amount = run.update(c, "TRUNCATE TABLE " + t);
                    } catch (SQLException ex) {
                        System.out.println("[iConomy] Error issueing SQL query: " + ex);
                    } finally {
                        DbUtils.close(c);
                    }

View Full Code Here

0 1 2 3 4 5 6 7 8

TOP

Related Classes of com.iCo6.util.org.apache.commons.dbutils.BasicRowProcessor$CaseInsensitiveHashMap

com.bekvon.bukkit.residence.economy.IConomy6Adapter

com.iCo6.command.exceptions.InvalidUsage

com.iCo6.command.Handler

com.iCo6.Constants.Drivers

com.iCo6.handlers.Create

com.iCo6.handlers.Empty

com.iCo6.handlers.Give

com.iCo6.handlers.Help

com.iCo6.handlers.Money

com.iCo6.handlers.Payment

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.