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

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

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

Introduction

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

Prototype

PreparedStatementSetter

Source Link

Usage

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

@Override
public int updateUserPwd(final TUserBO user) throws SQLException {
    int ret = 0;//from www  .  ja v  a2  s.  c  om
    String sql = "update T_SCS_USER set PWD=?, LASTUPDATE_DT=? where ID=?";
    try {
        ret = this.getJdbcTemplate().update(sql, new PreparedStatementSetter() {
            int i = 1;

            public void setValues(PreparedStatement ps) throws SQLException {
                ps.setString(i++, user.getPwd());
                ps.setTimestamp(i++, new Timestamp(new Date(System.currentTimeMillis()).getTime()));
                ps.setInt(i++, user.getId());
            }
        });
    } catch (Exception e) {
        throw new SQLException("? " + user.getLastupdateDt()
                + "  " + e.getMessage());
    }
    return ret;
}

From source file:com.jagornet.dhcp.db.JdbcLeaseManager.java

@Override
public List<IaPrefix> findExpiredIaPrefixes() {
    List<DhcpLease> leases = getJdbcTemplate().query("select * from dhcplease" + " where iatype = "
            + IdentityAssoc.PD_TYPE + " and validendtime < ? order by validendtime",
            new PreparedStatementSetter() {
                @Override//from ww  w.  ja va2  s  .  co m
                public void setValues(PreparedStatement ps) throws SQLException {
                    java.sql.Timestamp ts = new java.sql.Timestamp(new Date().getTime());
                    ps.setTimestamp(1, ts, Util.GMT_CALENDAR);
                }
            }, new DhcpLeaseRowMapper());
    return toIaPrefixes(leases);
}

From source file:com.jagornet.dhcp.db.JdbcIaManager.java

/**
 * Delete expired ia.//from w  w w .  j av a2 s  . com
 * 
 * @param id the id
 */
protected void deleteExpiredIA(final Long id) {
    getJdbcTemplate().update(
            "delete from identityassoc" + " where id=?" + " and not exists (select 1 from iaaddress"
                    + "              where identityassoc_id=identityassoc.id"
                    + "              and validendtime is not null and validendtime>=?)",
            new PreparedStatementSetter() {
                @Override
                public void setValues(PreparedStatement ps) throws SQLException {
                    ps.setLong(1, id);
                    java.sql.Timestamp now = new java.sql.Timestamp((new Date()).getTime());
                    ps.setTimestamp(2, now, Util.GMT_CALENDAR);
                }
            });

}

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

@Override
public int updateUserDynPwd(final TUserBO user) throws SQLException {
    int ret = 0;/*from   w  ww  .  j  a va2  s.co m*/
    String sql = "update T_SCS_USER set DYN_PWD=?, LASTUPDATE_DT=? where ID=?";
    try {
        ret = this.getJdbcTemplate().update(sql, new PreparedStatementSetter() {
            int i = 1;

            public void setValues(PreparedStatement ps) throws SQLException {
                ps.setString(i++, user.getDecPwd());
                ps.setTimestamp(i++, new Timestamp(new Date(System.currentTimeMillis()).getTime()));
                ps.setInt(i++, user.getId());
            }
        });
    } catch (Exception e) {
        throw new SQLException("? " + user.getLastupdateDt()
                + "  " + e.getMessage());
    }
    return ret;
}

From source file:com.jagornet.dhcp.db.JdbcIaManager.java

/**
 * Expire i as.//from  ww w .jav a2s.  co  m
 */
protected void expireIAs() {
    getJdbcTemplate().update("update identityassoc set state=" + IdentityAssoc.EXPIRED
            + " where exists (select 1 from iaaddress where identityassoc_id=identityassoc.id and validendtime<?)"
            + " and not exists (select 1 from iaaddress where identityassoc_id=identityassoc.id and validendtime>=?)",
            new PreparedStatementSetter() {
                @Override
                public void setValues(PreparedStatement ps) throws SQLException {
                    java.sql.Timestamp now = new java.sql.Timestamp((new Date()).getTime());
                    ps.setTimestamp(1, now, Util.GMT_CALENDAR);
                    ps.setTimestamp(2, now, Util.GMT_CALENDAR);
                }
            });
}

