Example usage for org.apache.commons.dbutils QueryRunner QueryRunner

Introduction

In this page you can find the example usage for org.apache.commons.dbutils QueryRunner QueryRunner.

Prototype

public QueryRunner(DataSource ds) 

Source Link

Document

Constructor for QueryRunner that takes a DataSource to use.

Usage

From source file:azkaban.database.AzkabanDatabaseSetupTest.java

private static void clearMySQLTestDB() throws SQLException {
    Props props = new Props();
    props.put("database.type", "mysql");
    props.put("mysql.host", "localhost");
    props.put("mysql.port", "3306");
    props.put("mysql.database", "");
    props.put("mysql.user", "root");
    props.put("mysql.password", "");
    props.put("mysql.numconnections", 10);

    DataSource datasource = DataSourceUtils.getDataSource(props);
    QueryRunner runner = new QueryRunner(datasource);
    try {/*w w  w  .j  av a 2s.  co m*/
        runner.update("drop database azkabanunittest");
    } catch (SQLException e) {
    }
    runner.update("create database azkabanunittest");
}

---

From source file:com.pinterest.deployservice.db.DBGroupDAOImpl.java

@Override
public void removeGroupCapacity(String envId, String group) throws Exception {
    new QueryRunner(dataSource).update(DELETE_GROUP, group, envId);
}

---

From source file:com.pinterest.deployservice.db.DBAgentDAOImpl.java

@Override
public void update(String hostId, String envId, AgentBean agentBean) throws Exception {
    SetClause setClause = agentBean.genSetClause();
    String clause = String.format(UPDATE_AGENT_TEMPLATE, setClause.getClause());
    setClause.addValue(hostId);/*from   ww w  .j a  va 2s .co m*/
    setClause.addValue(envId);
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}

---

From source file:com.pinterest.deployservice.db.DBDeployDAOImpl.java

@Override
public DeployQueryResultBean getAllDeploys(DeployQueryFilter filterBean) throws Exception {
    QueryRunner run = new QueryRunner(dataSource);
    ResultSetHandler<List<DeployBean>> h = new BeanListHandler<>(DeployBean.class);

    String queryStr;/*from w ww.  j  ava2 s. c  o  m*/
    if (StringUtils.isNotEmpty(filterBean.getFilter().getCommit())) {
        // TODO pretty hacky
        // It is very important to delete the commit from the filter, since we
        // want to return all deploys with commits later than this commit
        filterBean.getFilter().setCommit(null);
        filterBean.generateClauseAndValues();
        queryStr = String.format(GET_ALL_DEPLOYMENTS_WITH_COMMIT_TEMPLATE, filterBean.getWhereClause());
    } else {
        filterBean.generateClauseAndValues();
        queryStr = String.format(GET_ALL_DEPLOYMENTS_TEMPLATE, filterBean.getWhereClause());
    }

    Connection connection = dataSource.getConnection();
    try {
        List<DeployBean> deployBeans = run.query(connection, queryStr, h, filterBean.getValueArray());
        long total = run.query(connection, FOUND_ROWS, SingleResultSetHandlerFactory.newObjectHandler());
        long maxToReturn = filterBean.getFilter().getPageIndex() * filterBean.getFilter().getPageSize();
        return new DeployQueryResultBean(deployBeans, total, total > maxToReturn);
    } finally {
        DbUtils.closeQuietly(connection);
    }
}

---

From source file:com.eryansky.core.db.DbUtilsDao.java

/**
 * sql?,?????//from ww w.j a v a2  s.  co m
 * <br>?.
 * @param sql
 *            sql?
 * @param params
 *            ?
 * @return ??
 * @deprecated
 */
public int update(String sql, Object[] params) throws DaoException {
    queryRunner = new QueryRunner(dataSource);
    int affectedRows = 0;
    try {
        if (params == null) {
            affectedRows = queryRunner.update(sql);
        } else {
            affectedRows = queryRunner.update(sql, params);
        }
    } catch (SQLException e) {
        logger.error("Error occured while attempting to update data", e);
        throw new DaoException(e);
    }
    return affectedRows;
}

