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

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

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

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

BeanProcessor matches column names to bean property names and converts ResultSet columns into objects for those bean properties. Subclasses should override the methods in the processing chain to customize behavior.

This class is thread-safe.
@see BasicRowProcessor @since DbUtils 1.1

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

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.