Example usage for org.springframework.jdbc.core BeanPropertyRowMapper BeanPropertyRowMapper

List of usage examples for org.springframework.jdbc.core BeanPropertyRowMapper BeanPropertyRowMapper

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.core.*
  5. BeanPropertyRowMapper
  6. BeanPropertyRowMapper

Introduction

In this page you can find the example usage for org.springframework.jdbc.core BeanPropertyRowMapper BeanPropertyRowMapper.

Prototype

public BeanPropertyRowMapper(Class<T> mappedClass)

Source Link

Document

Create a new BeanPropertyRowMapper , accepting unpopulated properties in the target bean.

Usage

From source file:com.github.jrrdev.mantisbtsync.core.services.JdbcIssuesServiceTest.java

/**
 * Test method for {@link com.github.jrrdev.mantisbtsync.core.services.JdbcIssuesService#insertCustomFieldIfNotExists(biz.futureware.mantis.rpc.soap.client.ObjectRef, java.math.BigInteger)}.
 *//*from   w w  w  .j a v  a 2  s .c  o m*/
@Test
public void testInsertCustomFieldIfNotExists() {
    final Operation op = sequenceOf(
            insertInto("mantis_project_table").columns("id", "name").values(1, "project_1").build(),

            insertInto("mantis_enum_custom_field_types").columns("id", "name").values(1, "type_1").build());

    lauchOperation(op);

    final ObjectRef item = new ObjectRef(BigInteger.ONE, "item");
    dao.insertCustomFieldIfNotExists(item, BigInteger.ONE);

    final List<ObjectRef> list = getJdbcTemplate()
            .query("SELECT cf.id, cf.name" + " FROM mantis_custom_field_table cf"
                    + " INNER JOIN mantis_custom_field_project_table cfp ON cf.id = cfp.field_id"
                    + " WHERE cfp.project_id = 1", new BeanPropertyRowMapper<ObjectRef>(ObjectRef.class));

    assertEquals(1, list.size());
    assertEquals(item, list.get(0));

    dao.insertCustomFieldIfNotExists(item, BigInteger.ONE);
}

From source file:com.skycloud.management.portal.admin.sysmanage.dao.impl.UserManageDaoImpl.java

@Override
public List<TUserBO> searchUser(final QueryCriteria criteria) throws SQLException {
    final StringBuffer sql = new StringBuffer();
    sql.append("select ID,ACCOUNT,NAME from T_SCS_USER where 1 = 1 and DEPT_ID<>1 ");
    if (criteria.getUserName() != null && criteria.getUserName() != "")
        sql.append(" and ACCOUNT LIKE ? ");
    sql.append(" order by ID desc; ");
    /*if(criteria.getDeptId()>-1) 
       sql.append(" and DEPT_ID = ? ");       
    if(criteria.getRoleId()>-1) //from w  ww  .  j  av  a2  s. c o  m
       sql.append(" and ROLE_ID = ? ");       
    if(criteria.getStartTime()!=null && criteria.getEndTime()!=null) 
       sql.append(" and CREATE_DT between ? and ? "); */

    BeanPropertyRowMapper<TUserBO> userRowMapper = new BeanPropertyRowMapper<TUserBO>(TUserBO.class);
    List<TUserBO> returnList = null;

    try {
        returnList = this.getJdbcTemplate().query(sql.toString(), new PreparedStatementSetter() {
            @Override
            public void setValues(PreparedStatement ps) throws SQLException {
                int i = 1;
                if (criteria.getUserName() != null && criteria.getUserName() != "")
                    ps.setString(i++, "%" + criteria.getUserName() + "%");
                /*if(criteria.getDeptId()>-1) 
                   ps.setInt(i++, criteria.getDeptId());
                if(criteria.getRoleId()>-1) 
                   ps.setInt(i++, criteria.getRoleId());
                if(criteria.getStartTime()!=null && criteria.getEndTime()!=null){ 
                   ps.setDate(i++, criteria.getStartTime());
                    ps.setDate(i++, criteria.getEndTime());
                }else if(criteria.getStartTime()==null && criteria.getEndTime()!=null){
                   ps.setDate(i++, criteria.getStartTime());
                     ps.setDate(i++, criteria.getEndTime());
                }else{
                   ps.setDate(i++, criteria.getStartTime());
                    ps.setDate(i++, criteria.getEndTime());
                }*/
            }
        }, userRowMapper);
    } catch (Exception e) {
        throw new SQLException("" + e.getMessage());
    }
    return returnList;
}

From source file:konditer_reorganized_database.dao.ReorganizedDatabase.java

