Java Reference
In-Depth Information
Example 15.2
Simple sample program using JDBC for Oracle
// import oracle.jdbc.driver.*;
import java.sql.*;
public class
MyCon
{
public static void
main(String [] args)
{
try {
// A simple connection example looks like this:
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:mydbusername/mydbpasswd"+
"@host.domain.com:1521:dbname";
Connection conn = DriverManager.getConnection(url);
// query
String mySQL = "SELECT id, pw FROM Users WHERE name = ?";
PreparedStatement stmt = conn.prepareStatement(mySQL);
stmt.setString(1, args[0]);
// execute the query
ResultSet rs = stmt.executeQuery();
// read the results
while(rs.next()) {
int id = rs.getInt("id");
String pw = rs.getString("pw");
System.out.println("id="+id);
}
} catch (Exception e) {
System.out.println("Exception: "+e);
e.printStackTrace();
}
} // main
} // class MyCon
