Java Project: Login and registration NetBeans with SQLite3 Database | Connect to database | Part 1

Sdílet
Vložit
  • čas přidán 16. 01. 2021
  • This project illustrates the steps needed for a NetBeans Java application to connect to a database.
    The project creates a USER LOGIN System and A RGISTRATION System.
    PART2: • Java Project: Login an...
    Steps:
    1 - Download Sqlite Studio
    2 - Download Jar file
    3 - set up environment and database connection
    4 - Design GUI
    5 - Add service code
    Other Projects:
    To be added.....
    how to insert data from NetBeans into a Database
    Insert information rows into SQLite database
    Insert Data Into Database Using Netbeans
    how to insert java.sql.data into database
    sql - Java Date - Insert into database
    How to Insert Data into a table in mysql database
    insert values in table,JDBC Insert Row
    JDBC program to insert data into mysql database from java netbeans
    java netbeans
    java tutorial netbeans
    Other videos:
    Video1: How to Install NetBeans with JDK Cobundle.
    www.youtube.com/watch?v=ctIiu....
    Video2: First Java application:
    • Java Video 2: First Ja... ​​
    Video3: Java Variables:
    www.youtube.com/watch?v=G2Gtp....
    Video4: Java Arithmetic Operators
    www.youtube.com/watch?v=zujQE....
    Video5: Java Relational (comparison) Operators:
    www.youtube.com/watch?v=W-l08....
    Video6: Java Logical Operators:
    www.youtube.com/watch?v=FK2_b....
    Video7: Java Scanner How to Input Data Part1
    • Java Video 7: Java Sca... ​​
    Video8: Java Scanner Part2 How to input from a text file and a web page
    • Java Video 8: Java Sca... ​​
    Video9: Java Methods :
    • Java Video 9: Java Met... ​​
    Video10: Java If statements :
    • Java Video 10: Decisio... ​​
    Video11: Java Switch case:
    • Java Video 11: Decisio... ​​
    Video12: Read and Write to a File:
    • Java Video 12: Read an... ​​
    Video13: For loop:
    • Java Video 13: For Loop ​​
    Video14: while loop:
    • Java Video 14: While Loop ​​
    Video15: do .... while loop:
    • Java Video 15: do whil... ​​
    Video 16 : One Dimensional Arrays:
    • Java Video 16: One Dim... ​
    Video 17 : Strings Part1:
    • Java Video 17: Java St... ​
    Video 18 : Strings Part2 : Functions
    • Java Video 18: String ... ​
    Java Video 19: Classes and Objects
    • Java Video 19: Classes...
    Java Video 20: Inheritance | Abstract | Overloading | Overriding
    • Java Video 20: Inherit...

Komentáře • 16

  • @prabhakaraadhik7377
    @prabhakaraadhik7377 Před 2 měsíci

    thank you so much, i was strugglingfor 3 days to solve the connection problems...😇

  • @elijahayodele173
    @elijahayodele173 Před rokem

    I'm grateful for this. Its working without any errors.

  • @nikhitah5602
    @nikhitah5602 Před 3 lety

    Thank you sir

  • @Ankitsingh-my1vu
    @Ankitsingh-my1vu Před 3 lety +1

    Can you please help me,i code in Eclipse i created database, made a connection class and login class, connection was also successful, but after that when i enter password and click login it says missing database no such table found , but i have created table, put it in project folder also

  • @mohamedredha9586
    @mohamedredha9586 Před 2 lety

    sir everything is fine except the log in , it doesn't work but there is no error message ( the exit button is working , the connection to the data base is working too except the log in)

  • @julesruzindana-rukundo6254

    HI, is DB browser and sqlitestudio equivalent in terms of functionnalities?thx

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

    It's possible to create an exe file with this method right? (with the database of course)

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

      For sure It is possible. Simply create a .jre file. You can also create a setup file.

  • @zeynephakgul
    @zeynephakgul Před 3 lety

    Hi, thanks for the video. My code compiles and runs but when I click button to login, I get an error of Error: Cannot invoke "org.sqlite.DB.prepare(org.sqlite.Stmt)" because "this.db" is null. I couldn't figure it out even though I did pretty much the same with this video. It connects with my db but still says it's null. Why do you think I get this error? Thanks.

    • @thecsrevelation
      @thecsrevelation  Před 3 lety

      Email me your code at arfaoui.salim@gmail.com I will take a look

    • @khanhleduy5860
      @khanhleduy5860 Před 2 lety

      i have the same error, how can i fix it

    • @zeynephakgul
      @zeynephakgul Před 2 lety

      @@khanhleduy5860 It was more than a year ago, I can't really remember all of it but as soon as I recall, I wrote close db and than tried to reach it which gives null error since db is already closed. Make sure you did not close db.

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

    hello

  • @ezekieljohndecipulo4061

    23:57 then this is the result how can i fix it ?
    Connection Failed java.lang.ClassNotFoundException: org.sqlite.JBDC
    i already installed the mysqlite jbdc

  • @mehdimehido2294
    @mehdimehido2294 Před rokem

    thank you sir