import java.sql.*;
import oracle.jdbc.driver.*;


public class oracle
{
	public static void main( String[] args)
	{
		try{

		String url = "jdbc:oracle:thin:@192.168.1.207:1521:teste";
		String user = "teste";
		String pass = "teste";

		DriverManager.registerDriver(
		new OracleDriver());


		Connection conn = DriverManager.getConnection(url, user,pass);

		Statement stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery("SELECT * FROM EMP "+
										 "WHERE JOB = 'SALESMAN'");
		while(rs.next())
		{
			int    empno		= rs.getInt(1);
			String nome 		= rs.getString(2);
			String job			= rs.getString(3);
			int	   mgr			= rs.getInt(4);
			Date   data			= rs.getDate(5);
			long   sal			= rs.getLong(6);
			long   comm			= rs.getLong(7);
			int    dept			= rs.getInt(8);

			System.out.print(empno+" ");
			System.out.print(nome+" ");
			System.out.print(job+" ");
			System.out.print(mgr+" ");
			System.out.print(data+" ");
			System.out.print(sal+" ");
			System.out.print(comm+" ");
			System.out.println(dept);

		}


		}catch(SQLException e)
		{
			System.out.println(e.getMessage());
		}
	}
}
