package com.hospital.emr;

import java.sql.*; // need to import the java.sql package to use JDBC
import java.util.*; // needed for arraylist


public class JdbcConnection
{

    Connection conn;
    Statement stmt;

    ArrayList<ResultSet> rset = new ArrayList<ResultSet>(); // create an arraylist of result sets

    // constructors
    public JdbcConnection()
        throws SQLException
    {
        // Load the Oracle JDBC driver
        DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

        // Connect to the database

        Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.128:1521:xe", "hr","password");

        // Create a Statement
        Statement stmt = conn.createStatement();

        System.out.println("Database connection successful.");
    }


}