public void galary() throws SQLException, FileNotFoundException, IOException {
    String SQL_QUERY = "SELECT * FROM dmroy_kcake.galary ORDER BY id";
    //HashSet<String> hs = new HashSet<>();
    String image_small, image, name_section, name_cake, weight_cake, keywords;
    int cakesPage = 0, cakesPage_1 = 0, cakeTypes = 0, cakeTypes_1 = 0;
    new File(newPhotoCatalog).mkdirs();
    System.out.println(" ? : ");
    List<Map<String, Object>> rows = jdbcTemplate.queryForList(SQL_QUERY);
    for (Map<String, Object> row : rows) {
        image_small = (String) row.get("image_small");
        image = (String) row.get("image");
        name_section = (String) row.get("name_section");
        name_cake = (String) row.get("name_cake");
        weight_cake = (String) row.get("weight_cake");
        keywords = (String) row.get("keywords");

        String tmpStr = "";
        for (int i = 0; i < weight_cake.length(); i++) {
            if (weight_cake.charAt(i) == ',') {
                tmpStr += '.';
            } else {
                tmpStr += weight_cake.charAt(i);
            }// w w w.j a  v a  2s.c o m
        }
        Double cakeWeightParse = valueOf(tmpStr);

        // ?? ?? ?/ ?
        //hs.add(name_section);

        String SQL_QUERY_1 = "INSERT INTO cake_portal.cakes (CAKE_ID, CUSTOMER_ID, CAKE_PRICE, ORDER_ID, "
                + "CAKE_NAME, CAKE_WEIGHT, CAKE_PHOTO_MINI, CAKE_PHOTO_MAXI, CAKE_KEYWORDS ) "
                + "VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) ";
        int cakeId = genIdDao.getCakeId();
        oldCakeName = new ArrayList<>();
        oldCakeSection = new ArrayList<>();
        oldCakeImageName = new ArrayList<>();
        //newCakeImageName = new ArrayList<>();

        oldCakeImageName.add(image);
        oldCakeSection.add(name_section);
        oldCakeName.add(name_cake);

        if (cakeId % 2 == 0) {
            System.out.print(".");
        }
        if (cakeId % 50 == 0) {
            System.out.println(cakeId);
        }

        /////////////////////////////////////
        ////////
        //File inImageMini =  new File(oldPhotoCatalog+image_small+"");
        File inImageMini = new File("");
        inImageMini = getZipBytArrayImageIcon(oldPhotoCatalog + image_small + "", 150, 112);
        byte[] fileArrayMini = {};
        try {
            fileArrayMini = getBytesFromFile(inImageMini);
        } catch (IOException ex) {
            Logger.getLogger(ReorganizedDatabase.class.getName()).log(Level.SEVERE, null, ex);
        }

        FileOutputStream outImageMini = new FileOutputStream(newPhotoCatalog + cakeId + "_s.jpg");
        outImageMini.write(fileArrayMini);
        //inImageMini =  new File(oldPhotoCatalog+image_small+"");
        //inImageMini.delete();
        new File(oldPhotoCatalog + image_small + "").delete();

        ////////
        //File inImageMaxi =  new File(oldPhotoCatalog+image+"");
        File inImageMaxi = new File("");
        inImageMaxi = getZipBytArrayImageIcon(oldPhotoCatalog + image + "", 640, 480);
        byte[] fileArrayMaxi = {};
        try {
            fileArrayMaxi = getBytesFromFile(inImageMaxi);
        } catch (IOException ex) {
            Logger.getLogger(ReorganizedDatabase.class.getName()).log(Level.SEVERE, null, ex);
        }

        FileOutputStream outImageMaxi = new FileOutputStream(newPhotoCatalog + cakeId + ".jpg");
        outImageMaxi.write(fileArrayMaxi);
        //File inImageMaxi =  new File(oldPhotoCatalog+image+"");
        //inImageMaxi.delete();                
        new File(oldPhotoCatalog + image + "").delete();
        ///////////////////////////////////////// 
        String SQL_GET_ORDER = "SELECT ORDER_ID, " + "CUSTOMER_ID, " + "ORDER_STATUS_ID, " + "DELIVERY_ID, "
                + "ORDER_DATE_INCOME, " + "ORDER_DATE_END, " + "ORDER_CAKE_PRICE, " + "ORDER_DELIVERY_PRICE, "
                + "ORDER_INSIDES_ID, " + "ORDER_INFO, TIMESTAMP " + "FROM orders " + "WHERE ORDER_INFO = ?";
        Ordere order = (Ordere) jdbcTemplate.queryForObject(SQL_GET_ORDER, new Object[] { image },
                new BeanPropertyRowMapper(Ordere.class));
        int orderId = order.getOrderId();
        double cakePrice = order.getOrderCakePrice() * cakeWeightParse;
        cakesPage_1 = jdbcTemplate.update(SQL_QUERY_1, new Object[] { cakeId, 1, cakePrice, orderId, name_cake,
                cakeWeightParse, "" + cakeId + "_s.jpg", "" + cakeId + ".jpg", keywords });
        cakesPage += cakesPage_1;

        String SQL_SET_CAKE_TYPE = "INSERT INTO cake_portal.cakes_and_types (CAKE_AND_TYPE_ID, CAKE_ID, CAKE_TYPE_ID ) "
                + "VALUES (?, ?, (SELECT CAKE_TYPE_ID " + "FROM cake_portal.cake_types "
                + "WHERE CAKE_TYPE_NAME = ?))";

        jdbcTemplate.update(SQL_SET_CAKE_TYPE,
                new Object[] { genIdDao.getCakeAndTypeId(), cakeId, name_section });
    }
    System.out.println("\n  cakes  " + cakesPage + " ?.");
    /*
    String SQL_QUERY_2 = "INSERT INTO cake_portal.cake_types (CAKE_TYPE_ID, CAKE_TYPE_NAME ) "
                        + "VALUES ( ?, ? ) ";
    for (String str: hs){                    
        int cakeTypeId = genIdDao.getCakeTypeId();
        cakeTypes_1 = jdbcTemplate.update(SQL_QUERY_2, new Object[]{cakeTypeId, str});
        cakeTypes += cakeTypes_1;
    }
    System.out.println("  cake_types  " + cakeTypes + " ?.");
    */
}

