Package org.jpox.store.mapped.expression

Examples of org.jpox.store.mapped.expression.StringExpression

151
152
153
154
155
156
157
        ArrayList args = new ArrayList();
        args.add(str);
        args.add(begin.add(getMapping(BigInteger.class, str).newLiteral(str.getQueryExpression(), BigInteger.ONE)));
        args.add(end);

        return new StringExpression("SUBSTR", args);
    }
View Full Code Here
138
139
140
141
142
143
144
        ArrayList args = new ArrayList();
        args.add(str);
        args.add(begin.add(getMapping(Integer.class, str).newLiteral(str.getQueryExpression(), BigInteger.ONE)));
        args.add(lengthMethod(str).sub(begin));

        return new StringExpression("SUBSTRING", args);
    }
View Full Code Here
148
149
150
151
152
153
154
        ArrayList args = new ArrayList();
        args.add(str);
        args.add(begin.add(getMapping(BigInteger.class, str).newLiteral(str.getQueryExpression(), BigInteger.ONE)));
        args.add(end.sub(begin));

        return new StringExpression("SUBSTRING", args);
    }
View Full Code Here
372
373
374
375
376
377
378
        ArrayList args = new ArrayList();
        args.add(str);
        args.add(begin.add(getMapping(BigInteger.class, str).newLiteral(str.getQueryExpression(), BigInteger.ONE)));
        args.add(lengthMethod(str).sub(begin));

        return new StringExpression("SUBSTRING", args);
    }
View Full Code Here
384
385
386
387
388
389
390
        ArrayList args = new ArrayList();
        args.add(str);
        args.add(begin.add(getMapping(BigInteger.class, str).newLiteral(str.getQueryExpression(), BigInteger.ONE)));
        args.add(end.sub(begin));

        return new StringExpression("SUBSTRING", args);
    }
View Full Code Here
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
    {
        ArrayList args = new ArrayList();
        args.add(str);
        if (leading && trailing)
        {
            StringExpression strExpr = new StringExpression("RTRIM", args);
            args.clear();
            args.add(strExpr);
            return new StringExpression("LTRIM", args);
        }
        else if (leading)
        {
            return new StringExpression("LTRIM", args);
        }
        else if (trailing)
        {
            return new StringExpression("RTRIM", args);
        }
        return str;
    }
View Full Code Here
430
431
432
433
434
435
436
    {
        ScalarExpression integerLiteral = getMapping(BigInteger.class, source).newLiteral(source.getQueryExpression(), BigInteger.ONE);
        ArrayList args = new ArrayList();
        args.add(str);
        args.add(source);
        return new BooleanExpression(new StringExpression("CHARINDEX", args),ScalarExpression.OP_EQ,integerLiteral);
    }
View Full Code Here
262
263
264
265
266
267
268
    ArrayList args = new ArrayList();
    args.add(str);
    args.add(begin.add(getMapping(BigInteger.class, str).newLiteral(str.getQueryExpression(), BigInteger.ONE)));
    //Cloudscape 10.0
    //SUBSTR( string, start )
    return new StringExpression("SUBSTR", args);
  }
View Full Code Here
275
276
277
278
279
280
281
    args.add(str);
    args.add(begin.add(getMapping(BigInteger.class, str).newLiteral(str.getQueryExpression(), BigInteger.ONE)));
    args.add(end.sub(begin));
    //Cloudscape 10.0
    //SUBSTR( string, start, length )
    return new StringExpression("SUBSTR", args);
  }
View Full Code Here
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
    {
        ArrayList args = new ArrayList();
        args.add(str);
        if (leading && trailing)
        {
            StringExpression strExpr = new StringExpression("RTRIM", args);
            args.clear();
            args.add(strExpr);
            return new StringExpression("LTRIM", args);
        }
        else if (leading)
        {
            return new StringExpression("LTRIM", args);
        }
        else if (trailing)
        {
            return new StringExpression("RTRIM", args);
        }
        return str;
    }
View Full Code Here
TOP

Related Classes of org.jpox.store.mapped.expression.StringExpression

  • org.jpox.store.mapped.mapping.EnumMapping
  • org.jpox.store.mapped.mapping.ObjectAsStringMapping
  • org.jpox.store.mapped.mapping.StringMapping
  • org.jpox.store.rdbms.adapter.DatabaseAdapter
  • org.jpox.store.rdbms.adapter.DB2Adapter
  • org.jpox.store.rdbms.adapter.DerbyAdapter
  • org.jpox.store.rdbms.adapter.FirebirdAdapter
  • org.jpox.store.rdbms.adapter.HSQLAdapter
  • org.jpox.store.rdbms.adapter.InformixAdapter
  • org.jpox.store.rdbms.adapter.McKoiAdapter
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.