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



public class AgendaDAO {

    static Connection con = null;
    private Agenda agenda;
    private List<Agenda> list;

    public Agenda getAgenda() {
        return agenda;
    }

    public void setAgenda(Agenda agenda) {
        this.agenda = agenda;
    }

    public List<Agenda> getList() {
        return list;
    }

    public void setList(List<Agenda> list) {
        this.list = list;
    }

    public AgendaDAO() throws SQLException {

        agenda = new Agenda();
        list = new ArrayList<Agenda>();

        if (con == null) {
            try {
                Class.forName("com.mysql.jdbc.Driver");
                con =  DriverManager.getConnection(
                        "jdbc:mysql://127.0.0.1:3306/agenda", "root", "");
                System.out.println(con);
            } catch (ClassNotFoundException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

        }
    }

    public String listar() {

        try {

            PreparedStatement ps;
            ps = con.prepareStatement("SELECT * FROM pessoa");

            ResultSet rs = ps.executeQuery();

            while (rs.next()) {

                // agenda.setId(rs.getString("id"));
                agenda.setNome(rs.getString("nome"));
                agenda.setEndereco(rs.getString("endereco"));
                agenda.setCidade(rs.getString("cidade"));
                agenda.setTelefone(rs.getString("telefone"));

                list.add(agenda);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return "";
    }