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

List of usage examples for org.apache.commons.dbutils QueryRunner update

  1. HOME
  2. Java
  3. org.apache.commons
  4. org.apache.commons.dbutils.*
  5. QueryRunner
  6. update

Introduction

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

Prototype

public int update(Connection conn, String sql, Object... params) throws SQLException

Source Link

Document

Execute an SQL INSERT, UPDATE, or DELETE query.

Usage

From source file:azkaban.executor.JdbcExecutorLoader.java

private void addExecutorHelper(String host, int port) throws ExecutorManagerException {
    final String INSERT = "INSERT INTO executors (host, port) values (?,?)";
    QueryRunner runner = createQueryRunner();
    try {//from   www. j  ava 2s .co m
        runner.update(INSERT, host, port);
    } catch (SQLException e) {
        throw new ExecutorManagerException(String.format("Error adding %s:%d ", host, port), e);
    }
}

From source file:azkaban.executor.JdbcExecutorLoader.java

@Override
public void addActiveExecutableReference(ExecutionReference reference) throws ExecutorManagerException {
    final String INSERT = "INSERT INTO active_executing_flows " + "(exec_id, update_time) values (?,?)";
    QueryRunner runner = createQueryRunner();

    try {/*from  w w  w . j a va  2s  .c o  m*/
        runner.update(INSERT, reference.getExecId(), reference.getUpdateTime());
    } catch (SQLException e) {
        throw new ExecutorManagerException("Error updating active flow reference " + reference.getExecId(), e);
    }
}

From source file:com.versatus.jwebshield.securitylock.SecurityLockService.java

private SecurityLock checkSecurityLock(int userId, String ip) throws SQLException {

    logger.debug("checkAccountLock: userid=" + userId);
    logger.debug("checkAccountLock: ip=" + ip);

    SecurityLock res;//from   w  w  w . j a va 2 s .co m
    Object[] params = new Object[] { userId, ip };

    QueryRunner run = new QueryRunner();
    Connection conn = dbHelper.getConnection();
    BeanHandler<SecurityLock> rsh = new BeanHandler(SecurityLock.class) {

        @Override
        public SecurityLock handle(ResultSet rs) throws SQLException {
            SecurityLock brp = null;
            if (rs.first()) {
                brp = new BasicRowProcessor().toBean(rs, SecurityLock.class);
            }
            return brp;
        }
    };

    try {

        res = run.query(conn, lockCheckSql, rsh, params);

        logger.debug("checkAccountLock: response=" + res);

        if (res != null) {
            if (res.isLock()) {
                logger.debug("checkAccountLock: Calendar.getInstance()=" + Calendar.getInstance().getTime());
                logger.debug("checkAccountLock: TimeWhenUnlock()=" + res.getTimeWhenUnlock());
                logger.debug("checkAccountLock: is time to ulock="
                        + Calendar.getInstance().getTime().after(res.getTimeWhenUnlock()));
                if (Calendar.getInstance().getTime().after(res.getTimeWhenUnlock())) {
                    logger.info("unlocking IP " + res.getIp());
                    int r = run.update(conn, resetLockSql, new Object[] { ip });

                    logger.debug("checkAccountLock: reset response=" + r);

                    res = run.query(conn, lockCheckSql, rsh, params);

                    logger.debug("checkAccountLock: after reset response=" + res);
                }
            }

        } else {
            res = new SecurityLock();
            res.setLock(false);
        }

    } finally {

        try {
            DbUtils.close(conn);
        } catch (SQLException e) {
            // ignore
        }
    }

    return res;
}

From source file:azkaban.executor.JdbcExecutorLoader.java

@Override
public boolean updateExecutableReference(int execId, long updateTime) throws ExecutorManagerException {
    final String DELETE = "UPDATE active_executing_flows set update_time=? WHERE exec_id=?";

    QueryRunner runner = createQueryRunner();
    int updateNum = 0;
    try {/* ww w  .  ja  v a2s.  com*/
        updateNum = runner.update(DELETE, updateTime, execId);
    } catch (SQLException e) {
        throw new ExecutorManagerException("Error deleting active flow reference " + execId, e);
    }

    // Should be 1.
    return updateNum > 0;
}

From source file:azkaban.executor.JdbcExecutorLoader.java

