Lines Matching refs:ps
136 PreparedStatement ps = null;
138 ps = conn
140 ps.addBatch("INSERT INTO zoo VALUES (?,'Burenka', ?); ");
141 ps.addBatch("INSERT INTO zoo VALUES (?,'Mashka','cat')");
143 ps.executeBatch();
147 ps.setString(1, "dog");
150 ps.executeBatch();
167 ps.close();
173 ps = conn
175 ps.addBatch("");
180 ps.close();
186 ps = conn
188 ps.addBatch(null);
193 ps.close();
212 PreparedStatement ps = null;
216 ps = conn.prepareStatement(query);
217 ps.setInt(1, 3);
218 ps.setString(2, "No name");
219 assertFalse(ps.execute());
220 assertEquals(1,ps.getUpdateCount());
223 ps = conn.prepareStatement("select * from zoo");
224 assertTrue(ps.execute());
225 assertEquals(3, getCount(ps.getResultSet()));
230 ps.close();
237 ps = conn.prepareStatement(query);
238 ps.setString(1, "cat");
239 ps.setInt(2, 2);
240 assertFalse(ps.execute());
241 assertEquals(1, ps.getUpdateCount());
251 ps.close();
260 ps = conn.prepareStatement(query);
261 assertFalse(ps.execute());
262 assertTrue(ps.getUpdateCount() > 0);
267 ps.close();
274 ps = conn.prepareStatement(query);
275 ps.setInt(1, 1);
276 assertTrue(ps.execute());
281 ps.close();
288 ps = conn.prepareStatement(query);
289 ps.execute();
294 ps.close();
301 ps = conn.prepareStatement(query);
302 ps.setString(1, "cat");
303 ps.setInt(2, 2);
304 assertTrue(ps.execute("update zoo set name='Masha', family='cat' where id=2;"));
309 ps.close();
334 PreparedStatement ps = null;
336 ps = conn.prepareStatement(queries2[i]);
337 ps.executeQuery();
343 ps.close();
350 PreparedStatement ps = null;
352 ps = conn.prepareStatement(query);
353 ps.setInt(1, 1);
354 ResultSet rs = ps.executeQuery();
363 ps.close();
369 ps = conn.prepareStatement(query);
370 ps.setInt(1, 5);
371 ResultSet rs = ps.executeQuery();
378 ps.close();
400 PreparedStatement ps = null;
402 ps = conn.prepareStatement(queries1[i]);
403 ps.executeUpdate();
409 ps.close();
415 PreparedStatement ps = null;
417 ps = conn.prepareStatement(query);
418 ps.setInt(1, 2);
419 int updateCount = ps.executeUpdate();
421 ps.setInt(1, 1);
422 int updateCount1 = ps.executeUpdate();
428 ps.close();
451 PreparedStatement ps = null;
457 ps = conn.prepareStatement(query);
458 assertNotNull(ps);
459 ResultSetMetaData meta = ps.getMetaData();
469 ps.close();
476 ps = conn.prepareStatement(query);
477 ResultSetMetaData rsmd = ps.getMetaData();
485 ps.close();
490 // ps closed
492 ps.getMetaData();
510 PreparedStatement ps = null;
512 ps = conn.prepareStatement(query);
515 ParameterMetaData rsmd = ps.getParameterMetaData();
520 ps.close();
525 ps.close();
528 ps.getParameterMetaData();
548 PreparedStatement ps = null;
551 ps = conn.prepareStatement(query);
552 ps.clearParameters();
554 ps.execute();
559 ps.setInt(1, 2);
560 ps.setString(2, "dog");
561 ps.clearParameters();
563 ps.execute();
568 ps.setInt(1, 2);
569 ps.clearParameters();
571 ps.execute();
576 ps.setInt(1, 2);
577 ps.setString(2, "cat");
580 ps.execute();
588 ps.close();
607 PreparedStatement ps = null;
611 ps = conn.prepareStatement(query);
613 ps.setInt(1, Integer.MAX_VALUE);
614 ps.execute();
624 ps.close();
629 ps = conn.prepareStatement(query);
631 ps.setInt(1, Integer.MIN_VALUE);
632 ps.execute();
642 ps.close();
647 ps = conn.prepareStatement(query);
648 ps.close();
650 ps.setInt(1, Integer.MIN_VALUE);
661 ps.close();
679 PreparedStatement ps = null;
682 ps = conn.prepareStatement(query);
685 ps.setLong(1, Long.MAX_VALUE);
686 ps.execute();
703 ps.setLong(1, Long.MIN_VALUE);
704 ps.execute();
720 ps.close();
722 ps.setLong(1, Long.MIN_VALUE);
733 ps.close();
755 PreparedStatement ps = null;
757 ps = conn.prepareStatement(query);
763 ps.setFloat(1, value1);
764 ps.execute();
779 ps.setFloat(1, value2);
780 ps.execute();
794 ps.close();
796 ps.setFloat(1, Float.MIN_VALUE);
807 ps.close();
826 PreparedStatement ps = null;
828 ps = conn.prepareStatement(query);
834 ps.setDouble(1, Double.MAX_VALUE);
835 ps.execute();
851 ps.setDouble(1, Double.MIN_VALUE);
852 ps.execute();
867 ps.close();
869 ps.setDouble(1, 2.0);
880 ps.close();
899 PreparedStatement ps = null;
903 ps = conn.prepareStatement(query);
908 ps.setString(1, str);
909 ps.execute();
924 ps.setString(1, "");
925 ps.execute();
940 ps.setString(1, " ");
941 ps.execute();
957 ps.setString(1, " test & text * test % text * test ^ text ");
958 ps.execute();
964 ps.setString(1, null);
965 ps.execute();
970 ps.close();
973 ps.setString(1, "test text");
984 ps.close();
1002 PreparedStatement ps = null;
1006 ps = conn.prepareStatement(query);
1009 ps.setString(1, str);
1010 ps.execute();
1025 ps.setString(1, "");
1026 ps.execute();
1041 ps.setString(1, " ");
1042 ps.execute();
1058 ps.setString(
1061 ps.execute();
1067 ps.setString(1, null);
1068 ps.execute();
1073 ps.close();
1076 ps.setString(1, "test text");
1088 ps.close();
1105 PreparedStatement ps = null;
1109 ps = conn.prepareStatement(query);
1112 ps.setString(1, str);
1113 ps.execute();
1128 ps.setString(1, "");
1129 ps.execute();
1144 ps.setString(1, " ");
1145 ps.execute();
1166 ps.setString(1, longString);
1167 ps.execute();
1174 ps.setString(1, null);
1175 ps.execute();
1180 ps.close();
1183 ps.setString(2, "test text");
1193 ps.close();
1210 PreparedStatement ps = null;
1214 ps = conn.prepareStatement(query);
1217 ps.setString(1, str);
1218 ps.execute();
1233 ps.setString(1, "");
1234 ps.execute();
1249 ps.setString(1, " ");
1250 ps.execute();
1266 ps.setString(1, null);
1267 ps.execute();
1272 ps.close();
1275 ps.setString(2, "test text");
1288 ps.close();
1306 PreparedStatement ps = null;
1310 ps = conn.prepareStatement(query);
1313 ps.setString(1, str);
1314 ps.execute();
1329 ps.setString(1, "");
1330 ps.execute();
1345 ps.setString(1, " ");
1346 ps.execute();
1362 ps.setString(1, null);
1363 ps.execute();
1368 ps.close();
1371 ps.setString(1, "test text");
1383 ps.close();
1401 PreparedStatement ps = null;
1406 ps = conn.prepareStatement(query);
1409 ps.setShort(1, Short.MAX_VALUE);
1410 ps.execute();
1425 ps.setShort(1, Short.MIN_VALUE);
1426 ps.execute();
1440 ps.close();
1443 ps.setShort(1, Short.MIN_VALUE);
1476 ps.close();
1497 PreparedStatement ps = null;
1501 ps = conn.prepareStatement(query);
1504 ps.setBoolean(1, false);
1505 ps.execute();
1520 ps.setBoolean(1, true);
1521 ps.execute();
1535 ps.close();
1538 ps.setBoolean(1, false);
1558 ps.close();
1577 PreparedStatement ps = null;
1581 ps = conn.prepareStatement(query);
1584 ps.setByte(1, Byte.MAX_VALUE);
1585 ps.execute();
1600 ps.setByte(1, Byte.MIN_VALUE);
1601 ps.execute();
1616 ps.setByte(2, Byte.MAX_VALUE);
1622 ps.close();
1625 ps.setByte(1, Byte.MIN_VALUE);
1645 ps.close();
1666 PreparedStatement ps = null;
1670 ps = conn.prepareStatement(query);
1673 ps.setBytes(1, bytesArray);
1674 assertFalse(ps.execute());
1675 assertTrue(ps.getUpdateCount() > 0);
1681 ps.setBytes(2, bytesArray);
1687 ps.close();
1690 ps.setBytes(1, bytesArray);
1699 ps.setBytes(1, bytesArray);
1700 assertFalse(ps.execute());
1701 assertTrue(ps.getUpdateCount() > 0);
1711 if (ps != null) ps.close();
1733 PreparedStatement ps = null;
1737 ps = conn.prepareStatement(query);
1740 ps.setBigDecimal(1, bd);
1741 assertFalse(ps.execute());
1742 assertTrue(ps.getUpdateCount() > 0);
1749 ps.setBigDecimal(2, bd);
1757 ps.setBigDecimal(-2, bd);
1776 if (ps != null) ps.close();
1803 PreparedStatement ps = null;
1807 ps = conn.prepareStatement(query);
1811 ps.setDate(1, dates[i]);
1812 assertFalse(ps.execute());
1813 assertTrue(ps.getUpdateCount() > 0);
1820 ps.setDate(2, dates[0]);
1826 ps.close();
1829 ps.setDate(1, dates[0]);
1851 if (ps != null) ps.close();
1880 PreparedStatement ps = null;
1884 ps = conn.prepareStatement(query);
1889 ps.setDate(1, dates[i], cals[i]);
1890 assertFalse(ps.execute());
1891 assertTrue(ps.getUpdateCount() > 0);
1898 ps.setDate(2, dates[0], cals[0]);
1899 ps.execute();
1905 ps.close();
1908 ps.setDate(1, dates[0], cals[1]);
1928 if (ps != null) ps.close();
1948 PreparedStatement ps = null;
1951 ps = conn.prepareStatement(query);
1954 ps.setNull(1, Types.INTEGER);
1955 ps.execute();
1960 ps.close();
1966 ps
1969 ps.setNull(1, Types.BIGINT);
1970 ps.execute();
1975 ps.close();
1981 ps = conn.prepareStatement(query);
1984 ps.setNull(1, Types.DECIMAL);
1985 ps.execute();
1990 ps.close();
1996 ps = conn.prepareStatement(query);
1999 ps.setNull(1, Types.DATE);
2000 ps.execute();
2005 ps.close();
2011 ps = conn.prepareStatement(query);
2014 ps.setNull(1, Types.BLOB);
2015 ps.execute();
2020 ps.close();
2026 ps = conn.prepareStatement(query);
2029 ps.setNull(1, Types.CHAR);
2030 ps.execute();
2039 ps.close();
2062 PreparedStatement ps = null;
2069 ps = conn.prepareStatement(query);
2071 ps.setNull(1, Types.DATALINK);
2072 ps.execute();
2089 ps.close();
2101 ps = conn.prepareStatement(insert);
2103 ps.setNull(1,1, "");
2104 ps.execute();
2120 ps.close();
2134 ps = conn.prepareStatement(insert);
2136 ps.setNull(1,1, "");
2137 ps.execute();
2154 ps.close();
2176 PreparedStatement ps = null;
2179 ps = conn.prepareStatement(query);
2182 ps.setObject(1, Integer.MAX_VALUE);
2183 ps.execute();
2199 ps = conn.prepareStatement(query);
2202 ps.setObject(1, "test text");
2203 ps.execute();
2218 ps = conn.prepareStatement(query);
2221 ps.setObject(1, new Object());
2222 ps.execute();
2228 ps = conn.prepareStatement(query);
2232 ps.setObject(1, d);
2233 ps.execute();
2250 ps = conn.prepareStatement(query);
2253 ps.setObject(1, null);
2254 ps.execute();
2269 ps.close();
2274 ps.setObject(1, "test text");
2297 PreparedStatement ps = null;
2300 ps = conn.prepareStatement(query);
2303 ps.setObject(1, Integer.MAX_VALUE, Types.INTEGER);
2304 ps.execute();
2320 ps = conn.prepareStatement(query);
2323 ps.setObject(1, "test text", Types.CHAR);
2324 ps.execute();
2339 ps = conn.prepareStatement(query);
2342 ps.setObject(1, new Object(), Types.DECIMAL);
2343 ps.execute();
2349 ps = conn.prepareStatement(query);
2354 ps.setObject(1, d, Types.DATE);
2355 ps.execute();
2372 ps = conn.prepareStatement(query);
2375 ps.setObject(1, "", Types.BLOB);
2376 ps.execute();
2391 ps.close();
2397 ps.setObject(1, Integer.MAX_VALUE, Types.INTEGER);
2420 PreparedStatement ps = null;
2423 ps = conn.prepareStatement(query);
2426 ps.setObject(1, Integer.MAX_VALUE, Types.INTEGER,
2428 ps.execute();
2444 ps = conn.prepareStatement(query);
2447 ps.setObject(1, "test text", Types.CHAR, Integer.MIN_VALUE);
2448 ps.execute();
2463 ps = conn.prepareStatement(query);
2467 ps.setObject(1, bd2, Types.DECIMAL, 2);
2468 ps.execute();
2474 ps = conn.prepareStatement(query);
2477 ps.setObject(1, d , Types.DATE, -1);
2478 ps.execute();
2495 ps = conn.prepareStatement(query);
2498 ps.setObject(1, "", Types.BLOB, 0);
2499 ps.execute();
2514 ps.close();
2520 ps.setObject(1, "test text", Types.CHAR, Integer.MIN_VALUE);
2543 PreparedStatement ps = null;
2547 ps = conn.prepareStatement(query);
2551 ps.setTime(1, times[i]);
2552 ps.execute();
2569 ps.setTime(2, times[0]);
2575 ps.close();
2578 ps.setTime(1, times[0]);
2598 ps.close();
2626 PreparedStatement ps = null;
2630 ps = conn.prepareStatement(query);
2634 ps.setTime(1, times[i], cals[i]);
2635 assertFalse(ps.execute());
2636 assertTrue(ps.getUpdateCount() > 0);
2648 ps.setTime(2, times[0], cals[0]);
2654 ps.close();
2657 ps.setTime(-2, times[0], cals[1]);
2677 ps.close();
2701 PreparedStatement ps = null;
2705 ps = conn.prepareStatement(query);
2709 ps.setTimestamp(1, timestamps[i]);
2710 assertFalse(ps.execute());
2711 assertTrue(ps.getUpdateCount() > 0);
2718 ps.setTimestamp(2, timestamps[0]);
2725 ps.setTimestamp(-2, timestamps[0]);
2745 ps.close();
2763 PreparedStatement ps = null;
2767 ps = conn.prepareStatement(neverExecutedQuery);
2768 ps.setBlob(1,mock);
2786 PreparedStatement ps = null;
2790 ps = conn.prepareStatement(neverExecutedQuery);
2791 ps.setClob(1,mock);
2818 PreparedStatement ps = null;
2822 ps = conn.prepareStatement(query);
2826 ps.setTimestamp(1, timestamps[i], cals[i]);
2827 assertFalse(ps.execute());
2828 assertTrue(ps.getUpdateCount() > 0);
2840 ps.setTimestamp(2, timestamps[0], cals[0]);
2841 ps.execute();
2846 ps.close();
2848 ps.setTimestamp(1, timestamps[0], cals[1]);
2849 ps.execute();
2869 ps.close();
2888 PreparedStatement ps = null;
2891 ps = conn.prepareStatement(query);
2892 ps.setURL(1, new URL("http://www.android.com"));
2915 PreparedStatement ps = null;
2919 ps = conn.prepareStatement(query);
2920 ps.setArray(1, new MockArray());
2943 PreparedStatement ps = null;
2947 ps = conn.prepareStatement(neverExecutedQuery);
2948 ps.setRef(1,mock);
2968 PreparedStatement ps = null;
2971 ps = conn.prepareStatement(query);
2974 ps.setUnicodeStream(0, file, 100);
2996 PreparedStatement ps = null;
2999 ps = conn.prepareStatement(query);
3004 ps.setCharacterStream(1, reader, 100);
3026 PreparedStatement ps = null;
3029 ps = conn.prepareStatement(query);
3032 ps.setAsciiStream(0, file, 100);
3055 PreparedStatement ps = null;
3058 ps = conn.prepareStatement(query);
3061 ps.setBinaryStream(0, file, 100);
