Abrir uma nova tela em Client/Server

import java.awt.<em>;

import java.awt.event.</em>;

import java.sql.<em>;

import java.util.</em>;

public class TesteBD1 extends Frame implements ActionListener, ItemListener

{

Panel p, p1, p2, p3;

Button b1, b2, b3, b4, b5, b6;

java.awt.List list1;

TextField t1, t2, t3, t4, t5;

Label l1, l2, l3, l4, l5, l6;

String urlODBC = “jdbc:odbc:TesteBD”;

Vector listaDeFuncionarios;

TesteBD1()

{

setTitle(">> Cadastro de Contatos - .:: Oracle 9i / Java ::.");

setSize(780, 220);

setResizable(false);

addWindowListener(new WindowAdapter(){public void windowClosing(WindowEvent e){System.exit(0);}});

p = new Panel();

p.setLayout(new BorderLayout());

p1 = new Panel();

list1 = new java.awt.List(2,false);

list1.addItemListener(this);

l6 = new Label("Escolha: ");

p1.add(l6);

p1.add(list1);

p.add(p1, “North”);

p2 = new Panel();

p2.setLayout(new GridLayout(5,3));

l1 = new Label("Nome: ", Label.RIGHT);

l2 = new Label("Endereço: ", Label.RIGHT);

l3 = new Label("Salário: ", Label.RIGHT);

l4 = new Label("Data de contratação: ", Label.RIGHT);

l5 = new Label("Optante (Sim/Não): ", Label.RIGHT);

t1 = new TextField(40);

t2 = new TextField(40);

t3 = new TextField(40);

t4 = new TextField(40);

t5 = new TextField(40);

p2.add(l1); p2.add(t1);p2.add(new Label());

p2.add(l2); p2.add(t2);p2.add(new Label());

p2.add(l3); p2.add(t3);p2.add(new Label());

p2.add(l4); p2.add(t4);p2.add(new Label());

p2.add(l5); p2.add(t5);p2.add(new Label());

p.add(p2, “Center”);

p3 = new Panel();

b1 = new Button(“Limpar”); b1.addActionListener(this); p3.add(b1);

b2 = new Button(“Incluir”); b2.addActionListener(this); p3.add(b2);

b3 = new Button(“Alterar”); b3.addActionListener(this); p3.add(b3);

b4 = new Button(“Excluir”); b4.addActionListener(this); p3.add(b4);

b5 = new Button(“Ler da Tabela”);b5.addActionListener(this); p3.add(b5);

b6 = new Button(“Encerrar”); b6.addActionListener(this); p3.add(b6);

p.add(p3, “South”);

public void actionPerformed(ActionEvent evt)

{

String arg = evt.getActionCommand();

if (arg.equals(“Limpar”))

limpar();

else

if (arg.equals(“Ler da Tabela”))

ler();

else

if (arg.equals(“Excluir”))

excluir();

else

if (arg.equals(“Incluir”))

incluir();

else

if (arg.equals(“Alterar”))

alterar();

else

if (arg.equals(“Encerrar”))

System.exit(0);

}

public void itemStateChanged(ItemEvent evt)

{

int qual = list1.getSelectedIndex();

atualizaTela(qual);

}

public void limpar()

{

t1.setText("");

t2.setText("");

t3.setText("");

t4.setText("");

t5.setText(“Não”);

}

public void ler()

{

String nome, endereco, contratacao, optou;

float salario;

Funcionario f = null;

listaDeFuncionarios = new Vector();

list1.removeAll();

try

{

Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);

Connection con = DriverManager.getConnection (urlODBC,“agenda”,“agenda1”);

Statement stmt = con.createStatement();

String query = “SELECT * FROM Funcionarios ORDER BY nome”;

ResultSet rs = stmt.executeQuery(query);

nome = rs.getString(1);

endereco = rs.getString(2);

salario = rs.getFloat(3);

contratacao = rs.getString(4);

optou = rs.getString(5);

f = new Funcionario(nome,endereco,salario,contratacao,optou);

listaDeFuncionarios.addElement(f);

list1.add(f.devolveNome());

atualizaTela(0);