title
Java Eclipse GUI Tutorial 3 # Database Connection ( Sqlite ) to Java Part 1 of 2

description
SQLite JDBC Driver https://bitbucket.org/xerial/sqlite-jdbc ★★★Top Online Courses From ProgrammingKnowledge ★★★ Python Programming Course ➡️ http://bit.ly/2vsuMaS ⚫️ http://bit.ly/2GOaeQB Java Programming Course ➡️ http://bit.ly/2GEfQMf ⚫️ http://bit.ly/2Vvjy4a Bash Shell Scripting Course ➡️ http://bit.ly/2DBVF0C ⚫️ http://bit.ly/2UM06vF Linux Command Line Tutorials ➡️ http://bit.ly/2IXuil0 ⚫️ http://bit.ly/2IXukt8 C Programming Course ➡️ http://bit.ly/2GQCiD1 ⚫️ http://bit.ly/2ZGN6ej C++ Programming Course ➡️ http://bit.ly/2V4oEVJ ⚫️ http://bit.ly/2XMvqMs PHP Programming Course ➡️ http://bit.ly/2XP71WH ⚫️ http://bit.ly/2vs3od6 Android Development Course ➡️ http://bit.ly/2UHih5H ⚫️ http://bit.ly/2IMhVci C# Programming Course ➡️ http://bit.ly/2Vr7HEl ⚫️ http://bit.ly/2W6RXTU JavaFx Programming Course ➡️ http://bit.ly/2XMvZWA ⚫️ http://bit.ly/2V2CoAi NodeJs Programming Course ➡️ http://bit.ly/2GPg7gA ⚫️ http://bit.ly/2GQYTQ2 Jenkins Course For Developers and DevOps ➡️ http://bit.ly/2Wd4l4W ⚫️ http://bit.ly/2J1B1ug Scala Programming Tutorial Course ➡️ http://bit.ly/2PysyA4 ⚫️ http://bit.ly/2PCaVj2 Bootstrap Responsive Web Design Tutorial ➡️ http://bit.ly/2DFQ2yC ⚫️ http://bit.ly/2VoJWwH MongoDB Tutorial Course ➡️ http://bit.ly/2LaCJfP ⚫️ http://bit.ly/2WaI7Ap QT C++ GUI Tutorial For Beginners ➡️ http://bit.ly/2vwqHSZ ★★★ Online Courses to learn ★★★ Get 2 FREE Months of Unlimited Classes from skillshare - https://skillshare.eqcm.net/r1KEj Data Science - http://bit.ly/2lD9h5L | http://bit.ly/2lI8wIl Machine Learning - http://bit.ly/2WGGQpb | http://bit.ly/2GghLXX Artificial Intelligence - http://bit.ly/2lYqaYx | http://bit.ly/2NmaPya MERN Stack E-Degree Program - http://bit.ly/2kx2NFe | http://bit.ly/2lWj4no DevOps E-degree - http://bit.ly/2k1PwUQ | http://bit.ly/2k8Ypfy Data Analytics with R - http://bit.ly/2lBKqz8 | http://bit.ly/2lAjos3 AWS Certification Training - http://bit.ly/2kmLtTu | http://bit.ly/2lAkQL1 Projects in Java - http://bit.ly/2kzn25d | http://bit.ly/2lBMffs Machine Learning With TensorFlow - http://bit.ly/2m1z3AF | http://bit.ly/2lBMhnA Angular 8 - Complete Essential Guide - http://bit.ly/2lYvYRP Kotlin Android Development Masterclass - http://bit.ly/2GcblsI Learn iOS Programming Building Advance Projects - http://bit.ly/2kyX7ue ★★★ Follow ★★★ My Website - http://www.codebind.com DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This help support the channel and allows us to continue to make videos like this. Thank you for the support! SQLite Java Tutorial How to connect SQLite with Java? Java JDBC using SQLite/Connecting java - Connect to SQLite database SQLite JDBC for Windows android database connection sqlite sqlite database connection string android sqlite database connection code java netbeans and MySQL or SQLite connecting to database Connecting to a MySQL Database in Java connecting to a database with java code Database Programming with JDBC and Java Trying to connect to mysql database via JDBC Connect to MySQL database from Java What is Jdbc and how you connect Java with database

