logging in or signing up Java Database Connectivity mayura_jg Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 1165 Category: Education License: All Rights Reserved Like it (5) Dislike it (0) Added: January 18, 2010 This Presentation is Public Favorites: 3 Presentation Description No description available. Comments Posting comment... By: vanshthewinner (18 month(s) ago) u have a good and a brief description of the topic pls mail me at my id vanshthewinner@gmail.com i need it urgently Saving..... Post Reply Close Saving..... Edit Comment Close By: pallavip06 (21 month(s) ago) I am a Trainer. Your slides are very good. Could I use them in my training? If it is okay with you, please send me the slides asap to my mail id: pallavi200745@yahoo.com Thank you Pallavi Prasad Saving..... Post Reply Close Saving..... Edit Comment Close Premium member Presentation Transcript Java Database ConnectivityPresenterMayura Vidyasagar : Java Database ConnectivityPresenterMayura Vidyasagar author Mayura Vidyasagar Object Oriented Software Engineering JDBC Slide 2: author Mayura Vidyasagar Object Oriented Software Engineering JDBC JDBC is an API that defines how a java client may access a database. It provides database-independent connectivity between the Java programming language and a wide range of databases. Slide 3: author Mayura Vidyasagar Object Oriented Software Engineering JDBC The JDBC API makes it possible to do three things: 1. Establish a connection with a database or access any tabular data source 2. Send SQL statements 3. Process the results Slide 4: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Java application JDBC API JDBC driver Database Slide 5: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Types of JDBC drivers ~ Type 4 : Pure Java driver ~ Java application JDBC driver Database Client side Server side Slide 6: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Types of JDBC drivers ~ Type 3 : Pure Java driver for database middleware ~ Java application JDBC driver Database Database middleware Client side Server side Slide 7: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Types of JDBC drivers ~ Type 1 : JDBC-ODBC Bridge plus ODBC Driver ~ Java application JDBC-ODBC bridge driver Database Client side Server side ODBC driver Database client lib Not platform independent Slide 8: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Types of JDBC drivers ~ Type 2 : A native API partly Java technology-enabled driver ~ Java application Partial Java JDBC driver Database Client side Server side Database client lib Not platform independent Slide 9: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Using JDBC API Slide 10: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Using JDBC API Execute the query ResultSet resultSet = statement.executeQuery(“select * from xyz”); Slide 11: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Using JDBC API ~ Statement execution ~ Slide 12: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Using JDBC API ~ Types of Statement ~ Slide 13: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Using JDBC API Slide 14: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Referances http://en.wikipedia.org/wiki/Java_Database_Connectivity http://java.sun.com/products/jdbc/overview.html http://java.sun.com/docs/books/tutorial/jdbc/basics/index.html Slide 15: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Thank you! You do not have the permission to view this presentation. In order to view it, please contact the author of the presentation.
Java Database Connectivity mayura_jg Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 1165 Category: Education License: All Rights Reserved Like it (5) Dislike it (0) Added: January 18, 2010 This Presentation is Public Favorites: 3 Presentation Description No description available. Comments Posting comment... By: vanshthewinner (18 month(s) ago) u have a good and a brief description of the topic pls mail me at my id vanshthewinner@gmail.com i need it urgently Saving..... Post Reply Close Saving..... Edit Comment Close By: pallavip06 (21 month(s) ago) I am a Trainer. Your slides are very good. Could I use them in my training? If it is okay with you, please send me the slides asap to my mail id: pallavi200745@yahoo.com Thank you Pallavi Prasad Saving..... Post Reply Close Saving..... Edit Comment Close Premium member Presentation Transcript Java Database ConnectivityPresenterMayura Vidyasagar : Java Database ConnectivityPresenterMayura Vidyasagar author Mayura Vidyasagar Object Oriented Software Engineering JDBC Slide 2: author Mayura Vidyasagar Object Oriented Software Engineering JDBC JDBC is an API that defines how a java client may access a database. It provides database-independent connectivity between the Java programming language and a wide range of databases. Slide 3: author Mayura Vidyasagar Object Oriented Software Engineering JDBC The JDBC API makes it possible to do three things: 1. Establish a connection with a database or access any tabular data source 2. Send SQL statements 3. Process the results Slide 4: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Java application JDBC API JDBC driver Database Slide 5: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Types of JDBC drivers ~ Type 4 : Pure Java driver ~ Java application JDBC driver Database Client side Server side Slide 6: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Types of JDBC drivers ~ Type 3 : Pure Java driver for database middleware ~ Java application JDBC driver Database Database middleware Client side Server side Slide 7: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Types of JDBC drivers ~ Type 1 : JDBC-ODBC Bridge plus ODBC Driver ~ Java application JDBC-ODBC bridge driver Database Client side Server side ODBC driver Database client lib Not platform independent Slide 8: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Types of JDBC drivers ~ Type 2 : A native API partly Java technology-enabled driver ~ Java application Partial Java JDBC driver Database Client side Server side Database client lib Not platform independent Slide 9: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Using JDBC API Slide 10: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Using JDBC API Execute the query ResultSet resultSet = statement.executeQuery(“select * from xyz”); Slide 11: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Using JDBC API ~ Statement execution ~ Slide 12: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Using JDBC API ~ Types of Statement ~ Slide 13: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Using JDBC API Slide 14: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Referances http://en.wikipedia.org/wiki/Java_Database_Connectivity http://java.sun.com/products/jdbc/overview.html http://java.sun.com/docs/books/tutorial/jdbc/basics/index.html Slide 15: author Mayura Vidyasagar Object Oriented Software Engineering JDBC Thank you!