Example usage for org.springframework.jdbc.core.support AbstractLobCreatingPreparedStatementCallback AbstractLobCreatingPreparedStatementCallback

Introduction

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

Prototype

public AbstractLobCreatingPreparedStatementCallback(LobHandler lobHandler) 

Source Link

Document

Create a new AbstractLobCreatingPreparedStatementCallback for the given LobHandler.

Usage

From source file:org.sakaiproject.imagegallery.integration.standalone.FileLibraryStandalone.java

/**
 * @see org.sakaiproject.imagegallery.integration.FileLibraryService#storeImageFile(org.springframework.web.multipart.MultipartFile)
 *//*from   w  w  w.ja  v a2  s .  c o  m*/
@Transactional
public ImageFile storeImageFile(final MultipartFile sourceImageFile) {
    final String filename = sourceImageFile.getOriginalFilename();
    final String fileId = contextService.getCurrentContextUid() + "/" + filename;
    final String contentType = sourceImageFile.getContentType();

    ImageFile imageFile = new ImageFile();
    imageFile.setContentType(contentType);
    imageFile.setFilename(filename);
    imageFile.setFileId(fileId);
    imageFile.setDataUrl(urlPrefix + fileId);

    jdbcTemplate.getJdbcOperations().execute(
            "insert into IMAGE_GALLERY_STANDALONE_FILES_T (FILE_ID, CONTENT_TYPE, CONTENT) VALUES (?, ?, ?)",
            new AbstractLobCreatingPreparedStatementCallback(this.lobHandler) {
                protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                    ps.setString(1, fileId);
                    ps.setString(2, contentType);
                    try {
                        lobCreator.setBlobAsBinaryStream(ps, 3, sourceImageFile.getInputStream(),
                                (int) sourceImageFile.getSize());
                    } catch (IOException e) {
                        log.error("Error copying binary data from file " + filename, e);
                    }
                }
            });

    return imageFile;
}

---

From source file:bd.gov.forms.dao.ListDaoImpl.java

public void updateListData(final ListData lst) {
    String sql = "UPDATE list_data";
    sql += " set name = ?, detail = ?, list_values = ?";
    sql += " WHERE sys_id = ?";

    log.debug("SQL UPDATE query: {}", sql);

    jdbcTemplate.execute(sql, new AbstractLobCreatingPreparedStatementCallback(lobHandler) {

        @Override//  w ww. j av  a 2s.c  o  m
        protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
            int i = 1;

            ps.setString(i++, lst.getName());
            ps.setString(i++, lst.getDetail());
            ps.setString(i++, lst.getValues());
            ps.setString(i, lst.getSysId());
        }
    });
}

---

From source file:bd.gov.forms.dao.FormDaoImpl.java

public void updateForm(final Form form) {
    String sql = "UPDATE form";
    sql += " set title = ?, subtitle = ?, detail = ?, status = ?";

    if (formHasTemplate(form)) {
        sql += ", template_file = ?, template_file_name = ?";
    }/*w ww .j av  a  2 s . co  m*/

    sql += " WHERE form_id = ?";

    log.debug("SQL UPDATE query: {}", sql);

    jdbcTemplate.execute(sql, new AbstractLobCreatingPreparedStatementCallback(lobHandler) {

        @Override
        protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
            int i = 1;

            ps.setString(i++, form.getTitle());
            ps.setString(i++, form.getSubTitle());
            ps.setString(i++, form.getDetail());
            ps.setInt(i++, form.getStatus());

            if (formHasTemplate(form)) {
                lobCreator.setBlobAsBinaryStream(ps, i++, new ByteArrayInputStream(form.getPdfTemplate()),
                        form.getPdfTemplate().length);
                ps.setString(i++, form.getTemplateFileName());
            }

            ps.setString(i, form.getFormId());
        }
    });
}

---

From source file:bd.gov.forms.dao.UserDaoImpl.java

public void saveUser(final User user) {
    String sql = "INSERT INTO user";
    sql += " (sys_id, name, title, user, password, mobile, email, admin, active";
    sql += ")";//from   w w w.  jav  a 2 s .c  o  m
    sql += " VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?";
    sql += ")";

    log.debug("SQL INSERT query: {}", sql);

    jdbcTemplate.execute(sql, new AbstractLobCreatingPreparedStatementCallback(lobHandler) {

        @Override
        protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
            int i = 1;

            ps.setString(i++, user.getSysId());
            ps.setString(i++, user.getName());
            ps.setString(i++, user.getTitle());
            ps.setString(i++, user.getUserName());
            ps.setString(i++, user.getPassword());
            ps.setString(i++, user.getMobile());
            ps.setString(i++, user.getEmail());
            ps.setInt(i++, user.getAdmin());
            ps.setInt(i, user.getActive());
        }
    });
}

---

From source file:alfio.manager.UploadedResourceManager.java

public int saveResource(UploadBase64FileModification file) {
    if (hasResource(file.getName())) {
        uploadedResourceRepository.delete(file.getName());
    }// www .  j  ava  2s .  c o  m
    LobHandler lobHandler = new DefaultLobHandler();
    return jdbc.getJdbcOperations().execute(uploadedResourceRepository.uploadTemplate(file.getName()),
            new AbstractLobCreatingPreparedStatementCallback(lobHandler) {
                @Override
                protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                    setFileValues(ps, lobCreator, file, 1);
                }
            });

}

