FilesExpand file tree

 master

/

DB.java

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

25 lines (25 loc) · 818 Bytes

 master

/

DB.java

Top

File metadata and controls

• Code
• Blame

25 lines (25 loc) · 818 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

import java.sql.*; //1) import package after adding jdbc jar

//import oracle.jdbc.*;

class DB

{

public static void main(String args[])

{

try //2) always work in try block for exceptions

{

Class.forName("oracle.jdbc.driver.OracleDriver"); //3) initialize driver

Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","SYSTEM","12345678"); //4) Create connection object

Statement st = con.createStatement(); //5) Create statement object

String sql = "select * from courses";

ResultSet rs = st.executeQuery(sql); //6) Create result set object to invoke the select statement result

while(rs.next())

{

System.out.println(rs.getString(1) + " " + rs.getString(2));

}

con.close(); //7) Close the connection object

}

catch(Exception e)

{

System.out.println(e);

}

}

}