Why no any plotting?

Hi,

I am using a frame and database to create an interface.
My question is why no any frame display.
Thanks for your help.

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
 
public class DataBase2 extends JFrame {
int md_pid = 8893;
float acc;
char md[] = new char[4];
char pswd[] = new char[8];
String sname, spswd, paname, none = "", n = "", ss = "", phone = "",
account = "", last = "", add = "";
JButton a = new JButton("Login");
JButton b = new JButton("Exit");
JButton c = new JButton("Update");
JButton d = new JButton("Logout");
JButton e = new JButton("Continue");
JButton f = new JButton("Logout");
JButton k = new JButton("Enter New");
 
JTextField pname  = new JTextField(32);
JTextField pname2 = new JTextField(32);
JTextField pname3 = new JTextField(32);
JTextField pname4 = new JTextField(32);
JTextField pname5 = new JTextField(32);
JTextField pname6 = new JTextField(32);
JTextField user   = new JTextField(8);
JTextField ppname = new JTextField(16);
 
JPasswordField pass = new JPasswordField(8);
JPasswordField PID = new JPasswordField(4);
 
JPanel pp9 = new JPanel();
JPanel pp10 = new JPanel();
JPanel pp8 = new JPanel();
JPanel pp7 = new JPanel();
JPanel buttons = new JPanel();
JPanel client = new JPanel();
JPanel server = new JPanel();
JPanel panels = new JPanel();
JPanel Nuser = new JPanel();
 
CardLayout windowl = new CardLayout();
Statement s;
Connection con;
 
public void DataBase2() {
setTitle("Client Login");
setSize(400, 400);
Container window = getContentPane();
window.setLayout(new BorderLayout());
panels.setLayout(windowl);
client.setLayout(new GridLayout(4, 1));
server.setLayout(new GridLayout(13, 1));
Nuser.setLayout(new GridLayout(5, 1));
pp7.add(new JLabel("username:"));
pp7.add(user);
pp8.add(new JLabel("password:"));
pp8.add(pass);
pp9.add(c);
pp9.add(d);
pp10.add(new JLabel("Enter patient name:"));
pp10.add(ppname);
buttons.setLayout(new FlowLayout());
buttons.add(a);
buttons.add(b);
buttons.add(new JLabel("MD PID:"));
buttons.add(PID);
client.add(new JLabel("Enter username and password:"));
client.add(pp7);
client.add(pp8);
client.add(buttons);
Nuser.add(new JLabel("LOGIN SUCCESFUL!"));
Nuser.add(pp10);
Nuser.add(e);
Nuser.add(f);
Nuser.add(k);
panels.add(client, "client");
panels.add(Nuser, "getpatient");
window.add(panels, BorderLayout.CENTER);
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/pract",
"root", "000405");
s = con.createStatement();
} catch (java.lang.Exception ex) {
ex.printStackTrace();
}
 
