public class Main extends Application {
@Override
public void start(Stage primaryStage) {
try {
Parent root = FXMLLoader.load(getClass().getResource("view/Login.fxml"));
Scene scene = new Scene(root);
scene.getStylesheets().add(getClass().getResource("application.css").toExternalForm());
primaryStage.setScene(scene);
primaryStage.show();
} catch(Exception e) {
e.printStackTrace();
}
}

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

public class LoginController implements Initializable {
public LoginModel loginModel = new LoginModel();

@FXML
private Label isConnected;
@FXML
private TextField txtUsername;
@FXML
private TextField txtPassword;

@Override
public void initialize(URL location, ResourceBundle resources) {
// TODO Auto-generated method stub
if (loginModel.isDbConnected()) {
isConnected.setText("Connected");
} else {
isConnected.setText("Not Connected");
}
}
public void Login(ActionEvent event){
try {
if (loginModel.isLogin(txtUsername.getText(), txtPassword.getText())){
isConnected.setText("username and password is correct");
((Node)event.getSource()).getScene().getWindow().hide();
Stage primaryStage = new Stage();
FXMLLoader loader = new FXMLLoader();
Pane root = loader.load(getClass().getResource("view/test1.fxml").openStream());
CompanyMainController companyMainController = (CompanyMainController)loader.getController();
companyMainController.GetUser(txtUsername.getText());
Scene scene = new Scene(root);
scene.getStylesheets().add(getClass().getResource("application.css").toExternalForm());
primaryStage.setScene(scene);
primaryStage.show();
} else {
isConnected.setText("username and password is not correct");
}
} catch (SQLException e) {
isConnected.setText("username and password is not correct");
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}

public class CompanyMainController implements Initializable {
@FXML
private Label userLbl;
@Override
public void initialize(URL location, ResourceBundle resources) {
// TODO Auto-generated method stub

}

public void GetUser(String user) {
// TODO Auto-generated method stub
userLbl.setText(user);
}

public void SignOut(ActionEvent event) {
try {
((Node)event.getSource()).getScene().getWindow().hide();
Stage primaryStage = new Stage();
FXMLLoader loader = new FXMLLoader();
Pane root = loader.load(getClass().getResource("/application/Login.fxml").openStream());

Scene scene = new Scene(root);
scene.getStylesheets().add(getClass().getResource("application.css").toExternalForm());
primaryStage.setScene(scene);
primaryStage.show();
} catch (Exception e) {
// TODO: handle exception
}
}
}

public class LoginModel {
Connection conection;
public LoginModel () {
conection = SqliteConnection.Connector();

//*******************************if not conected all closes************************************
if (conection == null) {

System.out.println("connection not successful");
System.exit(1);}
}

public boolean isDbConnected() {
try {
return !conection.isClosed();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
}
public boolean isLogin(String user, String pass) throws SQLException {
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
// soo this one is searcing in db employee section for username and password
String query = "select * from employee where username = ? and password = ?";
try {
preparedStatement = conection.prepareStatement(query);
preparedStatement.setString(1, user);
preparedStatement.setString(2, pass);

resultSet = preparedStatement.executeQuery();
if (resultSet.next()) {
return true;
}
else {
return false;
}

} catch (Exception e) {
return false;
// TODO: handle exception
} finally {
preparedStatement.close();
resultSet.close();
}
}
}