From source file:com.skycloud.management.portal.admin.sysmanage.dao.impl.UserManageDaoImpl.java

@Override
/*????//w w w  .j a  va 2 s .  c  o  m
 * To Fix Bug Id:[1391][1697]
 */

public TUserBO findUserByAccout(final String account) throws SQLException {
    String sql = "select u.ID,u.ACCOUNT,u.PWD,u.NAME,u.DEPT_ID,u.ROLE_ID,u.EMAIL,u.PHONE,u.MOBILE,"
            + "u.FAX,u.POSITION,u.STATE,u.COMMENT,u.CHECK_CODE,u.IS_AUTO_APPROVE,"
            + "u.CREATOR_USER_ID,u.CREATE_DT,u.LASTUPDATE_DT,c.NAME CREATOR_USER_NAME "
            + "from T_SCS_USER u LEFT JOIN  "
            + "T_SCS_USER c on u.CREATOR_USER_ID=c.ID where u.ACCOUNT=? AND u.DEPT_ID>1;";
    BeanPropertyRowMapper<TUserBO> userRowMapper = new BeanPropertyRowMapper<TUserBO>(TUserBO.class);
    List<TUserBO> returnList = null;
    TUserBO user = null;
    try {
        returnList = this.getJdbcTemplate().query(sql, new PreparedStatementSetter() {
            public void setValues(PreparedStatement ps) throws SQLException {
                ps.setString(1, account);
            }
        }, userRowMapper);
    } catch (Exception e) {
        throw new SQLException("" + e.getMessage());
    }
    if (returnList != null && returnList.size() > 0)
        user = returnList.get(0);
    else
        return null;
    user.setDept(deptDao.findDeptById(user.getDeptId()));
    return user;
}

From source file:com.hexin.core.dao.BaseDaoSupport.java