detail
{'title': 'Java Eclipse GUI Tutorial 3 # Database Connection ( Sqlite ) to Java Part 1 of 2', 'heatmap': [{'end': 272.478, 'start': 248.381, 'weight': 0.729}, {'end': 354.295, 'start': 286.446, 'weight': 0.812}, {'end': 554.392, 'start': 543.945, 'weight': 0.841}], 'summary': 'Learn to build a small project in eclipse using java and window builder gui. understand the connection of a java application to an sqlite database, emphasizing serverless nature and transferability, along with creating tables, adding data, and creating a sqlite connection class.', 'chapters': [{'end': 60.618, 'segs': [{'end': 60.618, 'src': 'embed', 'start': 4.755, 'weight': 0, 'content': [{'end': 14.985, 'text': 'hello, guys, in the last couple of videos, I have been teaching you the basics of window builder GUI in eclipse using Java,', 'start': 4.755, 'duration': 10.23}, {'end': 30.476, 'text': 'and I have shown you some of the basic programs or basic concept of window builder GUI like this and how to use this window builder GUI in Eclipse using Java.', 'start': 14.985, 'duration': 15.491}, {'end': 42.141, 'text': "Now I want to build from this video a small little project so that I'm going to build this project and I'm going to teach.", 'start': 31.257, 'duration': 10.884}, {'end': 51.084, 'text': "I'm going to try to teach every tool or component we have in here by building that project.", 'start': 42.141, 'duration': 8.943}, {'end': 60.618, 'text': 'So in a way, you will build a project also and you will learn how to use these components or tools also.', 'start': 51.684, 'duration': 8.934}], 'summary': 'Teaching basics of window builder gui and building a small project in eclipse using java.', 'duration': 55.863, 'max_score': 4.755, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JuYb-VZaD1g/pics/JuYb-VZaD1g4755.jpg'}], 'start': 4.755, 'title': 'Window builder gui project tutorial', 'summary': 'Discusses building a small project in eclipse using java and window builder gui to provide hands-on learning experience, teaching every tool and component.', 'chapters': [{'end': 60.618, 'start': 4.755, 'title': 'Window builder gui project tutorial', 'summary': 'Discusses building a small project in eclipse using java and window builder gui to teach every tool and component, aiming to provide hands-on learning experience to the audience.', 'duration': 55.863, 'highlights': ['The tutorial focuses on building a small project in Eclipse using Java and Window Builder GUI, aiming to provide hands-on learning experience to the audience.', 'The instructor plans to teach every tool or component in the project, allowing the audience to learn and apply the concepts practically.', 'The chapter emphasizes practical learning by encouraging the audience to build the project and learn to use the components or tools involved.']}], 'duration': 55.863, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JuYb-VZaD1g/pics/JuYb-VZaD1g4755.jpg', 'highlights': ['The tutorial focuses on building a small project in Eclipse using Java and Window Builder GUI, aiming to provide hands-on learning experience to the audience.', 'The instructor plans to teach every tool or component in the project, allowing the audience to learn and apply the concepts practically.', 'The chapter emphasizes practical learning by encouraging the audience to build the project and learn to use the components or tools involved.']}, {'end': 433.772, 'segs': [{'end': 98.451, 'src': 'embed', 'start': 61.539, 'weight': 0, 'content': [{'end': 74.117, 'text': 'So, from this video, I am going to create connection to the database with this Java application.', 'start': 61.539, 'duration': 12.578}, {'end': 89.189, 'text': "so I'm going to use Escalite database for connection to this GUI which we are making in Java, and we are going to make a little login page, uh,", 'start': 74.117, 'duration': 15.072}, {'end': 91.29, 'text': 'in connection with this database.', 'start': 89.189, 'duration': 2.101}, {'end': 96.03, 'text': 'but first of all, i want to show you how you can create your database in escalite.', 'start': 91.29, 'duration': 4.74}, {'end': 98.451, 'text': 'escalite is a serverless database.', 'start': 96.03, 'duration': 2.421}], 'summary': 'Creating a database connection in java using escalite for a gui login page.', 'duration': 36.912, 'max_score': 61.539, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JuYb-VZaD1g/pics/JuYb-VZaD1g61539.jpg'}, {'end': 275, 'src': 'heatmap', 'start': 248.381, 'weight': 1, 'content': [{'end': 260.205, 'text': 'so click this add-ons here and search for the add-on called Escalite and press enter and you will find this Escalite manager 0.8..', 'start': 248.381, 'duration': 11.824}, {'end': 272.478, 'text': "1 it's free so just click install and will be installed in your Firefox browser as a plugin.", 'start': 260.205, 'duration': 12.273}, {'end': 275, 'text': 'Just restart your Firefox.', 'start': 273.159, 'duration': 1.841}], 'summary': 'Install escalite manager 0.8 for firefox, a free plugin.', 'duration': 102.962, 'max_score': 248.381, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JuYb-VZaD1g/pics/JuYb-VZaD1g248381.jpg'}, {'end': 354.295, 'src': 'heatmap', 'start': 286.446, 'weight': 0.812, 'content': [{'end': 294.033, 'text': 'so in the older version, the, it was really easier to find this SQLite manager by going to the top menu.', 'start': 286.446, 'duration': 7.587}, {'end': 299.838, 'text': 'but in this new Firefox you need to go to customize.', 'start': 294.033, 'duration': 5.805}, {'end': 307.26, 'text': 'so just click this customize here And in here you will be able to find your Escalite manager right?', 'start': 299.838, 'duration': 7.422}, {'end': 314.304, 'text': 'So just drag and drop this Escalite manager in this menu in here, okay?', 'start': 307.76, 'duration': 6.544}, {'end': 319.488, 'text': 'And you will be good to go and just exit customization.', 'start': 315.005, 'duration': 4.483}, {'end': 322.51, 'text': 'And now you will be able to see Escalite manager here.', 'start': 320.188, 'duration': 2.322}, {'end': 328.254, 'text': 'Just open this Escalite manager and we are ready to create our Escalite database.', 'start': 323.13, 'duration': 5.124}, {'end': 332.717, 'text': "It's really simple to make Escalite database in this Escalite manager.", 'start': 328.594, 'duration': 4.123}, {'end': 339.78, 'text': 'To create a new database, you can go here and say new database and give the name of the database.', 'start': 333.497, 'duration': 6.283}, {'end': 342.501, 'text': 'For example, I want to create a database for employees.', 'start': 339.82, 'duration': 2.681}, {'end': 354.295, 'text': 'So I will say employee, what we can say employee data database.', 'start': 343.002, 'duration': 11.293}], 'summary': "In the new firefox version, accessing sqlite manager requires customization, but once added, it's easy to create databases.", 'duration': 67.849, 'max_score': 286.446, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JuYb-VZaD1g/pics/JuYb-VZaD1g286446.jpg'}], 'start': 61.539, 'title': 'Java and firefox sqlite databases', 'summary': "Covers java application's connection to an sqlite database, emphasizing serverless nature and transferability, and also explains creating an sqlite database using firefox's sqlite manager, including add-on installation, database creation, and location specification.", 'chapters': [{'end': 124.113, 'start': 61.539, 'title': 'Java database connection and escalite basics', 'summary': 'Covers creating a connection to an escalite database in a java application, emphasizing its serverless nature and the process of creating a database, highlighting its transferability between computers without server connection worries.', 'duration': 62.574, 'highlights': ['Escalite is a serverless database, allowing easy transfer from one computer to another without needing a server connection.', 'The chapter demonstrates the process of creating a database in Escalite, highlighting its simplicity and ease of use.']}, {'end': 433.772, 'start': 124.313, 'title': 'Creating sqlite database in firefox', 'summary': "Explains how to create an sqlite database using firefox's sqlite manager, including finding and installing the add-on, creating a new database, and specifying its location.", 'duration': 309.459, 'highlights': ['Explained how to find and install the Escalite manager add-on in Firefox, including searching for the add-on, installing it, and restarting the browser.', 'Demonstrated the process of creating a new database in the Escalite manager within Firefox, specifying the database name and location for saving it.', 'Outlined the steps required to locate the Escalite manager in Firefox and customize the menu by dragging and dropping the manager to the desired location.', 'Detailed instructions on accessing tutorials for beginners on Escalite database via the Programming Knowledge YouTube channel and playlist.']}], 'duration': 372.233, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JuYb-VZaD1g/pics/JuYb-VZaD1g61539.jpg', 'highlights': ['Escalite is a serverless database, allowing easy transfer without a server connection.', 'Demonstrated the process of creating a new database in the Escalite manager within Firefox.', 'Explained how to find and install the Escalite manager add-on in Firefox.', 'Outlined the steps required to locate the Escalite manager in Firefox and customize the menu.', 'Detailed instructions on accessing tutorials for beginners on Escalite database via the Programming Knowledge YouTube channel.']}, {'end': 928.236, 'segs': [{'end': 468.348, 'src': 'embed', 'start': 433.772, 'weight': 0, 'content': [{'end': 445.422, 'text': 'okay, now, in order to add tables, you need to right click right now, whenever you create this database, it has zero tables.', 'start': 433.772, 'duration': 11.65}, {'end': 446.603, 'text': 'so you need to add tables.', 'start': 445.422, 'duration': 1.181}, {'end': 454.389, 'text': 'so just right click this tables here and click create table, and in here you can give create a table.', 'start': 446.603, 'duration': 7.786}, {'end': 468.348, 'text': 'so, for example, i name my table as employee info table and here i can make the column names.', 'start': 454.389, 'duration': 13.959}], 'summary': 'To add tables, right-click and create table in the database with zero tables.', 'duration': 34.576, 'max_score': 433.772, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JuYb-VZaD1g/pics/JuYb-VZaD1g433772.jpg'}, {'end': 595.58, 'src': 'heatmap', 'start': 543.945, 'weight': 1, 'content': [{'end': 546.066, 'text': 'I will click ok and click yes.', 'start': 543.945, 'duration': 2.121}, {'end': 554.392, 'text': 'So now I have one table created in the Escalite Manager and in this table I can add some data.', 'start': 546.707, 'duration': 7.685}, {'end': 565.019, 'text': 'So how to add data? You can just make it bigger and just go to the table and go to browse and search here.', 'start': 555.973, 'duration': 9.046}, {'end': 568.617, 'text': 'and to add some data.', 'start': 566.796, 'duration': 1.821}, {'end': 573.098, 'text': 'you can just go to add and, for example, employee id 1.', 'start': 568.617, 'duration': 4.481}, {'end': 583.402, 'text': 'name is mark, some surname, username, for example 1.', 'start': 573.098, 'duration': 10.304}, {'end': 586.383, 'text': 'you can give any username, password also.', 'start': 583.402, 'duration': 2.981}, {'end': 589.444, 'text': '1, for example, and age is 35, for example.', 'start': 586.383, 'duration': 3.061}, {'end': 594.439, 'text': 'ok, ok, so i have created.', 'start': 591.897, 'duration': 2.542}, {'end': 595.58, 'text': 'added one data.', 'start': 594.439, 'duration': 1.141}], 'summary': 'Created one table in escalite manager and added one data entry.', 'duration': 79.431, 'max_score': 543.945, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JuYb-VZaD1g/pics/JuYb-VZaD1g543945.jpg'}, {'end': 747.106, 'src': 'embed', 'start': 706.93, 'weight': 2, 'content': [{'end': 723.544, 'text': "click it and go to new and I'm going to add a class and this class I will call as Escalite connection class.", 'start': 706.93, 'duration': 16.614}, {'end': 731.311, 'text': 'so this class will help us to connect to the database and make sure this is not checked.', 'start': 723.544, 'duration': 7.767}, {'end': 734.154, 'text': 'public static void main is not checked.', 'start': 731.311, 'duration': 2.843}, {'end': 735.775, 'text': "it's unchecked.", 'start': 734.154, 'duration': 1.621}, {'end': 740.42, 'text': 'okay, so this method, this class, will not contain the main method.', 'start': 735.775, 'duration': 4.645}, {'end': 747.106, 'text': 'okay, this is our helper class and just click finish.', 'start': 740.42, 'duration': 6.686}], 'summary': 'Creating a new class named escaliteconnection to connect to the database.', 'duration': 40.176, 'max_score': 706.93, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JuYb-VZaD1g/pics/JuYb-VZaD1g706930.jpg'}], 'start': 433.772, 'title': 'Adding tables in database and creating sqlite connection class', 'summary': "Discusses adding tables in a database, creating columns, setting data types, and adding data, with an example of creating an 'employee info' table with two rows of data. it also demonstrates creating a new project named 'company'. additionally, it covers creating a helper class named escalite connection class to connect to a database, including adding imports, creating a method to return the connection, and implementing a try-catch block for exceptions.", 'chapters': [{'end': 706.93, 'start': 433.772, 'title': 'Adding tables in database', 'summary': "Discusses the process of adding tables in a database, creating columns, setting data types, adding data, and creating a new project, with an example of creating an 'employee info' table with two rows of data, demonstrating the process of creating a project named 'company'.", 'duration': 273.158, 'highlights': ["The process of adding tables in a database, creating columns, setting data types, and adding data is demonstrated with an example of creating an 'employee info' table with two rows of data, showcasing the process of creating a project named 'company'.", "The demonstration includes creating an 'employee info' table with specific column names such as eid, name, surname, username, password, and age, and setting their respective data types, where eid is specified as the primary key.", "The example showcases the addition of two rows of data into the 'employee info' table, with details such as employee id, name, surname, username, password, and age.", "The process of creating a new project named 'company' is illustrated, with details on creating a project folder, adding a class, and organizing the subfolders and libraries within the project."]}, {'end': 928.236, 'start': 706.93, 'title': 'Creating sqlite connection class', 'summary': 'Demonstrates how to create a helper class named escalite connection class to connect to a database, including the process of adding imports, creating a public static method to return the connection, and implementing a try-catch block for exceptions.', 'duration': 221.306, 'highlights': ['Creating a helper class named Escalite connection class to connect to the database The chapter explains the process of creating a helper class to establish a connection to the database, which does not contain the main method.', 'Adding necessary imports for database connection The tutorial covers the addition of java.sql.* and java x.swing imports to facilitate connection to the database.', "Creating a public static method to return the connection The chapter demonstrates the creation of a public static method named 'dbConnector' to return the connection, which does not require any arguments.", 'Implementing a try-catch block for exceptions The tutorial showcases the implementation of a try-catch block to handle exceptions during the database connection process.']}], 'duration': 494.464, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JuYb-VZaD1g/pics/JuYb-VZaD1g433772.jpg', 'highlights': ["The process of adding tables in a database, creating columns, setting data types, and adding data is demonstrated with an example of creating an 'employee info' table with two rows of data, showcasing the process of creating a project named 'company'.", "The demonstration includes creating an 'employee info' table with specific column names such as eid, name, surname, username, password, and age, and setting their respective data types, where eid is specified as the primary key.", 'Creating a helper class named Escalite connection class to connect to the database The chapter explains the process of creating a helper class to establish a connection to the database, which does not contain the main method.', "The example showcases the addition of two rows of data into the 'employee info' table, with details such as employee id, name, surname, username, password, and age."]}], 'highlights': ['The tutorial focuses on building a small project in Eclipse using Java and Window Builder GUI, aiming to provide hands-on learning experience to the audience.', "The process of adding tables in a database, creating columns, setting data types, and adding data is demonstrated with an example of creating an 'employee info' table with two rows of data, showcasing the process of creating a project named 'company'.", 'Escalite is a serverless database, allowing easy transfer without a server connection.', 'The instructor plans to teach every tool or component in the project, allowing the audience to learn and apply the concepts practically.']}