Package se.unlogic.standardutils.dao.querys

Examples of se.unlogic.standardutils.dao.querys.BooleanQuery

65
66
67
68
69
70
71
72
73
74
75
   
  }

  public BooleanQuery getBooleanQuery(String sql) throws SQLException {

    BooleanQuery query = new BooleanQuery(connection, false, sql);
   
    checkQueryList();
   
    this.queryList.add(query);
   
View Full Code Here
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
    return beanExists(bean, transactionHandler.getConnection());
  }

  public boolean beanExists(T bean, Connection connection) throws SQLException {

    BooleanQuery query = null;

    try {

      query = new BooleanQuery(connection, false, this.checkIfExistsSQL);

      IntegerCounter integerCounter = new IntegerCounter();

      // Keys from SimpleColumns for where statement
      this.setQueryValues(bean, query, integerCounter, this.simpleKeys);

      // Keys from many to one relations for where statement
      this.setQueryValues(bean, query, integerCounter, this.manyToOneRelationKeys.values());

      return query.executeQuery();

    } finally {

      BooleanQuery.autoCloseQuery(query);
    }
View Full Code Here
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
1335
1336
    return this.getBoolean(lowLevelQuery, transactionHandler.getConnection());
  }

  public boolean getBoolean(LowLevelQuery<T> lowLevelQuery, Connection connection) throws SQLException {

    BooleanQuery query = null;

    try {

      query = new BooleanQuery(connection, false, lowLevelQuery.getSql());

      this.setCustomQueryParameters(query, lowLevelQuery.getParameters());

      return query.executeQuery();

    } finally {

      PreparedStatementQuery.autoCloseQuery(query);
    }
View Full Code Here
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
    return this.getBoolean(highLevelQuery, transactionHandler.getConnection());
  }

  public boolean getBoolean(HighLevelQuery<T> highLevelQuery, Connection connection) throws SQLException {

    BooleanQuery query = null;

    try {
      query = new BooleanQuery(connection, false, this.getSQL + this.getCriterias(highLevelQuery, true));

      if (highLevelQuery.getParameters() != null) {

        setQueryParameters(query, highLevelQuery, 1);
      }

      return query.executeQuery();

    } finally {

      PreparedStatementQuery.autoCloseQuery(query);
    }
View Full Code Here
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
    return beanExists(bean, transactionHandler.getConnection());
  }

  public boolean beanExists(T bean, Connection connection) throws SQLException {

    BooleanQuery query = null;

    try {

      query = new BooleanQuery(connection, false, this.checkIfExistsSQL);

      IntegerCounter integerCounter = new IntegerCounter();

      // Keys from SimpleColumns for where statement
      this.setQueryValues(bean, query, integerCounter, this.simpleKeys);

      // Keys from many to one relations for where statement
      this.setQueryValues(bean, query, integerCounter, this.manyToOneRelationKeys.values());

      return query.executeQuery();

    } finally {

      BooleanQuery.autoCloseQuery(query);
    }
View Full Code Here
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
1335
    return this.getBoolean(lowLevelQuery, transactionHandler.getConnection());
  }

  public boolean getBoolean(LowLevelQuery<T> lowLevelQuery, Connection connection) throws SQLException {

    BooleanQuery query = null;

    try {

      query = new BooleanQuery(connection, false, lowLevelQuery.getSql());

      this.setCustomQueryParameters(query, lowLevelQuery.getParameters());

      return query.executeQuery();

    } finally {

      PreparedStatementQuery.autoCloseQuery(query);
    }
View Full Code Here
1407
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
    return this.getBoolean(highLevelQuery, transactionHandler.getConnection());
  }

  public boolean getBoolean(HighLevelQuery<T> highLevelQuery, Connection connection) throws SQLException {

    BooleanQuery query = null;

    try {
      query = new BooleanQuery(connection, false, this.getSQL + this.getCriterias(highLevelQuery, true));

      if (highLevelQuery.getParameters() != null) {

        setQueryParameters(query, highLevelQuery, 1);
      }

      return query.executeQuery();

    } finally {

      PreparedStatementQuery.autoCloseQuery(query);
    }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
   
  }

  public BooleanQuery getBooleanQuery(String sql) throws SQLException {

    BooleanQuery query = new BooleanQuery(connection, false, sql);
   
    checkQueryList();
   
    this.queryList.add(query);
   
View Full Code Here
TOP

Related Classes of se.unlogic.standardutils.dao.querys.BooleanQuery

  • se.unlogic.standardutils.dao.AnnotatedDAO
  • se.unlogic.standardutils.dao.TransactionHandler
  • java.sql.ResultSet
    • 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.