JAVA - How To Create Login And Register Form With MySQL DataBase In Java Netbeans

Sdílet
Vložit
  • čas přidán 6. 05. 2018
  • Java Make SignIn And SignUp Form With MySQL DataBase
    The Design Part - • JAVA - How To Design L...
    source code: 1bestcsharp.blogspot.com/2018...
    ▶ Download All My Java Projects Source Code: bit.ly/JavaProjectsBundle
    ----------------- Check out my Java Projects! -------------------
    ▶ Inventory Management System - bit.ly/Java_Inventory
    ▶ Java Project For Beginners - • Java Project For Begin...
    ▶ Students Information System - bit.ly/Students_System
    ▶ Contacts Management System - bit.ly/Contact_Project
    ▶ Hotel Management System - bit.ly/JavaHotelSystem
    ▶ Real Estate Management System - bit.ly/Java__RealEstate
    ▶ Library Management System - bit.ly/Java_Library
    ▶ Car Rental Management System - bit.ly/3SaTl43
    ▶ All My Programming Projects Here - bit.ly/2HrU8hK
    ▶ My Source Code Store Here - bit.ly/2OsC0TU
    ----------------------- Projects Source Code Bundles -----------------------
    Java Projects Bundle - bit.ly/JavaProjectsBundle
    ------------------------- JAVA COURSE ----------------------------
    ▶ master Java core development step-by-step - bit.ly/2HXSuAn
    ------------------------- JAVA Projects Bundle ----------------------------
    ▶ Buy The Java Projects Source Code Bundle: bit.ly/JavaProjectsBundle
    --------------------------------------------------------------------
    visit our blog 1bestcsharp.blogspot.com/
    CONNECT WITH ME ONLINE / 1bestcsharpblog
    subscribe: goo.gl/nRjPKk
    programming projects with source code:
    1bestcsharp.blogspot.com/p/pro...
    C# And Java Programming Books
    1bestcsharp.blogspot.com/2015/...
    ********************************************************************
    in a previous java tutorial we did a login and register form design ( video link: • JAVA - How To Design L... ),
    and in this one will see how to connect the login and signup form with a mysql database
    to do that you need to download mysql connector, watch tutorial from here: • Java - How To Connect ...
    and add it to your project
    we will ceate a class (MyConnection) to connect our login and register forms with mysql database
    in the register form wi will create a function (checkUsername) to check if the username you want to register is already exists in the database table
    what we will check when the user click on the register button:
    - if the username jtextfield is empty
    - if the password jtextfield is empty
    - if the retype_password text is equal to the password text
    - if the username already exists in the database using the "checkUsername" function
    - if the jdatechooser is empty
    in the login fom it's simple;
    the user enter his login and password and click on the login button,
    and all we have to do is to check if a user with this username and password already exists on the database
    other videos:
    Create Login Form In Java With MySQL Database Part 1
    • Java - How To Create L...
    Java And MySQL - Populate JTable Depending On a JCombobox Value In Java
    • Java And MySQL - Popul...
    Connect Java To MySQL Database
    • Java - How To Connect ...
    Bind a JCombobox With Mysql Database Values
    • JAVA - How To Bind a J...
    Search Values From MySQL Database And Set It Into JTextfield
    • JAVA - How To Search V...
    bind jtable from mysql database in netbeans
    • java & mysql - how to ...
    Bind JTable From MySQL DataBase Using ArrayList
    • How To Bind JTable Fro...
    Populate JCombobox Depending On Another JCombobox
    • Java And MySQL - Popu...
    Populate JCombobox From MySQL With Key And Value
    • Java & MySQL - How To ...
    How To Use Stored Procedure In Java And MySQL
    • Java And MySQL - How T...
    Insert Update Delete Data In Database
    • JAVA & MySQL - How To ...
    How To Bind a HashMap From DataBase In Java
    • JAVA & MySQL - How To ...
    display Image From database To jtable
    • Java And MySQL - How T...
    share this video: • JAVA - How To Create L...

