title
16.2 Java Database Connectivity Practical

description
Java Simplified LiveCourse : https://bit.ly/java-pro-telusko Advance Java with Spring Boot Live Course : https://bit.ly/adv-java-telusko Complete java developer Course : https://bit.ly/complete-java Coupon Code: TELUSKO10 (10% off) For More Queries WhatsApp or Call on : +919008963671 website : https://courses.telusko.com/ Instagram : https://www.instagram.com/navinreddyofficial/ Linkedin : https://in.linkedin.com/in/navinreddy20 TELUSKO Android App : https://bit.ly/TeluskoApp this video tells about steps to follow for connecting java program to mysql database. Java JDBC is a java API to connect and execute query with the database. JDBC API uses jdbc drivers to connect with the database. 7 Steps to Connect Application to database 1)Import the package 2)Load and Register driver 3)Create Connection 4)Create Statement 5)Execute the query 6)process the results 7)close connection Editing Monitors : https://amzn.to/2RfKWgL https://amzn.to/2Q665JW https://amzn.to/2OUP21a. Editing Laptop : ASUS ROG Strix - (new version) https://amzn.to/2RhumwO Camera : https://amzn.to/2OR56AV lens : https://amzn.to/2JihtQo Mics https://amzn.to/2RlIe9F https://amzn.to/2yDkx5F Java:- https://bit.ly/JavaUdemyTelusko Spring:- https://bit.ly/SpringUdemyTelusko More Learning : Java :- https://bit.ly/3x6rr0N Python :- https://bit.ly/3GRc7JX Django :- https://bit.ly/3MmoJK6 JavaScript :- https://bit.ly/3tiAlHo Node JS :- https://bit.ly/3GT4liq Rest Api :-https://bit.ly/3MjhZwt Servlet :- https://bit.ly/3Q7eA7k Spring Framework :- https://bit.ly/3xi7buh Design Patterns in Java :- https://bit.ly/3MocXiq Docker :- https://bit.ly/3xjWzLA Blockchain Tutorial :- https://bit.ly/3NSbOkc Corda Tutorial:- https://bit.ly/3thbUKa Hyperledger Fabric :- https://bit.ly/38RZCRB NoSQL Tutorial :- https://bit.ly/3aJpRuc Mysql Tutorial :- https://bit.ly/3thpr4L Data Structures using Java :- https://bit.ly/3MuJa7S Git Tutorial :- https://bit.ly/3NXyCPu Donation: PayPal Id : navinreddy20 https://www.telusko.com

