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

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.Map;

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

/**
* @param args
* @throws Exception 
*/
public static void main(String[] args) throws Exception {
  PersonBean person = new PersonBean();
  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);
  person.setBirthYear(2005);
  person.setFirstname("dot");
  person.setName("Myself");
  PreparedStatement pstmt = conn.prepareStatement ("INSERT INTO FRIENDS VALUES (?,?)");
  pstmt.setInt(1, 4);
  pstmt.setObject(2, person);
  pstmt.executeUpdate();
  pstmt.close();
  conn.close();
}

}