0

I'm having a hell of a time trying to make a login form.

This is what I have at the moment....

import javax.swing.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;

class LoginDemo extends JFrame{
 JButton SUBMIT;
 JLabel label1,label2;
 final JTextField  text1,text2;
  LoginDemo(){
    setTitle("Login Form");
    setLayout(null);
    label1 = new JLabel();
    label1.setText("Username:");
    text1 = new JTextField(15);

    label2 = new JLabel();
    label2.setText("Password:");
    text2 = new JPasswordField(15);

    SUBMIT=new JButton("SUBMIT");
    label1.setBounds(100,100,100,20);
    text1.setBounds(200,100,200,20);
    label2.setBounds(100,130,100,20);
    text2.setBounds(200,130,200,20);
    SUBMIT.setBounds(200,160,100,20);
   add(label1);
   add(text1);
   add(label2);
   add(text2);
   add(SUBMIT);

   setVisible(true);
   setSize(500,300);

 SUBMIT.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent e){
	
    String value1=text1.getText();
    String value2=text2.getText();
    try{
    	Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("select * from userInfo where username='"+value1+"' and password='"+value2+"'");
           int count=0;
           while(rs.next()){
               count++;
           }
          if(value1.equals("") && value2.equals("")) {
          JOptionPane.showMessageDialog(null,"Enter login name or password","Error",JOptionPane.ERROR_MESSAGE);
          }
          else if(count>0){
          System.out.println("Login Successful");
          page.setVisible(true);
          }
          else{
          text1.setText("");
          text2.setText("");
          System.out.println("Invalid Login name or password");
          }
    }
    catch(Exception e1){}
}
 });
  }
  public static void main(String arg[]){
  new LoginDemo();
}
}

When I hit my submit button, absolutely nothing happens...
Help?

Thanks

Edited by oldezwe: n/a

2
Contributors
4
Replies
8
Views
6 Years
Discussion Span
Last Post by JamesCherrill
0

The following line (line 63) is an absolute no-no when debugging

catch(Exception e1){}

if any problem of any kind happens in the preceding 22 lines you have just told Java to carry on as if nothing happened, and don't tell you anything.
Replace it with

catch(Exception e1){ e1.printStackTrace();}

and you'll probably get an error message that tells you exactly what went wrong.

0

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

This is the error.

What does this mean? and how do i fix it?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.