detail
{'title': '16.2 Java Database Connectivity Practical', 'heatmap': [{'end': 308.122, 'start': 280.266, 'weight': 1}], 'summary': 'Covers practical implementation of java database connectivity, including 7 steps to connect a java application with a database, types of drivers used, setting up jdbc in eclipse, understanding jdbc connection, database setup, mysql usage, working with mysql database in java, and jdbc connection, providing detailed step-by-step guides and emphasizing mysql usage.', 'chapters': [{'end': 260.516, 'segs': [{'end': 73.779, 'src': 'embed', 'start': 48.033, 'weight': 0, 'content': [{'end': 56.095, 'text': 'If you follow the seven steps, it is very easy for you to connect your Java application with database and you can fetch whatever values you want.', 'start': 48.033, 'duration': 8.062}, {'end': 61.096, 'text': 'You can insert values, you can fetch values, you can modify values, you can do all those stuff right?', 'start': 56.695, 'duration': 4.401}, {'end': 64.376, 'text': 'So the first step here is to import the package.', 'start': 62.016, 'duration': 2.36}, {'end': 69.078, 'text': 'The second step will be to load and register driver.', 'start': 64.657, 'duration': 4.421}, {'end': 70.138, 'text': 'So that is register.', 'start': 69.098, 'duration': 1.04}, {'end': 73.779, 'text': 'the driver right.', 'start': 71.678, 'duration': 2.101}], 'summary': '7 steps to connect java app with database for easy value manipulation', 'duration': 25.746, 'max_score': 48.033, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg48033.jpg'}, {'end': 235.07, 'src': 'embed', 'start': 132.458, 'weight': 1, 'content': [{'end': 142.221, 'text': "so let's say if you are working with MS access, so you have to work with JDBC one driver or JDBC type one driver, which is JDBC ODBC bridge.", 'start': 132.458, 'duration': 9.763}, {'end': 144.622, 'text': 'the problem is with the advance.', 'start': 142.221, 'duration': 2.401}, {'end': 148.883, 'text': "the new version of Java doesn't support ODBC.", 'start': 144.622, 'duration': 4.261}, {'end': 153.405, 'text': 'so now we cannot use ODBC feature using Java 7 or Java 8.', 'start': 148.883, 'duration': 4.522}, {'end': 159.591, 'text': 'so we need to go with the specific type of drivers for the specific type of DBMS.', 'start': 153.405, 'duration': 6.186}, {'end': 163.395, 'text': "so let's say, if you are working with oracle, we need to go with oracle driver.", 'start': 159.591, 'duration': 3.804}, {'end': 167.458, 'text': 'so if you are working with mysql, you have to go with mysql driver.', 'start': 163.395, 'duration': 4.063}, {'end': 171.722, 'text': 'in this example, we will try to connect our gem application with mysql.', 'start': 167.458, 'duration': 4.264}, {'end': 174.265, 'text': 'so for that we need to use mysql driver.', 'start': 171.722, 'duration': 2.543}, {'end': 176.577, 'text': 'now, how to connect mysql driver?', 'start': 174.975, 'duration': 1.602}, {'end': 179.68, 'text': 'so first you have to load the driver.', 'start': 176.577, 'duration': 3.103}, {'end': 186.207, 'text': 'so the driver is com.mysql.jdbc.driver.', 'start': 179.68, 'duration': 6.527}, {'end': 192.934, 'text': 'so we need to load this class as driver which belongs to a package which is com.mysql.jdbc.', 'start': 186.207, 'duration': 6.727}, {'end': 197.73, 'text': 'but the problem is it is not there in your system by default.', 'start': 194.426, 'duration': 3.304}, {'end': 201.054, 'text': 'okay, you will not find this in your uh, eclipse.', 'start': 197.73, 'duration': 3.324}, {'end': 206.16, 'text': 'by default, if you are using netbeans, well and good, we have this driver inbuilt.', 'start': 201.054, 'duration': 5.106}, {'end': 211.154, 'text': 'but if you are using eclipse, you have to download this, this thing, from internet.', 'start': 206.16, 'duration': 4.994}, {'end': 215.997, 'text': 'you just have to search for MySQL connector jar.', 'start': 211.154, 'duration': 4.843}, {'end': 219.599, 'text': 'so you have to search for this statement MySQL connector jar.', 'start': 215.997, 'duration': 3.602}, {'end': 223.522, 'text': 'and the best place to download anything is maven repository.', 'start': 219.599, 'duration': 3.923}, {'end': 230.287, 'text': "so if you don't know about maven, maven is just a global repository where you will have all the libraries available.", 'start': 223.522, 'duration': 6.765}, {'end': 232.548, 'text': "doesn't matter which java framework you work with.", 'start': 230.287, 'duration': 2.261}, {'end': 235.07, 'text': 'you have library there.', 'start': 232.548, 'duration': 2.522}], 'summary': 'Java 7 and 8 do not support odbc, specific drivers needed for dbms, mysql driver can be downloaded from maven repository', 'duration': 102.612, 'max_score': 132.458, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg132458.jpg'}], 'start': 1.215, 'title': 'Java database connectivity and gem application with mysql', 'summary': 'Covers the practical implementation of java database connectivity, including the seven steps to connect a java application with a database and types of drivers used. it also discusses connecting a gem application with mysql, highlighting the process, the need for a mysql driver, and accessing the mysql connector jar from maven repository.', 'chapters': [{'end': 159.591, 'start': 1.215, 'title': 'Java database connectivity', 'summary': 'Discusses the practical implementation of java database connectivity, emphasizing the seven steps to connect a java application with a database and the types of drivers used, highlighting the limitations of using jdbc odbc bridge with newer versions of java.', 'duration': 158.376, 'highlights': ['To connect a Java application with a database, one needs to follow seven steps, including importing the package, loading and registering the driver, creating a connection, creating a statement, executing the query, processing the results, and closing the connection.', 'Working with JDBC involves understanding the four types of drivers, such as JDBC type one driver (JDBC ODBC bridge) for MS Access, but newer versions of Java do not support ODBC, necessitating the use of specific drivers for different types of DBMS.']}, {'end': 260.516, 'start': 159.591, 'title': 'Connecting gem application with mysql', 'summary': 'Discusses the process of connecting a gem application with mysql, including the need for a mysql driver, the process of loading the driver, and accessing the mysql connector jar from maven repository.', 'duration': 100.925, 'highlights': ['The process involves the need to use a MySQL driver when working with a Gem application, specifically the com.mysql.jdbc.driver.', 'It is essential to load the com.mysql.jdbc.driver class as the driver, which may not be available by default in Eclipse and needs to be downloaded from the internet, particularly from the Maven repository.', 'The Maven repository is recommended as the best place to download the MySQL connector jar, providing access to various versions of the connector for use in the application.']}], 'duration': 259.301, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg1215.jpg', 'highlights': ['To connect a Java application with a database, follow seven steps: import package, load/register driver, create connection, create statement, execute query, process results, close connection.', 'Understanding the four types of JDBC drivers is essential for working with JDBC, including the JDBC type one driver for MS Access and specific drivers for different DBMS.', 'When working with a Gem application, it is necessary to use the com.mysql.jdbc.driver for MySQL.', 'Loading the com.mysql.jdbc.driver class may not be available by default in Eclipse and needs to be downloaded from the internet, particularly from the Maven repository.', 'The Maven repository is the recommended place to download the MySQL connector jar, providing access to various versions of the connector for application use.']}, {'end': 415.535, 'segs': [{'end': 313.244, 'src': 'heatmap', 'start': 260.516, 'weight': 1, 'content': [{'end': 264.878, 'text': 'okay, and we can just click on download here and you can see it is getting downloaded.', 'start': 260.516, 'duration': 4.362}, {'end': 269.617, 'text': 'so we have a file of approximately 1 MB.', 'start': 264.878, 'duration': 4.739}, {'end': 272.459, 'text': "okay, now let's go back to Eclipse.", 'start': 269.617, 'duration': 2.842}, {'end': 274.02, 'text': 'so we need to load this driver.', 'start': 272.459, 'duration': 1.561}, {'end': 275.522, 'text': 'okay, so we have to load and register driver.', 'start': 274.02, 'duration': 1.502}, {'end': 280.266, 'text': 'so when you want to work with external jar files, we need to add that jar file here.', 'start': 275.522, 'duration': 4.744}, {'end': 282.588, 'text': 'okay, so you can see we have already added that.', 'start': 280.266, 'duration': 2.322}, {'end': 285.951, 'text': 'let me show you how to this steps to how to add that.', 'start': 282.588, 'duration': 3.363}, {'end': 290.335, 'text': 'just right, click on your project and go to build path.', 'start': 285.951, 'duration': 4.384}, {'end': 293.645, 'text': 'configure build path here.', 'start': 290.335, 'duration': 3.31}, {'end': 296.709, 'text': 'let me remove this and i will show you how to add it once again.', 'start': 293.645, 'duration': 3.064}, {'end': 299.472, 'text': 'just click on add external jar.', 'start': 296.709, 'duration': 2.763}, {'end': 304.237, 'text': 'and so i have that file in my downloads folder.', 'start': 299.472, 'duration': 4.765}, {'end': 308.122, 'text': "okay, so that's downloads and you can select this file here and click on open.", 'start': 304.237, 'duration': 3.885}, {'end': 313.244, 'text': 'so you can see we got our jar file here and click on ok.', 'start': 308.902, 'duration': 4.342}], 'summary': 'Demonstration of downloading and adding a 1 mb jar file in eclipse.', 'duration': 52.728, 'max_score': 260.516, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg260516.jpg'}, {'end': 365.955, 'src': 'embed', 'start': 308.902, 'weight': 0, 'content': [{'end': 313.244, 'text': 'so you can see we got our jar file here and click on ok.', 'start': 308.902, 'duration': 4.342}, {'end': 320.206, 'text': "so, once you have imported that file, we need to load and register how to do that we'll see.", 'start': 313.244, 'duration': 6.962}, {'end': 322.167, 'text': 'then we have to create connection object,', 'start': 320.206, 'duration': 1.961}, {'end': 331.351, 'text': 'so we have to create the object of connection interface and then we need to create object of statement interface.', 'start': 322.167, 'duration': 9.184}, {'end': 338.11, 'text': 'then we have to execute the query and then we have to process the results again.', 'start': 331.351, 'duration': 6.759}, {'end': 339.991, 'text': 'then we have to close the connection.', 'start': 338.11, 'duration': 1.881}, {'end': 341.432, 'text': "so let's start with the first step.", 'start': 339.991, 'duration': 1.441}, {'end': 346.235, 'text': 'the first step is you have to import the package right now.', 'start': 341.432, 'duration': 4.803}, {'end': 349.056, 'text': 'which package to import?', 'start': 346.235, 'duration': 2.821}, {'end': 353.139, 'text': 'so this is let me write this the first line itself.', 'start': 349.056, 'duration': 4.083}, {'end': 364.334, 'text': 'so we write here the import statement, which is import java.sql dot star, because we want all the interfaces and classes.', 'start': 353.139, 'duration': 11.195}, {'end': 365.955, 'text': "so that's the first step.", 'start': 364.334, 'duration': 1.621}], 'summary': 'Import java.sql.*, create connection and execute query to process results.', 'duration': 57.053, 'max_score': 308.902, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg308902.jpg'}, {'end': 415.535, 'src': 'embed', 'start': 390.951, 'weight': 2, 'content': [{'end': 398.074, 'text': 'okay, once you specify driver, this class.fordname is responsible to load the driver for you.', 'start': 390.951, 'duration': 7.123}, {'end': 399.714, 'text': 'you just need to make sure that you have.', 'start': 398.074, 'duration': 1.64}, {'end': 405.696, 'text': "you're throwing the exception here because this fordname method will.", 'start': 399.714, 'duration': 5.982}, {'end': 406.276, 'text': "it's a.", 'start': 405.696, 'duration': 0.58}, {'end': 408.037, 'text': 'it will throw the checked exception.', 'start': 406.276, 'duration': 1.761}, {'end': 411.378, 'text': 'so you have to do here through those exception, or you can.', 'start': 408.037, 'duration': 3.341}, {'end': 415.535, 'text': 'either we can also use try catch, but the problem is this driver.', 'start': 411.378, 'duration': 4.157}], 'summary': 'The class.fordname loads the driver and throws a checked exception, requiring exception handling.', 'duration': 24.584, 'max_score': 390.951, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg390951.jpg'}], 'start': 260.516, 'title': 'Setting up jdbc in eclipse', 'summary': 'Demonstrates the process of setting up jdbc in eclipse, including downloading a 1 mb file, adding an external jar file, and importing java.sql package, with a detailed step-by-step guide on loading and registering the driver, creating connection and statement objects, executing queries, and closing the connection.', 'chapters': [{'end': 415.535, 'start': 260.516, 'title': 'Setting up jdbc in eclipse', 'summary': 'Demonstrates the process of setting up jdbc in eclipse, including downloading a 1 mb file, adding an external jar file, and importing java.sql package, with a detailed step-by-step guide on loading and registering the driver, creating connection and statement objects, executing queries, and closing the connection.', 'duration': 155.019, 'highlights': ['The chapter demonstrates the process of setting up JDBC in Eclipse, including downloading a 1 MB file, adding an external jar file, and importing java.sql package.', 'The step-by-step guide includes loading and registering the driver, creating connection and statement objects, executing queries, and closing the connection.', 'The process involves using class.forName method to load the driver and handling exceptions for the method.', "The import statement 'import java.sql.*' is used to import all the interfaces and classes necessary for the process."]}], 'duration': 155.019, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg260516.jpg', 'highlights': ['The step-by-step guide includes loading and registering the driver, creating connection and statement objects, executing queries, and closing the connection.', 'The chapter demonstrates the process of setting up JDBC in Eclipse, including downloading a 1 MB file, adding an external jar file, and importing java.sql package.', 'The process involves using class.forName method to load the driver and handling exceptions for the method.', "The import statement 'import java.sql.*' is used to import all the interfaces and classes necessary for the process."]}, {'end': 563.682, 'segs': [{'end': 444.923, 'src': 'embed', 'start': 415.535, 'weight': 2, 'content': [{'end': 423.829, 'text': 'what we need to also specify the packages for this, because we need to provide the qualified name.', 'start': 415.535, 'duration': 8.294}, {'end': 430.353, 'text': 'so we have to say this is com.mysql.jdbc.driver.', 'start': 423.829, 'duration': 6.524}, {'end': 432.395, 'text': 'so we need to mention the qualified name.', 'start': 430.353, 'duration': 2.042}, {'end': 439.339, 'text': 'okay, if you want to understand exactly how this class.forename works.', 'start': 432.395, 'duration': 6.944}, {'end': 440.84, 'text': 'so I have a video on that.', 'start': 439.339, 'duration': 1.501}, {'end': 444.923, 'text': 'just search for class forename, telisco.', 'start': 440.84, 'duration': 4.083}], 'summary': 'Specify the qualified name like com.mysql.jdbc.driver for the packages. to understand how class.forename works, watch the video on it by searching for class forename, telisco.', 'duration': 29.388, 'max_score': 415.535, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg415535.jpg'}, {'end': 489.521, 'src': 'embed', 'start': 465.56, 'weight': 0, 'content': [{'end': 471.783, 'text': 'If you are curious about that, just search for this video, you will understand how class.forname works.', 'start': 465.56, 'duration': 6.223}, {'end': 476.665, 'text': 'Not just for JDBC, but you can use class.forname for multiple things.', 'start': 472.403, 'duration': 4.262}, {'end': 481.961, 'text': 'ok, the next step is you have to create the connection object right.', 'start': 478.973, 'duration': 2.988}, {'end': 486.078, 'text': 'so for that we need to say connection con right.', 'start': 481.961, 'duration': 4.117}, {'end': 488.66, 'text': 'so we need to also import the package for this.', 'start': 486.078, 'duration': 2.582}, {'end': 489.521, 'text': 'we have already done that.', 'start': 488.66, 'duration': 0.861}], 'summary': 'Using class.forname for multiple purposes, including jdbc connection creation.', 'duration': 23.961, 'max_score': 465.56, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg465560.jpg'}, {'end': 537.654, 'src': 'embed', 'start': 510.682, 'weight': 1, 'content': [{'end': 519.109, 'text': 'you need to search for the method which will give you the instance of connection and luckily we have a method called as get connection.', 'start': 510.682, 'duration': 8.427}, {'end': 524.273, 'text': 'so get connection is a method in java which will give you the instance of connection.', 'start': 519.109, 'duration': 5.164}, {'end': 530.77, 'text': 'Now this getConnection is a method of a class called as driverManager.', 'start': 525.387, 'duration': 5.383}, {'end': 537.654, 'text': 'So driverManager is a class in which you have a method called as getConnection which is a static method.', 'start': 531.15, 'duration': 6.504}], 'summary': 'In java, the drivermanager class has a static method called getconnection, which provides an instance of connection.', 'duration': 26.972, 'max_score': 510.682, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg510682.jpg'}], 'start': 415.535, 'title': 'Understanding jdbc connection', 'summary': 'Explains the process of obtaining a jdbc connection, emphasizing the usage of class.forname and the method get connection in drivermanager to obtain the instance of connection.', 'chapters': [{'end': 563.682, 'start': 415.535, 'title': 'Understanding jdbc connection', 'summary': 'Explains the process of obtaining a jdbc connection, emphasizing the usage of class.forname and the method get connection in drivermanager to obtain the instance of connection.', 'duration': 148.147, 'highlights': ['The chapter emphasizes the importance of using class.forname when working with JDBC, as it is essential for obtaining the instance of connection, providing a clear understanding of its functionality and significance.', 'The method get connection in driverManager is highlighted as a crucial step, as it returns the instance of connection, providing a practical approach to creating a connection object.', 'The transcript also mentions the necessity of specifying the packages and the qualified name, emphasizing the importance of providing the correct package and qualified name for JDBC operations.']}], 'duration': 148.147, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg415535.jpg', 'highlights': ['The chapter emphasizes the importance of using class.forname when working with JDBC, as it is essential for obtaining the instance of connection.', 'The method get connection in driverManager is highlighted as a crucial step, as it returns the instance of connection, providing a practical approach to creating a connection object.', 'The transcript also mentions the necessity of specifying the packages and the qualified name, emphasizing the importance of providing the correct package and qualified name for JDBC operations.']}, {'end': 797.316, 'segs': [{'end': 592.044, 'src': 'embed', 'start': 563.682, 'weight': 0, 'content': [{'end': 565.524, 'text': "that's what we want here.", 'start': 563.682, 'duration': 1.842}, {'end': 570.389, 'text': 'so to achieve that, we need to pass three parameters, as you can see here.', 'start': 565.524, 'duration': 4.865}, {'end': 572.191, 'text': 'so we need to pass the URL.', 'start': 570.389, 'duration': 1.802}, {'end': 574.393, 'text': 'we need to pass the.', 'start': 572.191, 'duration': 2.202}, {'end': 576.234, 'text': "okay, that's not the method we want to work with.", 'start': 574.393, 'duration': 1.841}, {'end': 578.497, 'text': 'we want to work with the other type of get connections.', 'start': 576.234, 'duration': 2.263}, {'end': 580.459, 'text': 'yeah, so this is the get connection method we want to work with.', 'start': 578.497, 'duration': 1.962}, {'end': 582.38, 'text': 'we have to pass the URL.', 'start': 581.019, 'duration': 1.361}, {'end': 584.901, 'text': 'we need to pass username and password.', 'start': 582.38, 'duration': 2.521}, {'end': 588.142, 'text': 'right, so just go back to our class.', 'start': 584.901, 'duration': 3.241}, {'end': 590.043, 'text': 'here you have to mention three things.', 'start': 588.142, 'duration': 1.901}, {'end': 592.044, 'text': 'the first thing is the URL.', 'start': 590.043, 'duration': 2.001}], 'summary': 'To achieve the desired outcome, three parameters (url, username, password) need to be passed for the get connection method.', 'duration': 28.362, 'max_score': 563.682, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg563682.jpg'}, {'end': 748.604, 'src': 'embed', 'start': 689.124, 'weight': 1, 'content': [{'end': 690.824, 'text': 'that will not be that flexible, right?', 'start': 689.124, 'duration': 1.7}, {'end': 698.706, 'text': 'so what you can do is you can use a GUI for it, which is mysql workbench.', 'start': 690.824, 'duration': 7.882}, {'end': 703.707, 'text': 'so just go to google and again search for mysql workbench.', 'start': 698.706, 'duration': 5.001}, {'end': 705.007, 'text': 'okay, workbench.', 'start': 703.707, 'duration': 1.3}, {'end': 711.769, 'text': 'so this is a GUI tool where you can work with database creation, table creation, all those stuff.', 'start': 705.007, 'duration': 6.762}, {'end': 713.989, 'text': 'okay, so I have already done that.', 'start': 711.769, 'duration': 2.22}, {'end': 717.11, 'text': 'I have installed MySQL in my system.', 'start': 713.989, 'duration': 3.121}, {'end': 723.151, 'text': 'so if you want to learn about MySQL or SQL stuff, just again go to my channel.', 'start': 717.11, 'duration': 6.041}, {'end': 729.852, 'text': 'search for okay, search for MySQL tutorial telescope.', 'start': 723.151, 'duration': 6.701}, {'end': 733.393, 'text': 'okay. so just to give you a tool to my channel.', 'start': 729.852, 'duration': 3.541}, {'end': 741.83, 'text': 'so just go to YouTube and search for telescope learnings.', 'start': 733.393, 'duration': 8.437}, {'end': 743.111, 'text': "so that's my channel name.", 'start': 741.83, 'duration': 1.281}, {'end': 745.975, 'text': 'so if you go to my channel, I have lots of playlists.', 'start': 743.111, 'duration': 2.864}, {'end': 748.604, 'text': 'okay, so you can learn everything here.', 'start': 746.863, 'duration': 1.741}], 'summary': 'Use mysql workbench for database tasks, visit youtube channel for tutorials.', 'duration': 59.48, 'max_score': 689.124, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg689124.jpg'}], 'start': 563.682, 'title': 'Database setup and mysql usage', 'summary': 'Covers setting up database connection parameters including url, username, and password, emphasizing mysql usage. it also discusses installing mysql and using mysql workbench for database management, and introduces telescope learnings, a youtube channel for mysql and java tutorials.', 'chapters': [{'end': 664.969, 'start': 563.682, 'title': 'Setting up database connection parameters', 'summary': 'Discusses the process of setting up database connection parameters, emphasizing the need to pass three parameters - url, username, and password - and the importance of creating a database before establishing a connection, using mysql as an example.', 'duration': 101.287, 'highlights': ['The chapter emphasizes the need to pass three parameters - URL, username, and password - to establish the database connection, without specifying any specific values.', 'It mentions the importance of creating a database before establishing a connection and using MySQL as an example of a compatible DBMS.', "The speaker highlights the method of 'get connection' and the specific parameters required - URL, username, and password - to establish the desired connection."]}, {'end': 717.11, 'start': 665.63, 'title': 'Installing mysql and using mysql workbench', 'summary': 'Discusses the process of installing mysql and using mysql workbench, which provides a graphical user interface for database management, enabling easy execution of commands and operations for database creation and table creation.', 'duration': 51.48, 'highlights': ['MySQL Workbench provides a GUI tool for database management, enabling easy execution of commands and operations for database creation and table creation.', 'Installing MySQL involves searching for MySQL download or MySQL server on Google, downloading it from the official website, and using command line interface for executing commands.', 'Using MySQL Workbench provides a more flexible way of working with MySQL compared to the command line interface.']}, {'end': 797.316, 'start': 717.11, 'title': 'Telescope learnings: mysql and java tutorials', 'summary': 'Introduces telescope learnings, a youtube channel offering various playlists including mysql tutorials, java tutorials, and other programming related content, providing learners with access to a wide range of educational resources.', 'duration': 80.206, 'highlights': ['Telescope Learnings offers a diverse range of playlists including MySQL tutorials, Java tutorials, Android, Java 8 new features, design patterns, C programming, OOP concepts, and Maven, providing a comprehensive educational platform for learners.', 'The channel provides a dedicated MySQL tutorial playlist, enabling viewers to gain a thorough understanding of MySQL and its functionalities through a series of instructional videos.', 'Learners can access tutorials on how to use Eclipse, EJB, GUI development, and other programming related topics, expanding their knowledge and skills in various areas of software development.']}], 'duration': 233.634, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg563682.jpg', 'highlights': ['The chapter emphasizes the need to pass three parameters - URL, username, and password - to establish the database connection, without specifying any specific values.', 'MySQL Workbench provides a GUI tool for database management, enabling easy execution of commands and operations for database creation and table creation.', 'Telescope Learnings offers a diverse range of playlists including MySQL tutorials, Java tutorials, Android, Java 8 new features, design patterns, C programming, OOP concepts, and Maven, providing a comprehensive educational platform for learners.']}, {'end': 1221.485, 'segs': [{'end': 881.004, 'src': 'embed', 'start': 820.005, 'weight': 0, 'content': [{'end': 821.385, 'text': 'so let me insert some values here.', 'start': 820.005, 'duration': 1.38}, {'end': 826.635, 'text': "so we'll say insert Into.", 'start': 821.385, 'duration': 5.25}, {'end': 827.976, 'text': "Okay, what's the table name?", 'start': 826.635, 'duration': 1.341}, {'end': 831.999, 'text': "It's student.", 'start': 828.877, 'duration': 3.122}, {'end': 833.62, 'text': 'Then we say values.', 'start': 831.999, 'duration': 1.621}, {'end': 834.9, 'text': 'so we just specify the first thing.', 'start': 833.62, 'duration': 1.28}, {'end': 841.405, 'text': "let's say it is a user ID 2 And we'll insert a name as Naveen.", 'start': 834.9, 'duration': 6.505}, {'end': 844.226, 'text': "Okay, that's the first thing.", 'start': 841.405, 'duration': 2.821}, {'end': 845.047, 'text': "Let's run this code.", 'start': 844.226, 'duration': 0.821}, {'end': 848.108, 'text': 'okay, now we have the second record.', 'start': 846.567, 'duration': 1.541}, {'end': 849.349, 'text': "let's enter one more.", 'start': 848.108, 'duration': 1.241}, {'end': 854.013, 'text': "so let's say three, which is Mahesh, and if I run this code.", 'start': 849.349, 'duration': 4.664}, {'end': 855.474, 'text': 'we got three rows now.', 'start': 854.013, 'duration': 1.461}, {'end': 859.617, 'text': 'so if I run this code, okay, so we have three rows.', 'start': 855.474, 'duration': 4.143}, {'end': 865.501, 'text': "what we'll do in this code is we'll give the value and we'll try to fetch the name.", 'start': 859.617, 'duration': 5.884}, {'end': 871.926, 'text': 'okay, and the query for that will be just select when to fetch the username.', 'start': 865.501, 'duration': 6.425}, {'end': 879.32, 'text': 'so username from student, where user ID.', 'start': 871.926, 'duration': 7.394}, {'end': 881.004, 'text': 'user ID is equal to three.', 'start': 879.32, 'duration': 1.684}], 'summary': 'Inserting values into the student table to create three records, and fetching a specific username using a query.', 'duration': 60.999, 'max_score': 820.005, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg820005.jpg'}, {'end': 951.095, 'src': 'embed', 'start': 902.061, 'weight': 2, 'content': [{'end': 908.383, 'text': 'so when we talk about the url patterns or url, we have to specify jdbc, colon, mysql, colon, aliens.', 'start': 902.061, 'duration': 6.322}, {'end': 910.484, 'text': "so that's the composite things.", 'start': 908.983, 'duration': 1.501}, {'end': 918.648, 'text': 'because it specifies that you are working with JDBC and the DBMS you are working with is MySQL and inside MySQL you have aliens.', 'start': 910.484, 'duration': 8.164}, {'end': 927.033, 'text': 'but MySQL is a server level or what you say, LAN, LAN type of DBMS where you can have the database on other machine.', 'start': 918.648, 'duration': 8.385}, {'end': 928.934, 'text': 'you can access with other machine.', 'start': 927.033, 'duration': 1.901}, {'end': 934.737, 'text': 'so we need to also specify the IP address here, since it is there in the local machine, I will say localhost,', 'start': 928.934, 'duration': 5.803}, {'end': 937.84, 'text': 'And we need to also mention the port number.', 'start': 935.437, 'duration': 2.403}, {'end': 941.344, 'text': 'So I am using a port number which is 3307.', 'start': 938.381, 'duration': 2.963}, {'end': 946.45, 'text': 'If you are installing MySQL for the first time, the port number you will be getting is 3306.', 'start': 941.344, 'duration': 5.106}, {'end': 951.095, 'text': 'So you might be having a port number which is 3306.', 'start': 946.45, 'duration': 4.645}], 'summary': 'Specifying jdbc, mysql, and ip address with port number for server-level dbms.', 'duration': 49.034, 'max_score': 902.061, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg902061.jpg'}, {'end': 1032.217, 'src': 'embed', 'start': 1000.384, 'weight': 4, 'content': [{'end': 1001.645, 'text': "so that's the query we have, right?", 'start': 1000.384, 'duration': 1.261}, {'end': 1007.247, 'text': 'so we want to fetch the name of the user with row number or with user ID 3.', 'start': 1001.645, 'duration': 5.602}, {'end': 1008.327, 'text': 'now how to execute the query?', 'start': 1007.247, 'duration': 1.08}, {'end': 1008.947, 'text': "it's very simple.", 'start': 1008.327, 'duration': 0.62}, {'end': 1013.429, 'text': 'just say st.executeQuery and then you have to pass the query here.', 'start': 1008.947, 'duration': 4.482}, {'end': 1020.573, 'text': "Now, whenever you execute this query, let's execute this query here in MySQL, so you can see we are getting a data.", 'start': 1015.231, 'duration': 5.342}, {'end': 1022.754, 'text': 'So what data you are able to see?', 'start': 1021.213, 'duration': 1.541}, {'end': 1023.994, 'text': 'Is it just Mahesh?', 'start': 1022.974, 'duration': 1.02}, {'end': 1025.454, 'text': "And they'll say no, right?", 'start': 1024.534, 'duration': 0.92}, {'end': 1032.217, 'text': 'We are not just able to see Mahesh, we are also saying this username as the label right?', 'start': 1025.473, 'duration': 6.744}], 'summary': 'Fetching user name with row number or user id 3 using st.executequery in mysql.', 'duration': 31.833, 'max_score': 1000.384, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg1000384.jpg'}, {'end': 1137.348, 'src': 'embed', 'start': 1108.561, 'weight': 5, 'content': [{'end': 1111.982, 'text': "before that, let's do the last step, which is closing stuff right.", 'start': 1108.561, 'duration': 3.421}, {'end': 1113.363, 'text': 'so we have done with the processing.', 'start': 1111.982, 'duration': 1.381}, {'end': 1114.604, 'text': "let's close it.", 'start': 1113.363, 'duration': 1.241}, {'end': 1115.244, 'text': 'how to close?', 'start': 1114.604, 'duration': 0.64}, {'end': 1115.824, 'text': 'very simple.', 'start': 1115.244, 'duration': 0.58}, {'end': 1120.747, 'text': "it's first you have to close the statement, so you have to say st.close, and then we have to get,", 'start': 1115.824, 'duration': 4.923}, {'end': 1123.368, 'text': 'we have to close the connection also will say connection.close.', 'start': 1120.747, 'duration': 2.621}, {'end': 1128.382, 'text': "let's run this code and boom, we got the error.", 'start': 1124.42, 'duration': 3.962}, {'end': 1131.344, 'text': 'the error is before start of result set.', 'start': 1128.382, 'duration': 2.962}, {'end': 1137.348, 'text': "it's because whenever you run the query by default, you can see the pointer here right, like.", 'start': 1131.344, 'duration': 6.004}], 'summary': 'The transcript explains the process of closing a database connection and encountering an error before the start of a result set.', 'duration': 28.787, 'max_score': 1108.561, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg1108561.jpg'}], 'start': 797.316, 'title': 'Mysql database in java and jdbc connection', 'summary': 'Covers working with mysql database in java, demonstrating creating a table, inserting records, and querying data, along with details on jdbc connection, query execution, and the importance of proper connection handling.', 'chapters': [{'end': 927.033, 'start': 797.316, 'title': 'Working with mysql database in java', 'summary': "Demonstrates creating a table, inserting records, and querying data in a mysql database using java, with examples showing the insertion of records and fetching data from the 'student' table.", 'duration': 129.717, 'highlights': ["Creating a 'student' table and inserting records like 'user ID 2 Naveen' and 'user ID 3 Mahesh' into the MySQL database using Java.", "Querying the 'student' table to fetch the username 'Mahesh' based on the user ID using Java.", "Explaining the JDBC URL pattern for working with the MySQL database in Java, specifying 'jdbc:mysql:aliens' as the URL pattern for connecting to the MySQL database."]}, {'end': 1221.485, 'start': 927.033, 'title': 'Jdbc connection and query execution', 'summary': 'Details the steps for creating a jdbc connection, executing a query to fetch specific data, and the importance of closing the connection properly, emphasizing the need to use the correct methods for query execution and data retrieval.', 'duration': 294.452, 'highlights': ['The process of creating a JDBC connection, specifying the IP address and port number is explained, with the importance of knowing the port number emphasized, as it determines the successful connection establishment.', 'The steps for executing a query to fetch specific data from a MySQL database are detailed, highlighting the need to store the retrieved data in a result set and the process of fetching the data using the appropriate methods.', 'The significance of closing the connection properly is emphasized, with the correct procedure for closing the statement and connection highlighted to avoid errors and ensure the successful execution of the JDBC code.']}], 'duration': 424.169, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/5vzCjvUwMXg/pics/5vzCjvUwMXg797316.jpg', 'highlights': ["Creating a 'student' table and inserting records like 'user ID 2 Naveen' and 'user ID 3 Mahesh' into the MySQL database using Java.", "Querying the 'student' table to fetch the username 'Mahesh' based on the user ID using Java.", "Explaining the JDBC URL pattern for working with the MySQL database in Java, specifying 'jdbc:mysql:aliens' as the URL pattern for connecting to the MySQL database.", 'The process of creating a JDBC connection, specifying the IP address and port number is explained, with the importance of knowing the port number emphasized, as it determines the successful connection establishment.', 'The steps for executing a query to fetch specific data from a MySQL database are detailed, highlighting the need to store the retrieved data in a result set and the process of fetching the data using the appropriate methods.', 'The significance of closing the connection properly is emphasized, with the correct procedure for closing the statement and connection highlighted to avoid errors and ensure the successful execution of the JDBC code.']}], 'highlights': ['The Maven repository is the recommended place to download the MySQL connector jar, providing access to various versions of the connector for application use.', 'MySQL Workbench provides a GUI tool for database management, enabling easy execution of commands and operations for database creation and table creation.', 'The process of creating a JDBC connection, specifying the IP address and port number is explained, with the importance of knowing the port number emphasized, as it determines the successful connection establishment.', 'The significance of closing the connection properly is emphasized, with the correct procedure for closing the statement and connection highlighted to avoid errors and ensure the successful execution of the JDBC code.', "Creating a 'student' table and inserting records like 'user ID 2 Naveen' and 'user ID 3 Mahesh' into the MySQL database using Java.", "Querying the 'student' table to fetch the username 'Mahesh' based on the user ID using Java.", "Explaining the JDBC URL pattern for working with the MySQL database in Java, specifying 'jdbc:mysql:aliens' as the URL pattern for connecting to the MySQL database.", 'The steps for executing a query to fetch specific data from a MySQL database are detailed, highlighting the need to store the retrieved data in a result set and the process of fetching the data using the appropriate methods.', 'The chapter emphasizes the need to pass three parameters - URL, username, and password - to establish the database connection, without specifying any specific values.', 'The chapter demonstrates the process of setting up JDBC in Eclipse, including downloading a 1 MB file, adding an external jar file, and importing java.sql package.', 'The step-by-step guide includes loading and registering the driver, creating connection and statement objects, executing queries, and closing the connection.', 'Understanding the four types of JDBC drivers is essential for working with JDBC, including the JDBC type one driver for MS Access and specific drivers for different DBMS.', 'The chapter emphasizes the importance of using class.forname when working with JDBC, as it is essential for obtaining the instance of connection.', 'The method get connection in driverManager is highlighted as a crucial step, as it returns the instance of connection, providing a practical approach to creating a connection object.', 'The transcript also mentions the necessity of specifying the packages and the qualified name, emphasizing the importance of providing the correct package and qualified name for JDBC operations.', 'Loading the com.mysql.jdbc.driver class may not be available by default in Eclipse and needs to be downloaded from the internet, particularly from the Maven repository.', 'When working with a Gem application, it is necessary to use the com.mysql.jdbc.driver for MySQL.']}