Java Program Problem

From:

christopher_board@yahoo.co.uk

Newsgroups:

comp.lang.java.help

Date:

9 Sep 2006 16:01:52 -0700

Message-ID:

<1157842912.055295.52100@i42g2000cwa.googlegroups.com>

Hi.

I am writing a java application called pocket money calculator. It
connects to a MySQL Database.

My program is designed to allow multiple users to connect login to my
program to put information into tables within the database for your
personal use that no one except the user can see. I can login and it
loads MainScreen without any problems. I log off and it goes back to
the login screen. When I log in again it then loads the program twice
and I can't see any reason why. I have tried several things including
closing the connection before it opens the MainScreen. However this
doesn't work.

Below is all the code used for the login screen.

package pocket_money_calculator;

import java.awt.BorderLayout;
import java.awt.Dimension;

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import java.util.Properties;
import java.io.IOException;
import java.io.FileInputStream;
import java.io.FileWriter;
import java.io.BufferedWriter;

/**
* Title: Pocket Money Calculator
*
* Description: Allows you to easily save your pocket money details
onto your
* computer and allows you to enter information about your bank
details
*
* Copyright: Copyright (c) 2006
*
* Company: 
*
* @author Christopher Board
* @version 1.0
*/
public class Login extends JFrame {
 JPanel contentPane;
 JLabel jLabel1 = new JLabel();
 JLabel jLabel2 = new JLabel();
 static JTextField txtUser = new JTextField();
 JLabel jLabel3 = new JLabel();
 JPasswordField txtPassword = new JPasswordField();
 static JButton btnLogin = new JButton();
 JButton btnCancel = new JButton();
 JButton btnEnterDatabase = new JButton();
 static JLabel statusBar = new JLabel();
 protected Connection connection;
 protected boolean connected = false;
 protected Statement statement = null;
 protected ResultSet resultSet = null;
 private boolean result = false;

 public Login() {
 try {
 setDefaultCloseOperation(EXIT_ON_CLOSE);
 jbInit();
 } catch (Exception exception) {
 exception.printStackTrace();
 }
 }

