Package org.springframework.jdbc.core.namedparam

Examples of org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource

187
188
189
190
191
192
193
194
  /**
   * 适用sqlserver,mysql 自动生成主键
   */
  protected void insertWithGeneratedKey(Object entity, String insertSql) {
    KeyHolder keyHolder = new GeneratedKeyHolder();
    getNamedParameterJdbcTemplate().update(insertSql, new BeanPropertySqlParameterSource(entity) , keyHolder);
    setIdentifierProperty(entity, keyHolder.getKey().longValue());
  }
View Full Code Here
202
203
204
205
206
207
208
  }

  protected void insertWithSequence(Object entity,AbstractSequenceMaxValueIncrementer sequenceIncrementer,String insertSql) {
    Long id = sequenceIncrementer.nextLongValue();
    setIdentifierProperty(entity, id);
    getNamedParameterJdbcTemplate().update(insertSql, new BeanPropertySqlParameterSource(entity));
  }
View Full Code Here
216
217
218
219
220
221
222
  }
 
  protected void insertWithUUID(Object entity,String insertSql) {
    String uuid = UUID.randomUUID().toString().replace("-", "");
    setIdentifierProperty(entity, uuid);
    getNamedParameterJdbcTemplate().update(insertSql, new BeanPropertySqlParameterSource(entity));
  }
View Full Code Here
224
225
226
227
228
229
230
   * 手工分配ID插入
   * @param entity
   * @param insertSql
   */
  protected void insertWithAssigned(Object entity,String insertSql) {
    getNamedParameterJdbcTemplate().update(insertSql, new BeanPropertySqlParameterSource(entity));
  }
View Full Code Here
239
240
241
242
243
244
245
246
247
248
249
  }
 
  public E getById(PK id) {
    List list = null;
    if(getSqlGenerator().getTable().getPrimaryKeyCount() > 1) {
      list = getNamedParameterJdbcTemplate().query(getSqlGenerator().getSelectByPkSql(), new BeanPropertySqlParameterSource(id), new BeanPropertyRowMapper(getEntityClass()));
    }else if(getSqlGenerator().getTable().getPrimaryKeyCount() == 1){
      list = getSimpleJdbcTemplate().query(getSqlGenerator().getSelectByPkSql(), ParameterizedBeanPropertyRowMapper.newInstance(getEntityClass()), id);
    }else {
      throw new IllegalStateException("not found primary key on table:"+getSqlGenerator().getTable().getTableName());
    }
View Full Code Here
250
251
252
253
254
255
256
257
258
259
260
    return (E)CollectionHelper.findSingleObject(list);
  }

  public void deleteById(PK id) {
    if(getSqlGenerator().getTable().getPrimaryKeyCount() > 1) {
      getNamedParameterJdbcTemplate().update(getSqlGenerator().getDeleteByPkSql(),new BeanPropertySqlParameterSource(id));
    }else if(getSqlGenerator().getTable().getPrimaryKeyCount() == 1){
      getSimpleJdbcTemplate().update(getSqlGenerator().getDeleteByPkSql(), id);
    }else {
      throw new IllegalStateException("not found primary key on table:"+getSqlGenerator().getTable().getTableName());
    }
View Full Code Here
268
269
270
271
272
273
274
      update(entity);
    }
  }
  public void update(E entity) {
    String sql = getSqlGenerator().getUpdateByPkSql();
    getNamedParameterJdbcTemplate().update(sql, new BeanPropertySqlParameterSource(entity));
  }
View Full Code Here
183
184
185
186
187
188
189
  protected ParameterizedBeanPropertyRowMapper resultBeanMapper(Class clazz) {
    return ParameterizedBeanPropertyRowMapper.newInstance(clazz);
  }
 
  protected BeanPropertySqlParameterSource paramBeanMapper(Object object) {
    return new BeanPropertySqlParameterSource(object);
  }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
  public int updateObject(String sql, Object object) throws DataAccessException {
    if (debug) {
      logger.info("sql:" + sql);
      logger.info("object:" + object);
    }
    SqlParameterSource namedParam = new BeanPropertySqlParameterSource(object);
    KeyHolder keyHolder = new GeneratedKeyHolder();
    int ret = getNameParameterJdbcTemplate().update(sql, namedParam, keyHolder);
    if (ret <= 0)
      return ret;
    try {
View Full Code Here
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
      if (arg instanceof Map) {
        msp.addValues((Map)arg);
        continue;
      }
     
      BeanPropertySqlParameterSource sps = new BeanPropertySqlParameterSource(arg);
      List<Field> fields = new ArrayList<Field>();
      for (Class<?> c = arg.getClass(); c != null; c = c.getSuperclass()) {
        if (c.equals(Object.class))
          continue;
        fields.addAll(Arrays.asList(c.getDeclaredFields()));
      }
      for (Field f : fields) {
        try {
          String fn = f.getName();
          if (msp.hasValue(fn))
            sqlLogger.warn(String
                .format("Field with name=%s has "
                    + "been already mapped by another arg bean. Overriding!",
                    fn));
          if (Enum.class.isAssignableFrom(f.getType())) {
            sps.registerSqlType(f.getName(), Types.VARCHAR);
          }

          msp.addValue(fn, sps.getValue(fn), sps.getSqlType(fn),
              sps.getTypeName(fn));
          logger.debug(String.format("prepared sql arg: name=%s, value=%s, type=%s",
              fn, sps.getValue(fn), sps.getTypeName(fn)));
        } catch (Exception e) {
          Throwables.propagate(e);
        }
      }
    }
View Full Code Here
TOP

Related Classes of org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource

  • cc.concurrent.config.server.dao.impl.AppDaoImpl
  • cc.concurrent.config.server.dao.impl.FileCurrentDaoImpl
  • cc.concurrent.config.server.dao.impl.FileHistoryDaoImpl
  • cc.concurrent.config.server.dao.impl.FilePublishedDaoImpl
  • com.iqbon.jcms.dao.business.DocDAO
  • com.iqbon.jcms.dao.business.ModelDAO
  • com.iqbon.jcms.dao.business.PushRecordDAO
  • com.iqbon.jcms.dao.business.TopicDAO
  • com.iqbon.jcms.dao.business.UserDAO
  • com.iqbon.jcms.dao.system.CodeDAO
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.