/**
* @author Hyacinthe MENIET
* Created on 19 janv. 2006
*/
package net.dotmyself.j2sql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Map;

/**
* Creates JavaBeans which contain data from Oracle.
*/
public class SQL2Java {

/**
* @param args
* @throws Exception  
*/
public static void main(String[] args) throws Exception {
  int pid;
  PersonBean person;
  Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.8.1:1520:JBD","login","password");
  Map map = conn.getTypeMap();
  map.put("PERSON",Class.forName("net.dotmyself.j2sql.PersonBean"));
  conn.setTypeMap(map);
  Statement stmt = conn.createStatement();
  ResultSet rs = stmt.executeQuery("SELECT f_id,f_pers FROM FRIENDS");
  while(rs.next()) {
    pid = rs.getInt("F_ID");
    person = (PersonBean) rs.getObject("F_PERS");
    System.out.println(pid+". "+person.getFirstname()+" "+person.getName()+" ( "+person.getBirthYear()+" )");
  }
  rs.close();
  stmt.close();
  conn.close();
}

}