Lines Matching refs:st
50 Statement st = null;
55 st = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,
57 st.execute("select id, name from zoo");
58 rs = st.getResultSet();
68 st.close();
75 st = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,
77 st.execute("select id, name from zoo");
78 rs = st.getResultSet();
89 st.close();
96 st = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,
98 st.execute("select id, name from zoo");
99 rs = st.getResultSet();
110 st.close();
118 st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
120 st.execute("select name, family from zoo");
121 rs = st.getResultSet();
135 st.close();
141 st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
143 st.execute("select name, family from zoo");
144 rs = st.getResultSet();
158 st.close();
183 Statement st = null;
186 st = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,
189 assertNotNull(st);
190 st.execute("select id, name from zoo");
191 ResultSet rs = st.getResultSet();
199 if (st != null) st.close();
215 Statement st = null;
217 st = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,
220 assertNotNull(st);
221 st.execute("select id, name from zoo");
222 ResultSet rs = st.getResultSet();
231 if (st != null) {
233 st.close();
260 Statement st = null;
262 st = conn.createStatement();
263 st.execute("select animals from zoo");
269 st.close();
279 st = conn.createStatement();
280 st.execute("select monkey from zoo");
286 st.close();
308 Statement st = null;
313 st = conn.createStatement();
314 st.execute("select animals from zoooo");
326 Statement st = null;
331 st = conn.createStatement();
332 st.execute("select animals from zoooo");
348 st.execute("select horse from zoooooo");
364 st.close();
390 Statement st = null;
395 st = conn.createStatement();
396 st.execute("insert into zoo (id, name, family) values (3, 'Chichichi', 'monkey');");
402 st.close();
408 st = conn.createStatement();
409 st.execute("select * from zoo");
410 rs = st.getResultSet();
414 st.close();
422 st = conn.createStatement();
423 st.execute("insert into zoo (id, name, family) values (4, 'Burenka', 'cow');");
424 st.execute("select * from zoo");
425 rs = st.getResultSet();
429 rs1 = st.getResultSet();
435 st.close();
470 Statement st = null;
473 st = conn.createStatement();
474 st.execute("insert into zoo (id, name, family) values (3, 'ChiChiChi', 'monkey');");
478 st.close();
484 st = null;
487 st = conn.createStatement();
488 st.execute("insert into zoo (id, name, family) values (3, 'ChiChiChi', 'monkey');");
494 st.close();
501 st = conn.createStatement();
502 st.executeUpdate("insert into zoo (id, name, family) values (4, 'ChaChaCha', 'monkey');");
508 st.close();
515 st = conn.createStatement();
516 st.execute("insert into zoo (id, name, family) values (4, 'ChiChiChi', 'monkey');");
519 st.close();
560 Statement st = null;
566 st = conn.createStatement();
567 st.execute("insert into zoo (id, name, family) values (4, 'ChiChiChi', 'monkey');");
568 ResultSet rs = st.getResultSet();
578 st = conn.createStatement();
579 st.execute("insert into zoo (id, name, family) values (4, 'ChiChiChi', 'monkey');");
580 rs = st.getResultSet();
585 st.close();
673 Statement st = null;
678 st = conn.createStatement();
679 st
681 st.equals("drop table test_table;");
686 st.close();
693 Statement st = null;
699 st = conn.createStatement();
700 st
702 st.equals("drop table test_table;");
708 st.close();
714 Statement st = null;
719 st = conn.createStatement();
720 st
722 st.equals("drop table test_table;");
729 st.close();
756 Statement st = null;
842 Statement st = null;
848 st = conn.createStatement();
849 st.execute(nativeQuery);
855 st.close();
887 Statement st = null;
891 st = conn.createStatement();
892 st.execute("select * from zoo");
893 rs = st.getResultSet();
904 st.close();
984 Statement st = null;
986 st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
988 st.execute("select name, family from zoo");
989 rs = st.getResultSet();
1006 st.close();
1012 st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
1014 st.execute("select name, family from zoo");
1015 rs = st.getResultSet();
1032 st.close();
1094 Statement st = null;
1097 st = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,
1100 st.execute("select id, name from zoo");
1101 rs = st.getResultSet();
1125 Statement st = null;
1133 st = conn.createStatement();
1134 st.execute("select * from zoo where family = 'cat'");
1135 rs = st.getResultSet();
1138 st.execute("select * from zoo where family = 'cat'");
1139 rs1 = st.getResultSet();
1146 st.close();
1171 Statement st = null;
1195 st = conn.createStatement();
1196 st.execute("select * from zoo");
1197 rs = st.getResultSet();
1200 st.execute("select * from zoo where family = 'dog'");
1201 rs1 = st.getResultSet();
1221 st.close();
1228 Statement st = null;
1240 st = conn.createStatement();
1241 st.execute("insert into zoo (id, name, family) values (3, 'Vorobey', 'sparrow');");
1242 st.execute("insert into zoo (id, name, family) values (4, 'Orel', 'eagle');");
1280 st.close();
1288 Statement st = null;
1296 st = conn.createStatement();
1297 st.execute("insert into zoo (id, name, family) values (3, 'Vorobey', 'sparrow');");
1298 st.execute("insert into zoo (id, name, family) values (4, 'Orel', 'eagle');");
1307 st.close();
1315 st = conn.createStatement();
1316 st.execute("insert into zoo (id, name, family) values (3, 'Vorobey', 'sparrow');");
1317 st.execute("insert into zoo (id, name, family) values (4, 'Orel', 'eagle');");
1353 st.close();
1385 st = conn.createStatement();
1386 st
1388 st
1400 st
1420 st
1424 st
1444 st
1448 st
1472 st
1485 st.close();
1505 Statement st = null;
1511 st = conn.createStatement();
1512 st
1514 st
1526 st
1545 st
1548 st
1567 st
1570 st
1594 st
1607 st.close();
1626 Statement st = null;
1632 st = conn.createStatement();
1633 st
1635 st
1647 st
1666 st
1669 st
1688 st
1691 st
1715 st
1728 st.close();
1748 Statement st = null;
1754 st = conn.createStatement();
1755 st
1757 st
1769 st
1776 st
1798 st
1801 st
1833 st
1846 st.close();
1870 Statement st = null;
1884 st = conn.createStatement();
1885 st.execute("select * from zoo");
1886 rs = st.getResultSet();
1889 st.execute("select * from zoo where family = 'dog'");
1890 rs1 = st.getResultSet();
1914 st.close();
1939 PreparedStatement st = null;
1943 st = conn.prepareStatement(query, ResultSet.TYPE_FORWARD_ONLY,
1945 st.execute("select id, name from zoo");
1946 rs = st.getResultSet();
1956 if (st != null) st.close();
1962 st = conn.prepareStatement(query, ResultSet.TYPE_SCROLL_SENSITIVE,
1964 st.execute("select name, family from zoo");
1965 rs = st.getResultSet();
1978 st.close();
2000 PreparedStatement st = null;
2003 st = conn.prepareStatement(query,
2006 st.execute("select name, family from zoo");
2007 rs = st.getResultSet();
2016 if (st != null) st.close();
2025 PreparedStatement st = null;
2028 st = conn.prepareStatement(query, ResultSet.TYPE_FORWARD_ONLY,
2031 st.setInt(1, 3);
2032 st.setString(2, "Petya");
2033 st.setString(3, "Cock");
2034 st.execute("select id, name from zoo");
2035 rs = st.getResultSet();
2040 if (st != null) st.close();
2047 st = conn.prepareStatement(query, ResultSet.TYPE_FORWARD_ONLY,
2050 st.execute("select id, name from zoo");
2051 rs = st.getResultSet();
2062 st.close();
2119 Statement st = conn.createStatement();
2120 st.execute("select * from zoo");
2121 rs = st.getResultSet();
2124 st.execute("select * from zoo where family = 'dog'");
2125 rs1 = st.getResultSet();
2180 Statement st = conn.createStatement();
2181 st.execute("select * from zoo");
