/** * 获取游戏接口参数 * * @param id * 游戏接口参数编号 * @return 游戏接口参数 */ public wh.game.model.GameInterfaceParams get(int id) throws Exception{ wh.game.model.GameInterfaceParams model = null; Map<String, Object> inParameters = new HashMap<String, Object>(); inParameters.put("GameInterfaceParamsId", id); OutParameters outParameters = new OutParameters(); outParameters.putOutParmType("ErrNo", java.sql.Types.INTEGER); outParameters.putOutParmType("ErrMsg", java.sql.Types.NVARCHAR); ResultSet rs = null; CallableStatement cstmt = null; int errNo = 0; String errMsg = ""; try { rs = SQLHelper.runProcedure(Config.CONNECTION_STRING_ULD, "{call WH_Game_GameInterfaceParams_Get(?,?,?)}", inParameters, outParameters); if (rs != null) { rs.next(); model = getModel(rs); cstmt = (CallableStatement)rs.getStatement(); errNo = cstmt.getInt("ErrNo"); errMsg = cstmt.getString("ErrMsg"); } } catch (Exception e) { throw new Exception(e.getMessage(), e); } finally{ SQLHelper.closeAll(cstmt); } MyErr.checkErr(errNo, errMsg); return model; }
public int updateStatus(String status, String lineNo) { int success = 0; String stRef; System.out.println("entered update "); if (status.equals("deactivate")) { System.out.println("in if deacti"); stRef = "T"; } else if (status.equals("activate")) { stRef = "A"; } else { stRef = ""; System.out.println("incorrect status"); } try { System.out.println("in try"); csRef = conRef.prepareCall(Queries.UPDATE_PROC); csRef.setString(1, lineNo); csRef.setString(2, stRef); csRef.registerOutParameter(3, Types.INTEGER); csRef.execute(); System.out.println("output: " + csRef.getInt(3)); /*psRef=conRef.prepareStatement("update enterprise set status=? where line_no=?"); psRef.setString(1,stRef); psRef.setString(2,lineNo); if(status.equals("deactivate")) { psRef.setString(1,"T"); } else { psRef.setString(1,"A"); }*/ success = csRef.getInt(3); System.out.println(success); if (success > 0) { System.out.println("updated status"); conRef.commit(); } /*success=psRef.executeUpdate(); System.out.println(success); if(success>0) { System.out.println("updated status"); conRef.commit(); }*/ } catch (SQLException e) { e.printStackTrace(); } return success; }
/** * * * <PRE> * Desc : Excute Procedure SP_INSERT_CUST_FROM_SEG * </PRE> * * @param RetrieveModel * @return RetrieveModel */ public RetrieveModel execProcedure(Connection con, RetrieveModel retrieve) throws StoreException { CallableStatement cstmt = null; ResultSet rset = null; try { cstmt = con.prepareCall("begin SP_INSERT_CUST_FROM_SEG(?, ?, ?, '', ?, ?, ?, ?, ?); end;"); int index = 1; cstmt.setString(index++, retrieve.getString("flag")); cstmt.setString(index++, retrieve.getString("promo_no")); cstmt.setString(index++, retrieve.getString("segment_code")); cstmt.setString(index++, retrieve.getString("proc_date")); cstmt.setString(index++, retrieve.getString("user_id")); cstmt.registerOutParameter(index++, java.sql.Types.INTEGER); cstmt.registerOutParameter(index++, java.sql.Types.INTEGER); cstmt.registerOutParameter(index++, java.sql.Types.VARCHAR); // = log Save Data --------------------- StringBuffer logString = new StringBuffer(); logString.append(retrieve.getString("flag")); logString.append("/"); logString.append(retrieve.getString("promo_no")); logString.append("/"); logString.append(retrieve.getString("segment_code")); logString.append("/"); logString.append(retrieve.getString("proc_date")); logString.append("/"); logString.append(retrieve.getString("user_id")); logString.append("/"); logSave.info(logString.toString()); // == 프로시져를 실행합니다. cstmt.executeUpdate(); retrieve.put("out_proc_cnt", cstmt.getInt(6)); retrieve.put("out_rtn", cstmt.getInt(7)); retrieve.put("out_rtn_msg", ComUtils.NVL(cstmt.getString(8), "")); } catch (SQLException se) { logSave.error( "[PromoSegmentSvc.execProcedure() SQLException : ERR-" + se.getErrorCode() + ":" + se); throw new StoreException(se.getMessage()); } catch (Exception e) { logSave.error("[PromoSegmentSvc.execProcedure() Exception : ERR-" + e.getMessage()); throw new StoreException(e.getMessage()); } finally { DBUtils.freeConnection(null, null, null, cstmt, null, rset); } return retrieve; }
@Override public int save(java.sql.Connection connection) { int nParam = 1; CallableStatement callableStatement = null; mnLastDbActionResult = SLibConstants.UNDEFINED; try { callableStatement = connection.prepareCall("{ CALL erp.finu_tax_bas_save(" + "?, ?, ?, ?, ?, ?, ?) }"); callableStatement.setInt(nParam++, mnPkTaxBasicId); callableStatement.setString(nParam++, msTaxBasic); callableStatement.setBoolean(nParam++, mbIsDeleted); callableStatement.setInt(nParam++, mbIsRegistryNew ? mnFkUserNewId : mnFkUserEditId); callableStatement.registerOutParameter(nParam++, java.sql.Types.SMALLINT); callableStatement.registerOutParameter(nParam++, java.sql.Types.SMALLINT); callableStatement.registerOutParameter(nParam++, java.sql.Types.CHAR); callableStatement.execute(); mnPkTaxBasicId = callableStatement.getInt(nParam - 3); mnDbmsErrorId = callableStatement.getInt(nParam - 2); msDbmsError = callableStatement.getString(nParam - 1); if (mnDbmsErrorId != 0) { throw new Exception(msDbmsError); } else { // Save aswell the taxes nParam = 1; for (int i = 0; i < mvDbmsTaxes.size(); i++) { mvDbmsTaxes.get(i).setPkTaxBasicId(mnPkTaxBasicId); if (mvDbmsTaxes.get(i).save(connection) != SLibConstants.DB_ACTION_SAVE_OK) { throw new Exception(SLibConstants.MSG_ERR_DB_REG_SAVE_DEP); } } mbIsRegistryNew = false; mnLastDbActionResult = SLibConstants.DB_ACTION_SAVE_OK; } } catch (java.sql.SQLException e) { mnLastDbActionResult = SLibConstants.DB_ACTION_SAVE_ERROR; SLibUtilities.printOutException(this, e); } catch (java.lang.Exception e) { mnLastDbActionResult = SLibConstants.DB_ACTION_SAVE_ERROR; SLibUtilities.printOutException(this, e); } return mnLastDbActionResult; }
public static int ExisteServicio(int IdServicio) throws Exception { int resultado = 0; CallableStatement ObjProcedimiento; Connection conector = estado(); try { ObjProcedimiento = conector.prepareCall("{call ExisteServicio(?,?)}"); ObjProcedimiento.setInt(1, IdServicio); ObjProcedimiento.registerOutParameter(2, Types.INTEGER); ObjProcedimiento.execute(); resultado = ObjProcedimiento.getInt(2); } catch (Exception pp) { JOptionPane.showMessageDialog( null, "Error en Catalogo: ExisteServicio " + pp.getMessage(), "ATENCION", JOptionPane.WARNING_MESSAGE); } finally { conector.close(); } return resultado; }
public void save(Connection conn, String welfarefundId) throws SQLException { CallableStatement cstmt = null; try { String sql = "begin HR_WLF_WELFARE_PKG.SAVE_EMPOLYEE_TYPE(:1,:2,:3,:4); end;"; cstmt = conn.prepareCall(sql); DeBug.print(sql); cstmt.setString(1, Decoder.convertSetString(welfarefundId)); cstmt.setString(2, Decoder.convertSetString(this.getCurrentEmployeeType().getAttributeId())); cstmt.registerOutParameter(3, Types.INTEGER); cstmt.registerOutParameter(4, Types.VARCHAR); cstmt.execute(); int returnCode = cstmt.getInt(3); String returnMessage = cstmt.getString(4); DeBug.print("in Save : the returnCode : " + returnCode); DeBug.print("in Save : the returnMessage : " + returnMessage); } finally { try { cstmt.close(); cstmt = null; } catch (Exception e) { } } }
/** * @param ds * @param userId * @param e2bExchangeId * @param initOrFollow * @throws SQLException */ public void importE2bData(String userId, String e2bExchangeId) throws SQLException { log.info("### in importE2bData ("); Connection con = null; try { con = ds.getConnection(); String sql = "{ call ? := LAU_E2B_INBOUND.import_e2b_message(?,?,?,?,?,?,?,?)}"; CallableStatement stmt = con.prepareCall(sql); stmt.registerOutParameter(1, OracleTypes.VARCHAR); // 1 stmt.setString(2, e2bExchangeId); // P_CLOB_ID NUMBER , :2 stmt.registerOutParameter(3, OracleTypes.VARCHAR); // P_ERR_MSG OUT // varchar2, :3 stmt.registerOutParameter(4, OracleTypes.VARCHAR); // P_MSG OUT // varchar2, :4 stmt.registerOutParameter(5, OracleTypes.VARCHAR); // P_REPORT_ID_OUT // out VARCHAR2, // :5 stmt.registerOutParameter(6, OracleTypes.VARCHAR); // P_LAU_REPORT_ID_OUT // out VARCHAR2, // :6 stmt.registerOutParameter(7, OracleTypes.NUMBER); // P_ACK_ID_OUT out // NUMBER, :7 stmt.setString(8, userId); // P_USER_ID varchar2, :8 stmt.setString(9, "N"); // P_MULTICASES VARCHAR2 DEFAULT 'N', :9 // stmt.setString(10, initOrFollow);// P_PROCESSING_MODE VARCHAR2 // DEFAULT 'AUTOMATED', :10 // stmt.setString(11, "Y");// P_ACK VARCHAR2 DEFAULT 'Y', :11 // stmt.setString(12, "N"); // P_DISPLAY_OUTPUT VARCHAR2 DEFAULT 'N' // :12 log.info("15===="); log.info(sql); stmt.execute(); // FUNCTION output // int update = stmt.getInt(1); String retVal = stmt.getString(1); // 0 - Error, > 0 success String strError = stmt.getString(3); // P_ERR_MSG OUT varchar2, :3 String strMsg = stmt.getString(4); // P_MSG OUT varchar2, :4 String strRepId = stmt.getString(5); // P_REPORT_ID_OUT out VARCHAR2, // :5 String strLauRepId = stmt.getString(6); // P_LAU_REPORT_ID_OUT out // VARCHAR2, :6 String ackId = Integer.toString(stmt.getInt(7)); // P_ACK_ID_OUT out // NUMBER, :7 log.info("Funtion returned ...:" + retVal + "," + strError + "," + strRepId); stmt.close(); con.close(); } finally { try { if (con != null) con.close(); } catch (Exception e) { log.error(e, e); } } }
@Override protected ArrayList vAddRow(Connection conn) throws Exception { RBDocTypesDPanel p = new RBDocTypesDPanel(); AUniversalAddDialog d = new AUniversalAddDialog(p, null, true); d.setTitleIcon( new javax.swing.ImageIcon( getClass().getResource("/tradeterminal/icons/TT_icons/32X32/typplus.png"))); d.setVisible(true); d.dispose(); if (d.getReturnStatus() == ADialog.RET_OK) { CallableStatement proc = conn.prepareCall("{? = call rb_doc_types_insert(?,?)}"); proc.registerOutParameter(1, Types.INTEGER); proc.setString(2, p.get_Name()); proc.setString(3, p.getDescription()); proc.execute(); int id = proc.getInt(1); proc.close(); ArrayList newRow = new ArrayList(); newRow.add(id); newRow.add(p.get_Name()); newRow.add(p.getDescription()); return newRow; } else { return null; } }
// ELIMINAR public String EliminarAsistenciaCurso(PublicacionesDTO escolaridaDTO) { try { try { ConexionBD conexionBD = new ConexionBD(); conexionBD.abrir(); Connection connection = conexionBD.getConexion(); String sql = "{ ? = call eliminar_publicaciones(?)} "; CallableStatement callableStatement = connection.prepareCall(sql); callableStatement.registerOutParameter(1, Types.INTEGER); callableStatement.setInt(2, escolaridaDTO.getId()); callableStatement.execute(); Integer num = callableStatement.getInt(1); connection.close(); if (num == 1) { return "¡Se elimino satisfactoriamente!"; } else { return ""; } } catch (Exception e) { e.printStackTrace(); } } catch (Exception ex) { System.out.println("Error en.." + ex.getMessage()); } return ""; }
@Override public boolean getForumFullScan(String forum) { /* function get_forum_scan (p_forum in varchar2) return number; */ boolean result = true; String proc = "{? = call dxdy_executable.get_forum_scan (?)}"; CallableStatement st = null; try { st = connection.prepareCall(proc); st.registerOutParameter(1, Types.INTEGER); st.setString(2, forum); st.execute(); result = (st.getInt(1) == 1); } catch (SQLException e) { e.printStackTrace(); } finally { if (st != null) { try { st.close(); } catch (SQLException e) { e.printStackTrace(); } } } return result; }
@Override public int save(java.sql.Connection connection) { int i = 0; int nParam = 1; CallableStatement callableStatement = null; mnLastDbActionResult = SLibConstants.UNDEFINED; try { callableStatement = connection.prepareCall("{ CALL mfgu_line_save(" + "?, ?, ?, ?, ?, " + "?, ?, ?) }"); callableStatement.setInt(nParam++, mnPkMfgLineId); callableStatement.setString(nParam++, msMfgLine); callableStatement.setBoolean(nParam++, mbIsDeleted); callableStatement.setInt(nParam++, mnFkCostCenterId); callableStatement.setInt(nParam++, mbIsRegistryNew ? mnFkUserNewId : mnFkUserEditId); callableStatement.registerOutParameter(nParam++, java.sql.Types.INTEGER); callableStatement.registerOutParameter(nParam++, java.sql.Types.SMALLINT); callableStatement.registerOutParameter(nParam++, java.sql.Types.VARCHAR); callableStatement.execute(); mnPkMfgLineId = callableStatement.getInt(nParam - 3); mnDbmsErrorId = callableStatement.getInt(nParam - 2); msDbmsError = callableStatement.getString(nParam - 1); mbIsRegistryNew = false; mnLastDbActionResult = SLibConstants.DB_ACTION_SAVE_OK; } catch (java.lang.Exception e) { mnLastDbActionResult = SLibConstants.DB_ACTION_SAVE_ERROR; SLibUtilities.printOutException(this, e); } return mnLastDbActionResult; }
@Override public int getLastTopicPage(int tID) { String proc = "{? = call dxdy_executable.get_topic_last_page(?)}"; CallableStatement st = null; int res = 0; try { st = connection.prepareCall(proc); st.registerOutParameter(1, java.sql.Types.INTEGER); st.setInt(2, tID); st.execute(); res = st.getInt(1); } catch (SQLException e) { System.out.println("Error while querying last page of topic ID = " + tID); e.printStackTrace(); } finally { if (st != null) { try { st.close(); } catch (SQLException e) { e.printStackTrace(); } } } return res; }
public int nextTSecGroupIdGen(CFSecurityAuthorization Authorization, CFSecurityTenantPKey PKey) { final String S_ProcName = "nextTSecGroupIdGen"; if (!schema.isTransactionOpen()) { throw CFLib.getDefaultExceptionFactory() .newUsageException(getClass(), S_ProcName, "Not in a transaction"); } Connection cnx = schema.getCnx(); long Id = PKey.getRequiredId(); CallableStatement stmtSelectNextTSecGroupIdGen = null; try { String sql = "{ call sp_next_tsecgroupidgen( ?" + ", " + "?" + " ) }"; stmtSelectNextTSecGroupIdGen = cnx.prepareCall(sql); int argIdx = 1; stmtSelectNextTSecGroupIdGen.registerOutParameter(argIdx++, java.sql.Types.INTEGER); stmtSelectNextTSecGroupIdGen.setLong(argIdx++, Id); stmtSelectNextTSecGroupIdGen.execute(); int nextId = stmtSelectNextTSecGroupIdGen.getInt(1); return (nextId); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (stmtSelectNextTSecGroupIdGen != null) { try { stmtSelectNextTSecGroupIdGen.close(); } catch (SQLException e) { } stmtSelectNextTSecGroupIdGen = null; } } }
/** * Control de transacción en el procedimiento almacenado * * @param prod */ @Override public void create2(Producto prod) { Connection cn = null; try { cn = AccesoDB.getConnection(); cn.setAutoCommit(true); String query = "{call usp_crea_producto(?,?,?,?,?)}"; CallableStatement cstm = cn.prepareCall(query); cstm.registerOutParameter(1, Types.INTEGER); cstm.setInt(2, prod.getIdcat()); cstm.setString(3, prod.getNombre()); cstm.setDouble(4, prod.getPrecio()); cstm.setInt(5, prod.getStock()); cstm.executeUpdate(); prod.setIdprod(cstm.getInt(1)); cstm.close(); } catch (SQLException e) { throw new RuntimeException(e.getMessage()); } catch (Exception e) { throw new RuntimeException("No se puede crear el producto."); } finally { try { cn.close(); } catch (Exception e) { } } }
@Override public int call(java.sql.Connection connection) { int nParam = 1; java.sql.CallableStatement callableStatement = null; mnLastDbActionResult = SLibConstants.UNDEFINED; try { callableStatement = connection.prepareCall("{ CALL mfg_ltime_cob_val(?, ?, ?) }"); callableStatement.setInt(nParam, (Integer) mvParamsIn.get(nParam - 1)); nParam++; callableStatement.setInt(nParam, (Integer) mvParamsIn.get(nParam - 1)); nParam++; callableStatement.registerOutParameter(nParam, java.sql.Types.INTEGER); callableStatement.execute(); mvParamsOut.clear(); mvParamsOut.add(callableStatement.getInt(nParam)); mnLastDbActionResult = SLibConstants.DB_PROCEDURE_OK; } catch (java.sql.SQLException e) { mnLastDbActionResult = SLibConstants.DB_PROCEDURE_ERROR; SLibUtilities.printOutException(this, e); } catch (java.lang.Exception e) { mnLastDbActionResult = SLibConstants.DB_PROCEDURE_ERROR; SLibUtilities.printOutException(this, e); } return mnLastDbActionResult; }
public void testSum() throws SQLException { CallableStatement cs = con.prepareCall("{?= call mysum(?, ?)}"); cs.registerOutParameter(1, Types.INTEGER); cs.setInt(2, 2); cs.setInt(3, 3); cs.execute(); assertEquals("2+3 should be 5 when executed via {?= call mysum(?, ?)}", 5, cs.getInt(1)); }
@Override public int getCallableInt(int columnIndex) throws JdbcException { try { return callableStatement.getInt(columnIndex); } catch (SQLException ex) { throw newJdbcException(ex); } }
/* * (non-Javadoc) * * @see * pe.com.viajes.negocio.dao.ServicioNoviosDao#registrarNovios(pe.com * .logistica.bean.negocio.ProgramaNovios) */ @Override public Integer registrarNovios(ProgramaNovios programaNovios) throws SQLException { Integer codigoNovios = 0; Connection conn = null; CallableStatement cs = null; String sql = "{ ? = call negocio.fn_ingresarprogramanovios(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) }"; try { conn = UtilConexion.obtenerConexion(); cs = conn.prepareCall(sql); int i = 1; cs.registerOutParameter(i++, Types.INTEGER); cs.setInt(i++, programaNovios.getNovia().getCodigoEntero()); cs.setInt(i++, programaNovios.getNovio().getCodigoEntero()); cs.setInt(i++, programaNovios.getDestino().getCodigoEntero()); cs.setDate(i++, UtilJdbc.convertirUtilDateSQLDate(programaNovios.getFechaBoda())); cs.setDate(i++, UtilJdbc.convertirUtilDateSQLDate(programaNovios.getFechaViaje())); cs.setInt(i++, programaNovios.getMoneda().getCodigoEntero()); cs.setBigDecimal(i++, programaNovios.getCuotaInicial()); cs.setInt(i++, programaNovios.getNroDias()); cs.setInt(i++, programaNovios.getNroNoches()); cs.setDate(i++, UtilJdbc.convertirUtilDateSQLDate(programaNovios.getFechaShower())); if (StringUtils.isNotBlank(programaNovios.getObservaciones())) { cs.setString(i++, programaNovios.getObservaciones()); } else { cs.setNull(i++, Types.VARCHAR); } cs.setBigDecimal(i++, programaNovios.getMontoTotalServiciosPrograma()); cs.setInt(i++, programaNovios.getIdServicio()); cs.setString(i++, programaNovios.getUsuarioCreacion()); cs.setString(i++, programaNovios.getIpCreacion()); cs.execute(); codigoNovios = cs.getInt(1); } catch (SQLException e) { codigoNovios = 0; throw new SQLException(e); } finally { try { if (cs != null) { cs.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { try { if (conn != null) { conn.close(); } throw new SQLException(e); } catch (SQLException e1) { throw new SQLException(e); } } } return codigoNovios; }
@Override public E getNullableResult(CallableStatement cs, int columnIndex) throws SQLException { int i = cs.getInt(columnIndex); if (cs.wasNull()) { return null; } else { return convert(i); } }
public int getInt(String parameterName) throws SQLException { checkOpen(); try { return _stmt.getInt(parameterName); } catch (SQLException e) { handleException(e); return 0; } }
public String guardarDato(PublicacionesDTO asistenciacursosDTO) { try { try { ConexionBD conexionBD = new ConexionBD(); conexionBD.abrir(); Connection connection = conexionBD.getConexion(); String sql = "{ ? = call insertar_publicaciones(?,?,?,?,?,?,?,?)} "; CallableStatement callableStatement = connection.prepareCall(sql); callableStatement.registerOutParameter(1, Types.INTEGER); callableStatement.setString(2, asistenciacursosDTO.getPeriodo()); callableStatement.setString(3, asistenciacursosDTO.getPublicacion()); callableStatement.setString(4, asistenciacursosDTO.getInstitucion()); callableStatement.setBinaryStream(5, asistenciacursosDTO.getEvidencia().getInputstream()); callableStatement.setInt(6, asistenciacursosDTO.getIdmodif()); Calendar cal1 = Calendar.getInstance(); String Fecha = ("" + cal1.get(Calendar.DATE) + "/" + cal1.get(Calendar.MONTH) + "/" + cal1.get(Calendar.YEAR) + " " + cal1.get(Calendar.HOUR_OF_DAY) + ":" + cal1.get(Calendar.MINUTE) + ":" + cal1.get(Calendar.SECOND) + ":" + cal1.get(Calendar.MILLISECOND)); callableStatement.setString(7, Fecha); callableStatement.setInt(8, asistenciacursosDTO.getIdlic()); callableStatement.setInt(9, asistenciacursosDTO.getIdusuario()); callableStatement.execute(); Integer num = callableStatement.getInt(1); connection.close(); if (num == 1) { return "¡Se guardo satisfactoriamente!"; } else { return ""; } } catch (Exception e) { e.printStackTrace(); } } catch (Exception ex) { System.out.println("Error en.." + ex.getMessage()); } return ""; }
@Override public Object getResult(CallableStatement cs, int columnIndex) throws SQLException { try { Integer result = cs.getInt(columnIndex); return InvoiceType.getItem(result); } catch (SQLException e) { logger.error("自定义转换获取值的时候出错。", e); } return null; }
/* Business type 2 */ public void saveQuoteItemDtl(QuotationMgr quotationMgr, Connection conn, String quoteId) throws SQLException { CallableStatement cstmt = null; try { this.mCode = 0; conn.setAutoCommit(false); String sql = "begin OM_QUOTATION_PKG.SAVE_QUOTE_ITEM_DTL(:1,:2,:3,:4,:5,:6,:7,:8,:9); end;"; cstmt = conn.prepareCall(sql); DeBug.print(sql); if (quoteId == null || quoteId.equals("")) return; cstmt.setString(1, Decoder.convertSetString(quoteId)); cstmt.setNull(2, Types.VARCHAR); cstmt.setString(3, Decoder.convertSetString(this.getCustomerId())); cstmt.setString(4, Decoder.convertSetString(this.getCurrentSite().getSiteId())); cstmt.setString(5, Decoder.convertSetString(this.getCurrentContact().getContactId())); cstmt.setString(6, Decoder.convertSetString(this.getQuotePrice())); cstmt.setString(7, Decoder.convertSetString("CREATE")); cstmt.registerOutParameter(2, Types.VARCHAR); cstmt.registerOutParameter(8, Types.INTEGER); cstmt.registerOutParameter(9, Types.INTEGER); cstmt.execute(); int returnCode = cstmt.getInt(8); String returnMessage = cstmt.getString(9); DeBug.print(String.valueOf(returnCode), "(in Save : the returnCode )"); DeBug.print(returnMessage, "(in Save : the returnMessage )"); if (returnCode != 0) { // Non-manageable error. conn.rollback(); this.mCode = SAVE_ERROR; } else { this.setQuoteDtlId(cstmt.getString(2)); } } catch (Exception e) { conn.rollback(); e.printStackTrace(); this.mCode = SAVE_ERROR; } finally { try { if (cstmt != null) { cstmt.close(); } cstmt = null; } catch (Exception e) { e.printStackTrace(); } } }
/** * others method ** */ public void save() throws SQLException { Connection conn = OracleGate.getConnection(); CallableStatement cstmt = null; this.mCode = 0; try { conn.setAutoCommit(false); String sql = "begin BOM_PARAMETER_PKG.SAVE_PARAMETER(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); end;"; DeBug.print(sql); cstmt = conn.prepareCall(sql); cstmt.setString(1, this.getWeightBase()); cstmt.setString(2, this.getPacking()); cstmt.setString(3, this.getElectrolysis()); cstmt.setString(4, this.getManagement()); cstmt.setString(5, this.getSaraly()); cstmt.setString(6, this.getScript()); cstmt.setString(7, this.getAssemblybase()); cstmt.setString(8, this.getProfit()); cstmt.registerOutParameter(9, Types.INTEGER); cstmt.registerOutParameter(10, Types.VARCHAR); cstmt.execute(); int returnCode = cstmt.getInt(9); String returnMessage = cstmt.getString(10); DeBug.print(" returnCode ::" + returnCode); DeBug.print(" returnMessage ::" + returnMessage); if (returnCode == -2) { // Violate unique constraint in database conn.rollback(); this.mCode = UNIQUE_VIOLATION; } else if (returnCode != 0) { // Non-manageable error. conn.rollback(); this.mCode = SAVE_ERROR; } else { conn.commit(); } } catch (Exception e) { conn.rollback(); e.printStackTrace(); this.mCode = SAVE_ERROR; } finally { conn.setAutoCommit(true); if (conn != null) { OracleGate.freeConnection(conn); } try { if (cstmt != null) { cstmt.close(); } cstmt = null; } catch (Exception e) { e.printStackTrace(); } } }
/* Business type 2 */ public void saveStatus(QuotationMgr quotationMgr) throws SQLException { Connection conn = null; conn = OracleGate.getConnection(); CallableStatement cstmt = null; System.out.println("Quotation detail id : " + this.getQuoteDtlId()); try { this.mCode = 0; conn.setAutoCommit(false); String sql = "begin OM_QUOTATION_PKG.SAVE_QUOTE_ITEM_STATUS(:1,:2,:3); end;"; cstmt = conn.prepareCall(sql); DeBug.print(sql); cstmt.setString(1, Decoder.convertSetString(this.getQuoteDtlId())); cstmt.registerOutParameter(2, Types.INTEGER); cstmt.registerOutParameter(3, Types.INTEGER); cstmt.execute(); int returnCode = cstmt.getInt(2); String returnMessage = cstmt.getString(3); DeBug.print(String.valueOf(returnCode), "(in Save : the returnCode )"); DeBug.print(returnMessage, "(in Save : the returnMessage )"); if (returnCode != 0) { // Non-manageable error. conn.rollback(); this.mCode = SAVE_ERROR; } else { conn.commit(); } } catch (Exception e) { conn.rollback(); e.printStackTrace(); this.mCode = SAVE_ERROR; } finally { conn.setAutoCommit(true); if (conn != null) { OracleGate.freeConnection(conn); } try { if (cstmt != null) { cstmt.close(); } cstmt = null; } catch (Exception e) { e.printStackTrace(); } } }
public void testMultipleOutExecutions() throws SQLException { CallableStatement cs = con.prepareCall("{call myiofunc(?, ?)}"); for (int i = 0; i < 10; i++) { cs.registerOutParameter(1, Types.INTEGER); cs.registerOutParameter(2, Types.INTEGER); cs.setInt(1, i); cs.execute(); assertEquals(1, cs.getInt(1)); assertEquals(i, cs.getInt(2)); cs.clearParameters(); } }
public void testGetInt01() throws Throwable { try { Statement stmt = con.createStatement(); stmt.execute("create temp table i_tab ( max_val int, min_val int, null_val int )"); stmt.execute("insert into i_tab values (2147483647,-2147483648,null)"); boolean ret = stmt.execute( "create or replace function " + "int_proc( OUT IMAX int, OUT IMIN int, OUT INUL int) as " + "'begin " + "select max_val into imax from i_tab;" + "select min_val into imin from i_tab;" + "select null_val into inul from i_tab;" + " end;' " + "language plpgsql;"); } catch (Exception ex) { fail(ex.getMessage()); throw ex; } try { CallableStatement cstmt = con.prepareCall("{ call int_proc(?,?,?) }"); cstmt.registerOutParameter(1, java.sql.Types.INTEGER); cstmt.registerOutParameter(2, java.sql.Types.INTEGER); cstmt.registerOutParameter(3, java.sql.Types.INTEGER); cstmt.executeUpdate(); assertTrue(cstmt.getInt(1) == 2147483647); assertTrue(cstmt.getInt(2) == -2147483648); cstmt.getInt(3); assertTrue(cstmt.wasNull()); } catch (Exception ex) { fail(ex.getMessage()); } finally { try { Statement dstmt = con.createStatement(); dstmt.execute("drop function int_proc()"); } catch (Exception ex) { } } }
public void save(Connection conn, AccountingArMgr accMgr, int rowIndex) throws SQLException { CallableStatement cstmt = null; String verbEntryMode = accMgr.getEntryMode().split("-")[0]; try { this.mCode = 0; String sql = "begin FM_AR_PAYMENT_TERM_DETAIL_PKG.SAVE(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11); end;"; cstmt = conn.prepareCall(sql); DeBug.print(sql); cstmt.setLong(1, Long.parseLong(accMgr.getCurrentMiscellaneousInvoice().getInvoiceId())); cstmt.setLong(2, Long.parseLong(this.getPaymentTerm().getAttributeCode())); cstmt.setDouble(3, Double.parseDouble(this.getPercentage())); cstmt.setString( 4, Decoder.convertSetString(accMgr.getCurrentMiscellaneousInvoice().getStartDate())); cstmt.setNull(5, Types.VARCHAR); cstmt.setNull(6, Types.VARCHAR); cstmt.setString( 7, Decoder.convertSetString(accMgr.getCurrentMiscellaneousInvoice().getSourceType())); cstmt.setString(8, Decoder.convertSetString(verbEntryMode)); cstmt.setLong(9, rowIndex); cstmt.registerOutParameter(10, Types.INTEGER); cstmt.registerOutParameter(11, Types.VARCHAR); cstmt.execute(); int returnCode = cstmt.getInt(10); String returnMessage = cstmt.getString(11); if (returnCode == -2) { // Violate unique constraint in database this.mCode = UNIQUE_VIOLATION; throw new SQLException(returnMessage); } else if (returnCode != 0) { // Non-manageable error. this.mCode = SAVE_ERROR; throw new SQLException(returnMessage); } } catch (Exception e) { this.mCode = SAVE_ERROR; e.printStackTrace(); throw new SQLException(e.getMessage()); } finally { if (cstmt != null) { cstmt.close(); } cstmt = null; } }
/** The int value */ @Override public int getInt(String name) throws SQLException { try { return _cstmt.getInt(name); } catch (SQLException e) { onSqlException(e); throw e; } catch (RuntimeException e) { onRuntimeException(e); throw e; } }
public int saveMemo(Connection conn, Login login) throws SQLException { CallableStatement cstmt = null; try { this.mCode = 0; String sql = "begin FM_AR_SEND_TO_FM_PKG.SAVE_CREDIT_MEMO_TO_GL(:1,:2,:3,:4,:5); end;"; cstmt = conn.prepareCall(sql); DeBug.print(sql); int returnCode; String returnMessage; cstmt.setString(1, this.getMemoId()); cstmt.setString(2, Decoder.convertSetString(login.getLoginName())); cstmt.registerOutParameter(3, Types.VARCHAR); cstmt.registerOutParameter(4, Types.INTEGER); cstmt.registerOutParameter(5, Types.VARCHAR); cstmt.execute(); returnCode = cstmt.getInt(4); returnMessage = cstmt.getString(5); DeBug.print(returnCode + ":" + returnMessage); if (returnCode != 0) { this.mCode = SAVE_ERROR; return this.mCode; } else if (returnCode == -5) { this.mCode = TAX_ID_NOT_FOUND; return this.mCode; } else if (returnCode != 0) { this.mCode = SAVE_ERROR; return this.mCode; } else { this.setVoucherNo(cstmt.getString(3)); this.setIsSavedFlag("Y"); return this.mCode; } } catch (Exception e) { this.mCode = SAVE_ERROR; e.printStackTrace(); throw new SQLException(e.getMessage()); } finally { if (cstmt != null) { cstmt.close(); } cstmt = null; } }