/**
 *
 * {@inheritDoc}/*from  w  ww  .ja  va2  s .  c  o  m*/
 *
 * @see azkaban.executor.ExecutorLoader#assignExecutor(int, int)
 */
@Override
public void assignExecutor(int executorId, int executionId) throws ExecutorManagerException {
    final String UPDATE = "UPDATE execution_flows SET executor_id=? where exec_id=?";

    QueryRunner runner = createQueryRunner();
    try {
        Executor executor = fetchExecutor(executorId);
        if (executor == null) {
            throw new ExecutorManagerException(
                    String.format("Failed to assign non-existent executor Id: %d to execution : %d  ",
                            executorId, executionId));
        }

        int rows = runner.update(UPDATE, executorId, executionId);
        if (rows == 0) {
            throw new ExecutorManagerException(
                    String.format("Failed to assign executor Id: %d to non-existent execution : %d  ",
                            executorId, executionId));
        }
    } catch (SQLException e) {
        throw new ExecutorManagerException("Error updating executor id " + executorId, e);
    }
}

From source file:com.odap.server.audit.ConfigHandler.java

public ConfigMessage registerNewServer(ConfigMessage config) throws TException {
    logger.info("Enter registerNewServer()");
    ConfigMessage msg = new ConfigMessage();

    QueryRunner qRunner = new QueryRunner();

    Integer account_id = null;/*from  w w  w.  j a  va2 s  .com*/
    Integer server_id = null;
    //Authenticate the user and get the account_id;
    String query = "SELECT * FROM joomla.cloud_users WHERE username = ? AND password = ?";
    {
        String parameters[] = { config.getUsername().replaceAll("[^A-Za-z0-9 ]", ""),
                DigestUtils.md5Hex(config.getPassword().replaceAll("[^A-Za-z0-9 ]", "")) };
        try {
            List<Map<String, Object>> mapList = (List<Map<String, Object>>) qRunner
                    .query(AuditServer.connectionPool.getConnection(), query, new MapListHandler(), parameters);

            if (mapList.size() < 1) {
                logger.warn("Username " + config.getUsername() + " not authenticated");
                return msg;
            }

            account_id = (Integer) mapList.get(0).get("account_id");

        } catch (SQLException e) {
            logger.error("Issue finding user account", e);
            return msg;
        }
    }

    String session_id = nextSessionId();
    {
        try {
            {
                query = "INSERT INTO servers (account_id,server_name,server_software,server_port,server_authentication_token,server_timezone,strip_predicates) VALUES (?,?,?,?,?,?,?)";
                Object parameters[] = { account_id.toString(),
                        config.getServer_name().replaceAll("[^A-Za-z0-9 ]", ""), config.getServer_software(),
                        new Short(config.getPort()), session_id, new Double(config.getTimezone_offset()),
                        config.strip_predicates };
                qRunner.update(AuditServer.connectionPool.getConnection(), query, parameters);
            }
            {
                String parameters[] = { account_id.toString(), config.getServer_name(), session_id };
                query = "SELECT * FROM servers WHERE account_id = ? AND server_name = ? and server_authentication_token = ?";
                List<Map<String, Object>> mapList = (List<Map<String, Object>>) qRunner.query(
                        AuditServer.connectionPool.getConnection(), query, new MapListHandler(), parameters);

                if (mapList.size() < 1) {
                    logger.error("Unable to find server after after registering it");
                    return msg;
                }

                server_id = (Integer) mapList.get(0).get("id");
            }
        } catch (SQLException e) {
            logger.error("Issue registering server", e);
        }
    }

    msg.token = session_id;
    msg.server_id = server_id.shortValue();
    msg.server = "dbauditcloud.com";
    logger.info("Exiting registerNewServer()");
    return msg;
}

From source file:com.demo.db.dao.impl.DriverDaoImpl.java

