import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class ConnectionOracle {

	public static void main(String[] args){
		
		try{
			
			Class.forName("oracle.jdbc.OracleDriver");
			
			String url="jdbc:oracle:thin:@127.0.0.1:1521:king11g";
			
			String name="programmer";String pass="password";
			
			String sqlStr="select username,email from o_user";
			
			Connection conn=DriverManager.getConnection(url,name,pass);
			
			Statement stmt=conn.createStatement();
			
			ResultSet resultSet=stmt.executeQuery(sqlStr);
			
			while(resultSet.next()){
				
				String str1=resultSet.getString(1);
				
				String str2=resultSet.getString(2);
				
				System.out.println(str1+" "+str2);
			}
			
			if(resultSet!=null){resultSet.close();}	
			
			if(stmt!=null){stmt.close();}
			
			if(conn!=null){conn.close();}

		}catch(SQLException se){
			
			se.printStackTrace();
		}
		catch(ClassNotFoundException ce){
		
			ce.printStackTrace();
		}
	}
}