import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class OracleJDBC {
public static void main(String[] args) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "system", "oracle");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from employees");
List<Employee> employees = new ArrayList<>();
while (rs.next()) {
Employee employee = new Employee();
employee.setId(rs.getInt("id"));
employee.setName(rs.getString("name"));
employee.setSalary(rs.getInt("salary"));
employees.add(employee);
}
for (Employee employee : employees) {
System.out.println(employee);
}
} catch (Exception e) {
e.printStackTrace();
}
}
public static class Employee {
private int id;
private String name;
private int salary;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getSalary() {
return salary;
}
public void setSalary(int salary) {
this.salary = salary;
}
@Override
public String toString() {
return "Employee{" + "id=" + id + ", name='" + name + '\'' + ", salary=" + salary + '}';
}
}
}
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)