Java StoredProcedureQuery.setParameter方法代码示例

import javax.persistence.StoredProcedureQuery; //导入方法依赖的package包/类
@Test
public void calculate() {
	log.info("... calculate ...");
	EntityManager em = emf.createEntityManager();
       em.getTransaction().begin();
       
	// define the stored procedure
	StoredProcedureQuery query = em.createStoredProcedureQuery("calculate");
	query.registerStoredProcedureParameter("x", Double.class, ParameterMode.IN);
	query.registerStoredProcedureParameter("y", Double.class, ParameterMode.IN);
	query.registerStoredProcedureParameter("sum", Double.class, ParameterMode.OUT);
	
	// set input parameter
	query.setParameter("x", 1.23d);
	query.setParameter("y", 4d);
	
	// call the stored procedure and get the result
	query.execute();
	Double sum = (Double) query.getOutputParameterValue("sum");
	log.info("Calculation result: 1.23 + 4 = " + sum);

       em.getTransaction().commit();
       em.close();
}
 

import javax.persistence.StoredProcedureQuery; //导入方法依赖的package包/类
@Test
public void calculate() {

	EntityManager em = emf.createEntityManager();
       em.getTransaction().begin();
       
	StoredProcedureQuery query = em.createNamedStoredProcedureQuery("calculate");
	query.setParameter("x", 1.23d);
	query.setParameter("y", 4d);
	query.execute();
	Double sum = (Double) query.getOutputParameterValue("sum");
	log.info("Calculation result: 1.23 + 4 = " + sum);

       em.getTransaction().commit();
       em.close();
}
 

import javax.persistence.StoredProcedureQuery; //导入方法依赖的package包/类
/**
 * Creates a Backup of the Database in the directory specified in
 * config.properties.
 *
 * @param name the name of the Backup.
 *
 * @return Backup entinty.
 *
 * @throws QueryTimeoutException if the query should fail.
 * @throws PersistenceException if persisting should fail.
 * @Throws IOException if config.properties is not readable.
 */
public Backup runBackup(String name) throws QueryTimeoutException,
       PersistenceException, IOException {
    Properties props = ServerProperties.getProperties();
    Date date = new Date();
    String path = props.getProperty(dirPropertyKey)
            + name + "_" + getDateAsString(date);

    StoredProcedureQuery query = em.createStoredProcedureQuery(
            "SYSCS_UTIL.SYSCS_BACKUP_DATABASE");
    query.registerStoredProcedureParameter(1, String.class,
            ParameterMode.IN);
    query.setParameter(1, path);
    query.execute();
    log.debug("Backup query executed!");

    Backup backup =  generateBackup(name, path, date, getDirectorySize(new File(path)));

    return backup;
}
 

import javax.persistence.StoredProcedureQuery; //导入方法依赖的package包/类
/**
 * Checks whether the current day is a holiday.
 *
 * @param now The current day.
 * @return True if the current date is a holiday, false otherwise.
 * @throws BatchProcessingException If major error occurred.
 */
protected boolean isNowHoliday(Date now) throws BatchProcessingException {
    Calendar calendar = Calendar.getInstance();
    calendar.setTime(now);
    int dayOfWeek = calendar.get(Calendar.DAY_OF_WEEK);

    if (dayOfWeek == Calendar.SUNDAY || dayOfWeek == Calendar.SATURDAY) {
        return true; // Sunday for 0 and Saturday for 6 are holidays
    }

    try {
        startTransaction();

        StoredProcedureQuery sp = entityManager.createNamedStoredProcedureQuery("IsThisHoliday");
        sp.setParameter("pDate2Test", now, TemporalType.DATE);

        Boolean result = (Boolean) sp.getSingleResult();

        commitTransaction();

        return result;
    } catch (PersistenceException pe) {
        throw new BatchProcessingException("Database error checking holiday.", pe);
    }
}
 

import javax.persistence.StoredProcedureQuery; //导入方法依赖的package包/类
/**
 * Batch daily account update.
 * <p/>
 * This method does not throw any exception.
 *
 * @param procMessage The process message. Used to build the mail message.
 * @return true if execution is successful; false otherwise.
 */
private boolean batchDailyAccountUpdate(StringBuilder procMessage) {
    try {
        startTransaction();

        StoredProcedureQuery sp = entityManager.createNamedStoredProcedureQuery("BatchDailyAccountUpdate");
        sp.setParameter("pAuditBatchIDLog", todayAuditBatch.getId());

        Integer count = (Integer) sp.getSingleResult();

        commitTransaction();

        String msg = "Updated " + count + " master records to history or ACH Stop status.";
        logger.info(msg);
        procMessage.append(CRLF).append(CRLF).append(msg);

        return true;
    } catch (PersistenceException pe) {
        logger.error("ERROR: Updating master records to history or ACH Stop status failed.", pe);
        procMessage.append(CRLF).append(CRLF)
            .append("ERROR: Updating master records to history or ACH Stop status failed. ");
        return false;
    }
}
 

import javax.persistence.StoredProcedureQuery; //导入方法依赖的package包/类
@Test
public void testCallStoreProcedure() {

	StoredProcedureQuery query = entityManager.createStoredProcedureQuery("my_sum");
	query.registerStoredProcedureParameter("x", Integer.class, IN);
	query.registerStoredProcedureParameter("y", Integer.class, IN);

	query.setParameter("x", 5);
	query.setParameter("y", 4);
	query.execute();
	Integer sum = (Integer) query.getSingleResult();
	assertEquals("the sum in the stored procedure", sum, new Integer(9));
}
 

import javax.persistence.StoredProcedureQuery; //导入方法依赖的package包/类
@Test
public void plainJpa21() {

	StoredProcedureQuery proc = em.createStoredProcedureQuery("plus1inout");
	proc.registerStoredProcedureParameter(1, Integer.class, ParameterMode.IN);
	proc.registerStoredProcedureParameter(2, Integer.class, ParameterMode.OUT);

	proc.setParameter(1, 1);
	proc.execute();

	assertThat(proc.getOutputParameterValue(2), is((Object) 2));
}
 

import javax.persistence.StoredProcedureQuery; //导入方法依赖的package包/类
/**
 * Saves a bid to the database
 * @param bid - bid
 */
public void save(Bid bid) {   
    entityManager.persist(bid);
    StoredProcedureQuery spq = entityManager.createStoredProcedureQuery("getQtyOrders");
    spq.registerStoredProcedureParameter("param1", Integer.class, ParameterMode.IN);
    spq.setParameter("param1",55);
    Object[] count = (Object[])spq.getSingleResult();
    logger.log(Level.INFO, "Single result: {0}", count[0]);
}
 

import javax.persistence.StoredProcedureQuery; //导入方法依赖的package包/类
public void aggregateResults(Long processingId) {
	StoredProcedureQuery query = createProcedureQuery("aggregate_results");
	query.registerStoredProcedureParameter("process_id", Long.class, ParameterMode.IN);
	query.setParameter("process_id", processingId);
	query.execute();
}
 

import javax.persistence.StoredProcedureQuery; //导入方法依赖的package包/类
@Test
public void plainJpa21_entityAnnotatedCustomNamedProcedurePlus1IO() {

	StoredProcedureQuery proc = em.createNamedStoredProcedureQuery("User.plus1");

	proc.setParameter("arg", 1);
	proc.execute();

	assertThat(proc.getOutputParameterValue("res"), is((Object) 2));
}