Flashcards
JDBC
Flashcards do conjunto (15)
- 1What 3 functions can JDBC do with an SQL DB?1) Establish a connection
2) Write Statements
3) Process Results - 2JDBC Statements Statement - The statement is sent to the DB upon each and every _____execution
- 3JDBC PreparedStatements the statement is _____ and then the execution path is predetermined on the DB server allowing it to be executed multiple times in an efficient mannercached
- 4JDBC CallableStatement Used for executing stored _____ already on a DBprocedures
- 5JDBC Statement Returns Update statements return an _____ _____ that indicate how many rows were affected in the DBupdate count
- 6JDBC Query Statements Return a JDBC _____ _____.results set
- 7JDBC Executing an SQL Statement To access a DB a _____ object is usedconnection
- 8JDBC Executing an SQL Statement A Connection object can create _____ objectsstatement
- 9JDBC Executing an SQL Statement The execute method of the statement class executes a _____ _____SQL statement
- 10Layer (n-tier) architecture Each tier contains a unique system _____component
- 11Layer (n-tier) architecture Information tier stores data in a DB. It is also known as the _____ _____ layerData Access Layer
- 12Layer (n-tier) architecture Middle tier AKA _____ _____ layerBusiness Logic
- 13Layer (n-tier) architecture Middle tier processes _____-_____ requests and calls on the DAL to read and write to the DB. It is the ______ tierintermediary
- 14Layer (n-tier) architecture The Client tier AKA _____ LayerPresentation
- 15Layer (n-tier) architecture Client Tier Why is it useful?A designer can modify one layer without having to modify the others
Informações
- Descrição
- Masters of Science Programming 2 FlashCards sobre JDBC, criado por Nathan Hunsdale em 02-06-2014.
- Criado por
- Nathan Hunsdale
- Visualizações
- 26
- Avaliação