Examples of SqlQuery

Examples of com.mysema.query.sql.SQLQuery

13
14
15
16
17
18
19
20
21
   
    private QSurvey survey = new QSurvey("survey");
   
    @Before
    public void setUp() {
        query = new SQLQuery(null, new H2Templates() {{
            newLineToSingleSpace();
        }});
    }
View Full Code Here

Examples of com.nykredit.kundeservice.data.sql.SqlQuery

47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
    String sql = "SELECT " +
               "* " +
           "FROM " +
               "KS_DRIFT.WEBDESK_DEPARTMENT";

    SqlQuery query = new SqlQuery(conn, sql);

    try {
      query.execute();
     
      while(query.next())
        departments.add(new WebdeskDepartment(query.getInteger("ID"), query.getString("DEPARTMENT")));
    } catch (DopeException e) {
      throw new OperationAbortedException(e, "Error during load of webdesk departments.", "Der skete en fejl ved indl�sning af webdesk departments.");
    }

    return departments;
View Full Code Here

Examples of edu.spbstu.hoteldb.interfaces.SQLQuery

40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
    String lang = ((ChoiceBox<String>) args.get(5)).getValue();
    if ((email.compareTo("") == 0) || (pass.compareTo("") == 0)
        || (name.compareTo("") == 0)) {
      textArea.appendText("Login, password and name are required to complete registration.");
    } else {
      SQLQuery nuu = new NewUserUpdate(connect, textArea);
      List<Object> args = new LinkedList<Object>();
      args.add(login); args.add(email); args.add(pass); args.add(name); args.add(country); args.add(lang);
      try {
        nuu.prepareQuery(args);
        nuu.doQuery();
        main.setPanel(PanelType.LoginPanel, null);       
      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
View Full Code Here

Examples of fi.evident.dalesbred.SqlQuery

53
54
55
56
57
58
59
60
61
    }

    @Test
    public void placeholders() {
        QueryBuilder qb = new QueryBuilder("select * from document");
        SqlQuery query = qb.append(" where id in (").appendPlaceholders(4).append(")").addArguments(1,2,3).addArgument(4).build();

        assertEquals(query("select * from document where id in (?,?,?,?)", 1, 2, 3, 4), query);
    }
View Full Code Here

Examples of gc.base.sql.SqlQuery

227
228
229
230
231
232
233
234
235
236
237
238
    SqlQInfo info = getSqlQInfo();
    info.setWhere("DOCUUID=?");
    List<Object> bindings = new ArrayList<Object>();
    bindings.add(docuuid);
    info.setQueryBindings(bindings);
    SqlQuery q = new SqlQuery();
    q.query(context,con,info, new SqlRowHandler() {
      @Override
      public void handleSqlRow(TaskContext context, Connection con, ResultSet rs,
          long rowNum) throws Exception {
        readFields(rs);
      }
View Full Code Here

Examples of jimm.datavision.source.sql.SQLQuery

84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
    try {
  report.setDatabasePassword(DB_PASSWORD);
  report.read(EXAMPLE_REPORT);

  Database db = (Database)report.getDataSource();
  SQLQuery query = (SQLQuery)db.getQuery();

  assertEquals("{jobs.ID} < 100", query.getWhereClause());
  assertNotNull(db.findColumn("ALL_CAPS.COL1"));
  assertNotNull(db.findColumn("jobs.fk_office_id"));
  assertNotNull(db.findColumn("office.email"));
  assertNotNull(db.findColumn("aggregate_test.value"));

  // We should only have two tables in the query.
  query.findSelectablesUsed();
  assertEquals(2, query.getNumTables());

  db.reset(DRIVER_CLASS_NAME, CONNECTION_INFO, DB_NAME, DB_USER,
     DB_PASSWORD);
  // The query doesn't have to be the same object, but it's where
  // clause (and all other information) should darned well be the same.
  assertEquals("{jobs.ID} < 100", query.getWhereClause());
  assertNotNull(db.findColumn("public.ALL_CAPS.COL1"));
  assertNotNull(db.findColumn("public.jobs.fk_office_id"));
  assertNotNull(db.findColumn("public.office.email"));
  assertNotNull(db.findColumn("public.aggregate_test.value"));

  // Make sure we still have two tables in the query.
  query.findSelectablesUsed();
  assertEquals(2, query.getNumTables());
    }
    catch (Exception e) {
  fail(e.toString());
    }
}
View Full Code Here

Examples of jimm.datavision.source.sql.SQLQuery

121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
    Report report = new Report();
    report.setDatabasePassword(DB_PASSWORD);
    report.read(EXAMPLE_REPORT);

    Database db = (Database)report.getDataSource();
    SQLQuery origQuery = (SQLQuery)db.getQuery();

    db.reset(db.getDriverClassName(), db.getConnectionInfo(), db.getName(),
       db.getUserName(), "");
    SQLQuery q = (SQLQuery)db.getQuery();

    // Unfortunately, we can't just compare query strings. That's because
    // the table and column lists aren't guaranteed to be sorted.
    //
    // At least these tests detect the bug we're fixing.
    assertEquals(origQuery.getNumTables(), q.getNumTables());
    assertEquals(origQuery.getNumSelectables(), q.getNumSelectables());
}
View Full Code Here

Examples of mondrian.rolap.sql.SqlQuery

153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
    protected boolean isOrdered() {
        return false;
    }

    public String generateSqlQuery() {
        SqlQuery sqlQuery = newSqlQuery();

        int k = getDistinctMeasureCount();
        final Dialect dialect = sqlQuery.getDialect();
        if (!dialect.allowsCountDistinct() && k > 0
            || !dialect.allowsMultipleCountDistinct() && k > 1)
        {
            distinctGenerateSql(sqlQuery, countOnly);
        } else {
            nonDistinctGenerateSql(sqlQuery);
        }
        if (!countOnly) {
            addGroupingFunction(sqlQuery);
            addGroupingSets(sqlQuery);
        }
        return sqlQuery.toString();
    }
View Full Code Here

Examples of org.dayatang.domain.SqlQuery

380
381
382
383
384
385
386
387
     * Test of createSqlQuery method
     */
    @Test
    public void testCreateSqlQuery() {
        String sql = "select * from dictionaries";
        SqlQuery query = repository.createSqlQuery(sql);
        assertEquals(sql, query.getSql());
    }
View Full Code Here

Examples of org.exoplatform.applications.ooplugin.search.SQLQuery

121
122
123
124
125
126
127
128
129
130
131
132
         try
         {
            DavSearch davSearch = new DavSearch(config.getContext());
            davSearch.setResourcePath("/");

            SQLQuery sqlQuery = new SQLQuery();
            sqlQuery.setQuery("select * from nt:base where contains(*, '" + searchContent + "')");

            davSearch.setQuery(sqlQuery);

            int status = davSearch.execute();

View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.