Which statement will set the value john to the first parameter of the preparedstatement below?
string sql = "insert into student (first, middle, last) values ? , ? )" ;
preparedstatement ps = conn. preparestaement(sql);

ps. setstring(0, "john");
ps. setstring(0, ‘john’);
ps. setstring(1, "john");
ps. setstring(1, ‘john’);
question 7

which statement is used to execute the query "select * from products" using the statement object stmt?

stmt. executeupdate("select * from products");
stmt. exectue("select * from products");
stmt. exectuequery("select * from products");
stmt. query("select * from products");
question 8

what statement needs to be included below to retrieve all rows from the invoices table with invoicetotal greater than 100?
string sql = "select invoicedate, invoicetotal "
+ "from invoices where invoicetotal > ? ";
preparedstatement ps = connection. preparestatement(sql);
//what goes here
resultset invoices = ps. executequery();

ps. setvalue(0, 100);
ps. setvalue(1, 100);
ps. setdouble(0, 100);
ps. setdouble(1, 100);
question 9

what must you make available to your application before you can use jdbc to connect to a database?

a database driver
a web server
a firewall
an odbc data source
question 10

a is a swing gui component that can be bound to a database to display the results of a query.

tablemodel
jtextfield
jtable
jquery