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

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

625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
        if (useOrbDB())
            return (iConomy.Server.getPlayer(name) != null) ? 1 : (database.hasIndex(name)) ? database.getArguments(name).getInteger("status") : 0;

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

            try{
                String t = Constants.Nodes.DatabaseTable.toString();
                status = run.query(c, "SELECT status FROM " + t + " WHERE username=?", returnStatus, name.toLowerCase());
            } catch (SQLException ex) {
                System.out.println("[iConomy] Error issueing SQL query: " + ex);
            } finally {
                DbUtils.close(c);
            }
View Full Code Here
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
            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 status=? WHERE username=?", status, name.toLowerCase());
            } catch (SQLException ex) {
                System.out.println("[iConomy] Error issueing SQL query: " + ex);
            } finally {
                DbUtils.close(c);
            }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
    public boolean tableExists(String table) {
        boolean exists = false;

        try {
            Connection conn = getConnection();
            QueryRunner run = new QueryRunner();

            try {
                String t = Constants.Nodes.DatabaseTable.toString();
                exists = run.query(conn, "SELECT id FROM " + table, returnBoolean);
            }  finally {
                DbUtils.close(conn);
            }
        } catch (SQLException e) {
            exists = false;
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
            return accounts;
        }

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

            try{
                String t = Constants.Nodes.DatabaseTable.toString();
                accounts = run.query(c, "SELECT username FROM " + t, returnList);
            } catch (SQLException ex) {
                System.out.println("[iConomy] Error issueing SQL query: " + ex);
            } finally {
                DbUtils.close(c);
            }
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
                    total.add(p.getName());

            total.addAll(database.getIndices().keySet());
        } else {
            try {
                QueryRunner run = new QueryRunner();
                Connection c = iConomy.Database.getConnection();

                try{
                    String t = Constants.Nodes.DatabaseTable.toString();
                    total = run.query(c, "SELECT username FROM " + t + " WHERE status <> 1 ORDER BY balance DESC LIMIT " + amount, returnList);
                } catch (SQLException ex) {
                    System.out.println("[iConomy] Error issueing SQL query: " + ex);
                } finally {
                    DbUtils.close(c);
                }
View Full Code Here
354
355
356
357
358
359
360
361
362
363
364
                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
TOP

Related Classes of com.iCo6.util.org.apache.commons.dbutils.QueryRunner

  • 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
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.