Database access. and JDBC. ?. Integrating database access into JSP. applications ... JDBC does not mean Java Database. Connectivity :) ...Short Desciption: Database access. and JDBC. ?. Integrating database access into JSP. applications... JDBC does not mean Java Database. Connectivity :) ...
Content Inside: Database access and JDBC Integrating database access into JSP applications Goals Access SQL DBMSs from JSP pages JDBC technology Integrate SQL query results into the resulting HTML content Generate SQL queries according to FORM values JDBC Standard library for accessing relational databases Compatible with most/all different databases JDBC does not mean Java Database Connectivity :) Defined in package java.sql and javax.sql Documentation: http://java.sun.com/javase/technologies/databa se/index.jsp Architecture JDBC scope Standardizes Mechanism for connecting to DBMSs Syntax for sending queries Structure representing the results Does not standardize SQL syntax: dialects, variants, extensions, Main elements Java application (in our case, JSP) JDBC Driver Manager For loading the JDBC Driver DBMS vendor JDBC Driver From DBMS In our case, MySQL Basic steps Load the JDBC driver Define the connection URL Establish the connection Create a statement object Execute a query or update Process the results Close the connection 1. Loading the driver A Driver is a DMBS-vendor provided class, that must be available
::download::
Content Inside: Database access and JDBC Integrating database access into JSP applications Goals Access SQL DBMSs from JSP pages JDBC technology Integrate SQL query results into the resulting HTML content Generate SQL queries according to FORM values JDBC Standard library for accessing relational databases Compatible with most/all different databases JDBC does not mean Java Database Connectivity :) Defined in package java.sql and javax.sql Documentation: http://java.sun.com/javase/technologies/databa se/index.jsp Architecture JDBC scope Standardizes Mechanism for connecting to DBMSs Syntax for sending queries Structure representing the results Does not standardize SQL syntax: dialects, variants, extensions, Main elements Java application (in our case, JSP) JDBC Driver Manager For loading the JDBC Driver DBMS vendor JDBC Driver From DBMS In our case, MySQL Basic steps Load the JDBC driver Define the connection URL Establish the connection Create a statement object Execute a query or update Process the results Close the connection 1. Loading the driver A Driver is a DMBS-vendor provided class, that must be available
::download::
Custom Search
