Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- // import java.util.*;
- public class App {
- public static void main(String[] args) {
- try {
- DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
- Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "system",
- "pratyay");
- Statement statement = (Statement) connection.createStatement();
- System.out.println("connect");
- // statement.executeUpdate("create table empl(eno number, ename varchar(12))");
- // statement.executeUpdate("insert into empl values(222, 'def')");
- ResultSet rs = statement.executeQuery("select * from empl");
- ResultSetMetaData rsmd = rs.getMetaData();
- System.out.println(rsmd.getColumnCount()+ " " + rsmd.getColumnType(1));
- while (rs.next()) {
- System.out.println(rs.getString(1) + " " + rs.getString(2));
- }
- connection.close();
- } catch (Exception ex) {
- System.out.println("The exception raised is:" + ex);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment