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

List of usage examples for org.springframework.jdbc.core.support AbstractLobCreatingPreparedStatementCallback AbstractLobCreatingPreparedStatementCallback

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.core.support.*
  5. AbstractLobCreatingPreparedStatementCallback
  6. 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:com.suntek.gztpb.dao.DriverLicenseDao.java

public void saveApply(final DriverLicenseModel apply) {
    String sql = "INSERT INTO " + apply.getTableName() + " (APPLYNUM,BIZTYPE, DOCNUM,BIZREASON,receiptNum,"
            + "OWNERNAME,country,IDTYPE,IDNO,SEX,BIRTHDAY," + "HOMEADDRESS,postAddress,PHONE,MOBILE,EMAIL,"
            + "RECEIVETYPE, RECEIVER, RECEIVEADDRESS, RECEIVEPHONE," + "CREATOR, CREATEDTIME, SOURCE) VALUES("
            + "?,?,?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, sysdate, ?)";
    getJdbcTemplate().execute(sql, new AbstractLobCreatingPreparedStatementCallback(this.lobHandler) {
        protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
            ps.setString(1, apply.getApplyNum());
            ps.setString(2, apply.getBizType());
            ps.setString(3, apply.getDocNum());
            ps.setString(4, apply.getBizReason());
            ps.setString(5, apply.getReceiptNum());

            ps.setString(6, apply.getOwnerName());
            ps.setString(7, apply.getCountry());
            ps.setInt(8, apply.getIdType());
            ps.setString(9, apply.getIdNO());
            ps.setInt(10, apply.getSex());
            ps.setString(11, apply.getBirthday());

            ps.setString(12, apply.getHomeAddress());
            ps.setString(13, apply.getPostAddress());
            ps.setString(14, apply.getPhone());
            ps.setString(15, apply.getMobile());
            ps.setString(16, apply.getEmail());

            ps.setInt(17, apply.getReceiveType());
            ps.setString(18, apply.getReceiver());
            ps.setString(19, apply.getReceiveAddress());
            ps.setString(20, apply.getReceivePhone());

            ps.setString(21, apply.getCreator());
            ps.setInt(22, apply.getSource());
        }//from w  ww. j  a  v a 2s  . c o  m
    });
}

From source file:com.suntek.gztpb.dao.VehicleLicenseDao.java

public void saveApply(final VehicleLicenseModel apply, final byte[] fileStream) {
    String sql = "INSERT INTO itms_vehicle_license_apply_tmp (APPLYNUM,"
            + "BIZTYPE, SERVICEITEMNUM, BIZREASON, OWNERNAME, HOMEADDRESS, ZIP, EMAIL, PHONE,"
            + " MOBILE, IDTYPE, IDNO, SEX, BIRTHDAY, NATIVEPLACE, IGAMA, PLATENUMTYPE, PLATENUM,"
            + "VEHICLEIDNUM, ENGINENUM, VEHICLEIMAGE, PROXYFLAG, PROXYNAME,"
            + "PROXYADDRESS, PROXYZIP, PROXYPHONE, PROXYEMAIL, RECEIVETYPE, RECEIVER, RECEIVEADDRESS, RECEIVEPHONE,"
            + "CREATOR, CREATEDTIME, SOURCE) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, sysdate, ?)";
    getJdbcTemplate().execute(sql, new AbstractLobCreatingPreparedStatementCallback(this.lobHandler) {
        protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
            ps.setString(1, apply.getApplyNum());
            ps.setString(2, apply.getBizType());
            ps.setString(3, apply.getSERVICEITEMNUM());
            ps.setString(4, apply.getBizReason());
            ps.setString(5, apply.getOwnerName());
            ps.setString(6, apply.getHomeAddress());
            ps.setString(7, apply.getZip());
            ps.setString(8, apply.getEmail());
            ps.setString(9, apply.getPhone());

            ps.setString(10, apply.getMobile());
            ps.setInt(11, apply.getIdType());
            ps.setString(12, apply.getIdNO());
            ps.setInt(13, apply.getSex());
            ps.setString(14, apply.getBirthday());
            ps.setString(15, apply.getNATIVEPLACE());
            ps.setString(16, apply.getIGAMA());
            ps.setString(17, apply.getPlateNumType());
            ps.setString(18, apply.getPlateNum());

            ps.setString(19, apply.getVehicleIdNum());
            ps.setString(20, apply.getengineNum());
            // ps.setString(21, apply.getVehicleImage());
            lobCreator.setBlobAsBytes(ps, 21, fileStream);
            ps.setInt(22, apply.getProxyFlag());
            // ps.setString(23, apply.getLetterOfAuth());
            ps.setString(23, apply.getPROXYNAME());

            ps.setString(24, apply.getPROXYADDRESS());
            ps.setString(25, apply.getPROXYzip());
            ps.setString(26, apply.getPROXYphone());
            ps.setString(27, apply.getPROXYemail());
            ps.setInt(28, apply.getReceiveType());
            ps.setString(29, apply.getReceiver());
            ps.setString(30, apply.getReceiveAddress());
            ps.setString(31, apply.getReceivePhone());
            ps.setString(32, apply.getCreator());
            //  ps.setDate(35, java.sql.Date.valueOf("2012-08-17"));// apply.getCreatedTime().toString()
            ps.setInt(33, apply.getSource());// 
            // ps.setString(37,"2012-09-09");//apply.getSUBMITTIME()
        }/*from  w w  w.j a v a 2s  .  co m*/
    });
}

From source file:org.snaker.engine.spring.SpringJdbcAccess.java

