Searched refs:selectQuery (Results 1 – 4 of 4) sorted by relevance
114 String selectQuery = "SELECT field1 FROM " in testUpdate1() local116 ResultSet result = statement.executeQuery(selectQuery); in testUpdate1()140 String selectQuery = "SELECT * FROM " + DatabaseCreator.TEST_TABLE1; in testUpdate2() local141 ResultSet result = statement.executeQuery(selectQuery); in testUpdate2()172 String selectQuery = "SELECT field2, field3 FROM " in testUpdate3() local174 ResultSet result = statement.executeQuery(selectQuery); in testUpdate3()203 String selectQuery = "SELECT id, field2, field3 FROM " in testUpdate4() local205 ResultSet result = statement.executeQuery(selectQuery); in testUpdate4()236 String selectQuery = "SELECT field2 FROM " in testUpdate5() local238 ResultSet result = statement.executeQuery(selectQuery); in testUpdate5()[all …]
160 String selectQuery = "SELECT * FROM " + DatabaseCreator.TEST_TABLE1 in test_MultipleOperationsInSeveralTables() local163 ResultSet result = statement.executeQuery(selectQuery + id1); in test_MultipleOperationsInSeveralTables()166 result = statement.executeQuery(selectQuery + id2); in test_MultipleOperationsInSeveralTables()178 result = statement.executeQuery(selectQuery + oldID); in test_MultipleOperationsInSeveralTables()182 result = statement.executeQuery(selectQuery + newID); in test_MultipleOperationsInSeveralTables()205 String selectQuery = "SELECT * FROM " + DatabaseCreator.TEST_TABLE1 in test_MultipleUpdatesInOneTables() local209 ResultSet result = statement.executeQuery(selectQuery); in test_MultipleUpdatesInOneTables()223 result = statement.executeQuery(selectQuery); in test_MultipleUpdatesInOneTables()
395 String selectQuery = "SELECT rating, SUM(snum) AS sum FROM " in test_SelectGroupBy() local397 ResultSet result = statement.executeQuery(selectQuery); in test_SelectGroupBy()422 String selectQuery = "SELECT onum FROM " + DatabaseCreator.ORDERS_TABLE in test_SelectOrderBy() local424 ResultSet result = statement.executeQuery(selectQuery); in test_SelectOrderBy()455 String selectQuery = "SELECT DISTINCT rating FROM " in test_SelectDistinct() local457 ResultSet result = statement.executeQuery(selectQuery); in test_SelectDistinct()526 String selectQuery = "SELECT snum, max(amt) AS max FROM " in test_SelectHaving() local529 ResultSet result = statement.executeQuery(selectQuery); in test_SelectHaving()
1389 String selectQuery = "SELECT " + quote + "fieLD1" + quote + " FROM " in test_storesMixedCaseQuotedIdentifiers() local1393 statement.executeQuery(selectQuery); in test_storesMixedCaseQuotedIdentifiers()1453 String selectQuery = "SELECT field1 AS " + alias + " FROM " in test_supportsColumnAliasing() local1455 ResultSet rs = statement.executeQuery(selectQuery); in test_supportsColumnAliasing()1489 String selectQuery = "SELECT * FROM " + DatabaseCreator.TEST_TABLE1 in test_supportsExpressionsInOrderBy() local1493 statement.executeQuery(selectQuery); in test_supportsExpressionsInOrderBy()1523 String selectQuery = "SELECT * FROM " + DatabaseCreator.TEST_TABLE1 in test_supportsGroupBy() local1527 statement.executeQuery(selectQuery); in test_supportsGroupBy()1557 String selectQuery = "SELECT field1, field2 FROM " in test_supportsGroupByUnrelated() local1561 statement.executeQuery(selectQuery); in test_supportsGroupByUnrelated()[all …]