public <T> Page<T> findMySqlPage(JdbcTemplate jdbcTemplate, String sql, Class<T> dtoClass,
        PageCondition pageCondition, Object... args) {

    Page<T> page = new Page<T>();
    StringBuffer countSqlBuf = new StringBuffer();
    int currentPage = 1;
    int pageSize = 10;
    String camelSortBy = "";
    String underlineSortBy = "";
    String orderBy = "";
    long total;//from w ww  .java 2s .  co  m
    long totalPage;
    List<T> resultList = null;

    // distinct
    countSqlBuf.append("select count(*) from (");
    countSqlBuf.append(StringUtils.substringBeforeLast(sql, "order "));
    countSqlBuf.append(") tmp_table");
    debugSql(countSqlBuf.toString(), args);

    // 
    total = jdbcTemplate.queryForObject(countSqlBuf.toString(), Long.class, args);
    page.setTotal(total);

    StringBuffer pageSqlBuf = new StringBuffer();
    pageSqlBuf.append("select * from (");
    pageSqlBuf.append(sql);
    pageSqlBuf.append(") t ");

    if (pageCondition != null) {
        currentPage = pageCondition.getPage();
        pageSize = pageCondition.getRows();
        camelSortBy = pageCondition.getSort();
        orderBy = pageCondition.getOrder();

        // ????
        underlineSortBy = IcpObjectUtil.camelToUnderline(camelSortBy);
    }

    if (StringUtils.isNotEmpty(underlineSortBy) && StringUtils.isNotEmpty(orderBy)) {
        pageSqlBuf.append(" order by ");
        pageSqlBuf.append(underlineSortBy).append(" ").append(orderBy).append(" ");
    }
    pageSqlBuf.append(" limit ");
    pageSqlBuf.append((currentPage - 1) * pageSize);
    pageSqlBuf.append(" ,");
    pageSqlBuf.append(pageSize);
    pageSqlBuf.append(" ");

    debugSql(pageSqlBuf.toString(), args);

    RowMapper<T> rowMapper = new BeanPropertyRowMapper<T>(dtoClass);
    resultList = jdbcTemplate.query(pageSqlBuf.toString(), rowMapper, args);

    long mod = total % pageSize;
    if (mod == 0) {
        totalPage = total / pageSize;
    } else {
        totalPage = total / pageSize + 1;
    }

    page.setRows(resultList);
    page.setCurrentPage(currentPage);
    page.setPageSize(pageSize);
    page.setTotalPage(totalPage);
    page.setPageIndex(PageIndex.getPageIndex(Constants.PAGE_RANGE, pageSize, totalPage));

    return page;
}

From source file:au.aurin.org.svc.GeodataFinder.java

public List<dummyuserData> getAllUsers() {

    String query = "select * from users";

    try {// ww w .  j av  a 2  s  .c  o  m
        final JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

        LOGGER.info("getUser: query is {} ", query);

        query = "select a.user_id,a.email,a.firstname, a.lastname from users as a ";
        final List<dummyuserData> listusers = jdbcTemplate.query(query,
                new BeanPropertyRowMapper(dummyuserData.class));

        return listusers;

    } catch (final Exception e) {

        LOGGER.info("error in  getAllUsers is : {}", e.toString());

    }
    return null;

}

From source file:au.aurin.org.svc.GeodataFinder.java

public List<dummyuserData> searchAllUsers(String name, String family, String email) {

    String query = "select * from users";

    try {/*from w w  w.  ja  va  2s. c  o m*/
        final JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

        email = email.replace("'", "''");
        name = name.replace("'", "''");
        family = family.replace("'", "''");

        query = "select a.user_id,a.email,a.firstname, a.lastname from users as a where a.firstname ~* '" + name
                + "' and  a.lastname ~* '" + family + "' and a.email ~* '" + email + "'";

        LOGGER.info("serachAllUsers: query is {} ", query);
        final List<dummyuserData> listusers = jdbcTemplate.query(query,
                new BeanPropertyRowMapper(dummyuserData.class));

        return listusers;

    } catch (final Exception e) {

        LOGGER.info("error in  serachAllUsers is : {}", e.toString());

    }
    return null;

}

From source file:com.krawler.workflow.module.dao.DataObjectOperationDAOImpl.java

@Override
public List getAllDataObjects(String objName, Class classObj, List<ModuleClause> clauses) {
    List results = null;// w ww .  j  a  v  a 2s. co  m
    StringBuilder query = new StringBuilder("SELECT * FROM ");
    String tableName = getTableName(objName);
    query.append(tableName);
    List params = new ArrayList();
    query.append(buildClause(tableName, clauses, params));
    try {
        results = getJdbcTemplate().query(query.toString(), params.toArray(),
                new BeanPropertyRowMapper(classObj));
    } catch (DataAccessException e) {
        LOG.warn("Can not fetch all records", e);
    }

    return results;
}

From source file:com.skycloud.management.portal.admin.sysmanage.dao.impl.UserManageDaoImpl.java

