import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import oracle.jdbc.pool.OracleDataSource;

/**
 *
 * @author Rahman YAZGAN
 *
 * Oracle 10g Express
 * jdbcUrl = "jdbc:oracle:thin:hr/hr@localhost:1521/XE"
 *
 */
public class OracleDBConnection {
    public static void main(String[] args) throws SQLException {
        String jdbcUrl, userid, password, query;
        Connection connection;
        Statement statement;
        ResultSet resultSet;

        jdbcUrl = "jdbc:oracle:thin:hr/hr@localhost:1521/XE";
        userid = "user";
        password = "1111";

        OracleDataSource dataSource = new OracleDataSource();
        dataSource.setURL(jdbcUrl);
        connection = dataSource.getConnection(userid, password);
        statement = connection.createStatement();

        query = "INSERT INTO UYELER (ID, AD, SOYAD) VALUES (NULL, 'MEHMET', 'BİLİR')";
        resultSet = statement.executeQuery(query);

        query = "SELECT * FROM UYELER";
        resultSet = statement.executeQuery(query);

        String column[] = {"ID", "AD", "SOYAD"};

        while (resultSet.next()) {
            for (int i = 1; i <= column.length; i++) {
                System.out.print(resultSet.getString(i) + " ");
            }
            System.out.println("");
        }
    }
}