Title: Theory / Important / CS / Algo / Database / Database System Concept 6 - McGraw Hill+27{ / 1 Introduction / Java
Tags: automatedNewLineAfterCommaSpace

Name: Java Database Connectivity
Page: 158
Chapter: 4
Section: 6.5
Context: sql
Abbreviation: JDBC
Typ: dynamic sql

Typ: Connection
Meaning: A connection to some database. Can be use to make query
Page: 159

Instruction: DriverManager
  .getConnection(address, user, passwd)
Page: 159
Returns: A connection to a database, with the given parameter
Exception: SQLException

Instruction: conn.createStatement()
Page: 159
Returns: A new empty statement.
Variables: Connection conn

Typ: Statement
Meaning: object used for executing a static SQL statement and returning the results it produces.
Page: 159
Variables: Connection conn

Instruction: stmt.executeQuery(query)
Page: 159
Effect: execute query
Returns: A non null
 ResultSet that contains the data produced by the given query
Variables: Statement stmt
Exception: SQLTimeoutException or SQLException

Instruction: stmt.close()
Page: 159
Effect: close the Statement
Variables: Statement stmt

Typ: ResultSet
Meaning: A table of data representing a database result set, which is usually generated by executing a statement that queries the database.
Page: 159

Instruction: r_set.next()
Page: 159
Effect: move the cursor forward one row from its current position
Variables: ResultSet r_set

Instruction: rset.getType(index)
Page: 159
Returns: The index-th value of type type
Variables: ResultSet rset

Instruction: rset.getType(key)
Page: 159
Returns: The value of column named key of type Type
Variables: ResultSet rset

Typ: CallableStatement
Meaning: interface used to execute SQL stored procedures
Page: 164

Instruction: conn.prepareClass(foo)
Page: 164
Returns: A callable statement for conn
Variables: Connection conn
Typ: CallableStatement

Instruction: rs.getMetaData()
Page: 164
Returns: Information about the column type of the result set
Variables: ResultSet rs

Typ: ResultSetMetaData
Meaning: can be used to get information about the types and properties of the columns in a ResultSet object.
Page: 164
Variables: ResultSet rs