ummugulsum86 / jdbc_project

Practice Git and Github for EU3

JDBC Project for Batch 18

A project to demonstrate usage of Java Database Connectivity from JDK.

• DriverManager
• Driver
• Connection
• Statement
• ResultSet
• SQLException

---

public class DB_Connection {

    public static void main(String[] args) throws SQLException {

        String connectionStr = "jdbc:oracle:thin:@YourIP:1521:XE";
        String username = "hr" ;
        String password = "hr" ;

        Connection conn = DriverManager.getConnection(connectionStr, username, password);
        Statement stmnt = conn.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,
                                                ResultSet.CONCUR_READ_ONLY);
        ResultSet rs = stmnt.executeQuery("SELECT * FROM JOBS");
        
        rs.next();
        

    }
}