@Override
public int update(Driver driver) {
    QueryRunner queryRunner = dbHelper.getRunner();

    try {//from   w w w . j a  v  a2 s .co  m
        List<String> columnList = new LinkedList<String>();
        List<String> valueList = new LinkedList<String>();
        if (StringUtils.isNotBlank(driver.getName())) {
            columnList.add("name");
            valueList.add(driver.getName());
        }
        if (StringUtils.isNotBlank(driver.getSfzA())) {
            columnList.add("sfz_a");
            valueList.add(driver.getSfzA());
        }
        if (StringUtils.isNotBlank(driver.getSfzB())) {
            columnList.add("sfz_b");
            valueList.add(driver.getSfzB());
        }
        if (StringUtils.isNotBlank(driver.getJszA())) {
            columnList.add("jsz_a");
            valueList.add(driver.getJszA());
        }
        if (StringUtils.isNotBlank(driver.getXszA())) {
            columnList.add("xsz_a");
            valueList.add(driver.getXszA());
        }
        if (StringUtils.isNotBlank(driver.getLicensePlate())) {
            columnList.add("license_plate");
            valueList.add(driver.getLicensePlate());
        }
        if (columnList.size() == 0) {
            return 0;
        }
        for (int i = 0; i < columnList.size(); i++) {
            String strColumn = columnList.get(i);
            columnList.set(i, strColumn + "=?");
        }
        final String strUpdateSet = StringUtils.join(columnList.toArray(), ",");
        if (StringUtils.isBlank(strUpdateSet)) {
            throw new RuntimeException("");
        }
        StringBuilder sb = new StringBuilder();
        sb.append("update demo_driver set ");
        sb.append(strUpdateSet);
        sb.append(" where cell=?");
        valueList.add(driver.getCell());
        int rows = queryRunner.update(dbHelper.getConnection(), sb.toString(), valueList.toArray());
        return rows;
    } catch (SQLException e) {
        LOGGER.error("?? ?{}", driver);
        throw new RuntimeException("??", e);
    }
}

From source file:com.demo.db.dao.impl.DriverAuditDaoImpl.java

@Override
public int update(DriverAudit driverAudit) {
    QueryRunner queryRunner = dbHelper.getRunner();

    try {/* w  w w .j  a v  a  2 s  .c o m*/
        List<String> columnList = new LinkedList<String>();
        List<Object> valueList = new LinkedList<Object>();
        if (null != driverAudit.getName() && driverAudit.getName() == 0) {
            columnList.add("name");
            valueList.add(driverAudit.getName());
            columnList.add("name_reject");
            valueList.add("");
        }
        if (null != driverAudit.getSfzA() && driverAudit.getSfzA() == 0) {
            columnList.add("sfz_a");
            valueList.add(driverAudit.getSfzA());
            columnList.add("sfz_a_reject");
            valueList.add("");
        }
        if (null != driverAudit.getSfzB() && driverAudit.getSfzB() == 0) {
            columnList.add("sfz_b");
            valueList.add(driverAudit.getSfzB());
            columnList.add("sfz_b_reject");
            valueList.add("");
        }
        if (null != driverAudit.getJszA() && driverAudit.getJszA() == 0) {
            columnList.add("jsz_a");
            valueList.add(driverAudit.getJszA());
            columnList.add("jsz_a_reject");
            valueList.add("");
        }
        if (null != driverAudit.getXszA() && driverAudit.getXszA() == 0) {
            columnList.add("xsz_a");
            valueList.add(driverAudit.getXszA());
            columnList.add("xsz_a_reject");
            valueList.add("");
        }
        if (null != driverAudit.getLicensePlate() && driverAudit.getLicensePlate() == 0) {
            columnList.add("license_plate");
            valueList.add(driverAudit.getLicensePlate());
            columnList.add("license_plate_reject");
            valueList.add("");
        }
        if (columnList.size() == 0) {
            return 0;
        }
        for (int i = 0; i < columnList.size(); i++) {
            String strColumn = columnList.get(i);
            columnList.set(i, strColumn + "=?");
        }
        final String strUpdateSet = StringUtils.join(columnList.toArray(), ",");
        if (StringUtils.isBlank(strUpdateSet)) {
            throw new RuntimeException("");
        }
        valueList.add(driverAudit.getDriverId());
        StringBuilder sb = new StringBuilder();
        sb.append("update demo_driver_audit set ");
        sb.append(strUpdateSet);
        sb.append(" where cell=?");
        int rows = queryRunner.update(dbHelper.getConnection(), sb.toString(), valueList.toArray());
        return rows;
    } catch (SQLException e) {
        logger.error("?? ?{}", driverAudit);
        throw new RuntimeException("??", e);
    }
}

From source file:com.demo.admin.dao.impl.AdminDriverDaoImpl.java