---

From source file:io.apiman.manager.api.jdbc.JdbcMetricsAccessor.java

/**
 * @see io.apiman.manager.api.core.IMetricsAccessor#getUsage(java.lang.String, java.lang.String, java.lang.String, io.apiman.manager.api.beans.metrics.HistogramIntervalType, org.joda.time.DateTime, org.joda.time.DateTime)
 *///from  w w w  . ja  v a  2  s  .c o m
@Override
public UsageHistogramBean getUsage(String organizationId, String apiId, String version,
        HistogramIntervalType interval, DateTime from, DateTime to) {
    UsageHistogramBean rval = new UsageHistogramBean();
    Map<Long, UsageDataPoint> index = generateHistogramSkeleton(rval, from, to, interval, UsageDataPoint.class,
            Long.class);

    try {
        QueryRunner run = new QueryRunner(ds);
        String gbColumn = groupByColumn(interval);
        String sql = "SELECT " + gbColumn //$NON-NLS-1$
                + ", count(*) FROM gw_requests WHERE api_org_id = ? AND api_id = ? AND api_version = ? AND rstart >= ? AND rstart < ? GROUP BY " //$NON-NLS-1$
                + gbColumn;
        ResultSetHandler<UsageHistogramBean> handler = new UsageHistogramHandler(rval, index);
        run.query(sql, handler, organizationId, apiId, version, from.getMillis(), to.getMillis());
    } catch (SQLException e) {
        e.printStackTrace();
    }

    return rval;
}

---

From source file:com.pinterest.arcee.db.DBSpotAutoScalingDAOImpl.java

@Override
public void updateSpotAutoScalingGroup(String groupName, SpotAutoScalingBean spotAutoScalingBean)
        throws Exception {
    SetClause setClause = spotAutoScalingBean.genSetClause();
    String clause = String.format(UPDATE_ASG_BY_CLUSTER, setClause.getClause());
    setClause.addValue(groupName);//from w  ww .  j a va  2 s . co m
    new QueryRunner(dataSource).update(clause, setClause.getValueArray());
}

---

From source file:de.iritgo.aktario.buddylist.BuddyListManager.java

public void generateGroups(final User user) {
    final DataSource dataSource = (DataSource) CommandTools.performSimple("persist.GetDefaultDataSource");
    final BuddyList buddyList = addBuddyList(user);
    final ResourceService resources = Engine.instance().getResourceService();

    QueryRunner query = new QueryRunner(dataSource);
    try {// ww w .  j  ava2s .  co  m
        query.query(
                "select * from akteragroup left join akteragroupentry on akteragroup.id = akteragroupentry.groupid left join keelusers on keelusers.uniqid = akteragroupentry.userid where keelusers.username="
                        + "'" + user.getName() + "' and akteragroup.visible = true",
                new ResultSetHandler() {
                    public Object handle(ResultSet rs) throws SQLException {
                        while (rs.next()) {
                            try {
                                long groupId = rs.getLong("groupId");

                                String displayName = rs.getString("title");
                                if (StringTools.isTrimEmpty(displayName)) {
                                    displayName = rs.getString("name");
                                }
                                displayName = resources.getStringWithoutException(displayName);
                                final BuddyListGroup buddyListGroup = addBuddyListGroup(user, buddyList,
                                        groupId, displayName);

                                QueryRunner query2 = new QueryRunner(dataSource);

                                query2.query(
                                        "select * from akteragroup left join akteragroupentry on akteragroup.id = akteragroupentry.groupid "
                                                + "left join keelusers on keelusers.uniqid = akteragroupentry.userid where akteragroup.id="
                                                + groupId,
                                        new ResultSetHandler() {
                                            public Object handle(ResultSet rs) throws SQLException {
                                                while (rs.next()) {
                                                    try {
                                                        addParticipant(rs.getString("username"),
                                                                buddyListGroup);
                                                    } catch (Exception ignored) {
                                                        Log.logError("persist", "LoadObject",
                                                                "NoSuchIObjectException");
                                                        ignored.printStackTrace();
                                                    }
                                                }

                                                return null;
                                            }
                                        });
                            } catch (Exception x) {
                                Log.logError("plugin", "BuddyListManager.generateGroups", x.toString());
                            }
                        }

                        return null;
                    }
                });
    } catch (Exception x) {
        Log.logError("plugin", "BuddyListManager.generateGroups", x.toString());
    }
}

