public static PreparedStatement setParams()

in shardingsphere-benchmark/src/main/java/org/apache/shardingsphere/benchmark/db/jdbc/JDBCDataSourceUtil.java [167:182]


    public static PreparedStatement setParams(PreparedStatement result, List params) throws SQLException {
        if(params != null){
            for (int i = 0; i < params.size(); i++){
                if (params.get(i) instanceof Long){
                    result.setLong(i+1, (Long) params.get(i));
                } else if(params.get(i) instanceof Integer){
                    result.setInt(i+1, (Integer) params.get(i));
                } else if(params.get(i) instanceof  String){
                    result.setString(i+1, (String)params.get(i));
                } else if(params.get(i) instanceof Double){
                    result.setDouble(i+1, (Double)params.get(i));
                }
            }
        }
        return result;
    }