Example usage for org.apache.commons.dbutils.handlers BeanHandler BeanHandler

Introduction

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

Prototype

public BeanHandler(Class<T> type)

Source Link

Document

Creates a new instance of BeanHandler.

Usage

From source file:com.bjond.Main.java

public static String findRuleDefinitionNameByID(final Connection connection, final String ID)
        throws SQLException {
    String name = nameIDMap.get(ID);
    if (name != null) {
        return name;
    }/*from   w w w  . ja v a 2  s.  c  om*/

    val run = new QueryRunner();
    final StringStub stub = run.query(connection, "SELECT p.name FROM rule_definition p WHERE p.id = ?",
            new BeanHandler<>(StringStub.class), ID);

    if (stub != null) {
        nameIDMap.put(ID, stub.getName());
        return stub.getName();
    } else {
        return ID;
    }
}

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

@Override
public HostBean getByEnvIdAndHostId(String envId, String hostId) throws Exception {
    ResultSetHandler<HostBean> h = new BeanHandler<>(HostBean.class);
    return new QueryRunner(dataSource).query(GET_HOST_BY_ENVID_AND_HOSTID, h, envId, hostId);
}

From source file:com.bjond.Main.java

public static String findPersonPersonByID(final Connection connection, final String ID) throws SQLException {
    PersonStub stub = personMap.get(ID);
    if (stub != null) {
        return stub.toString().replace(',', '|');
    }//w  ww . j a  v a 2 s  .  com

    val run = new QueryRunner();
    stub = run.query(connection,
            "SELECT p.id, p.first_name, p.middle_name, p.last_name FROM person_person p WHERE p.id = ?",
            new BeanHandler<>(PersonStub.class), ID);

    if (stub != null) {
        personMap.put(ID, stub);
        return stub.toString().replace(',', '|');
    } else {
        return ID;
    }
}

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

@Override
public HostBean getByEnvIdAndHostName(String envId, String hostName) throws Exception {
    ResultSetHandler<HostBean> h = new BeanHandler<>(HostBean.class);
    return new QueryRunner(dataSource).query(GET_HOST_BY_ENVID_AND_HOSTNAME, h, envId, hostName);
}

From source file:com.bjond.Main.java

/**
 * @param connection/* w w w  .  j  a  va 2 s  .com*/
 * @param ID
 * @return
 * @throws SQLException
 */
public static String findUserDefinedRoleTaskNameByID(final Connection connection, final String ID)
        throws SQLException {
    String name = nameIDMap.get(ID);
    if (name != null) {
        return name;
    }

    val run = new QueryRunner();
    final StringStub stub = run.query(connection,
            "SELECT p.name FROM permissionsuserdefinedrole p WHERE p.id = ?",
            new BeanHandler<>(StringStub.class), ID);

    if (stub != null) {
        nameIDMap.put(ID, stub.getName());
        return stub.getName();
    } else {
        return ID;
    }
}

From source file:com.bjond.Main.java

public static String findBjondTaskNameByID(final Connection connection, final String ID) throws SQLException {
    String name = nameIDMap.get(ID);
    if (name != null) {
        return name;
    }//from   w w w  .ja  v  a 2  s  .  co  m

    val run = new QueryRunner();
    final StringStub stub = run.query(connection, "SELECT p.name FROM bjondtask p WHERE p.id = ?",
            new BeanHandler<>(StringStub.class), ID);

    if (stub != null) {
        nameIDMap.put(ID, stub.getName());
        return stub.getName();
    } else {
        return ID;
    }
}

From source file:com.bjond.Main.java

public static String findAssessmentNameByID(final Connection connection, final String ID) throws SQLException {
    String name = nameIDMap.get(ID);
    if (name != null) {
        return name;
    }//from  w  ww.  j a  va  2  s.  com

    val run = new QueryRunner();
    final StringStub stub = run.query(connection, "SELECT p.name FROM assessment p WHERE p.id = ?",
            new BeanHandler<>(StringStub.class), ID);

    if (stub != null) {
        nameIDMap.put(ID, stub.getName());
        return stub.getName();
    } else {
        return ID;
    }
}

From source file:com.bjond.Main.java

public static String findRoleNameByID(final Connection connection, final String ID) throws SQLException {
    String name = nameIDMap.get(ID);
    if (name != null) {
        return name;
    }//from  w w w  . j av a2s.c  om

    val run = new QueryRunner();
    final StringStub stub = run.query(connection, "SELECT p.name FROM roletypeentity p WHERE p.id = ?",
            new BeanHandler<>(StringStub.class), ID);

    if (stub != null) {
        nameIDMap.put(ID, stub.getName());
        return stub.getName();
    } else {
        return ID;
    }
}

From source file:com.bjond.Main.java

public static String findGroupNameByID(final Connection connection, final String ID) throws SQLException {
    String name = nameIDMap.get(ID);
    if (name != null) {
        return name;
    }/*from w w w  .  j ava  2s.  com*/

    val run = new QueryRunner();
    final StringStub stub = run.query(connection, "SELECT p.name FROM grouptypeentity p WHERE p.id = ?",
            new BeanHandler<>(StringStub.class), ID);

    if (stub != null) {
        nameIDMap.put(ID, stub.getName());
        return stub.getName();
    } else {
        return ID;
    }
}

From source file:com.bjond.Main.java

public static User findUserByID(final Connection connection, final String ID) throws SQLException {

    // Cached?/*w w  w .j  ava 2s . c  o  m*/
    User user = userMap.get(ID);
    if (user != null) {
        return user;
    }

    val run = new QueryRunner();
    user = run.query(connection,
            "SELECT p.id, p.loginname, p.firstname, p.lastname, p.email  FROM accounttypeentity p WHERE p.id = ?",
            new BeanHandler<>(User.class), ID);

    // Cache it
    if (user != null) {
        userMap.put(ID, user);
    }

    return user;
}