Lines Matching refs:st
32 Statement st = null;
34 st = conn.createStatement();
35 st.addBatch("INSERT INTO zoo VALUES (3,'Tuzik','dog')");
36 st.addBatch("INSERT INTO zoo VALUES (4,'Mashka','cat')");
38 int[] updateCounts = st.executeBatch();
44 st.close();
50 st = conn.createStatement();
51 st.addBatch("");
52 st.executeBatch();
58 st.close();
64 st = conn.createStatement();
65 st.addBatch(null);
66 st.executeBatch();
71 st.close();
78 Statement st = null;
80 st = conn.createStatement();
81 st.execute("select animals from zoo");
86 st.close();
91 st = conn.createStatement();
92 st.clearWarnings();
93 SQLWarning w = st.getWarnings();
97 st.close();
105 Statement st = null;
110 st = conn.createStatement();
111 st.execute("select animals from zoooo");
118 SQLWarning wrs = st.getWarnings();
122 Statement st = null;
127 st = conn.createStatement();
128 st.execute("select animals from zoooo");
134 SQLWarning wrs = st.getWarnings();
140 st.execute("select horse from zoooooo");
147 SQLWarning wrs = st.getWarnings();
156 st.close();
164 Statement st = null;
167 st = conn.createStatement();
168 st.addBatch("INSERT INTO zoo VALUES (3,'Tuzik','dog'); ");
169 st.addBatch("INSERT INTO zoo VALUES (4,'Mashka','cat')");
171 st.clearBatch();
173 int[] updateCounts = st.executeBatch();
180 st.close();
186 st = conn.createStatement();
187 st.addBatch("");
188 st.executeBatch();
194 st.close();
200 st = conn.createStatement();
201 st.addBatch(null);
202 st.executeBatch();
207 st.close();
229 Statement st = null;
231 st = conn.createStatement();
232 boolean res = st.execute(queries[i]);
238 st.close();
252 Statement st = null;
254 st = conn.createStatement();
255 st.execute(inc_queries[i]);
261 st.close();
281 Statement st = null;
283 st = conn.createStatement();
284 st.execute(queries[i], Statement.NO_GENERATED_KEYS);
286 ResultSet rs = st.getGeneratedKeys();
293 st.close();
300 Statement st = null;
302 st = conn.createStatement();
303 st.execute(queries[i], Statement.RETURN_GENERATED_KEYS);
306 ResultSet rs = st.getGeneratedKeys();
314 st.close();
323 Statement st = null;
325 st = conn.createStatement();
326 assertSame(conn, st.getConnection());
329 st.close();
335 st.close();
336 st.getConnection();
345 Statement st = null;
347 st = conn.createStatement();
348 assertEquals(ResultSet.FETCH_UNKNOWN, st.getFetchDirection());
351 st.close();
357 st = conn.createStatement();
358 st.setFetchDirection(ResultSet.FETCH_FORWARD);
359 assertEquals(ResultSet.FETCH_FORWARD, st.getFetchDirection());
365 st.close();
371 st.getFetchDirection();
380 Statement st = null;
382 st = conn.createStatement();
383 st.setFetchDirection(ResultSet.FETCH_FORWARD);
384 st.executeQuery("select * from zoo;");
386 // assertEquals(ResultSet.FETCH_FORWARD, st.getFetchDirection());
392 st.close();
400 Statement st = null;
402 st = conn.createStatement();
403 st.execute("select * from zoo;");
404 assertEquals(1, st.getFetchSize());
407 st.close();
413 st.close();
414 st.getFetchSize();
423 Statement st = null;
425 st = conn.createStatement();
429 st.setFetchSize(i);
430 assertEquals(i, st.getFetchSize());
438 st.setFetchSize(-1);
447 st.close();
455 Statement st = null;
457 st = conn.createStatement();
460 st.setMaxFieldSize(i);
461 assertEquals(i, st.getMaxFieldSize());
469 st.close();
477 Statement st = null;
479 st = conn.createStatement();
482 st.setMaxFieldSize(i);
490 st.close();
497 Statement st = null;
499 st = conn.createStatement();
501 st.setMaxRows(i);
502 assertEquals(i, st.getMaxRows());
503 ResultSet r = st.executeQuery("select * from zoo;");
517 st.setMaxRows(-1);
524 st.close();
532 Statement st = null;
540 st = conn.createStatement();
542 st.execute(queries[i]);
544 res = st.getResultSet();
547 st.close();
550 st.close();
569 Statement st = null;
582 st = conn.createStatement();
584 st.execute(queries[i], (int[]) array.elementAt(i));
589 assertNotNull(st.getResultSet());
590 st.close();
591 assertNull(st.getResultSet());
598 st.close();
605 Statement st = null;
618 st = conn.createStatement();
620 st.execute(queries[i], (String[]) array.elementAt(i));
624 assertNotNull(st.getResultSet());
625 st.close();
626 assertNull(st.getResultSet());
630 st.close();
655 Statement st = null;
659 st = conn.createStatement();
660 assertEquals(0, st.executeBatch().length);
662 st.addBatch(wrongQueries[i]);
664 st.executeBatch();
670 st.close();
676 st = conn.createStatement();
677 assertEquals(0, st.executeBatch().length);
679 st.addBatch(queries[i]);
681 int[] resArray = st.executeBatch();
685 st.close();
691 st = conn.createStatement();
692 st.addBatch("select * from zoo");
693 st.executeBatch();
699 st.close();
705 st.close();
706 st.executeBatch();
728 Statement st = null;
731 st = conn.createStatement();
734 ResultSet rs = st.executeQuery(queries1[i]);
742 st.close();
750 st = conn.createStatement();
753 ResultSet rs = st.executeQuery(queries2[i]);
762 st.close();
786 Statement st = null;
788 st = conn.createStatement();
790 int count = st.executeUpdate(queries1[i]);
794 assertEquals(0, st.executeUpdate(queries2));
798 st.close();
835 Statement st = null;
856 st = conn.createStatement();
858 st.executeUpdate(queries1[i], (int[]) array.elementAt(i));
865 st.close();
883 Statement st = null;
886 st = conn.createStatement();
887 st.executeUpdate(queries[1], Statement.NO_GENERATED_KEYS);
888 rs = st.getGeneratedKeys();
896 st.close();
902 st = conn.createStatement();
903 st.executeUpdate(queries[1], Statement.RETURN_GENERATED_KEYS);
904 rs = st.getGeneratedKeys();
912 st.close();
920 Statement st = null;
944 st = conn.createStatement();
946 st.executeUpdate(queries[i], (String[]) array.elementAt(i));
953 st.close();
961 Statement st = null;
964 st = conn.createStatement();
965 st.executeUpdate(query);
966 assertEquals(1, st.getUpdateCount());
968 st.executeUpdate(query);
969 assertEquals(0, st.getUpdateCount());
972 st.close();
978 st.getUpdateCount();
986 Statement st = null;
989 st = conn.createStatement();
990 assertNull(st.getGeneratedKeys());
999 Statement st = null;
1002 st = conn.createStatement();
1003 st.setCursorName("test");
1012 Statement st = null;
1015 st = conn.createStatement();
1016 st.setEscapeProcessing(true);
1024 Statement st = conn.createStatement();
1025 st.setQueryTimeout(2);
1026 assertEquals(2, st.getQueryTimeout());
1029 st = conn.createStatement();
1030 st.setQueryTimeout(-1);
1037 st = conn.createStatement();
1038 st.close();
1039 st.setQueryTimeout(3);
1048 Statement st = null;
1051 st = conn.createStatement();
1052 st.getResultSetType();
1053 assertEquals(ResultSet.TYPE_SCROLL_INSENSITIVE, st
1061 st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
1063 st.getResultSetType();
1064 assertEquals(ResultSet.TYPE_SCROLL_SENSITIVE, st.getResultSetType());
1070 st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
1072 st.getResultSetType();
1073 assertEquals(ResultSet.TYPE_SCROLL_SENSITIVE, st.getResultSetType());
1079 st = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,
1081 st.getResultSetType();
1082 assertEquals(ResultSet.TYPE_FORWARD_ONLY, st.getResultSetType());
1092 Statement st = null;
1094 st = conn.createStatement();
1095 assertEquals(ResultSet.CLOSE_CURSORS_AT_COMMIT, st
1117 st.getResultSetHoldability();
1118 assertEquals(ResultSet.CLOSE_CURSORS_AT_COMMIT, st
1127 Statement st = null;
1131 st = conn.createStatement();
1132 st.getResultSetConcurrency();
1133 assertEquals(ResultSet.CONCUR_READ_ONLY, st
1142 st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
1144 st.getResultSetConcurrency();
1145 assertEquals(ResultSet.CONCUR_UPDATABLE, st.getResultSetConcurrency());
1153 st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
1155 st.getResultSetConcurrency();
1156 assertEquals(ResultSet.CONCUR_READ_ONLY, st.getResultSetConcurrency());
1165 Statement st = null;
1168 st = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,
1171 st.execute("create table test (c1);");
1172 res = st.getResultSet();
1175 st = conn.createStatement();
1178 st.execute(insert);
1179 st.execute(select);
1180 assertEquals(-1, st.getUpdateCount());
1181 res = st.getResultSet();
1187 // assertEquals(0, st.getUpdateCount()); not supported
1190 st = conn.createStatement();
1192 st.execute(insert);
1193 res = st.getResultSet();
1195 if (st.getUpdateCount() > 0) {
1200 st.close();
1201 st.getResultSet();
1210 Statement st = null;
1211 st = conn.createStatement();
1212 st.setQueryTimeout(2000);
1213 assertEquals(2000, st.getQueryTimeout());
1215 st = conn.createStatement();
1216 assertEquals(0,st.getQueryTimeout());
1219 st.close();
1220 st.getQueryTimeout();
1229 Statement st = null;
1238 st = conn.createStatement();
1239 st.execute(queries[0]);
1240 assertFalse(st.getMoreResults());
1243 st.getResultSet();
1250 st.close();
1256 st.getMoreResults();
1265 Statement st = null;
1266 st = conn.prepareStatement("insert into zoo values (7,'Speedy Gonzales','Mouse');");
1268 CancelThread c = new CancelThread(st);
1269 InsertThread ins = new InsertThread((PreparedStatement)st);
1282 ResultSet res = st.executeQuery("select * from zoo where id=7");
1286 st.close();
1287 st.cancel();
