Busy. Please wait.

show password
Forgot Password?

Don't have an account?  Sign up 

Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.
We do not share your email address with others. It is only used to allow you to reset your password. For details read our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.

Remove ads
Don't know
remaining cards
To flip the current card, click it or press the Spacebar key.  To move the current card to one of the three colored boxes, click on the box.  You may also press the UP ARROW key to move the card to the "Know" box, the DOWN ARROW key to move the card to the "Don't know" box, or the RIGHT ARROW key to move the card to the Remaining box.  You may also click on the card displayed in any of the three boxes to bring that card back to the center.

Pass complete!

"Know" box contains:
Time elapsed:
restart all cards

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how


Cert Obj Submit Queries and Read Results from DB

[9.3.1] What are the steps? a) Get Connection b) Create statement c) Execute query d) Process results
[9.3.2] Which ones return an int? SQL INSERT, UPDATE,DELETE commands, or any of the SQL Data Definition Language (DDL) statements, like CREATE TABLE, return either the number of rows affected by the query or 0 //executeUpdate(),and execute()
[9.3.3] Which ones return a ResultSet? ResultSet rs = stmt.executeQuery("SELECT * from Customer");// executeQuery()
[9.3.4] When Statement? when you need to send a SQL statement to the database without any parameter. In normal cases, you need to use this interface only. You can create an instance of Statement using the createStatement() method in the Connection interface.
[9.3.5] When PreparedStatement (subclass of Statement)? represents precompiled SQL statement that can be customized using IN parameters. Used to improve performance, if SQL statement is executed multiple times.can get an instance of PreparedStatement by calling preparedStatement() method in Connection.
[9.3.6] When CallableStatement (extends PreparedStatement) ? used to execute stored procedures. CallableStatement instances can handle IN as well as OUT and INOUT parameters. You need to call the prepareCall() method in the Connection interface to get an instance of this class.
[9.3.7] Statement interface The Statement interface provides three execute methods: executeQuery(), executeUpdate(),and execute()
[9.3.8] ResultSet call next() to read the first row, and so on
[9.3.9]Closure when execute() is executed or Statement is closed, all opem ResultSets are also closed. when connection is closed, all Statement and ResultSet are closed
[9.3.10]ResultSet numbered from 1, read-only, forward only, fetch size can be controlled
Created by: MVK2013