/JDBC_Project_B18

Primary LanguageJava

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();
        

    }
}