Komentáře • 133

  • @1BestCsharpblog
    @1BestCsharpblog  Před 4 lety +6

    Java Login and Register Form - czcams.com/video/3vauM7axnRs/video.html
    Java Menu Design - czcams.com/video/6Cm31H_zmvM/video.html
    Java Dashboard Design - czcams.com/video/dC66Nt_76kA/video.html

  • @user-of9um8eq7j
    @user-of9um8eq7j Před 2 lety +5

    You saved my life today. My lecturer didn't teach us this at all but put it on a POE for us to complete. It's my first year and l have to say your videos really helped me out

  • @hickimse3421
    @hickimse3421 Před 4 lety +11

    Some heroes don't wear capes, you are one of them buddy!

  • @euricocatumbela5789
    @euricocatumbela5789 Před 6 lety +2

    Thanks a lot... You really helped a lot

  • @yasirtariq4616
    @yasirtariq4616 Před 5 lety +1

    Man you are the best

  • @xegaihadgu3582
    @xegaihadgu3582 Před 5 lety +2

    thank you much bro... you saved my ass..!

  • @PankajThakur-if2gp
    @PankajThakur-if2gp Před 4 lety +1

    thanks, great work, it helped me a lot,keep it up

  • @mohammadezzeddine6651
    @mohammadezzeddine6651 Před rokem +2

    thanks a lot! very helpful
    literally saved me

  • @nitishajain1146
    @nitishajain1146 Před 5 lety +1

    Thankyou so much 👌

  • @bhanukavithanage4911
    @bhanukavithanage4911 Před 3 lety +3

    This was a very helpful video thank you very much for sharing stuff like these you're a life saver

  • @VinayKumar-xo7kq
    @VinayKumar-xo7kq Před 6 lety +1

    nice work bro

  • @newtonk7574
    @newtonk7574 Před 5 lety +1

    Bro, Nice Code you have here.... it has helped me Alot. Thanks

  • @raman6271
    @raman6271 Před 4 lety +3

    Great man 👍👍👍👍

  • @springmasti2019
    @springmasti2019 Před 5 lety +1

    Thank u so much brother
    By-Durgesh

  • @danielleclere9904
    @danielleclere9904 Před 5 lety +3

    Good video!

  • @user-ht8hm5gv8g
    @user-ht8hm5gv8g Před 5 lety +1

    thank you V.

  • @gabrielchavanon4981
    @gabrielchavanon4981 Před rokem +1

    Gros merci de la part de La France mon ami.

  • @riks324
    @riks324 Před 5 lety +1

    Thnx budy.....helped me a lot....

    • @bidhyasapkota2234
      @bidhyasapkota2234 Před 3 lety

      please help me in how to create mysql database , ....to complete this project ,.. because i got a error on this

  • @omarabomoeliq6040
    @omarabomoeliq6040 Před 6 lety +2

    nice work

  • @tuanduynguyen1500
    @tuanduynguyen1500 Před 5 lety +2

    So GOODDDDDDDDDDDDDDDDDDDDDDDDDDDD also your page is good too !!!!

  • @hubcreek6957
    @hubcreek6957 Před 2 lety +1

    Excelente!!!

  • @akashdeepbhattacharjee4017

    please show the making of database part in detail..otherwise it has no use !!!!!!!!!!!

  • @FADEDElement
    @FADEDElement Před 4 lety +1

    Is there any way to use this program on a different computer in terms of the database because as far as I know this is a local method and I really cant figure out how to do it to where no matter i bring the program it will work so please tell me what I need to do for this

  • @dzemilpazar
    @dzemilpazar Před 5 lety +3

    PreparedStatement ps; variable when use it in ps = MyConnection.getConnection().preparedStatement(query); i get CreateClass MyConnection... does this class exist but im not inport it or i just missundestand something from this video 12:19 ??

  • @Robertkingz
    @Robertkingz Před 4 lety +1

    It Worked! Thanks!

  • @rupertacuesta
    @rupertacuesta Před 5 lety +10

    You didnt explain how to make an mysql database, looking at how to make a design for the login and register is good. But why would you make that tutorial without showing how to store the data? Genuinely dont understand that.

  • @nikhilkhariya8247
    @nikhilkhariya8247 Před 6 lety +6

    i m having an error in my Prepared statement line, in get connection()

  • @asiyakhan9384
    @asiyakhan9384 Před 5 lety +10

    Hey man! your videos are amazingly helpful, but it would be much more better if you explain what you are doing rather than silence... :/

  • @jasrajjuneja3253
    @jasrajjuneja3253 Před 5 lety +1

    thanks

  • @chrisony9341
    @chrisony9341 Před 5 lety

    Nice video but no sound to let us know some of the terminologies used

  • @chilli3672
    @chilli3672 Před 3 lety

    Thank you 😭❤️

  • @user-bu8mg7uq3s
    @user-bu8mg7uq3s Před rokem +1

    thank you so much

  • @hermanomonya9945
    @hermanomonya9945 Před 6 lety +1

    Hello my IDE gives an error during runtime "Unsupported major.minor version 52.0" please advice

  • @ralucosma3076
    @ralucosma3076 Před 6 lety

    Hello. I have a problem. In phpmyadmin at u_date I can't put NULL. I selected NULL button and when I go back at structure atu null column says YES , but at column Default says None. And it should be NULL as well. Can you help me fix this ? thank you.

  • @karthinaguleswaran9224
    @karthinaguleswaran9224 Před 5 lety +1

    Hi, this works but the only problem is that I can login to an account even if the casing of the letters are different. For example i can login if username is "ADMIN" but on database it is "admin". What am i doing wrong?

  • @smartjoe6974
    @smartjoe6974 Před 4 lety +2

    This is wow

  • @ruturajnikam5206
    @ruturajnikam5206 Před 5 lety +1

    You are Gold. :)

    • @trailerhub4476
      @trailerhub4476 Před 5 lety

      do you receive a download link? can you send it to me? i didn't receive a link.

    • @1BestCsharpblog
      @1BestCsharpblog  Před 5 lety

      check your spam folder or re-donwload it

    • @trailerhub4476
      @trailerhub4476 Před 5 lety

      @@1BestCsharpblog Thank you brother!!!

  • @amazing188
    @amazing188 Před 5 lety +1

    Nice Video
    #knowledgeinflow

  • @shafiqeakhtar6687
    @shafiqeakhtar6687 Před 4 lety +1

    During final step user and pass..error sqlEx index out of range(1> WHOSE IS 0)
    Why this error.. Can u suggest and correct me

  • @clairjacob8908
    @clairjacob8908 Před 4 lety +3

    would be more helpful if you explain everything

  • @SauravKumar-fe6jr
    @SauravKumar-fe6jr Před 4 lety

    Phpmyadmin setup par vedio banao plz

  • @erict6156
    @erict6156 Před 3 lety

    How do you transition from the login window to the register window after clicking the create new account button?

  • @senorvc8534
    @senorvc8534 Před 6 lety

    and my localhost/phpmyadmin doesnt get reflected at all... it is as it, no data is added to it
    please help me

  • @sarveshmore4756
    @sarveshmore4756 Před 6 lety +3

    So my if and else statement aren't working in loginform and no matter what i enter in login it does incorrect username and password

  • @vanishreetalewad3516
    @vanishreetalewad3516 Před 3 lety +1

    Hi sir
    Send the program using java or html

  • @1navaneet
    @1navaneet Před 6 lety

    make a video for home.when you make this videos.

  • @fathonynur8528
    @fathonynur8528 Před 6 lety +6

    sir i have some problem to connect my db like
    "com.mysql.jdbc.Driver
    Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException"
    can you help me?

  • @euricocatumbela5789
    @euricocatumbela5789 Před 6 lety

    I followed all your procedures but I'm having Link failure could you explain to me please

  • @dianthus1666
    @dianthus1666 Před 3 lety

    How to create exe file if i have mysql database with xampp server? Pls help me

  • @harrirnaima9969
    @harrirnaima9969 Před 5 lety

    Thank you sir for this video , can you tell us how to add the "the forget password" button ??

    • @Isho242
      @Isho242 Před 5 lety

      all write
      please help us sir

  • @Reaper-lh4yq
    @Reaper-lh4yq Před 2 lety +1

    You didnt explain how to make an mysql database, looking at how to make a design for the login and register is good. But why would you make that tutorial without showing how to store the data? Genuinely dont understand that. (2)

  • @0xNETCAT
    @0xNETCAT Před 5 lety +1

    dont forget to make the form draggable..
    code in netbeans:
    assuming you are in the source code of the Jform.
    int pX, pY;
    //global vars
    //make the upper (orange) panel event mouse pressed.
    private void jPanel1MousePressed(java.awt.event.MouseEvent evt) {
    // Get x,y and store them
    pX = evt.getX();
    pY = evt.getY();
    }
    //make the upper panel event mouse dragged.
    private void jPanel1MouseDragged(java.awt.event.MouseEvent evt) {
    this.setLocation(this.getLocation().x + evt.getX() - pX,
    this.getLocation().y + evt.getY() - pY);
    }
    now you can move your window :)

  • @annakarenina9600
    @annakarenina9600 Před 4 lety

    hi, i try to do the same coding as you but i got the com.mysql.jdbc.Driver
    Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException eror, please help me to solve this

    • @vinnaeyshnair4281
      @vinnaeyshnair4281 Před 3 lety

      Hi , I got the same error too. Did you find a solution to it because I need help

  • @iimsleeepy
    @iimsleeepy Před 3 lety +1

    is there someway to contact you? i really need help

  • @girraj1093
    @girraj1093 Před 6 lety

    How can I add any thing in jcombobox

  • @sivakumar-gm9vv
    @sivakumar-gm9vv Před 5 lety

    Pls help me sql execution update erorr will appear

  • @AscendingPilot
    @AscendingPilot Před 5 lety

    So how do you install php and sql and get that all installed and working then?

    • @xxthenotoriousvxx
      @xxthenotoriousvxx Před 5 lety

      You could use WAMP Pro to set almost everything up for you but this would cost about $190 for the software. I would highly recommend downloading XAMPP which does the same thing for free. It comes with an MySQL server and sets the ports for you. Once everything is downloaded and your servers are started (apache and mysql) type "localhost" or "localhost:(your port number you set in the apache configuration)" into your browser to get to the xampp homepage and phpmyadmin will be in the top right tab. Clicking on this should get you going.

  • @johnpaulsantiago2034
    @johnpaulsantiago2034 Před 3 lety

    I am facing a problem when I try to add a new user into the database it says, "Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because the return value of "MyConnection.getConnection()" is null". I've been finding the error since the last day and up until now, I can't seem to fix it.
    Can somebody help me? I am still an IT student that's why I still have difficulty with this.

  • @77nu43
    @77nu43 Před 6 lety

    where is the part when you make a verification of username if it is already existed there. i mean if you input a username but someone already created the same username. help me please.

  • @bellshi_
    @bellshi_ Před 2 lety

    It is good tutorial but just got lazy to edit the video to cut the wrong step.

  • @kailashmodi298
    @kailashmodi298 Před 4 lety

    Getting error how i can contact u plz tekk

  • @kailashmodi298
    @kailashmodi298 Před 4 lety

    What is that localhost part

  • @abulbasarpias
    @abulbasarpias Před 4 lety

    good, but why there is no sound?

  • @nikhilkundu6138
    @nikhilkundu6138 Před 4 lety +1

    How did you set up PHPmyAdmin on the computer? I don't know how to set it up.

    • @1BestCsharpblog
      @1BestCsharpblog  Před 4 lety

      open xampp
      start apach and mysql
      go to localhost/phpmyadmin

  • @giordanotubeo8778
    @giordanotubeo8778 Před 5 lety

    Thanks a lot, but how to get the symbol .getDate() ??? .getDateFormat() is the only one appears!
    thanks

  • @girraj1093
    @girraj1093 Před 6 lety

    How can I add images to jlabel in java

  • @i4_04dikshapatil6
    @i4_04dikshapatil6 Před 3 lety

    i am getting error
    cannot find symbol
    symbol: method prepareStatement(String)
    location: class Object
    please help sir

  • @sebastianariastay6235
    @sebastianariastay6235 Před 6 lety +1

    Are you God? :V

  • @Black-xy4pj
    @Black-xy4pj Před rokem

    why didn't you show how to create the project folder...

    • @1BestCsharpblog
      @1BestCsharpblog  Před rokem

      watch the first part - czcams.com/video/XAowXcmQ-kA/video.html

  • @sanjukoujalagi5800
    @sanjukoujalagi5800 Před 5 lety

    no audio...only video

  • @elikarlcalma4201
    @elikarlcalma4201 Před 5 lety +2

    I have a problem in Prepared Statement please someone help me

    • @vinnaeyshnair4281
      @vinnaeyshnair4281 Před 3 lety

      Same . I keep getting a null exception there > Did you manage to solve it ?

  • @megetube3584
    @megetube3584 Před 5 lety

    video kana hojjachu keessanif bayyee galatooma

  • @tienayihabeley6549
    @tienayihabeley6549 Před 5 lety

    no sound

  • @kashmir398
    @kashmir398 Před 5 lety

    i tried this code to connect to my database. but i cant seem to get the connection.

    • @kashmir398
      @kashmir398 Před 5 lety

      Anyone else with this problem ?
      It may be a careless mistake of my own while coding. Ive spent days looking at it and still cant get it right

    • @1BestCsharpblog
      @1BestCsharpblog  Před 5 lety +1

      did you added the mysql connector jar file to your project ?

    • @kashmir398
      @kashmir398 Před 5 lety

      @@1BestCsharpblog Yes sir I did. Downloaded and added the jar file into the library. however, it shows .jar at the end unlike yours in the video which shows -bin.jar not sure if this could be the issue but....

    • @1BestCsharpblog
      @1BestCsharpblog  Před 5 lety +1

      if you can't figure out what's the problem, get the source code form the link in the description

    • @kashmir398
      @kashmir398 Před 5 lety +1

      @@1BestCsharpblog Okay will do :)

  • @exceling3820
    @exceling3820 Před 4 lety

    video has no sound

  • @sheharyarali4505
    @sheharyarali4505 Před 4 lety

    no sound ..

  • @kashmir398
    @kashmir398 Před 5 lety

    Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
    anyone else having this error ?

    • @hug00l
      @hug00l Před 5 lety +1

      Did you find the solution?? Im having the same problem :(

    • @kashmir398
      @kashmir398 Před 5 lety

      @@hug00l check your coding part where you insert sql query. There might be an extra '?' or lesser than the text fields you want to getText from

    • @vinnaeyshnair4281
      @vinnaeyshnair4281 Před 3 lety

      @@kashmir398 I checked mine and everything was okay . Im not sure why i still have the error

  • @DeepakLalchandaniProfile

    No audio

  • @dispydanio8372
    @dispydanio8372 Před 5 lety

    dat filmpje is kort

  • @tanvigurav928
    @tanvigurav928 Před 3 lety

    I am getting an NullPointerException error

  • @feather3006
    @feather3006 Před 3 lety

    Without audio ...seriously?

  • @zahralotfi9818
    @zahralotfi9818 Před 5 lety

    No sound!!!!

  • @senapoochyful
    @senapoochyful Před 3 lety

    ..

  • @iceman340h
    @iceman340h Před 5 lety

    get up with the times speak, I stopped watch 3 seconds in