 /**
 * Component initialization.
 *
 * @throws java.lang.Exception
 */
 private void jbInit() throws Exception {
 contentPane = (JPanel) getContentPane();
 contentPane.setLayout(null);
 setSize(new Dimension(355, 235));
 setTitle("Login To Pocket Money Calculator");
 jLabel1.setFont(new java.awt.Font("Dialog", Font.BOLD, 25));
 jLabel1.setForeground(new Color(0, 0, 125));
 jLabel1.setText("Pocket Money Calculator");
 jLabel1.setBounds(new Rectangle(11, 18, 306, 39));
 jLabel2.setFont(new java.awt.Font("Dialog", Font.BOLD, 11));
 jLabel2.setText("User");
 jLabel2.setBounds(new Rectangle(42, 66, 40, 21));
 txtUser.setToolTipText("");
 txtUser.setText("");
 txtUser.setBounds(new Rectangle(111, 67, 172, 19));
 jLabel3.setFont(new java.awt.Font("Dialog", Font.BOLD, 11));
 jLabel3.setText("Password");
 jLabel3.setBounds(new Rectangle(38, 93, 64, 16));
 txtPassword.setBounds(new Rectangle(111, 93, 172, 21));
 btnLogin.setBounds(new Rectangle(54, 125, 95, 25));
 btnLogin.setText("Login");
 btnLogin.addActionListener(new
Login_btnLogin_actionAdapter(this));
 btnCancel.setBounds(new Rectangle(188, 125, 92, 24));
 btnCancel.setText("Cancel");
 btnCancel.addActionListener(new
Login_btnCancel_actionAdapter(this));
 btnEnterDatabase.setBounds(new Rectangle(54, 158, 225, 23));
 btnEnterDatabase.setText("Re-connect to database");
 btnEnterDatabase.addActionListener(new

Login_btnEnterDatabase_actionAdapter(this));
 statusBar.setFont(new java.awt.Font("Dialog", Font.BOLD, 20));
 statusBar.setMaximumSize(new Dimension(335, 235));
 statusBar.setPreferredSize(new Dimension(335, 235));
 this.setSize(new Dimension(335, 255));
 contentPane.setSize(new Dimension(335, 235));
 statusBar.setText("jLabel4");
 statusBar.setBounds(new Rectangle(6, 188, 338, 28));
 contentPane.setMinimumSize(new Dimension(335, 235));
 contentPane.setPreferredSize(new Dimension(335, 235));
 contentPane.add(jLabel1);
 contentPane.add(jLabel2);
 contentPane.add(txtUser);
 contentPane.add(jLabel3);
 contentPane.add(txtPassword);
 contentPane.add(btnLogin);
 contentPane.add(btnEnterDatabase);
 contentPane.add(btnCancel);
 contentPane.add(statusBar);
 getProperties();
// enterDatabase();
// checkLogin();
// checkUsers();
// checkAdministrator();
 }

// public void checkAdministrator() {
// try {
// BufferedWriter out = new BufferedWriter(new FileWriter(
// "Logs.html", true));
// try {
// out.write("Checking Administrator Account
exists ");
// statement = connection.createStatement();
// resultSet = statement.executeQuery(
// "SELECT * FROM login WHERE
user='Administrator'");
// resultSet.last();
// int r = resultSet.getRow();
// if (r > 0) {
// out.write("Administrator account exists ");
// out.close();
// } else {
// out.write("Administrator does not exist ");
// System.out.println("No administrator used ");
// statement = connection.createStatement();
// statement.execute(
// "insert into login set id=null,
user='Administrator', password='password'");
// System.out.println("Administrator Account
Added");
// out.write("Administrator account added
successfully");
// out.close();
// }
//
// } catch (SQLException ex) {
// out.write(
// "Unable to get
results and add Administrator account");
// out.write("" +
ex.toString());
// out.close();
// }
// } catch (IOException e) {
// System.err.println("" + e.toString());
// }
// }
//
// public void checkUsers() {
// try {
// BufferedWriter out = new BufferedWriter(new FileWriter(
// "Logs.html", true));
// try {
// out.write("Checking to make sure users are in the
database ");
// statement = connection.createStatement();
// resultSet = statement.executeQuery("SELECT * FROM
LOGIN");
// resultSet.last();
// int r = resultSet.getRow();
// if (r > 0) {
// System.out.println("results found");
// out.write("Users found ");
// out.close();
// return;
//
// } else {
// System.out.println("no results found");
// noUsersFound dlg = new noUsersFound();
// Dimension dlgSize = dlg.getPreferredSize();
// Dimension frmSize = getSize();
// Point loc = getLocation();
// dlg.setLocation((frmSize.width - dlgSize.width) /
2 +
// loc.x,
// (frmSize.height - dlgSize.height)
/ 2 +
// loc.y);
// dlg.setModal(true);
// dlg.pack();
// dlg.show();
// out.write("No users found");
// out.close();
// }
// } catch (SQLException ex) {
// System.err.println("" + ex.toString());
// System.err.println("" + ex.getErrorCode());
// }
// } catch (IOException e) {
//
// }
//
// }
//
// public void checkLogin() {
// try {
// BufferedWriter out = new BufferedWriter(new FileWriter(
// "Logs.html", true));
// try {
// statement = connection.createStatement();
// resultSet = statement.executeQuery("show tables from
" +
// pocket_money_calculator.
// MySQL_Options.txtDatabase.
// getText() + " like 'login'");
// resultSet.last();
// int r = resultSet.getRow();
// if (r > 0) {
// System.out.println("Login Table Found");
// out.write(" The Login table was
found ");
// } else {
// out.write("Login table not found ");
// System.out.println("Login table not found");
// statement = connection.createStatement();
// out.write("Creating login table ");
// statement.execute("CREATE TABLE `login` (`id`
INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,`first` TEXT NOT NULL DEFAULT
'',`last` TEXT NOT NULL DEFAULT '',`user` VARCHAR(45) NOT NULL DEFAULT
'',`password` VARCHAR(45) NOT NULL DEFAULT '',PRIMARY KEY(`id`))");
// out.write("Login Table created sucessfully ");
// out.close();
// }
// } catch (SQLException ex) {
// System.err.println("" + ex.toString());
// }
// } catch (IOException e) {
// System.err.println("" + e.toString());
// }
// }

 public void getProperties() {

 try {
 Properties properties = new Properties();
 properties.load(new FileInputStream(
 "MySQL Server.properties"));
 pocket_money_calculator.MySQL_Options.txtUser.setText(
 properties.
 getProperty("user"));
 pocket_money_calculator.MySQL_Options.txtPassword.
 setText(
 properties.getProperty("password"));
 pocket_money_calculator.MySQL_Options.txtHost.setText(
 properties.
 getProperty("host"));
 pocket_money_calculator.MySQL_Options.txtPort.setText(
 properties.
 getProperty("port"));
 pocket_money_calculator.MySQL_Options.txtDatabase.
 setText(
 properties.getProperty("database"));
 } catch (IOException ex) {

 }
 }

 public void enterDatabase() {
 getProperties();
 try {
 String connectArguement = null;
 connectArguement = "jdbc:mysql://" + "" +

pocket_money_calculator.MySQL_Options.txtHost.
 getText() + "" +
 ":" + "" +

pocket_money_calculator.MySQL_Options.txtPort.
 getText() + "" +
 "/" + "" +
 pocket_money_calculator.MySQL_Options.
 txtDatabase.
 getText() + "" + "?user=" +
 "" +

pocket_money_calculator.MySQL_Options.txtUser.
 getText() + "" +
 "&password=" + "" +
 pocket_money_calculator.MySQL_Options.
 txtPassword.getText() + "";
 connection = DriverManager.getConnection(connectArguement);
 statusBar.setForeground(Color.green);
 statusBar.setText("Connected to MySQL Server");
 btnLogin.setEnabled(true);
 } catch (SQLException ex) {
 connected = false;
 System.err.println("" + ex.toString());
 statusBar.setForeground(Color.red);
 statusBar.setText("Unable to connect to Server");
 btnLogin.setEnabled(false);
 }
// checkLogin();
// checkUsers();
// checkAdministrator();

 }

 public void btnLogin_actionPerformed(ActionEvent e) {
 if (txtUser.getText().equals("Administrator")) {
 Administrator();
 } else {
 anotherUser();
 }
 }

 public void Administrator() {
 try {
 if (txtUser.getText().equals("Administrator")) {
 statement = connection.createStatement();
 resultSet = statement.executeQuery(
 "SELECT * FROM login where user='" +
 txtUser.getText() +
 "' and password='" + txtPassword.getText() +
 "'");
 resultSet.last();
 int r = resultSet.getRow();
 if (r > 0) {
 System.out.println("This is an administrator");
 dispose();
 Administrator dlg = new Administrator();
 Dimension dlgSize = dlg.getPreferredSize();
 Dimension frmSize = getSize();
 Point loc = getLocation();
 dlg.setLocation((frmSize.width - dlgSize.width) / 2
+
 loc.x,
 (frmSize.height - dlgSize.height) /
 2 +
 loc.y);
 dlg.pack();
 dlg.show();
 } else {
 System.out.println("Incorrect password");
 incorrectPassword dlg = new incorrectPassword();
 Dimension dlgSize = dlg.getPreferredSize();
 Dimension frmSize = getSize();
 Point loc = getLocation();
 dlg.setLocation((frmSize.width - dlgSize.width) / 2
+
 loc.x,
 (frmSize.height - dlgSize.height) /
 2 +
 loc.y);
 dlg.setModal(true);
 dlg.pack();
 dlg.show();

 }
 } else {
 System.out.println("Another User");
 anotherUser();
 }
 } catch (SQLException ex) {

 }
 }

 public void anotherUser() {
 enterDatabase();
 try {
 statement = connection.createStatement();
 resultSet = statement.executeQuery(
 "SELECT * FROM login where user='" +
 txtUser.getText() +
 "' and password='" + txtPassword.getText() +
 "'");
 resultSet.last();
 int r = resultSet.getRow();
 if (r > 0) {
 dispose();
 MainScreen dlg = new MainScreen();
 Dimension dlgSize = dlg.getPreferredSize();
 Dimension frmSize = getSize();
 Point loc = getLocation();
 dlg.setLocation((frmSize.width - dlgSize.width) / 2 +
 loc.x,
 (frmSize.height - dlgSize.height) /
 2 +
 loc.y);
 dlg.pack();
 dlg.show();
 } else {
 System.out.println("Incorrect password");
 incorrectPassword dlg = new incorrectPassword();
 Dimension dlgSize = dlg.getPreferredSize();
 Dimension frmSize = getSize();
 Point loc = getLocation();
 dlg.setLocation((frmSize.width - dlgSize.width) / 2 +
 loc.x,
 (frmSize.height - dlgSize.height) /
 2 +
 loc.y);
 dlg.setModal(true);
 dlg.pack();
 dlg.show();
 }
 } catch (SQLException ex) {

 }
 try {
 connection.close();
 System.out.println("Closing connection");
 }
 catch (SQLException ex)
 {
 System.err.println("Closing connection failed " +
ex.toString());
 }

 }

 public void btnEnterDatabase_actionPerformed(ActionEvent e) {
 enterDatabase();
 }

 public void btnCancel_actionPerformed(ActionEvent e) {
 dispose();
 }
}

class Login_btnCancel_actionAdapter implements ActionListener {
 private Login adaptee;
 Login_btnCancel_actionAdapter(Login adaptee) {
 this.adaptee = adaptee;
 }

 public void actionPerformed(ActionEvent e) {
 adaptee.btnCancel_actionPerformed(e);
 }
}

class Login_btnEnterDatabase_actionAdapter implements ActionListener {
 private Login adaptee;
 Login_btnEnterDatabase_actionAdapter(Login adaptee) {
 this.adaptee = adaptee;
 }

 public void actionPerformed(ActionEvent e) {
 adaptee.btnEnterDatabase_actionPerformed(e);
 }
}

class Login_btnLogin_actionAdapter implements ActionListener {
 private Login adaptee;
 Login_btnLogin_actionAdapter(Login adaptee) {
 this.adaptee = adaptee;
 }

 public void actionPerformed(ActionEvent e) {

 adaptee.btnLogin_actionPerformed(e);
 }
}

Thanm you very much for your help.