@Override
public List<TUserBO> queryUserForFront(TUserBO searchUser) throws SQLException {
    String query = "SELECT `T_SCS_USER`.`ID`, `T_SCS_USER`.`ACCOUNT`, `T_SCS_USER`.`PWD`, `T_SCS_USER`.`NAME`, "
            + " `T_SCS_USER`.`DEPT_ID`, `T_SCS_USER`.`ROLE_ID`, `T_SCS_USER`.`EMAIL`, `T_SCS_USER`.`PHONE`, "
            + " `T_SCS_USER`.`MOBILE`, `T_SCS_USER`.`FAX`, `T_SCS_USER`.`POSITION`, `T_SCS_USER`.`STATE`, `T_SCS_USER`.`COMMENT`,"
            + " `T_SCS_USER`.`CHECK_CODE`, IFNULL(IS_AUTO_APPROVE,0) as  IS_AUTO_APPROVE, `T_SCS_USER`.`CREATOR_USER_ID`,"
            + " `T_SCS_USER`.`CREATE_DT`, `T_SCS_USER`.`LASTUPDATE_DT`, `T_SCS_ROLE`.`ROLE_ID`, `T_SCS_ROLE`.`ROLE_NAME`,"
            + " `T_SCS_ROLE`.`ROLE_APPROVE_LEVEL`,T_SCS_DEPARTMENT.DEPT_NAME, `T_SCS_COMPANY_INFO`.`COMP_CN_NAME`"
            + " FROM `T_SCS_USER` JOIN `T_SCS_ROLE` ON `T_SCS_USER`.`ROLE_ID` = `T_SCS_ROLE`.`ROLE_ID` "
            + " JOIN T_SCS_DEPARTMENT ON `T_SCS_USER`.`DEPT_ID` = `T_SCS_DEPARTMENT`.`DEPT_ID` "
            + " LEFT JOIN `T_SCS_COMPANY_INFO` ON `T_SCS_USER`.`COMP_ID` = `T_SCS_COMPANY_INFO`.`COMP_ID` "
            + " AND  (T_SCS_USER.STATE=?)";
    StringBuilder sql = new StringBuilder(500);
    sql.append(query);//  w w w.  j  a v a2  s.c om
    if (null != searchUser) {
        if (searchUser.getId() > 0) {
            sql.append(" AND T_SCS_USER.ID = " + searchUser.getId());
        }
        if (StringUtils.isNotEmpty(searchUser.getAccount())) {
            sql.append(" AND T_SCS_USER.ACCOUNT like %" + searchUser.getId() + "%");
        }
        if (StringUtils.isNotEmpty(searchUser.getName())) {
            sql.append(" AND T_SCS_USER.NAME like %" + searchUser.getId() + "%");
        }
        if (searchUser.getDeptId() > 0) {
            sql.append(" AND T_SCS_USER.DEPT_ID = " + searchUser.getDeptId());
        }
        if (searchUser.getRoleId() > 0) {
            sql.append(" AND T_SCS_USER.ROLE_ID = " + searchUser.getRoleId());
        }
        if (searchUser.getCompId() > 0) {
            sql.append(" AND T_SCS_USER.COMP_ID = " + searchUser.getCompId());
        }
    }
    sql.append(" ORDER BY T_SCS_USER.ID");
    List<TUserBO> userList = null;
    TUserBO user = null;
    BeanPropertyRowMapper<TUserBO> userRowMapper = new BeanPropertyRowMapper<TUserBO>(TUserBO.class);

    userList = this.getJdbcTemplate().query(sql.toString(), new PreparedStatementSetter() {
        public void setValues(PreparedStatement ps) throws SQLException {
            ps.setInt(1, CompanyCheckStateEnum.SUCCESS);
        }
    }, userRowMapper);

    return userList;
}

From source file:com.skycloud.management.portal.admin.sysmanage.dao.impl.UserManageDaoImpl.java

@Override
public List<TUserBO> queryUserForAsync() throws SQLException {
    //fix bug 5006
    StringBuilder sql = new StringBuilder();
    sql.append("SELECT b.* FROM `T_SCS_ROLE` a,`T_SCS_USER` b ");
    sql.append("where a.role_approve_level in (1,2) ");
    sql.append("and a.role_id = b.role_id and b.state = " + CompanyCheckStateEnum.SUCCESS);
    //      Date currDate = new Date(System.currentTimeMillis());       
    //      sql.append(" and b.LASTUPDATE_DT <= '"+new Timestamp(currDate.getTime())+"'");
    //      if(null!=createDate){
    //         sql.append(" and b.LASTUPDATE_DT >'"+createDate+"'");
    //      }/*  www.j  a  v  a  2  s.c om*/
    //      System.out.println(createDate);
    //      System.out.println(currDate);
    //      System.out.println(sql.toString());
    BeanPropertyRowMapper<TUserBO> userRowMapper = new BeanPropertyRowMapper<TUserBO>(TUserBO.class);
    List<TUserBO> userList = null;
    userList = this.getJdbcTemplate().query(sql.toString(), userRowMapper);
    //      createDate = new Timestamp(currDate.getTime());
    return userList;
}