public void saveProcess(final Process process) {
    super.saveProcess(process);
    if (process.getBytes() != null) {
        template.execute(PROCESS_UPDATE_BLOB, new AbstractLobCreatingPreparedStatementCallback(lobHandler) {

            protected void setValues(PreparedStatement ps, LobCreator lobCreator)
                    throws SQLException, DataAccessException {
                try {
                    lobCreator.setBlobAsBytes(ps, 1, process.getBytes());
                    StatementCreatorUtils.setParameterValue(ps, 2, Types.VARCHAR, process.getId());
                } catch (Exception e) {
                    e.printStackTrace();
                }/*from  w  w  w .j a v a2  s . c o  m*/
            }
        });
    }
}

From source file:org.snaker.engine.access.spring.SpringJdbcAccess.java

@Override
public void saveProcess(final Process process) {
    super.saveProcess(process);
    if (process.getBytes() != null) {
        template.execute(PROCESS_UPDATE_BLOB, new AbstractLobCreatingPreparedStatementCallback(lobHandler) {
            @Override//  www .ja  va2 s.c o m
            protected void setValues(PreparedStatement ps, LobCreator lobCreator)
                    throws SQLException, DataAccessException {
                try {
                    lobCreator.setBlobAsBytes(ps, 1, process.getBytes());
                    StatementCreatorUtils.setParameterValue(ps, 2, Types.VARCHAR, process.getId());
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        });
    }
}

From source file:org.snaker.engine.spring.SpringJdbcAccess.java

public void updateProcess(final Process process) {
    super.updateProcess(process);
    if (process.getBytes() != null) {
        template.execute(PROCESS_UPDATE_BLOB, new AbstractLobCreatingPreparedStatementCallback(lobHandler) {

            protected void setValues(PreparedStatement ps, LobCreator lobCreator)
                    throws SQLException, DataAccessException {
                try {
                    lobCreator.setBlobAsBytes(ps, 1, process.getBytes());
                    StatementCreatorUtils.setParameterValue(ps, 2, Types.VARCHAR, process.getId());
                } catch (Exception e) {
                    e.printStackTrace();
                }/*  ww  w.jav  a 2s . c  om*/
            }
        });
    }
}

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

public void saveForm(final Form form) {
    String sql = "INSERT INTO form";
    sql += " (form_id, title, subtitle, detail, status";

    if (formHasTemplate(form)) {
        sql += ", template_file, template_file_name";
    }/*from   www  .ja  v a  2  s . c o m*/

    sql += ")";
    sql += " VALUES (?, ?, ?, ?, ?";

    if (formHasTemplate(form)) {
        sql += " , ?, ?";
    }

    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++, form.getFormId());
            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());
            }
        }
    });
}

From source file:org.snaker.engine.access.spring.SpringJdbcAccess.java

@Override
public void updateProcess(final Process process) {
    super.updateProcess(process);
    if (process.getBytes() != null) {
        template.execute(PROCESS_UPDATE_BLOB, new AbstractLobCreatingPreparedStatementCallback(lobHandler) {
            @Override//from ww w .j a v a2 s. c om
            protected void setValues(PreparedStatement ps, LobCreator lobCreator)
                    throws SQLException, DataAccessException {
                try {
                    lobCreator.setBlobAsBytes(ps, 1, process.getBytes());
                    StatementCreatorUtils.setParameterValue(ps, 2, Types.VARCHAR, process.getId());
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        });
    }
}

From source file:com.ttech.cordovabuild.domain.asset.AssetServiceImpl.java

@Override
public AssetRef save(final InputStream inputStream, String mimeType) {
    final AssetRef ref = new AssetRef();
    ref.setMimeType(mimeType);/*from ww w  .ja va  2s . co m*/
    jdbcTemplate.execute("insert into ASSETS (uuid,data) values (?,?)",
            new AbstractLobCreatingPreparedStatementCallback(lobHandler) {
                @Override
                protected void setValues(PreparedStatement ps, LobCreator lobCreator)
                        throws SQLException, DataAccessException {
                    ref.setUuid(UUID.randomUUID().toString());
                    ps.setString(1, ref.getUuid());
                    try {
                        lobCreator.setBlobAsBytes(ps, 2, ByteStreams.toByteArray(inputStream));
                    } catch (IOException e) {
                        throw new AssetCreationException(e);
                    }
                }
            });
    return ref;
}

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

public void saveListData(final ListData listData) {
    String sql = "INSERT INTO list_data";
    sql += " (sys_id, name, detail, list_values";
    sql += ")";/*from www .  j  ava 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++, listData.getSysId());
            ps.setString(i++, listData.getName());
            ps.setString(i++, listData.getDetail());
            ps.setString(i, listData.getValues());
        }
    });
}

From source file:alfio.manager.FileUploadManager.java

public String insertFile(UploadBase64FileModification file) {
    String digest = DigestUtils.sha256Hex(file.getFile());

    if (Integer.valueOf(1).equals(repository.isPresent(digest))) {
        return digest;
    }/*  w  ww  . jav a2s .c o  m*/

    LobHandler lobHandler = new DefaultLobHandler();

    jdbc.getJdbcOperations().execute(repository.uploadTemplate(),
            new AbstractLobCreatingPreparedStatementCallback(lobHandler) {
                @Override
                protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                    ps.setString(1, digest);
                    ps.setString(2, file.getName());
                    ps.setLong(3, file.getFile().length);
                    lobCreator.setBlobAsBytes(ps, 4, file.getFile());
                    ps.setString(5, file.getType());
                    ps.setString(6, Json.GSON.toJson(getAttributes(file)));
                }
            });
    return digest;
}