Java Database Connectivity: Difference between revisions

Revision as of 18:27, 24 October 2019

Revision as of 18:29, 24 October 2019

Line 38:

JDBC 4.2, is specified by a maintenance release 2 of JSR 221<ref>{{cite web|url=https://jcp.org/aboutJava/communityprocess/mrel/jsr221/index2.html|title=The Java Community Process(SM) Program - communityprocess - mrel|author=|date=|website=jcp.org|accessdate=22 March 2018}}</ref> and is included in Java SE 8.<ref>{{cite web|url=http://docs.oracle.com/javase/8/docs/technotes/guides/jdbc/jdbc_42.html|title=JDBC 4.2|author=|date=|website=docs.oracle.com|accessdate=22 March 2018}}</ref>

The latest version, JDBC 4.3, is specified by a maintenance release 3 of JSR 221<ref>{{cite web|url=https://jcp.org/aboutJava/communityprocess/mrel/jsr221/index3.html|title=The Java Community Process(SM) Program - communityprocess - mrel|author=|date=|website=jcp.org|accessdate=22 March 2018}}</ref> and is included in Java SE 9.<ref>{{cite web|url=http://docs.oracle.com/javase/9/docs/api/java/sql/package-summary.html|title=java.sql (Java SE 9 & JDK 9 )|author=|date=|website=docs.oracle.com|accessdate=22 March 2018}}</ref>

==Functionality==

Line 120:

"jdbc:somejdbcvendor:other data needed by some jdbc vendor",

"myLogin",

"myPassword" );

try {

/* you use the connection here */

Line 161:

<source lang=java5>

try (Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery( "SELECT * FROM MyTable" )

) {

while (rs.next()) {

Line 196:

while (rs.next()) {

int numColumns = rs.getMetaData().getColumnCount();

for (int i = 1; i <= numColumns; i++ ) {

// Column numbers start at 1.

// Also there are many methods on the result set to return