package ModelClass;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.SessionScoped;

import java.util.Calendar;
import java.util.GregorianCalendar;

@ManagedBean(name = "RegionBean")
@SessionScoped
public class RegionBean {

    private final String user = "Navid";
    private final String password = "1234";

public List<Region> getRegionList() throws ClassNotFoundException, SQLException
{
List<Region> list = new ArrayList<>();

Statement stmt = null;
PreparedStatement ps = null;
Connection con = null;
ResultSet rs = null;
System.out.print("In RegionBean");

try {


            //Class.forName("oracle.jdbc.driver.OracleDriver");
            DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

            String dbURL2 = "jdbc:oracle:thin:@localhost:1521:orcl";
            con = DriverManager.getConnection(dbURL2, user, password);
            if (con!= null) {
                System.out.println("Connected with connection #2");
                stmt = con.createStatement();
            try {
            rs = stmt.executeQuery("SELECT * FROM REGION");
            while(rs.next())
            {
                Region region = new Region();
                region.setRegionID(rs.getInt(1));
                region.setRegionName(rs.getString(2));
                list.add(region);
            }
            }
            catch(SQLException e)
            {
                System.out.println("No data found");
            }
            }
        } catch (SQLException e) {
            System.out.println(e.toString());
        }


}