code1

public void actionPerformed(ActionEvent arg0) {
				 try
				     {
					   String login="select * from connection where Username=? and Password=?";
					   PreparedStatement prepare=myConn.prepareStatement(login);
					   prepare.setString (1,textFieldUsernameEnter.getText() );
					   prepare.setString (2,passwordFieldPasswordEnter.getText() );

					   ResultSet loginresult=prepare.executeQuery();
					   int count=0;
					   while(loginresult.next())
					   {
						   count=count+1;
					   }

					   if(count==1)
					   {
						   textFieldUsernameEnter.setText("");
						   passwordFieldPasswordEnter.setText("");
						   Employee_Account.setVisible(true);
						   Login.setVisible(false);
					   }

					   else if(count>1)
					   {
						   textFieldUsernameEnter.setText("");
						   passwordFieldPasswordEnter.setText("");
						   Manager_Account.setVisible(true);
						   Login.setVisible(false);
					   }

					   else
					   {
						   JOptionPane.showMessageDialog(null, "Username and/or password is not correct");
					   }

					   loginresult.close();
					   prepare.close();

				     }