---

From source file:com.pymmasoftware.platform.login.loginmodule.DroolsLoginModule.java

@Override
public boolean login() throws LoginException {
    succeeded = false;//from  w  ww .  j a  v  a2 s . c  o  m
    QueryRunner queryRunner = null;
    try {
        userPrincipal = null;
        roles = null;
        if (callbackHandler == null)
            throw new LoginException("No callback handler");

        NameCallback nameCallback = new NameCallback("Username");
        PasswordCallback passwordCallback = new PasswordCallback("Password", false);

        Callback[] callbacks = new Callback[] { nameCallback, passwordCallback };
        try {
            callbackHandler.handle(callbacks);
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (UnsupportedCallbackException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        username = nameCallback.getName();
        password = new String(passwordCallback.getPassword());

        queryRunner = new QueryRunner(dataSource);

        // Create a ResultSetHandler implementation to convert the
        // first row into an Object[].
        ResultSetHandler<DroolsPrincipal> h = new ResultSetHandler<DroolsPrincipal>() {
            public DroolsPrincipal handle(ResultSet rs) throws SQLException {
                if (!rs.next()) {
                    return null;
                }

                ResultSetMetaData meta = rs.getMetaData();
                String userName = rs.getString("username");

                DroolsPrincipal droolsPrincipal = new DroolsPrincipal(userName);
                droolsPrincipal.setId(rs.getInt("id"));

                return droolsPrincipal;
            }
        };
        ResultSetHandler<List<String>> hh = new ResultSetHandler<List<String>>() {
            public List<String> handle(ResultSet rs) throws SQLException {
                if (!rs.next()) {
                    return null;
                }
                List<String> droolsGroups = new ArrayList<>();
                boolean goOne = true;
                while (goOne) {
                    String groupName = rs.getString("groups");

                    droolsGroups.add(groupName);
                    if (rs.next() == false) {
                        goOne = false;
                    }
                }
                return droolsGroups;
            }
        };

        String sqlname = "select * from guvnorusers where username = ? and password = ? ";
        DroolsPrincipal user = queryRunner.query(sqlname, h, username, password);
        if (user == null) {
            succeeded = false;
            throw new FailedLoginException("The username or The password is incorrect");
        } else {

            userPrincipal = user;
            String sqlname2 = "select groups from guvnorgroups gr,guvnorusers_groups gr_user "
                    + "where gr.id = gr_user.groups_id  " + "and gr_user.guvnorusers_id= ?";
            List<String> droolsGroups = queryRunner.query(sqlname2, hh, user.getId());
            if (droolsGroups != null) {
                int i = droolsGroups.size();
                roles = new String[i];
                i = 0;
                for (String droolsGroup : droolsGroups) {
                    roles[i] = droolsGroup;
                    i++;
                }
            }
            succeeded = true;
            return true;
        }

    } catch (Exception e) {
        throw new LoginException(e.getMessage());
    } finally {
        queryRunner = null;
    }

}

---

From source file:com.pinterest.arcee.db.DBHealthCheckDAOImpl.java

@Override
public List<HealthCheckBean> getHealthChecksByGroup(String groupName, int pageIndex, int pageSize)
        throws Exception {
    QueryRunner run = new QueryRunner(this.dataSource);
    long start = (pageIndex - 1) * pageSize;
    ResultSetHandler<List<HealthCheckBean>> h = new BeanListHandler<>(HealthCheckBean.class);
    return run.query(GET_HEALTH_CHECK_BY_GROUP, h, groupName, start, pageSize);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• »