Lines Matching refs:statement
59 SQLiteStatement statement;
61 statement = mDatabase.compileStatement("SELECT num1 FROM test WHERE num2 = ?;");
62 statement.bindLong(1, 30);
63 assertEquals(12, statement.simpleQueryForLong());
66 statement.bindDouble(1, 589.0);
67 assertEquals(213, statement.simpleQueryForLong());
68 statement.close();
70 statement = mDatabase.compileStatement("SELECT text1 FROM test WHERE text2 = ?;");
72 statement.bindDouble(1, 589.0); // Wrong binding
74 statement.simpleQueryForString();
79 statement.bindString(1, "test2");
80 assertEquals("test1", statement.simpleQueryForString());
81 statement.clearBindings();
83 statement.simpleQueryForString();
88 statement.close();
114 statement = mDatabase.compileStatement(
116 statement.bindString(1, "Jack");
117 statement.bindLong(2, 30);
118 assertEquals("Mike", statement.simpleQueryForString());
119 statement.close();
126 SQLiteStatement statement = mDatabase.compileStatement("INSERT INTO test " +
128 statement.bindString(1, "string1");
129 statement.bindString(2, "string2");
130 statement.bindLong(3, 100);
131 statement.bindNull(4);
132 statement.execute();
133 statement.close();
156 SQLiteStatement statement = mDatabase.compileStatement("INSERT INTO test " +
158 statement.bindString(1, "string1");
159 statement.bindString(2, "string2");
160 statement.bindLong(3, 100);
162 statement.bindBlob(4, blob);
163 statement.execute();
164 statement.close();