@Override
public int updateDriverAudit(DriverAudit driverAudit) {
    QueryRunner queryRunner = dbHelper.getRunner();
    try {/*  w  w w .j a  va 2  s  . co  m*/
        List<String> setList = new ArrayList<String>();
        List<Object> paramList = new ArrayList<Object>();
        // name
        if (null != driverAudit.getName() && driverAudit.getName() != 0) {
            setList.add("name=?");
            paramList.add(driverAudit.getName());
            if (driverAudit.getName() == 2) {
                setList.add("name_reject=?");
                paramList.add(driverAudit.getNameReject());
            }
        }
        // cell
        if (null != driverAudit.getCell() && driverAudit.getCell() != 0) {
            setList.add("cell=?");
            paramList.add(driverAudit.getCell());
            if (driverAudit.getCell() == 2) {
                setList.add("cell_reject=?");
                paramList.add(driverAudit.getCellReject());
            }
        }
        // driver_place_id
        if (null != driverAudit.getDriverPlaceId() && driverAudit.getDriverPlaceId() != 0) {
            setList.add("driver_place_id=?");
            paramList.add(driverAudit.getDriverPlaceId());
        }
        // sfz_a
        if (null != driverAudit.getSfzA() && driverAudit.getSfzA() != 0) {
            setList.add("sfz_a=?");
            paramList.add(driverAudit.getSfzA());
            if (driverAudit.getSfzA() == 2) {
                setList.add("sfz_a_reject=?");
                paramList.add(driverAudit.getSfzAReject());
            }
        }
        // sfz_b
        if (null != driverAudit.getSfzB() && driverAudit.getSfzB() != 0) {
            setList.add("sfz_b=?");
            paramList.add(driverAudit.getSfzB());
            if (driverAudit.getSfzB() == 2) {
                setList.add("sfz_b_reject=?");
                paramList.add(driverAudit.getSfzBReject());
            }
        }
        // jsz_a
        if (null != driverAudit.getJszA() && driverAudit.getJszA() != 0) {
            setList.add("jsz_a=?");
            paramList.add(driverAudit.getJszA());
            if (driverAudit.getJszA() == 2) {
                setList.add("jsz_a_reject=?");
                paramList.add(driverAudit.getJszAReject());
            }
        }
        // xsz_a
        if (null != driverAudit.getXszA() && driverAudit.getXszA() != 0) {
            setList.add("xsz_a=?");
            paramList.add(driverAudit.getXszA());
            if (driverAudit.getXszA() == 2) {
                setList.add("xsz_a_reject=?");
                paramList.add(driverAudit.getXszAReject());
            }
        }
        // license_plate
        if (null != driverAudit.getLicensePlate() && driverAudit.getLicensePlate() != 0) {
            setList.add("license_plate=?");
            paramList.add(driverAudit.getLicensePlate());
            if (driverAudit.getLicensePlate() == 2) {
                setList.add("license_plate_reject=?");
                paramList.add(driverAudit.getLicensePlateReject());
            }
        }
        // driver_id
        // if (null != driverAudit.getDriverId()) {
        // setList.add("driver_id=?");
        // paramList.add(driverAudit.getDriverId());
        // }
        paramList.add(driverAudit.getDriverId());
        int rows = queryRunner.update(dbHelper.getConnection(),
                "update demo_driver_audit set " + StringUtils.join(setList, ",") + " where driver_id=?",
                paramList.toArray());
        return rows;
    } catch (SQLException e) {
        String methodName = Thread.currentThread().getStackTrace()[1].getMethodName();
        logger.error("{}??{}", methodName, driverAudit);
        throw new RuntimeException(e);
    }
}

From source file:org.codesearch.commons.database.DBAccessImpl.java

/**
 * {@inheritDoc}/*from ww w  .  j a  v  a  2  s  .  c  o m*/
 */
@Override
public synchronized void setLastAnalyzedRevisionOfRepository(String repositoryName, String revision)
        throws DatabaseAccessException {
    QueryRunner run = new QueryRunner(dataSource);
    try {
        run.update(STMT_SET_LAST_ANALYZED_REVISION_OF_REPOSITORY, revision, repositoryName);
    } catch (SQLException ex) {
        throw new DatabaseAccessException("SQLException while trying to access the database\n" + ex);
    }
}