---

From source file:alfio.manager.UploadedResourceManager.java

public int saveResource(int organizationId, UploadBase64FileModification file) {
    if (hasResource(organizationId, file.getName())) {
        uploadedResourceRepository.delete(organizationId, file.getName());
    }//from ww  w.  ja v  a  2s . com
    LobHandler lobHandler = new DefaultLobHandler();
    return jdbc.getJdbcOperations().execute(
            uploadedResourceRepository.uploadTemplate(organizationId, file.getName()),
            new AbstractLobCreatingPreparedStatementCallback(lobHandler) {
                @Override
                protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                    ps.setInt(2, organizationId);
                    setFileValues(ps, lobCreator, file, 2);
                }
            });
}

---

From source file:bd.gov.forms.dao.UserDaoImpl.java

public void updateUser(final User user) {
    String sql = "UPDATE user";
    sql += " set name = ?, title = ?, mobile = ?, email = ?, admin = ?, active = ?";
    sql += " WHERE sys_id = ?";

    log.debug("SQL UPDATE query: {}", sql);

    jdbcTemplate.execute(sql, new AbstractLobCreatingPreparedStatementCallback(lobHandler) {

        @Override/*w w w . ja  va 2  s. c om*/
        protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
            int i = 1;

            ps.setString(i++, user.getName());
            ps.setString(i++, user.getTitle());
            ps.setString(i++, user.getMobile());
            ps.setString(i++, user.getEmail());
            ps.setInt(i++, user.getAdmin());
            ps.setInt(i++, user.getActive());
            ps.setString(i, user.getSysId());
        }
    });
}

---

From source file:alfio.manager.UploadedResourceManager.java

public int saveResource(int organizationId, int eventId, UploadBase64FileModification file) {
    if (hasResource(organizationId, eventId, file.getName())) {
        uploadedResourceRepository.delete(organizationId, eventId, file.getName());
    }//  w ww  . j av a 2 s  .  com
    LobHandler lobHandler = new DefaultLobHandler();
    return jdbc.getJdbcOperations().execute(
            uploadedResourceRepository.uploadTemplate(organizationId, eventId, file.getName()),
            new AbstractLobCreatingPreparedStatementCallback(lobHandler) {
                @Override
                protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                    ps.setInt(2, organizationId);
                    ps.setInt(3, eventId);
                    setFileValues(ps, lobCreator, file, 3);
                }
            });

}

---

From source file:bd.gov.forms.dao.FormDaoImpl.java

public void saveField(final Field field) {
    String sql = "INSERT INTO field";
    sql += " (field_id, form_id, type, input_type, label, required, help_text, options, list_data_id, def_value, "
            + "field_order";
    sql += ")";//from   w ww.j a v  a2 s  . c  o  m
    sql += " VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?";
    sql += ")";

    log.debug("SQL INSERT query: {}", sql);

    jdbcTemplate.execute(sql, new AbstractLobCreatingPreparedStatementCallback(lobHandler) {

        @Override
        protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
            int i = 1;

            ps.setString(i++, field.getFieldId());
            ps.setInt(i++, field.getFormId());
            ps.setString(i++, field.getType());
            ps.setString(i++, field.getInputType());
            ps.setString(i++, field.getLabel());
            ps.setInt(i++, field.getRequired());
            ps.setString(i++, field.getHelpText());
            ps.setString(i++, field.getOptions());
            ps.setInt(i++, field.getListDataId());
            ps.setString(i++, field.getDefaultValue());
            ps.setInt(i, field.getFieldOrder());
        }
    });
}

---

From source file:bd.gov.forms.dao.FormDaoImpl.java

public void updateField(final Field field) {
    String sql = "UPDATE field";
    sql += " set type = ?, input_type = ?, label = ?, required = ?, help_text = ?, options = ?, list_data_id = ?, "
            + "def_value = ?, field_order = ?";
    sql += " WHERE field_id = ? and form_id = ?";

    log.debug("SQL UPDATE query: {}", sql);
    log.debug("formId: {}, fieldId: {}", field.getFormId(), field.getFieldId());

    jdbcTemplate.execute(sql, new AbstractLobCreatingPreparedStatementCallback(lobHandler) {

        @Override/*from   ww w . j  a  va2s. c o  m*/
        protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
            int i = 1;

            ps.setString(i++, field.getType());//*
            ps.setString(i++, field.getInputType());
            ps.setString(i++, field.getLabel());
            ps.setInt(i++, field.getRequired());
            ps.setString(i++, field.getHelpText());
            ps.setString(i++, field.getOptions());
            ps.setInt(i++, field.getListDataId());
            ps.setString(i++, field.getDefaultValue());
            ps.setInt(i++, field.getFieldOrder());//*

            ps.setString(i++, field.getFieldId());
            ps.setInt(i, field.getFormId());
        }
    });
}

---

• «
• 1
• 2
• 3
• »