Guest User

Untitled

a guest
Jan 26th, 2024
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.12 KB | Source Code | 0 0
  1. import java.sql.*;
  2.  
  3. // import java.util.*;
  4. public class App {
  5.     public static void main(String[] args) {
  6.         try {
  7.             DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  8.             Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "system",
  9.                     "pratyay");
  10.             Statement statement = (Statement) connection.createStatement();
  11.             System.out.println("connect");
  12.             // statement.executeUpdate("create table empl(eno number, ename varchar(12))");
  13.             // statement.executeUpdate("insert into empl values(222, 'def')");
  14.             ResultSet rs = statement.executeQuery("select * from empl");
  15.             ResultSetMetaData rsmd = rs.getMetaData();
  16.             System.out.println(rsmd.getColumnCount()+ "     " + rsmd.getColumnType(1));
  17.             while (rs.next()) {
  18.                 System.out.println(rs.getString(1) + " " + rs.getString(2));
  19.             }
  20.             connection.close();
  21.         } catch (Exception ex) {
  22.             System.out.println("The exception raised is:" + ex);
  23.         }
  24.     }
  25.  
  26. }
  27.  
Advertisement
Add Comment
Please, Sign In to add comment