A Simple Example

import java.sql.* ;

public class ShowStudents {

public static void main(String args[]) throws Exception {

System.setProperty(“jdbc.drivers”,

“oracle.jdbc.driver.OracleDriver”) ;

String url = “jdbc:oracle:thin:@sirah.csit.fsu.edu:1521:oralin” ;

Connection conn =

DriverManager.getConnection(url, “dbc”, “ . . . ”) ;

Statement stat = conn.createStatement() ;

ResultSet rs = stat.executeQuery(“SELECT * FROM students”) ;

while(rs.next())

System.out.println(rs.getString(1) + “ ” +

rs.getString(2) + “ ” + rs.getString(3)) ;

conn.close() ;

}

}

Previous slide

Next slide

Back to first slide

View graphic version