Computers and Technology, 24.12.2019 19:31 selenaK9514
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
Answers: 2
Computers and Technology, 23.06.2019 15:00, victordhernandez01
Jake really works well with numbers and is skilled with computers but doesn't work well with others. which of the jobs discussed in this unit might be best for jake? why?
Answers: 3
Computers and Technology, 24.06.2019 01:30, jadaroyval
Write a program that asks the user to enter the name of an input file. if the file does not exist, the program should prompt the user to enter the file name again. if the user types quit in any uppercase/lowercase combinations, then the program should exit without any further output.
Answers: 3
Computers and Technology, 24.06.2019 02:30, journeyhile5
How to apply the fly in effect to objects on a slide
Answers: 1
Computers and Technology, 24.06.2019 07:30, Isabellawuzhere
Aproject involves many computing systems working together on disjointed task towards a single goal what form of computing would the project be using
Answers: 3
Which statement will set the value john to the first parameter of the preparedstatement below?
Mathematics, 25.10.2021 22:50
English, 25.10.2021 22:50
Mathematics, 25.10.2021 23:00
Mathematics, 25.10.2021 23:00