From source file:net.algem.security.UserDaoImpl.java

private void createToken(final int userId, final String token) {
    String query = "INSERT INTO " + T_TOKEN + " VALUES(?,?,?)";
    jdbcTemplate.update(query, new PreparedStatementSetter() {

        @Override//  ww w.  jav  a 2  s .c o  m
        public void setValues(PreparedStatement ps) throws SQLException {
            ps.setInt(1, userId);
            ps.setString(2, token);
            ps.setTimestamp(3, new java.sql.Timestamp(new java.util.Date().getTime()));
        }
    });

}

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  ww .  j  ava 2 s .  c  o  m*/
    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:net.sf.infrared.collector.impl.persistence.ApplicationStatisticsDaoImpl.java

private void insertTree(final String appName, final String hostName, final Tree tree) {
    byte[] byteArray = null;
    try {/*from   w  ww . j  av a2 s . c o m*/
        ByteArrayOutputStream baos = serializeObject(tree);
        byteArray = baos.toByteArray();
    } catch (IOException e) {
        log.error("IOException : Unable to serialize the Aggregate Operation Tree Object");
    }
    final ByteArrayInputStream bais = new ByteArrayInputStream(byteArray);
    getJdbcTemplate().update(SQL_INSERT_TREE, new PreparedStatementSetter() {
        public void setValues(PreparedStatement ps) throws SQLException {
            ps.setString(1, appName);
            ps.setString(2, hostName);
            ps.setBinaryStream(3, bais, bais.available());
            ps.setTimestamp(4, new Timestamp(System.currentTimeMillis()));
        }
    });
}

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

@Override
public List<TUserBO> queryUserForAsync(final TUserBO user) 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);
    if (StringUtils.isNotEmpty(user.getStartLastUpdate())) {
        sql.append(" AND b.LASTUPDATE_DT >= ?");
    }/*from  w  ww  . j  a v  a  2  s  . c  om*/
    if (StringUtils.isNotEmpty(user.getEndLastUpdate())) {
        sql.append(" AND b.LASTUPDATE_DT < ?");
    }
    if (StringUtils.isNotEmpty(user.getAccount())) {
        sql.append(" AND b.ACCOUNT like '%" + user.getAccount() + "%'");
    }

    BeanPropertyRowMapper<TUserBO> userRowMapper = new BeanPropertyRowMapper<TUserBO>(TUserBO.class);
    List<TUserBO> userList = null;
    userList = this.getJdbcTemplate().query(sql.toString(), new PreparedStatementSetter() {
        @Override
        public void setValues(PreparedStatement ps) throws SQLException {
            int i = 1;
            if (StringUtils.isNotEmpty(user.getStartLastUpdate())) {
                ps.setString(i++, user.getStartLastUpdate());
            }
            if (StringUtils.isNotEmpty(user.getEndLastUpdate())) {
                ps.setString(i++, user.getEndLastUpdate());
            }
            //            if(StringUtils.isNotEmpty(user.getAccount())){
            //               ps.setString(i++, "'%"+user.getAccount()+"%'");
            //            }
        }
    }, userRowMapper);
    //      createDate = new Timestamp(currDate.getTime());
    return userList;
}

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

@Override
public TUserBO findUserByOrderId(final int orderId) 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 " + "from T_SCS_ORDER o  JOIN  "
            + "T_SCS_USER u on o.CREATOR_USER_ID=u.ID where o.ORDER_ID=? ";
    BeanPropertyRowMapper<TUserBO> userRowMapper = new BeanPropertyRowMapper<TUserBO>(TUserBO.class);
    List<TUserBO> returnList = null;
    try {/*from  w ww  . j a  v  a 2s . c om*/
        returnList = this.getJdbcTemplate().query(sql, new PreparedStatementSetter() {
            public void setValues(PreparedStatement ps) throws SQLException {
                ps.setInt(1, orderId);
            }
        }, userRowMapper);
    } catch (Exception e) {
        throw new SQLException("" + e.getMessage());
    }
    if (returnList != null && returnList.size() > 0)
        return returnList.get(0);
    else
        return null;
}