java程序调用Sybase存储过程:
public void saveHeader() throws SQLException {
CallableStatement cStmt = null;
String sqlStr = "{call AMS_ITEM_TRANS.SAVE_ALLOCATE_HEADER(?,?,?,?,?,?,?,?,?,?)}";
try {
cStmt = conn.prepareCall(sqlStr);
cStmt.setString(1, dto.getTransId());
cStmt.setString(2, dto.getTransNo());
cStmt.setString(3, dto.getTransType());
cStmt.setString(4, dto.getTransStatus());
cStmt.setString(5, dto.getFromObjectNo());
cStmt.setString(6, dto.getToObjectNo());
cStmt.setString(7, ConvertUtil.int2String(sfUser.getOrganizationId()));
cStmt.setString(8, ConvertUtil.int2String(dto.getToOrganizationId()));
cStmt.setString(9, dto.getRcvUser());
cStmt.setString(10, ConvertUtil.int2String(sfUser.getUserId()));
cStmt.registerOutParameter(1, Types.VARCHAR); //返回值
cStmt.execute();
dto.setTransId(cStmt.getString(1));
prodMessage("UPDATE_DATA_SUCCESS");
} finally {
DBManager.closeDBStatement(cStmt);
}
}