Lines Matching refs:st
84 Statement st = null;
86 st = conn.createStatement();
88 st.execute(queries[i]);
92 st.close();
99 Statement st = null;
101 st = conn.createStatement();
102 st.execute("drop table if exists type");
105 st.close();
125 Statement st = null;
128 st = conn.createStatement();
129 st.execute("select * from zoo");
130 ResultSet rs = st.getResultSet();
136 st.close();
177 Statement st = null;
206 st = conn.createStatement();
207 st.execute("select family from zoo where id=2");
208 ResultSet rs = st.getResultSet();
214 st.close();
485 Statement st = null;
492 st = conn.createStatement();
493 st.execute("select * from type where IntVal="
495 ResultSet rs = st.getResultSet();
500 st.close();
508 st = conn.createStatement();
509 st.execute("select * from type where IntVal="
511 ResultSet rs = st.getResultSet();
516 st.close();
544 Statement st = null;
548 st = conn.createStatement();
549 st.execute("select * from type where LongVal=" + Long.MAX_VALUE);
550 ResultSet rs = st.getResultSet();
554 st.close();
562 st = conn.createStatement();
563 st.execute("select * from type where LongVal=" + Long.MAX_VALUE);
564 ResultSet rs = st.getResultSet();
568 st.close();
600 Statement st = null;
604 st = conn.createStatement();
605 st.execute("select * from type where FloatVal=" + value1);
606 ResultSet rs = st.getResultSet();
610 st.close();
618 st = conn.createStatement();
619 st.execute("select * from type where FloatVal=" + value2);
620 ResultSet rs = st.getResultSet();
624 st.close();
653 Statement st = null;
657 st = conn.createStatement();
658 st.execute("select * from type where DoubleVal="
660 ResultSet rs = st.getResultSet();
664 st.close();
672 st = conn.createStatement();
673 st.execute("select * from type where DoubleVal="
675 ResultSet rs = st.getResultSet();
679 st.close();
708 Statement st = null;
712 st = conn.createStatement();
713 st.execute("select * from type where charStr='" + str + "'");
714 ResultSet rs = st.getResultSet();
718 st.close();
726 st = conn.createStatement();
727 st.execute("select * from type where charStr=''");
728 ResultSet rs = st.getResultSet();
732 st.close();
740 st = conn.createStatement();
741 st.execute("select * from type where charStr=' '");
742 ResultSet rs = st.getResultSet();
746 st.close();
778 Statement st = null;
782 st = conn.createStatement();
783 st.execute("select * from type where TText='" + str + "'");
784 ResultSet rs = st.getResultSet();
788 st.close();
796 st = conn.createStatement();
797 st.execute("select * from type where TText=''");
798 ResultSet rs = st.getResultSet();
802 st.close();
810 st = conn.createStatement();
811 st.execute("select * from type where TText=' '");
812 ResultSet rs = st.getResultSet();
816 st.close();
858 Statement st = null;
862 st = conn.createStatement();
863 st.execute("select * from type where TextVal='" + str + "'");
864 ResultSet rs = st.getResultSet();
868 st.close();
876 st = conn.createStatement();
877 st.execute("select * from type where TextVal=''");
878 ResultSet rs = st.getResultSet();
882 st.close();
890 st = conn.createStatement();
891 st.execute("select * from type where TextVal=' '");
892 ResultSet rs = st.getResultSet();
896 st.close();
933 Statement st = null;
937 st = conn.createStatement();
938 st.execute("select * from type where MText='" + str + "'");
939 ResultSet rs = st.getResultSet();
943 st.close();
951 st = conn.createStatement();
952 st.execute("select * from type where MText=''");
953 ResultSet rs = st.getResultSet();
957 st.close();
965 st = conn.createStatement();
966 st
968 ResultSet rs = st.getResultSet();
972 st.close();
1002 Statement st = null;
1006 st = conn.createStatement();
1007 st.execute("select * from type where LText='" + str + "'");
1008 ResultSet rs = st.getResultSet();
1012 st.close();
1020 st = conn.createStatement();
1021 st.execute("select * from type where LText=''");
1022 ResultSet rs = st.getResultSet();
1026 st.close();
1034 st = conn.createStatement();
1035 st.execute("select * from type where LText=' '");
1036 ResultSet rs = st.getResultSet();
1040 st.close();
1071 Statement st = null;
1075 st = conn.createStatement();
1076 st.execute("select * from type where Sint=" + Short.MAX_VALUE);
1077 ResultSet rs = st.getResultSet();
1081 st.close();
1089 st = conn.createStatement();
1090 st.execute("select * from type where Sint=" + Short.MIN_VALUE);
1091 ResultSet rs = st.getResultSet();
1095 st.close();
1117 st = conn.createStatement();
1118 st.execute("select * from type where IntVal=" + Short.MAX_VALUE);
1119 ResultSet rs = st.getResultSet();
1139 Statement st = null;
1143 st = conn.createStatement();
1144 st.execute("select * from type where BoolVal = 0");
1145 ResultSet rs = st.getResultSet();
1149 st.close();
1157 st = conn.createStatement();
1158 st.execute("select * from type where BoolVal= 1");
1159 ResultSet rs = st.getResultSet();
1163 st.close();
1198 Statement st = null;
1202 st = conn.createStatement();
1203 st.execute("select * from type where Tint=" + Byte.MAX_VALUE);
1204 ResultSet rs = st.getResultSet();
1208 st.close();
1216 st = conn.createStatement();
1217 st.execute("select * from type where Tint=" + Byte.MIN_VALUE);
1218 ResultSet rs = st.getResultSet();
1222 st.close();
1313 Statement st = null;
1464 Statement st = null;
1547 Statement st = null;
1550 st = conn.createStatement();
1551 st.execute(typeCreationStmtUDT);
1552 st.execute(personTableCreateUDT);
1564 st.close();
1573 st.execute("drop table if exists person");
1582 st = conn.createStatement();
1583 st.execute(personTableCreate);
1594 st.close();
1600 st.execute("drop table if exists person");
1610 st = conn.createStatement();
1611 st.execute("drop table if exists person");
1612 st.execute(personTableCreate);
1621 st.close();
1627 st.execute("drop table if exists person");
1640 Statement st = null;
1644 st = conn.createStatement();
1645 st.execute("select * from type where IntVal="
1647 ResultSet rs = st.getResultSet();
1651 st.close();
1662 st = conn.createStatement();
1663 st.execute("select * from type where LongVal='test text';");
1664 ResultSet rs = st.getResultSet();
1668 st.close();
1690 st = conn.createStatement();
1691 st.execute("select * from type where dateVal='"
1693 ResultSet rs = st.getResultSet();
1697 st.close();
1711 st.close();
1739 Statement st = null;
1743 st = conn.createStatement();
1744 st.execute("select * from type where IntVal="
1746 ResultSet rs = st.getResultSet();
1750 st.close();
1761 st = conn.createStatement();
1762 st.execute("select * from type where LongVal='test text';");
1763 ResultSet rs = st.getResultSet();
1767 st.close();
1784 st = conn.createStatement();
1785 st.execute("select * from type where dateVal='"
1787 ResultSet rs = st.getResultSet();
1791 st.close();
1805 st.close();
1832 Statement st = null;
1837 st = conn.createStatement();
1838 st.execute("select * from type where IntVal="
1840 ResultSet rs = st.getResultSet();
1844 st.close();
1855 st = conn.createStatement();
1856 st.execute("select * from type where LongVal='test text';");
1857 ResultSet rs = st.getResultSet();
1861 st.close();
1878 st = conn.createStatement();
1879 st.execute("select * from type where dateVal='"
1881 ResultSet rs = st.getResultSet();
1885 st.close();
1899 st.close();
1928 Statement st = null;
1933 st = conn.createStatement();
1934 st.execute("select * from type where timeVal='"
1936 ResultSet rs = st.getResultSet();
1940 st.close();
1988 Statement st = null;
1996 st.close();
2115 Statement st = null;
2123 st.close();
