public class Login {

	Connection con;
	Statement st;
	ResultSet rs;

	JFrame f = new JFrame("User Login");
	JLabel l = new JLabel("Username");
	JLabel l1 = new JLabel("Password");
	JTextField t = new JTextField(10);
	JTextField t1 = new JTextField(10);
	JButton b = new JButton("Login");

	public Login {
		connect();
		frame();

	}

	public void connect {

		try {

		String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
		Class.forName(driver);

		String db = "jdbc:odbc:DATENBANKNAME";
		con = DriverManager.getConnection(db);
		st = con.createStatement();

		}

		catch(Exception ex) {


		}
	}

	public void frame() {
		f.setSize(600,400);
		f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		f.setVisible(true);

		JPanel p = new JPanel();
		p.add(l);
		p.add(t):
		p.add(l1);
		p.add(t1);
		p.add(b);

		f.add(p);

		b.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {

				try {
				String user = t.getText().trim();
				String pass = t1.getTExt().trim();

				String sql = "select user,pass from TABLENAME where user = '" +user+"'and pass = '"+pass+"'";
				rs = st.executiveQuery(sql);

				int count = 0;
				while(rs.next()) {
					count = count + 1;
					}

				if(count == 1) {
					JOptionPane.showMessageDialog(null, "User wurde gefunden";
					}

				else if(count > 1) {
					JOptionPane.showMessageDialog(null, "User ist mehrmals vorhanden!");
				}

				else {
					JOptionPane.showMessageDialog(null, "User wurde nicht gefunden!);
				}

				}
				catch(Exception ex) {

				}

			}
		});

	}



	public static void main(String[] args) {
		new Login();
	}


}