a.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent g) {
sname = user.getText();
pswd = pass.getPassword();
spswd = String.valueOf(pswd);
try {
if (md_pid == Integer.valueOf(String.valueOf(PID
.getPassword()))) {
try {
ResultSet rs = s
.executeQuery("SELECT password FROM MD2 WHERE username LIKE '"
+ sname + "'");
rs.next();
String name = rs.getString("password");
if (spswd.equals(name)) {
windowl.show(panels, "getpatient");
}
} catch (java.lang.Exception ex) {
JOptionPane.showMessageDialog(client, "Try Again",
"LOGIN ERROR", 1);
}
} else
JOptionPane.showMessageDialog(client, "Try Again",
"LOGIN ERROR", 1);
} catch (java.lang.Exception ae) {
JOptionPane.showMessageDialog(client, "Try Again",
"LOGIN ERROR", 1);
}
user.setText(null);
pass.setText(null);
PID.setText(null);
}
});
ActionListener g = new ActionListener() {
public void actionPerformed(ActionEvent l) {
paname = ppname.getText();
server.add(new JLabel("Enter information and click Update:"));
try {
if (l.getSource() == k)
s.execute("Insert into Pa set name=�" + paname + "�");
ResultSet rs2 = s
.executeQuery("SELECT*FROM PA WHERE name LIKE '"
+ paname + "'");
rs2.next();
server.add(new JLabel("Name: " + rs2.getString("name")));
server.add(pname);
server.add(new JLabel("Address: "
+ rs2.getString("address")));
server.add(pname2);
server.add(new JLabel("SS#: "
+ String.valueOf(rs2.getInt("ss"))));
server.add(pname3);
server.add(new JLabel("Phone Number: "
+ String.valueOf(rs2.getLong("phone"))));
server.add(pname4);
server.add(new JLabel("Cost of Last Visit: $"
+ String.valueOf(rs2.getFloat("last"))));
server.add(pname6);
server.add(new JLabel("Account Balance: $"
+ String.valueOf(rs2.getFloat("account"))));
server.add(pp9);
panels.add(server, "server");
acc = rs2.getFloat("account");
windowl.show(panels, "server");
} catch (java.lang.Exception ex) {
server.removeAll();
System.out.println("Patient not in System.");
}
ppname.setText(null);
}
};
b.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent g) {
try {
s.close();
} catch (java.lang.Exception ex) {
ex.printStackTrace();
}
System.exit(0);
}
});
ActionListener h = new ActionListener() {
public void actionPerformed(ActionEvent g) {
server.removeAll();
windowl.show(panels, "client");
}
};
e.addActionListener(g);
k.addActionListener(g);
d.addActionListener(h);
f.addActionListener(h);
c.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
if (!(none.equals(pname.getText()))) {
s.executeUpdate("Update pa set name='"
+ pname.getText() + "' WHERE name='" + paname
+ "'");
paname = pname.getText();
}
if (!(none.equals(pname2.getText())))
s.executeUpdate("Update pa set address='"
+ pname2.getText() + "' WHERE name='" + paname
+ "'");
if (!(none.equals(pname3.getText())))
s.executeUpdate("Update pa set ss=" + pname3.getText()
+ " WHERE name='" + paname + "'");
if (!(none.equals(pname4.getText())))
s.executeUpdate("Update pa set phone="
+ pname4.getText() + " WHERE name='" + paname
+ "'");
if (!(none.equals(pname6.getText())))
s.executeUpdate("Update pa set account="
+ String.valueOf(acc
+ Float.parseFloat(pname6.getText()))
+ ", last=" + pname6.getText()
+ " WHERE name='" + paname + "'");
ResultSet rs1 = s.executeQuery("Select Now()");
rs1.next();
String time = rs1.getString("Now()");
ResultSet rs2 = s
.executeQuery("SELECT*FROM PA WHERE name LIKE '"
+ paname + "'");
rs2.next();
JOptionPane.showMessageDialog(server, "Name: "
+ rs2.getString("name") + "\nAddress: "
+ rs2.getString("address") + "\nSS#: "
+ String.valueOf(rs2.getInt("ss"))
+ "\nPhone Number: "
+ String.valueOf(rs2.getLong("phone"))
+ "\nCost of Last Visit: $"
+ String.valueOf(rs2.getFloat("last"))
+ "\nAccount Balance: $"
+ String.valueOf(rs2.getFloat("account")), time, 1);
pname.setText(null);
pname2.setText(null);
pname3.setText(null);
pname4.setText(null);
pname6.setText(null);
server.removeAll();
windowl.show(panels, "client");
} catch (java.lang.Exception ex) {
JOptionPane.showMessageDialog(server, "Try Again",
"SYSTEM ERROR", 1);
}
}
});
}
 
public static void main(String args[]) {
DataBase2 login = new DataBase2();

login.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
}

Originally posted by Hui Zhao:

My question is why no any frame display.
DataBase2 login = new DataBase2(); login.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

Perhaps add login.setVisible(true) ?
[ February 15, 2008: Message edited by: Brian Cole ]

I added it. The frame displays but no any panels.
why?

Thanks

Where is your constructor? You have a method. . . but no obvious constructor. Try removing the return type from that method and it will probably turn into a constructor. That might sort out your problem.

CR