没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
package com.gemship.common.service.impl;
import java.lang.reflect.Method;
import java.math.BigDecimal;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Types;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
import oracle.jdbc.OracleTypes;
import org.apache.commons.beanutils.converters.BooleanConverter;
import org.apache.commons.lang.time.DateUtils;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.jdbc.core.RowMapper;
import com.gemship.common.DateUtil;
import com.gemship.common.service.HelperService;
import com.gemship.commondata.util.ProcedureUtil;
import com.gemship.ecm.entity.RemindDaysSet;
import java.lang.reflect.Method;
import java.math.BigDecimal;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Types;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
import oracle.jdbc.OracleTypes;
import org.apache.commons.beanutils.converters.BooleanConverter;
import org.apache.commons.lang.time.DateUtils;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.jdbc.core.RowMapper;
import com.gemship.common.DateUtil;
import com.gemship.common.service.HelperService;
import com.gemship.commondata.util.ProcedureUtil;
import com.gemship.ecm.entity.RemindDaysSet;
import com.gemship.ecm.service.RemindDaysSetService;
import com.gfa4j.exception.ValidateRuntimeException;
import com.gfa4j.hibernate.BaseObject;
import com.gfa4j.query.StoredQueryInfo;
import com.gfa4j.service.impl.BaseServiceImpl;
import com.gfa4j.util.StringUtils;
public class HelperServiceImpl extends BaseServiceImpl implements HelperService {
private RemindDaysSetService remindDaysSetService;
public Map queryProcedure(List list, String strStoredProcedureName, int[] cursorIndexes,
Map<Integer, Integer> cursorTypes) {
StoredQueryInfo queryInfo = new StoredQueryInfo(strStoredProcedureName);
int size = list.size() + cursorIndexes.length;
int[] paramTypes = new int[size];
String[] paramNames = new String[size];
Object[] paramValues = new Object[size];
RowMapper[] dataExtracters = new RowMapper[size];
for (int i=0,j=0,k=0; i<size; i++) {
if(j < cursorIndexes.length && i == cursorIndexes[j]) {
//该参数为输出
Integer cursorType = cursorTypes.get(list.size()+j);
paramTypes[i] = cursorType == null ? OracleTypes.CURSOR : cursorType;
paramNames[i] = createCursorName(j);
paramValues[i] = null;
dataExtracters[i] = new RowMapper(){
@SuppressWarnings("unchecked")
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
Map resultData = new HashMap();
import com.gfa4j.exception.ValidateRuntimeException;
import com.gfa4j.hibernate.BaseObject;
import com.gfa4j.query.StoredQueryInfo;
import com.gfa4j.service.impl.BaseServiceImpl;
import com.gfa4j.util.StringUtils;
public class HelperServiceImpl extends BaseServiceImpl implements HelperService {
private RemindDaysSetService remindDaysSetService;
public Map queryProcedure(List list, String strStoredProcedureName, int[] cursorIndexes,
Map<Integer, Integer> cursorTypes) {
StoredQueryInfo queryInfo = new StoredQueryInfo(strStoredProcedureName);
int size = list.size() + cursorIndexes.length;
int[] paramTypes = new int[size];
String[] paramNames = new String[size];
Object[] paramValues = new Object[size];
RowMapper[] dataExtracters = new RowMapper[size];
for (int i=0,j=0,k=0; i<size; i++) {
if(j < cursorIndexes.length && i == cursorIndexes[j]) {
//该参数为输出
Integer cursorType = cursorTypes.get(list.size()+j);
paramTypes[i] = cursorType == null ? OracleTypes.CURSOR : cursorType;
paramNames[i] = createCursorName(j);
paramValues[i] = null;
dataExtracters[i] = new RowMapper(){
@SuppressWarnings("unchecked")
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
Map resultData = new HashMap();
剩余14页未读,继续阅读
资源评论
- 码农20032020-01-17还可以吧,参考一下还是可以的
泰格数据
- 粉丝: 48
- 资源: 9
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功