JDBC basics:On Statement Interface

[laavanya]

What does this mean ? Statement st=con.CreateStatement(); how method of Statement interface is accessed by Connection interface reference con ? please help me to understand the concept...

[stultuske]

are you talking about createStatement ?
this is a method from the Connection interface, returning a Statement.
just check here .

EDIT: the Statement interface doesn't have a createStatement method, by the way. if you check the api, you'll see this:

See Also:
Connection.createStatement(), ResultSet

which is basicly telling: the createStatement method of the Connection interface is related to the Statement interface. it's not part of it, though.

[shashikumar s g]

try {
    stmt = con.createStatement();
    ResultSet rs = stmt.executeQuery(query);
    while (rs.next()) {
        String coffeeName = rs.getString("COF_NAME");
        int supplierID = rs.getInt("SUP_ID");
        float price = rs.getFloat("PRICE");
        int sales = rs.getInt("SALES");
        int total = rs.getInt("TOTAL");
        System.out.println(coffeeName + "\t" + supplierID +
                           "\t" + price + "\t" + sales +
                           "\t" + total);
    }
}

[laavanya]

Thank you for clarifing my doubt....

[shashikumar s g]

more details http://www.tutorialspoint.com/jdbc/jdbc-db-connections.htm learn for this website

[laavanya]

con.setAutoCommit(true); the parameter to this method is true by default...why is it so ?? please help me know the reason for the default value true..

[JamesCherrill]

Read the API doc for The Connection class, setAutoCommit method.