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.ruihu.easyshop.order.dao.OrderDao.java

public Order load(String oid) throws SQLException {
    String sql = "select * from t_order where oid=?";
    Order order = qr.query(sql, new BeanHandler<Order>(Order.class), oid);
    loadOrderItem(order);//load all order items
    return order;
}

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

@Override
public SpotAutoScalingBean getClusterByAutoScalingGroup(String autoScalingGroup) throws Exception {
    ResultSetHandler<SpotAutoScalingBean> h = new BeanHandler<>(SpotAutoScalingBean.class);
    return new QueryRunner(dataSource).query(GET_CLUSTER_BY_ID, h, autoScalingGroup);
}

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

@Override
public AsgAlarmBean getAlarmInfoById(String alarmId) throws Exception {
    ResultSetHandler<AsgAlarmBean> h = new BeanHandler<AsgAlarmBean>(AsgAlarmBean.class);
    return new QueryRunner(dataSource).query(GET_ALARM_BY_ID, h, alarmId);
}

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

@Override
public ImageBean getById(String amiId) throws Exception {
    ResultSetHandler<ImageBean> h = new BeanHandler<>(ImageBean.class);
    return new QueryRunner(dataSource).query(GET_AMI_BY_ID, h, amiId);
}

From source file:dbutils.ExampleJDBC.java

/**
 * BeanListHandler ResultSet??ListList//from  ww w.j a  v  a  2s . c o m
 */
public static void getBeanListData() {
    Connection conn = getConnection();
    QueryRunner qr = new QueryRunner();
    try {
        ResultSetHandler<Student> rsh = new BeanHandler(Student.class);
        Student usr = qr.query(conn,
                "SELECT id, name, gender, age, team_id as teamId FROM test_student WHERE id=1", rsh);
        System.out.println(StringUtils.center("findById", 50, '*'));
        System.out.println("id=" + usr.getId() + " name=" + usr.getName() + " gender=" + usr.getGender());

        List<Student> results = (List<Student>) qr.query(conn,
                "SELECT id, name, gender, age, team_id as teamId FROM test_student LIMIT 10",
                new BeanListHandler(Student.class));
        System.out.println(StringUtils.center("findAll", 50, '*'));
        for (Student result : results) {
            System.out.println(
                    "id=" + result.getId() + "  name=" + result.getName() + "  gender=" + result.getGender());
        }
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        DbUtils.closeQuietly(conn);
    }
}

From source file:com.paladin.sys.db.QueryHelper.java

/**
 * ? ? //from   w w  w . j  av a2s . c  o m
 *
 * @param sql
 * @param params
 * @return
 */
public static <T> T read(Class<T> beanClass, String sql, Object... params) {
    try {
        return (T) RUNNER.query(getConnection(), sql,
                IS_PRIMITIVE(beanClass) ? scalar_handler : new BeanHandler(beanClass), params);
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        DBManager.closeConnection();
    }
    return null;
}

From source file:com.softberries.klerk.dao.ProductDao.java

@Override
public Product find(Long id) throws SQLException {
    Product p = null;//w ww  . j  ava2 s.co m
    try {
        init();
        ResultSetHandler<Product> h = new BeanHandler<Product>(Product.class);
        p = run.query(conn, SQL_FIND_PRODUCT_BY_ID, h, id);
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } finally {
        close(conn, st, generatedKeys);
    }
    return p;
}

From source file:epgtools.epgdbbean.bean.programme.ProgrammeGetter.java

/**
 * DB???????1?//from ww w  .  java2  s  .  c  o m
 * ?????????????2??????
 * (??????????????ID?????????????)
 *
 * @param Channel_id ??ID
 * @param Channel_no ????
 * @param StartDatetime ?
 * @return 1?(????,ID,??,?,?)
 * @throws java.sql.SQLException
 */
public synchronized ProgrammeChannelNo_ReadOnly getProgramme(String Channel_id, int Channel_no,
        Timestamp StartDatetime) throws SQLException {
    //
    //        try (CallableStatement ps = con.prepareCall(ProgrammeGetter.GET_PROGRAMME_FUZZY)) {
    //            //???????????????
    //            ps.setString(1, Channel_id);//??ID
    //            ps.setInt(2, Channel_no);//????
    //            ps.setTimestamp(3, StartDatetime);//?
    //
    //            // ????
    //            ResultSet rs = ps.executeQuery();
    //            return new BeanHandler<>(ProgrammeChannelNo.class).handle(rs);
    //        }
    return runner.query(con, ProgrammeGetter.GET_PROGRAMME_FUZZY,
            new BeanHandler<ProgrammeChannelNo>(ProgrammeChannelNo.class), Channel_id, Channel_no,
            StartDatetime);
}

From source file:com.ruihu.easyshop.user.dao.UserDao.java

/**
 * using code find user/*from  w  ww .jav a  2 s  .c om*/
 * @param code
 * @return 
 */
public User findByCode(String code) throws SQLException {
    String sql = "select *from t_user where activationCode=?";
    return qr.query(sql, new BeanHandler<User>(User.class), code);
}

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

@Override
public ConfigHistoryBean getByChangeId(String changeId) throws Exception {
    ResultSetHandler<ConfigHistoryBean> h = new BeanHandler<>(ConfigHistoryBean.class);
    return new QueryRunner(dataSource).query(GET_BY_CHANGE_ID, h, changeId);
}