import java.sql.*;
public class connectoracle {

  public static void main(String[] args) throws Exception {
    try{
    String driver = "oracle.jdbc.driver.OracleDriver"; 
    
	String url = "jdbc:oracle:thin:@127.0.0.1:1521:mydatabase";
    
	String username = "root";
    String password = "root";
    
    Class.forName(driver);
    Connection conn = DriverManager.getConnection(url, username, password);
   
	System.out.println("Connected");
    Statement st = conn.createStatement();
    
	ResultSet rs = st.executeQuery("SELECT * FROM employee");
    ResultSetMetaData rsmd = rs.getMetaData();
    int NumOfCol=rsmd.getColumnCount();
    System.out.println("Number of Columns="+NumOfCol);
   
	st.close();
    conn.close();
  }catch(SQLException ex) {
     for(Throwable e : ex ) {
        System.out.println("Error occurred: " + e);
     }
    } 
  }
}