package at.irian.jsfatwork.gui.page;
import java.sql.*;
import java.util.*;

import java.util.ArrayList;
import java.util.List;

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

import com.sun.jndi.cosnaming.IiopUrl.Address;

/*
 * customer profile
 */
@ManagedBean
@SessionScoped
public class Customer {
    Connection con ;
    Statement ps;
    ResultSet rs;

    private String firstName;
    private String lastName;
    private List<perInfo> perInfoAll = new ArrayList<perInfo>();

    public String getFirstName() {
        return firstName;
    }

    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public String save() {
        return "/showCustomer.xhtml";
    }

    public List getperInfoAll() {
         int i = 0;
            try
            {

            Class.forName("oracle.jdbc.driver.OracleDriver");
            con = DriverManager.getConnection("jdbc:oracle:thin:@server:1521:EW62","user","pw");
            ps = con.createStatement();
            rs = ps.executeQuery("select * from user");
            while(rs.next()){
              System.out.println(rs.getString(1));
              perInfoAll.add(i,new perInfo(rs.getString(1),rs.getString(2),rs.getString(3)));
              i++;

              }

            }
            catch (Exception e)
            {
              System.out.println("Error Data : " + e.getMessage());
            }
        return perInfoAll;
        }


}


package at.irian.jsfatwork.gui.page;

public class perInfo {

    String uname;
    String firstName;
    String lastName;

    public perInfo(String firstName, String lastName, String uname) {
        this.uname = uname;
        this.firstName = firstName;
        this.lastName = lastName;

    }

    public String getUname() {
        return uname;
    }

    public String getFirstName() {
        return firstName;
    }

    public String getLastName() {
        return lastName;
    }

}