Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.company;
- import oracle.jdbc.OracleDriver;
- import java.sql.*;
- public class Main {
- private static String SELECTSQL = "SELECT PERSON_ID AS Id, p.PERSON_DATA.FIRSTNAME AS fName, p.PERSON_DATA.LASTNAME AS lName, p.PERSON_DATA.AGE AS Age FROM PEOPLE p";
- private static String INSERTSQL = "INSERT INTO PEOPLE (PERSON_ID, PERSON_DATA) VALUES (?, NEW PERSON (?, ?, ?))";
- private static Connection getDBConnection() {
- Connection dbConnection = null;
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- } catch (ClassNotFoundException e) {
- System.out.println(e.getMessage());
- }
- try {
- Driver driver = new OracleDriver();
- DriverManager.registerDriver(driver);
- dbConnection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:TestDB",
- "SYS as SYSDBA", "MySecretPassword2k18");
- return dbConnection;
- } catch (SQLException e) {
- System.out.println(e.getMessage());
- }
- return dbConnection;
- }
- private static void FillTable() {
- try {
- Connection dbConnection = getDBConnection();
- PreparedStatement statement = dbConnection.prepareStatement(INSERTSQL);
- statement.setInt(1, 1);
- statement.setString(2, "Maxim");
- statement.setString(3, "Kuraksin");
- statement.setInt(4, 20);
- statement.execute();
- statement.setInt(1, 2);
- statement.setString(2, "Andrey");
- statement.setString(3, "Konovalov");
- statement.setInt(4, 25);
- statement.execute();
- statement.setInt(1, 3);
- statement.setString(2, "Alexey");
- statement.setString(3, "Stepanov");
- statement.setInt(4, 19);
- statement.execute();
- statement.setInt(1, 4);
- statement.setString(2, "Igor");
- statement.setString(3, "Kolesnikov");
- statement.setInt(4, 20);
- statement.execute();
- statement.setInt(1, 5);
- statement.setString(2, "Olga");
- statement.setString(3, "Volnova");
- statement.setInt(4, 21);
- statement.execute();
- }
- catch (SQLException e) {
- System.out.println(e.getMessage());
- }
- }
- public static void main(String[] args) {
- try {
- FillTable();
- Connection dbConnection = getDBConnection();
- PreparedStatement statement = dbConnection.prepareStatement(SELECTSQL);
- ResultSet rs = statement.executeQuery();
- System.out.println(" Id fName lName Age");
- System.out.println("------------------------------");
- while (rs.next()) {
- String id = rs.getString("Id");
- String fName = rs.getString("fName");
- String lName = rs.getString("lName");
- String age = rs.getString("Age");
- System.out.println(id + "\t " + fName + "\t " + lName + "\t " + age);
- }
- } catch (SQLException e) {
- System.out.println(e.getMessage());
- }
- }
- }
- OUTPUT:
- Id fName lName Age
- ------------------------------
- 1 Maxim Kuraksin 20
- 2 Andrey Konovalov 25
- 3 Alexey Stepanov 19
- 4 Igor Kolesnikov 20
- 5 Olga Volnova 21
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement