idk

import java.sql.*;
public class JDBC{
    public static void main(String[] args)throws ClassNotFoundException,SQLException{
        String url="jdbc:oracle:thin:@//localhost:1521/XE";
        String username="system";
        String password="cvr123";
        String query="SELECT * FROM Employee";
        
        try{
            Connection conn = DriverManager.getConnection(url,username,password);
            Statement statement1 = conn.createStatement();
            ResultSet result1 = statement1.executeQuery(query);
            while(result1.next()){
                int id = result1.getInt(1);
                String name = result1.getString(2);
                int salary = result1.getInt(3);
                System.out.println(id+" "+name+" "+salary);
            }
        }catch (Exception e){
            e.printStackTrace();
        }
    }   
}






        ID NAME                                                                                                                                                       SALARY
---------- ------------------------------------------------------------------------------------------------------------------------------------------------------ ----------
         1 Varshith                                                                                                                                                     5000
         2 Suhas                                                                                                                                                        5000
         3 Manish                                                                                                                                                       6000
         4 Keerthan                                                                                                                                                     3000
         5 Chandhu                                                                                                                                                      3500






D:\22B81A05V5>set classpath=C:\oraclexe\app\oracle\product\11.2.0\server\jdbc\lib\ojdbc6_g.jar;.;

D:\22B81A05V5>JAVAC JDBC.java

D:\22B81A05V5>java JDBC
1 Varshith 5000
2 Suhas 5000
3 Manish 6000
4 Keerthan 3000
5 Chandhu 3500