Examples of com.iCo6.util.org.apache.commons.dbutils.QueryLoader

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

Examples of com.iCo6.util.org.apache.commons.dbutils.QueryLoader

com.iCo6.util.org.apache.commons.dbutils.QueryRunner
QueryLoader is a registry for sets of queries so that multiple copies of the same queries aren't loaded into memory. This implementation loads properties files filled with query name to SQL mappings. This class is thread safe.

                    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.QueryLoader

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.