JavaFX Tutorial | Login Screen with database connection (2021) 

Welcome to coding world! May sometimes frustrating but so rewarding once you've make it work!

You're Welcome! Thanks Karla. Enjoy and keep on coding!

Love to hear that!

You are welcome! Keep on coding!

Glad it helped!

Hey there Dragan, the main class should atleast have below. Ensure that your "login.fxml" is using the corresponding controller, you can check that in the FMXL or Scene Builder. ... public void start(Stage primaryStage) throws Exception{ Parent root = FXMLLoader.load(getClass().getResource("login.fxml")); primaryStage.setTitle("Hello World"); primaryStage.setScene(new Scene(root, 520, 400)); primaryStage.show(); }

You're welcome!

Hey John are you still having this issue? can you share your String here?

@@tookootek I'm not getting the issue now as I changed my code to be 'String verifyLogin = "SELECT username, password from User";' I think the issue was that it was looping through all the logins stored in the database and I hadn't coded it to stop after a successful hit.

@@JohnRehill good job! The thrill of debugging lives on! Keep it up my friend, you are in the right track.

Hello there! Scene Builder 19 has still have OnAction however please remember that not all objects has OnAction event i.e Button will have it while Label will not. As for Java version / Scenebuilder combination, you can use version that not too far off with each other. There is no universal rule against it except for reasons like potential compatibility issue. As for "Exception in Application start method", can you please check if your fxmlloader have the correct fxml.

@@tookootek I will check and let you know. I am really enjoying your vids. Ty for responding; I appreciate it.

@@tookootek bugs found; 1. I had used a “Label” for instead of “Button” for the “Login” ans “Cancel” buttons and thus that why 1. I could fine the “OnAction” in Scene Builder. Secondly, after correcting my error, I created duplicates of “cancelButton” in login.fxml which max my Application Crash giving me that error message. What a Noob. Great lesson in debugging.

@@mastershonobi110 Excellent work! Error is always very much welcome and I personally recommend to work with lots lots of them while they are free. Coding without error is usually good only on production releases but for learning, they are highly recommended whether intentionally done or not. It is part of good learning.

Hi, how do I have the components resize automatic using Scene Builder when I maximize the UI? How can I make it “auto size” when the UI is stretched?

Hello there my friend. Your code is having issue connecting to your database. Please ensure that the DB account you use is working with your local database.

Do you have a method or variable variable named isBlank? If it is a method, ensure you got the name right however if it is variable, ensure it was declared.

@@tookootek i used isempty instead it works but ill try to fix it thank you im trying to setup the database rn amazing video btw.

Thanks komang we all love you so much :***

Hi Tidus & Rod, You can add sort of "Role" field. One of the simplest is add a new boolean field, i.e isAdmin the value is just between true or false however you can also use string or number type, it totally depends on how many user you have and how much flexible you want it.

Using the "role" field, you can control what level of access the user will have or what functionality will going to be available

@@tookootek Thank you very very very much, helpfull !!!! :)

Check this if it can help you can as well share link ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QsTOAXAtdrM.html

tookootek 1 second ago Hello There Jakuzo! If you just got Invalid Login then this is good, you are able to connect to your DB and Table. The first we can do is try to "Hard Code" the login and password and try to run again. If that works then it means you might just have extra space in between concat either in Username or Password. You can revert back to username and password TextFields once you resolve the issue. Let me know, there are couple of things we can check what went wrong.

Hi Ankel, check your DatabaseConnection.java specifically check getConnection() method under DatabaseConnection class - the variables, login account and connection string you use. It might be just a a simple typo in one of them. ConnectDB is null error just telling you it got nothing from trying to establish that connection when you call getConnection().

did you find out how ? i'm struggrling to find out

Hello there Eoghan, IntelliJ IDEA is a good start for JavaFX using Maven, I don't have one yet but I am pretty sure there are coupe of videos that already tackle this. It should give you a good start

Hello S K! In the DatabaseConnection class, have you filled out the Username and password? if you did, please try to login directly to your database if you get the same error. Getting Access Denied error is excellent, it means you are halfway to successfully connecting. You were able to setup the correct connection string, you just need to have a proper account.

@@tookootek i found the mistake. i added a new user to the table UserAccount and tried to login with it. Then i used my root account and it worked!

Try to add something like this in the Log in button. Stage stage = (stage) logInButton.getScene().getWindow(); stage.close();

​@@tookootek But it closes without validating the username or account, so if I hit the login button it automatically closes even though the account is incorrect

Nevermind I fixed it, thanks by the way!

Hey bro! thanks for watching my video, it is in the works but not sure when I can complete and upload it as there is one or two videos ahead of it. But i am hoping soon.

@@tookootek please do a video about how to print a bill information on javafx with scene builder please i didn't find any tutorial on youtube about it

Thanks man for giving me a clue, I will let YT copyright management handle that. There are couple of them that copied my videos by trimming the start and end however YT algorithm is too smart to fall for that. By the way this login screen has another version. Either you saw the first version or the one that was copied and re-uploaded by someone. Happy Learning!

Check on this, you can share ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QsTOAXAtdrM.html

Who cares. Sharing is caring

Check on this, you can share if you love it ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QsTOAXAtdrM.html