fdsfsdfsd

import java.sql.SQLException;

import javax.sql.rowset.JdbcRowSet;
import javax.sql.rowset.RowSetProvider;

public class tourdumonde {
	JdbcRowSet rowSetMySQL;
	JdbcRowSet rowSetOracle;

	public void connectMySQL() throws SQLException{
		rowSetMySQL = RowSetProvider.newFactory().createJdbcRowSet();
		rowSetMySQL.setUrl("jdbc:mysql://localhost:3306/qc");
		rowSetMySQL.setUsername("root");
		rowSetMySQL.setPassword("toto");

		rowSetMySQL.setCommand("select * from Escales");
		rowSetMySQL.execute();
		System.out.println("job done");

	}
	public void connectOracle() throws SQLException{
		rowSetOracle = RowSetProvider.newFactory().createJdbcRowSet();
		rowSetOracle.setUrl("jdbc:oracle:thin:\"qcoloos\"/20051996@192.168.22.60:1521:orcl2");

		rowSetOracle.setCommand("select * from vol");
		rowSetOracle.execute();
		System.out.println("job 2 done");

	}
	public void print() throws SQLException {
		while(rowSetOracle.next()){
			System.out.println("--------------------");
			System.out.println("NumVol: "+rowSetOracle.getString("NumVol"));
			System.out.println("Heure de Depart: "+rowSetOracle.getDate("Heure_depart"));
		}

	}
	public static void main(String[] args) throws SQLException {
		tourdumonde tdm = new tourdumonde();
		tdm.connectMySQL();
		tdm.connectOracle();
		tdm.print();
	}

}